Category: azure sql data warehouse
kwdibm on Wed, 24 Apr 2019 12:33:04
I got the following error from Azure SQL Data Warehouse with MS ODBC Driver 126.96.36.199.
42000 [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
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.
kwdibm on Wed, 24 Apr 2019 13:09:39
I found RAND has the same behavior.
42000 [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
Can you file an Azure Support Request to file this issue ad a bug? Thank you...