Release Notes for MariaDB Connector/ODBC 3.1.16

Overview

MariaDB Connector/ODBC is a standard ODBC driver for building cross-platform applications on top of MariaDB database products. It is compliant with ODBC 3.5. It is written in C and uses MariaDB Connector/C.

MariaDB Connector/ODBC 3.1.16 was released on 2022-06-22. This release is of General Availability (GA) maturity.

Notable Changes

  • A failover feature has been added. It is now possible to provide a comma separated list of hosts as a server name, for simple failover in case one or more hosts are not available. The failover feature requires using MariaDB Connector/ODBC with MariaDB Connector/C 3.3 or greater. (ODBC-366)

    The following syntax is required:

    • IPv6 addresses must be enclosed within square brackets "[]"

    • hostname and port must be separated by a colon ":"

    • hostname:port pairs must be be separated by a comma ","

    • if only one hostname:port is specified, the host string must end with a comma

    • if no port is specified, the default port will be used

    Example for failover host string:

    [::1]:3306,192.168.0.1:3307,test.example.com

  • MariaDB Connector/ODBC 3.1.16 is statically linked for Windows and macOS with MariaDB Connector/C 3.3.1

  • MariaDB Connector/ODBC 3.1.16 is dynamically linked for Linux with MariaDB Connector/C. MariaDB Connector/C versions 3.2 or greater can be used, but version 3.3 or greater is required for the failover feature.

  • The NULLISCURRENT connection string option has been added. NULLISCURRENT allows forcing a NULL catalog name value to be treated as the currently selected schema in SQLTables(). If NULLISCURRENT is not used, a NULL catalog name value is treated as "any" schema and SQLTables() returns tables from all databases. (ODBC-298)

  • The NOLOCALINFILE connection string option has been added. A non-zero value for NOLOCALINFILE disables LOAD DATA LOCAL INFILE execution. A zero value enables it. By default LOAD DATA LOCAL INFILE is enabled. (ODBC-347)

  • Release tarball layout has been cleaned up and re-organized. (ODBC-352)

Issues Fixed

  • If the NULL SQL_C_WCHAR buffer is bound in SQLBindCol to obtain the required buffer length, a segmentation fault can occur. (ODBC-359)

  • MariaDB Connector/ODBC package for macOS is missing the Connector/C runtime library. (ODBC-346)

  • Fixed use of indexes in search for the best row identifier for positioned operations. (ODBC-356)

  • Connecting to some server versions that do not support session tracking causes an Unknown system variable 'session_track_schema' error. In particular, this bug occurs if connecting to MariaDB Xpand. (ODBC-328)

  • If a UNIQUEUNIQUE index on a nullable column is used, MS Access could pick up that index for use and get wrong data. (ODBC-361)

Installation