MariaDB Connector/Node.js 2.5.0 Release Notes
The most recent Stable (GA) release of MariaDB Connector/Node.js is:
MariaDB Connector/Node.js 3.4.0
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
| option | description | type | default |
|---|---|---|---|
| arrayParenthesis | Indicate if array are included in parenthesis. This option permit compatibility with version < 2.5 | *boolean* | false |
| rsaPublicKey | Indicate path/content to MySQL server RSA public key. use requires Node.js v11.6+ | *string* | |
| cachingRsaPublicKey | Indicate path/content to MySQL server caching RSA public key. use requires Node.js v11.6+ | *string* | |
| allowPublicKeyRetrieval | Indicate that if `rsaPublicKey` or `cachingRsaPublicKey` public key are not provided, if client can ask server to send public key. | *boolean* | false |
| supportBigInt | Whether 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 |
| keepAliveDelay | permit 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.
