Question

kwdibm on Wed, 24 Apr 2019 12:33:04


I got the following error from Azure SQL Data Warehouse with MS ODBC Driver 17.3.1.1.
42000[104162] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]'CHECKSUM' is not a recognized built-in function name.

CHECKSUM itself is supported on Azure SQL Data Warehouse
T-SQL language elements supported in Azure SQL Data Warehouse
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-reference-tsql-language-elements#functions


The sql is the following.
select name,CHECKSUM(name) from sysdatabases

This sql works on SQL Server 2016 and Azure SQL Database and also Azure SQL Data Warehouse with Management Console.
The error occurs only with ODBC Driver 17.

Replies

kwdibm on Wed, 24 Apr 2019 13:09:39


I found RAND has the same behavior.

42000[104162] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]'RAND' is not a recognized built-in function name.

Mike Ubezzi (Azure) on Wed, 01 May 2019 01:53:29


Hi Kwdibm,

Can you file an Azure Support Request to file this issue ad a bug? Thank you...