Document fields containing arrays can now be indexed by setting array to true in an index fields definition.
Added support for the
NOT OVERLAPSoperators; which is equivalent to the SQL JSON_OVERLAPS() function.
These binary operators are used with a general "expression operator expression" syntax; and the expressions return a JSON array or object. Example usage: [1, 2, 3] overlaps $.list
Added support for the utf8mb4_0900_bin collation added in MySQL Server 8.0.17.
README.mdfile was split and reformatted with some content moved into the new
The SQL CAST function did not work as a valid lookup expression. (Bug #29807792)
Added backtick support for table column identifiers in valid expressions. (Bug #29789818)
NOTunary operators are now allowed; and are case-insensitive. (Bug #29771833, Bug #29771027)
The collection.dropIndex method now silently fails if the index does not exist, as expected, when before it generated a "Can't DROP" error. (Bug #29765589)
Column.getCollationName() would potentially return the incorrect name. (Bug #29704185)