No support for unquoted identifiers. The driver always enforces ANSI rules regarding quotation marks for Azure Synapse Analytics and Analytics Platform System connections.
No support for connection pooling reauthentication.
No support for Data Definition Language (DDL) queries within transactions.
No support for closing holdable cursors when a transaction is committed.
No support for server-side cursors; therefore:
Scroll-sensitive result sets are not supported.
The UseServerSideUpdatableCursors property is set to false, and server-side cursors are not used.
No support for XA connections.
Support for isolation levels is limited to only the read uncommitted level. See "Isolation Levels" for more information.
No support for the following SQL Server data types in either the Azure Synapse Analytics or Analytics Platform System.
|
decimal() identity
|
timestamp
|
|
image
|
tinyint identity
|
|
numeric() identity
|
ntext
|
|
smallint identity
|
xml
|
|
text
|
Support for scalar string functions is limited to the following functions.
|
ASCII
|
LEFT
|
RTRIM
|
|
CHAR
|
LTRIM
|
SOUNDEX
|
|
CONCAT
|
REPLACE
|
SPACE
|
|
DIFFERENCE
|
RIGHT
|
SUBSTRING
|
Support for scalar numeric functions is limited to the following functions.
|
ABS
|
EXP
|
ROUND
|
|
ACOS
|
FLOOR
|
SIGN
|
|
ASIN
|
LOG
|
SIN
|
|
ATAN
|
LOG10
|
SQRT
|
|
CEILING
|
PI
|
TAN
|
|
COS
|
POWER
|
TRUNCATE
|
|
COT
|
RADIANS
|
|
|
DEGREES
|
RAND (Azure Warehouse only)
|
Support for scalar date and time functions is limited to the following functions.
|
CURDATE
|
DAYOFWEEK
|
QUARTER
|
|
CURRENT_DATE
|
DAYOFYEAR
|
SECOND
|
|
CURRENT_TIME
|
HOUR
|
WEEK
|
|
CURTIME
|
MINUTE
|
YEAR
|
|
DAYNAME
|
MONTH
|
|
|
DAYOFMONTH
|
MONTHNAME
|