amazon-redshift-odbc-driver

1. Fixed an inconsistent metadata issue for Redshift type timestamptz in SQLColumns and SQLDescribeCol by changing the return value for Data type column in SQLColumns API from 2014 to SQL_TYPE_TIMESTAMP (93) and in SQLDescribeCol API from SQL_VARCHAR (12) to SQL_TYPE_TIMESTAMP (93).
2. Fixed an issue when invoking SQLBindParameter with the C type SQL_C_DEFAULT by converting SQL_C_DEFAULT to a new C type based on the SQL type. Also, added enhanced logging to provide informational and error messages related to SQL_C_DEFAULT conversions.
3. Added missing group federation checkbox in JWT IAM Auth Plugin ODBC DSN GUI in Windows.
4. Fixed an issue where an incorrect return value was generated when calling SQLGetData with the C type SQL_C_DEFAULT.
5. Added support for a new browser authentication plugin called BrowserIdcAuthPlugin to facilitate single-sign-on integration with AWS IAM Identity Center.

Full Changelog: https://github.com/aws/amazon-redshift-odbc-driver/compare/v2.1.2...v2.1.3

1. Upgraded the deprecated minimum TLS functions in OpenSSL to more versatile TLS methods that can support multiple TLS protocol versions.
2. Updated the default minimum TLS version to the more secure and faster TLS 1.2, changed from the previous default of TLS 1.0.
3. Added new options in the Windows ODBC DSN GUI to allow setting the minimum TLS version to any supported version.
4. Fixed a bug where the user option to provide the database username in the connection string was not working when connecting to Redshift using a database username and password.
5. Fixed an issue with querying large geometry data type using SQLGetData.
6. Fixed an issue in SQLFetch function where query buffer offset was not being reset properly, causing function execution to hang.
7. Fixed issues in unicode conversion utility methods used internally. Updated calls to these conversion methods in the SQLForeignKeysW, SQLPrimaryKeysW, SQLColumnsW and SQLDriverConnectW APIs.
8. Added missing OID mapping for Redshift Text data type.
9. Added missing invalid SQL type validation in SQLBindParameter API.
10. Fixed bug where databaseMetadataCurrentDbOnly flag was not using its default value when it is not included in DSN in Linux.
11. Updated catalog filter to use LIKE instead of = to allow filter patterns with '%' in catalog name in ODBC metadata APIs like SQLTables.
12. Fixed a bug where datatype of DECIMAL_DIGITS, NUM_PREC_RADIX, and NULLABLE columns in SQLColumns API result set were not following ODBC specification. This can impact behavior on some clients and tools.

Full Changelog: https://github.com/aws/amazon-redshift-odbc-driver/compare/v2.1.1...v2.1.2

v2.1.1 (2024-04-01)

1. Corrected the data type of the bind offset pointer to SQLLEN from long for the plBindOffsetPtr variable in RS_DESC_HEADER to ensure compatibility
2. Modified the default value for SQL_BOOKMARK_PERSISTENCE from SQL_BP_UPDATE | SQL_BP_SCROLL to SQL_BP_DROP
3. Upgraded logging capabilities and streamlined the logging system to boost speed and transparency.
4. Expanded unicode library capabilities by introducing wchar16_to_utf8_char() to convert 16-bit wide characters to UTF-8 char array.
5. Improved buffer safety checks in unicode function char_utf8_to_wchar_utf16() to make it more robust.
6. Enhanced unicode conversion within SQLTablesW and SQLPrepareW for improved compatibility and accuracy.
7. Resolved issues causing Power Query container crashes in Microsoft products.
8. The catalog filter was updated to use 'LIKE' instead of '+' to allow filter patterns with '%' which impacted metadata ODBC APIs like SQLTables.
9. In case the IAM authentication client cannot deduce the workgroup configuration from the serverless destination address, use the user-provided DSN setting as an alternative.
10. Invoke both cmake.find_library() and cmake.find_package() functions to locate the Gtest library, so that if one method fails to find Gtest, the other can be used as a fallback option.
11. Ensure that CaFile and CaPath connection settings are available to both IAM as well as Idp authentication plugins.
12. The TCP Proxy implementation in the DSN GUI was improved by fixing issues related to saving and loading proxy settings. Additionally, the connection handling routines in lipbq's library were enhanced to better support connections made through proxies. Specifically, the connect_using_proxy, connectDBStart, PQconnectPoll, and internal_cancel functions were updated to properly handle proxy configurations.
13. Updated the registry path that stores Windows DSN log settings for the ODBC driver, from "HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\ODBC" to "HKEY_LOCAL_MACHINE\SOFTWARE\Amazon\Amazon Redshift ODBC Driver (x64)\Driver".

