Release Notes for MariaDB Connector/C++ 1.0.2

Overview

MariaDB Connector/C++ is the interface between C++ applications and MariaDB Server. MariaDB Connector/C++ enables development of C++ applications using a JDBC-based API, which is also used by MariaDB Connector/J.

MariaDB Connector/C++ 1.0.2 was released on 2022-10-11. This release is of General Availability (GA) maturity.

MariaDB Connector/C++ implements the MySQL protocol using the MariaDB Connector/C API. This release depends on MariaDB Connector/C 3.3.2.

Notable Changes

  • Added support of two optimized modes of executeBatch/executeLargeBatch PreparedStatement methods execution: (CONCPP-106)

    • rewriteBatchedStatements connection option

    • useBulkStmts connection option

rewriteBatchedStatements

  • When using the rewriteBatchedStatements connection option, for INSERT queries the connector will construct a single query using batch parameter sets. For example:

    INSERT INTO ab (i) VALUES (?) with first batch values = 1, second = 2
    

    will be rewritten as:

    INSERT INTO ab (i) VALUES (1), (2)
    

    If the query cannot be rewritten in multi-values, the rewriteBatchedStatements connection option will use multi-queries. For example:

    INSERT INTO ab(col1) VALUES (?) ON DUPLICATE KEY UPDATE col2=? with values [1,2] and [2,3]
    

    will be rewritten as:

    INSERT INTO ab(col1) VALUES (1) ON DUPLICATE KEY UPDATE col2=2;INSERT INTO TABLE(col1) VALUES (3) ON DUPLICATE KEY UPDATE col2=4
    
  • If the rewriteBatchedStatements connection option is selected, the useServerPrepStmts option is set to false.

  • If both rewriteBatchedStatements and useBulkStmts options are selected, rewriteBatchedStatements takes precedence.

useBulkStmts

  • The useBulkStmts connection option uses the MariaDB bulk execution feature, so it requires MariaDB Server 10.2.7 or later. useBulkStmts will be used even if useServerPrepStmts is not set, in other words, if the default statement prepare method is client-side prepare.

  • If both useBulkStmts and rewriteBatchedStatements options are selected, rewriteBatchedStatements takes precedence.

Issues Fixed

  • Attempting connections from multiple threads causes the connector to crash. (CONCPP-105)

  • PreparedStatement setDouble only processes the first 6 significant digits and zeros any additional digits. (CONCPP-96)

  • Result-set streaming is not supported in this release series, but setting setFetchSize does not throw an exception and can cause the application to crash.

    • Starting with this release, setting setFetchSize will throw SQLFeatureNotImplementedException at the attempt to set fetch size >0 (CONCPP-107)