MariaDB Connector/Node.js 2.5.0 Release Notes

Download Release Notes Changelog Connector/Node.js Overview

Release date: 19 Oct 2020

MariaDB Connector/Node.js 2.5.0 is a Stable (GA) release.

For an overview of MariaDB Connector/Node.js see the About MariaDB Connector/Node.js page

Notable Changes

  • CONJS-148 - permit setting socket keep alive (option `keepAliveDelay`)
  • CONJS-143 - Array parameter escaping differ from mysql/mysql2
  • CONJS-133 - Support ES2020 BigInt object (option `supportBigInt`)
  • CONJS-77 - Support MySQL caching_sha256_password authentication
  • CONJS-76 - Support MySQL sha256_password authentication

New Options

optiondescriptiontypedefault
arrayParenthesisIndicate if array are included in parenthesis. This option permit compatibility with version < 2.5*boolean*false
rsaPublicKeyIndicate path/content to MySQL server RSA public key. use requires Node.js v11.6+*string*
cachingRsaPublicKeyIndicate path/content to MySQL server caching RSA public key. use requires Node.js v11.6+*string*
allowPublicKeyRetrievalIndicate that if `rsaPublicKey` or `cachingRsaPublicKey` public key are not provided, if client can ask server to send public key.*boolean*false
supportBigIntWhether resultset should return javascript ES2020 BigInt for BIGINT data type. This ensures having expected value even for value > 2^53 (see safe range).*boolean*false
keepAliveDelaypermit to enable socket keep alive, setting delay. 0 means not enabled. Keep in mind that this don't reset server @@wait_timeout (use pool option idleTimeout for that). in ms*int*

CONJS-143 is a breaking change. Queries that have a IN parameter with array parameters format change. previous format did not accept parenthesis :

conn.query('SELECT * FROM arrayParam WHERE id = ? AND val IN ?', [1, ['b', 'c']]);

now, format is

conn.query('SELECT * FROM arrayParam WHERE id = ? AND val IN (?)', [1, ['b', 'c']]);

same than mysql/mysql2 drivers. previous behaviour can be reverted setting option `arrayParenthesis` to true.

Bugs Fixed

  • CONJS-145 - batch rewrite error when packet reach maxAllowedPacket
  • CONJS-146 - Using callback API, batch, avoid return error if connection not established
  • CONJS-144 - TypeScript type ssl wrong definitions

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.