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.

Last updated

Was this helpful?