Changes in MySQL Connector/Node.js 8.0.8 (2017-09-28, Development Milestone)

• Functionality Added or Changed

• Bugs Fixed

Functionality Added or Changed

• The following Collection methods were added: replaceOne(), addOrReplaceOne(), getOne(), and removeOne(). For details, see Tutorial: Working with Documents. (WL #10903)

• lockExclusive() and lockShared() methods have been added in this release to the CollectionFind and TableSelect classes to provide row locking support. For additional information, see Tutorial: Row Locking. (WL #10902)

• Connector/Node.js now provides extended authentication support, including SHA-256. For additional information, see Tutorial: Secure Sessions. (WL #10757)

• Added containment operator support for objects and arrays. This allows additional types of expressions such as IN [x, y, z] and IN { "x": "foo", "y": "bar" }, as well as expressions referencing field names that map to arrays and objects, such as someArray IN $.field and someObject IN $.field. (WL #10901)

Bugs Fixed

• Added support for parenthetical IN syntax, such as IN (x, y, z, ...), as defined by the X DevAPI. (Bug #26666817)