Full Changelog: https://github.com/aws/amazon-redshift-odbc-driver/compare/v2.1.0.0...v2.1.1

1. Added support for LZ4 and ZSTD compression over wire protocol communication between Redshift server and the client/driver. Compression is turned off by default and can be set using a new connection parameter compression=off or lz4 or zstd.
2. Added support for unit-testing using Google Test framework.
3. Upgrade unixODBC dependency from v2.3.1 to v2.3.7 (Linux release).
4. Fix handling of null termination during unicode processing in SQLDescribeColW API.

1. Added support for Serverless Custom Name. Upgraded windows aws-sdk-cpp to 1.11.218 accordingly.
2. Added support for interval data types: SQL_INTERVAL_YEAR_TO_MONTH and SQL_INTERVAL_DAY_TO_SECOND. They can be retrieved as text or using the C structures SQL_YEAR_MONTH_STRUCT and SQL_DAY_SECOND_STRUCT.
3. Migrated Linux to cmake build system.
4. Build base libraries statically into librsodbc64.so including libgcc and libstdc++.
5. Fixed CaFile and CaPath connection options and default root certificate name for IAM and non-IAM connections.
6. Fixed support for group_federation connection parameter that allows customers to use getClusterCredentialsWithIAM in provisioned clusters.
7. Removed ssooidc dependencies from build system.

Full Changelog: https://github.com/aws/amazon-redshift-odbc-driver/compare/v2.0.0.11...v2.0.1.0

• Upgraded openssl (v1.1.1w) and removed redundant libcURL build dependencies for Windows.
• Removed outdated Linux build dependencies.
• Added ability to connect to datashare databases for clusters and serverless workgroups running the PREVIEW_2023 track
• Removed BrowserIdcAuthPlugin.
• Disabled the rudimentary check in SQLColumns, SQLStatistics and SQLSpecialColumns APIs, for equality of catalog name and database name.
• Improved ODBC Error messages for unsupported metadata features.
• Allowed overriding DSN config options in connection string.
• Fixed memory issue in Statement Descriptors and Query Parameter types by using stack memory vs heap allocation.
• Add new logging module based on aws-sdk-cpp. It has standard logging levels from FATAL to TRACE, plus OFF mode.
• Upgraded SQLGetStmtOption and SQLSetStmtOption APIs to be compatible with their new versions in ODBC standard 3: SQLGetStmtAttr, SQLSetStmtAttr
• Fixed SQLSetConnectAttr to return SQL_ERROR for SQL_ATTR_ANSI_APP as per standard.
• Minor adjustments in build scripts (windows and linux) and windows’s config page.
  Note: This release also includes changes from the recalled version 2.0.0.10.

• Added Identity Center authentication support with new plugins.
• Fixed IAM Authentication to support longer temporary passwords from 129 to 32767 characters.
• Added automatic region detection for Custom Cluster Naming (CNAME) feature.

• Fixed regular expressions used for parsing HTML Tag value responses received form for Ping IdP.
• Added a new JWT IAM authentication plugin (JwtIamAuthPlugin) to replace BasicJwtCredentialsProvider which has been repurposed to support the new nativeIdP authentication.
• Revert a memory issue fix in libpq’s MesageLoopState that was resulting in crashes since v2.0.0.6.
• Fixed enablement settings for Custom-Cluster Naming (CNAME) for Windows platform which was disabling CNAME permanently.

• Upgrade windows aws-sdk-cpp to 1.11.111.
• Enable CNAME for windows.
• Fix windows log settings.
• FAdd new pg type: NAMEARRAYOID.
• Fix NULLABLE and IS_NULLABLE definition in Metadata.
• Fix SQL_C_CHAR&SQL_C_WCHAR -> SQL_VARCHAR conversion.