Changes in MySQL Connector/Node.js 8.0.17 (2019-07-22, General Availability)

• Functionality Added or Changed

• Bugs Fixed

Functionality Added or Changed

• Document fields containing arrays can now be indexed by setting array to true in an index fields definition. (WL #12295)

• Added support for the OVERLAPS and NOT OVERLAPS operators; these are equivalent to the MySQL JSON_OVERLAPS() function.

  The syntax employed for these binary operators take the form expression [NOT] OVERLAPS expression where each expression returns a JSON array or object. For example, [1, 2, 3] overlaps $.list. (WL #12745)

• Added support for the utf8mb4_0900_bin collation added in MySQL Server 8.0.17. (WL #13138)

• The bundled README.md file was split and reformatted with some content moved into the new README.txt and CONTRIBUTING.md files. (WL #13097)

Bugs Fixed

• The MySQL CAST function did not work as a valid lookup expression. (Bug #29807792)

• Added backtick (`) support for table column identifiers in valid expressions. (Bug #29789818)

• The DIV binary and NOT unary operators are now supported; these are case-insensitive. (Bug #29771833, Bug #29771027)

• Collection.find() now supports the JavaScript Date type. (Bug #29766014)

• The collection.dropIndex() method now silently fails if the index does not exist, as expected; previously, it raised a Can't DROP error. (Bug #29765589)

• In some cases, Column.getCollationName() returned the incorrect name. (Bug #29704185)