ODBC Driver release notes for 2023¶

This article contains the release notes for the ODBC Driver, including the following when applicable:

Snowflake uses semantic versioning for ODBC Driver updates.

Version 3.1.0 (August 23, 2023)¶

Fixed an issue where, under certain conditions, the driver could retry HTTP requests indefinitely.

Previously, during an outage the driver would retry the failed HTTP call continuously until the request succeeds or until someone force kills the operation.

With this change, the driver disables infinite HTTP retries originating from execute and executeQuery calls. Now, the driver limits HTTP retries to seven, by default. Customers can set the maxHttpRetries connection parameter to customize the maximum number of retries. Customers can set maxHttpRetries=0 to remove the retry limit, but doing so runs the risk of the driver infinitely retrying failed HTTP calls.
To improve performance, the SQLExecDirect() function no longer unnecessarily validates parameter bindings for a query.

Previously, the driver sent two requests for each SQLExecDirect() call: a describe request and an execute request. To improve the performance describe request is omitted. With this change the driver won’t validate the parameter bindings needed by the query. If the parameter bindings from the previous query are not cleared using SQLFreeStmt(SQL_RESET_PARAMS), they could be applied to the following query incorrectly and cause issues.

Added the CLIENT_OUT_OF_BAND_TELEMETRY_ENABLED session parameter to enable and disable out-of-band (OOB) telemetry support.

Fixed an issue where the driver might fail when getting a query result for mulit-statement queries that begin with new statement types, such as CALL.
Fixed an issue that could cause the SQLColAttribute() function to return an incorrect value of SQL_DESC_OCTET_LENGTH on VARCHAR columns, which could truncate data.
Fixed an issue where the driver failed to download query results by incorrectly sending out-of-band (OOB) telemetry timeouts when using private links.

Updated the following software libraries:
- util-linux to version 2.39.0.
- curl to version 8.1.2.
Enhanced hybrid transactional/analytical processing (HTAP).
Set the LogLevel default to OFF for ODBC clients running on Windows platforms.

Starting with version 3.0.1 of the ODBC driver:

Upgraded from openssl 1.1.1 to openssl 3.0.9. Consequently, private keys generated using the deprecated encryption algorithms in previous openssl library version no longer work. When you update to ODBC 3.0.1, you must regenerate your private key file used for key pair authentication.
Dropped support for CentOS 6 and MacOS 10.14 and 10.15.

Updated the following software libraries:
- openssl to version 3.0.9.
- icu to version 71.1.0.
Created a single, unified release package architecture that supports both x86_64 and arm64 Mac systems.

Fixed an issue where the driver crashed intermittently when CLIENT_SESSION_KEEP_ALIVE is set to true on Windows systems.

None.

Fixed an issue where very large requests with large amounts of parameter bindings could crash an application by exceeding the logging size.
Fixed an issue with OCSP validation.
Fixed an issue that could inadvertently reveal a proxy password in the Snowflake log file.

Fixed an invalid URL issue that could occur during OCSP validation when making connections.
Fixed an issue where connections would fail when credentials were supplied when using proxies that do not need them.
Removed deprecated openssl function calls.
Fixed an issue where double type parameter bindings could lose precision.
Removed unsafe function calls banned by Microsoft.

Fixed an issue the prevented clients from creating a file DSN (data source name).
Fixed an issue where the PUT command failed to replicated data.
Fixed an issue a Macintosh application running an the ARM64 architecture would fail to connect to Snowflake using the native Apple Silicon ODBC driver.

None.

Added support for the GEOMETRY data type in the SnowflakeType enum to fix an issue that occurred when calling the SQLColumns() function to return metadata that included GEOMETRY data.
Fixed an issue where timestamp data was wrongly returned as NULL in some cases.

None.

Fixed an issue where an array binding INSERT statement failed when the schema is not defined in the session.
Fixed an issue that occasionally caused the ODBC driver to crash when executing GET and PUT queries.
Fixed an issue where the ODBC driver sent SIGPIPE signals after the session was idle for around 120 seconds.
Fixed an issue where using Okta authentication failed when receiving an HTTP 429 error.