Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayList of bugs fixed
This page contains a listing of bugs fixed in each release, starting with Microsoft ODBC Driver 17 for SQL Server.
- Fix crashes when receiving invalid data from server
- Fix sending of null data for fixed-length types using DAE
- Fix 10-minute delay upon disconnection after timeout
- Fix memory leak upon disconnection when an error occurs
- Fix memory leak upon reconnection with Strict encryption
- Fix intermittent crash when connecting with Strict encryption and TLS 1.3
- Fix crashes under low-memory conditions
- Fix crashes when receiving invalid data from server
- Fix infinite loop when receiving invalid data from server
- Fix App Service Containers MSI Authentication
- Fix crashes when receiving invalid data from server
- Fix infinite loop when receiving invalid data from server
- Fix a crash when attempting to connect under low-memory conditions
- Fix memory leak upon reconnect
- Fix App Service Containers MSI Authentication
- Fix crashes when receiving invalid data from server
- Fix infinite loop when receiving invalid data from server
- Fix a crash when attempting to connect under low-memory conditions
- Fix crashes when receiving invalid data from server
- Fix a bug in setting of data classification version attribute
- Fix a crash when retrieving data with AutoTranslate option off
- Fix partial writes on Linux in presence of signals
- Fix crashes when receiving invalid data from server
- Fix memory leak when processing encrypted columns
- Fix errors with long enclave queries
- Fix a crash when retrieving data with AutoTranslate option off
- Fix partial writes on Linux in presence of signals
- Fix crashes when receiving invalid data from server
- Fix memory leak when processing encrypted columns
- Fix VBS-NONE enclave attestation protocol
- Fix error when retrieving numeric column with Regional=Yes
- Fix intermittent lack of error when server is stopped during bcp out operation
- Fix error when stored procedure call contains unquoted string parameter
- Fix a memory leak upon reconnect
- Fix a crash when receiving invalid data from server
- Correct error message when Dedicated Administrative Connections (DAC) fail
- Correct error message when Dedicated Administrative Connections (DAC) fail
- Fix VBS-NONE enclave attestation protocol.
- Fix error when retrieving numeric column with Regional=Yes.
- Fix intermittent lack of error when server is stopped during bcp out operation.
- Fix error when stored procedure call contains unquoted string parameter.
- Fix intermittent issue with polling for first successful connection when multiple IP addresses are resolved.
- Fix intermittent hang when using SQLBulkOperations in async mode.
- Fix connecting with Strict and non-Strict encryption modes simultaneously.
- Fix missing dependency in Debian package.
- Fix issue with idle connection resiliency when Kerberos authentication is used.
- Fix UI issues where text was cut off and position of items was off.
- Fix issue with Active Directory Interactive login where attempting to login after closing the window of the first failure would automatically succeed if cached credentials were available.
- Fix use of XADTC with Azure SQL Managed Instance.
- Fix loss of Microsoft Entra authentication mode when reconnecting an idle connection.
- Fix an issue with federated authentication when using PingFed.
- Fix error when retrieving numeric column with Regional=Yes
- Fix intermittent lack of error when server is stopped during bcp out operation
- Fix error when stored procedure call contains unquoted string parameter
- Fix a crash when receiving invalid data from server
- Fix intermittent issue with polling for first successful connection when multiple IP addresses are resolved.
- Fix missing dependency in Debian package.
- Fix for only using ADAL when required.
- Fix issue with idle connection resiliency when Kerberos auth was used.
- Fix UI issues where text was cut off and position of items was off.
- Fix issue with Active Directory Interactive login where attempting to login after closing the window of the first failure would automatically succeed if cached credentials were available.
- Fix use of XADTC with Azure SQL Managed Instance.
- Fix loss of Microsoft Entra authentication mode when reconnecting an idle connection.
- Fix an issue with federated authentication when using PingFed.
- Fix for restrictions on connection string regarding usage of
UIDandPWDkeywords - Fix for inconsistent fonts in non-English dialogs
- Fix issue with having multiple connections with different AKV credentials
- Fix issue with NVDA not reading connection test results in DSN configuration UI
- Fix issue with 404 Not Found errors when using Managed Service Identity authentication
- Fix for intermittent Encryption Not Supported errors under high multithreaded loads
- Fix for intermittent crash under high multithreaded loads
- Fix character encoding of VARIANT columns in BCP NATIVE mode
- Fix setting of SQL_ATTR_PARAMS_PROCESSED_PTR under specific conditions
- Fix SQLDescribeParam in FMTONLY mode for statements containing comments
- Fix an issue with federated authentication when using Okta
- Fix excessive memory usage on multi-processor systems
- Fix Microsoft Entra authentication for some variants of Azure SQL
- Fix ADAL error when authenticating with a federated account (Windows)
- Fix an issue where the driver becomes unresponsive when a timeout occurs during an asynchronous notification operation
- Fix driver reference count upon upgrade in Alpine Linux
- Fix libc6 dependency version for Ubuntu
- Add missing defines to Linux/Mac msodbcsql.h
- Fix a crash when using Always Encrypted with secure enclaves on Alpine Linux
- Added msodbcsql.h to Alpine Linux package
- Fix AKV CMK metadata hash computation on Linux/macOS
- Fix error when loading OpenSSL 1.0.0
- Fix conversion issues when using ISO-8859-1 and ISO-8859-2 codepages
- Fix internal library name on macOS to include version number
- Fix setting of null indicator when separate length and indicator bindings are used
- Fix for an issue where process ID and application name wouldn't be sent correctly to SQL Server (for sys.dm_exec_sessions analysis) (Linux)
- Removed redundant dependency on libuuid (Linux)
- Fix for a bug with sending UTF8 data to SQL Server 2019
- Fix for a bug where locales that end in "@euro" weren't being correctly detected (Linux)
- Fix for XML data being returned incorrectly when fetched as an output parameter while using Always Encrypted
- Fix for intermittent issue when Multiple Active Results Sets (MARS) is enabled where the driver stops responding
- Fix connection resiliency issue when async notification is enabled where the driver stops responding
- Fix crash when retrieving diagnostic records for multithreaded connection attempts
- Fix 'Encryption not supported' upon reconnect after calling SQLGetInfo() with SQL_USER_NAME and SQL_DATA_SOURCE_READ_ONLY
- Fix COM initialization error during Microsoft Entra interactive authentication
- Fix SQLGetData() for multi-byte UTF8 data
- Fix retrieving length of sql_variant columns using SQLGetData()
- Fix importing of sql_variant columns containing more than 7,992 bytes using bcp
- Fix sending of correct encoding to server for narrow character data
- Fixed TCP send notification event handle memory leak
- Fixed redefinition issue of enum _SQL_FILESTREAM_DESIRED_ACCESS in msodbcsql.h header file
- Fixed missing ACCESS_TOKEN and AUTHENTICATION related definition in msodbcsql.h header file for Linux
- Fixed an error message about Microsoft Entra authentication
- Fixed encoding detection when locale environment variables are set differently
- Fixed a crash upon disconnect with connection recovery in progress
- Fixed detection of connection liveness
- Fixed incorrect detection of closed sockets
- Fixed an infinite wait when attempting to release a statement handle during failed recovery
- Fixed incorrect uninstallation behavior when both version 13 and 17 are installed on Windows
- Fixed decryption behavior on older Windows platform (Windows 7, 8 and Server 2012)
- Fixed a cache issue when using ADAL Authentication on Windows
- Fixed an issue that was locking and overwriting trace logs on Windows
- Fixed 1-second delay when calling SQLFreeHandle with MARS enabled and connection attribute "Encrypt=yes"
- Fixed an error 22003 crash in SQLGetData when the size of the buffer passed in is smaller than the data being retrieved (Windows)
- Fixed truncated ADAL error messages
- Fixed a rare bug on 32-bit Windows when converting a floating point number to an integer
- Fixed an issue where inserting double into decimal field with Always Encrypted on would return data truncation error
- Fixed a warning on macOS installer
- Fixed sending incorrect state to SQL Server during Session Recovery attempt when Connection Resiliency and Connection Pooling both are enabled, causing the server to drop the session
- Fixed a bug where when using Kerberos authentication, bulk insert could fail with "access denied" error
- Removed workaround for a unixODBC bug present in versions older than 2.3.1 (driver doubled the sizes of certain buffers passed to unixODBC)
- Fixed Connection Resiliency (reconnect) stopping to respond when using ColumnEncryption=enabled
- Fixed DSN creation bug, where when using "Active Directory Interactive authentication" option Azure Authentication window could become unresponsive (Windows)
- Fixed a rare crash during ODBC shutdown when asynchronous execution is enabled (happened when clearing connection handle)
- Fixed an issue where SQL Driver caused high CPU consumption while executing long stored procedures
- Fixed inability to retrieve data in an encrypted varbinary(max) column without conversion
- Fixed a problem where after a null varchar(max) encrypted column is fetched using SQLGetData() on a static cursor, the following column is also nulled even if it has data
- Fixed an issue with fetching varbinary(max) field with Always Encrypted on
- Fixed a problem of setlocale() not working with Always Encrypted
- Fixed an issue with SQLDescribeParam() returning error when called on XML-type stored procedure parameter with Always Encrypted on
- Fixed escaped underscores not working in SQLTables
- Fixed a bug where Hebrew data (varchar) is truncated when returned as wide chars on Linux
- Fixed an issue with querying Shift-JIS encoded char/varchar from UTF-8 application
- Fixed the bug where calling SQLGetInfo with SQL_DRIVER_NAME parameter returned Linux-style filename on macOS
- Fixed an issue where loading Windows-1252 character data, using input files larger than 32k bytes into VARCHAR columns using the BCP utility would result in failures
Additional resources
Training
Module
Introduction to SQL Server 2022 T-SQL enhancements - Training
SQL Server 2022 introduces a range of new features and enhancements, providing powerful tools and capabilities that optimize performance and offer better control on SQL objects manipulation and creation.