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.2

DownloadRelease NotesChangelogConnector/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 theAbout 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
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.