SingleStore ODBC Connector v1.2.0

SingleStore ODBC Connector v1.2.0

The main purpose of this release is dependencies update (OpenSSL and Zlib).

What's Changed

• Changed KILL to KILL CONNECTION using node_id by @vmittal-ss in #25
• Update zlib to 1.3.1 by @pmishchenko-ua in #30
• Update build files to link to OpenSSL 3 libraries. This would be a BREAKING CHANGE for older systems
• Minor improvements to the GitHub Workflows

Installation

Please refer to SingleStore documentation for installation instructions.

Downloads

• Linux (Ubuntu): singlestore-connector-odbc-1.2.0-ubuntu-*.tar.gz
• Linux (CentOS/RHEL): singlestore-connector-odbc-1.2.0-centos-*.tar.gz
• macOS: singlestore-connector-odbc-1.2.0-macos-*.pkg
• Windows: singlestore-connector-odbc-1.2.0-win*.msi

New Contributors

• @vmittal-ss made their first contribution in #25

Full Changelog: v1.1.7...v1.2.0

SingleStore Connector/ODBC 1.1.7

• Fix SQLGetData for reading BIGINT data with SQL_C_DEFAULT output parameter type
• Add option to use WCHAR types to read fields asked with SQL_C_DEFAULT in SQLGetData
• Fix skipping error if it comes after the result set
• Misc fixes for metadata methods and some other:
  • Remove SQL_AUTO_IS_NULL usage
  • Fix setting connection charset
  • Cap LONGTEXT size by 1 GB in MADB_SetIrdRecord and MADB_PROCEDURE_COLUMNS
  • Resolve TODOSs in SQLColumns
  • Fix precision for Double and Float
  • Fix SQLGetTypeInfo for VARCHAR

SingleStore Connector/ODBC 1.1.6

• Fixed the issue where error messages from the server are not returned if they are too long (more than 492 bytes long). Now they are truncated so that the total length of the message and prefix (it has the form [ss-1.1.6][8.5.24]) is not larger than 512.
• Added ECHO query type so that it's possible to execute queries of the form ECHO my_stored_procedure(...)
• Added a boolean DSN option REWRITE_CALL_SP. If this parameter is set to true, then queries of the form CALL my_stored_procedure(...) are sent to the database as ECHO my_stored_procedure(...). This is needed for the users of third-party tools that want to get the result of the stored procedure, while the third-party tool is running it with CALL. If REWRITE_CALL_SP option is set for a DSN, the user must have RETURN clause in all their SPs that are invoked using this DSN.

SingleStore Connector/ODBC 1.1.5

This release contains the following changes

• Fixed SQLSpecialColumns with SQL_ROWVER IdentifierType
• Improved cleanup for emulated statements and added OPTIMIZE query type
• Split parameter array into batches when using INSERT query to fix the error Query cannot be completed because of Parameter Array capacity of 1048576 which is generated when large parameter arrays are used

SingleStore Connector/ODBC 1.1.4

• Introduced a possibility connect with JWT without supplying UID (SingleStoreDB supports this starting from 8.1.20)
• Cnahged SQLCancel to send query KILL QUERY <thread_id> <aggregator_id> instead of KILL QUERY <thread_id>
• Added installation package for arm64-based Mac OS (M1, M2)

SingleStore Connector/ODBC 1.1.4-beta

• Added CONVERT_FROM_LATIN option that forces the driver to convert parameters from latin1 to UTF-8 before sending them to the database.

SingleStore Connector/ODBC 1.1.3

• In order to identify programs using ODBC connector, we now pass connection attributes along with a new parameter that allows setting connection attributes for third-party apps
• Added gssapi auth plugin to Linux packages

SingleStore Connector/ODBC 1.1.2

• Added a 32-bit Windows version of the driver
• Fixed a bug that caused a crash on calling SQLPrimaryKeys for an information_schema table
• Made libsecret and libglib (used for SSO) loading on-demand.
• Optimize running statements of the form INSERT INTO <table_name> VALUES (?,...,?) with SQL_ATTR_PARAMSET_SIZE set. Instead of sending each paramset row in a separate query, we join the rows and send them in one query

SingleStore Connector/ODBC 1.1.1

• Performance improvements for reading query result

SingleStore Connector/ODBC 1.1.0

• Added support for Single Sign-On Authentication to database servers on SingleStore Cloud
• Fixed a few bugs for multi-statement queries
• Fixed SQL_ATTR_MAX_ROWS usage in non-SELECT statements
• Fixed crash on Mac when iODBC tried to list installed ODBC drivers