Changes in MySQL Connector/Node.js 8.0.22 (2020-10-19, General Availability)

• Deprecation and Removal Notes

• Functionality Added or Changed

• Bugs Fixed

Deprecation and Removal Notes

• Deprecated the dbPassword and dbUser property names, which were aliases for, respectively, the password and user properties. Using the old names now raises deprecation errors. (Bug #31599660)

Functionality Added or Changed

• Test execution configuration has been aligned with that of other MySQL Connectors. This includes unifying environment variable names; for example, NODE_TEST_MYSQL_HOST has been changed to MYSQLX_HOST. See the Connector/Node.js documentation for more information. (WL #13854)

Bugs Fixed

• Values of types other than BIGINT which were stored in BIGINT columns were not decoded properly in result sets. (Bug #31686805, Bug #100324)

• Fetched results from a SET column contained only one value from the set. (Bug #31654667, Bug #100255)

• Added a SERVER_GONE error handler to avoid potential circular dependency warnings with Node.js 14.0.0 and later. (Bug #31586107, Bug #99869)

• The offset() method is now available only with CollectionFind and TableSelect, as described in the X DevAPI specification. Using offset() with other interfaces yielded the error Error: The server has gone away. The intended behavior is available by using a combination of either sort() or orderBy(), together with limit(). (Bug #31418813)

• The nextResult() method returned false when used with an empty result set; in such cases, it now returns true. To check whether a result set contains data, use the hasData() method. (Bug #31037211)

• The column.getType() method returned the numeric value for a type identifier; now it returns the type identifier's name. For example, the method now returns DATETIME, rather than 12 as before. (Bug #30922711)

• Improved memory management for work performed by third-party APIs. (Bug #30845472)

• Added support for “lazy” decoding of binary column metadata. (Bug #30845366)