Skip to content

v4.1.0

Choose a tag to compare

@lehni lehni released this 17 Oct 09:58
· 25 commits to main since this release

All changes are in the changelog.

Changes

  • On PostgreSQL, JSON field expressions with a single key use -> / ->> instead of #> / #>>, so expression indexes like ((props->>'points')) match them. An index built on the #>>'{key}' form needs to be rebuilt with ->>.

Fixes

  • ref().castText() on JSON paths works with mysql2 on MySQL, e.g. in JSON relation joins
  • JSON keys with backslashes read the right values on PostgreSQL with standard_conforming_strings off
  • In strict mode, editors suggest column names in where({ }), findOne({ }) and having({ })