rogerpadilla / uql / 30230650503

97%

push

github

feat(orm): $set/$pull JSON operators, typed comparisons, vector index guard

- Rename $merge to $set (shallow key assignment, matching MongoDB's own
  $set); add $pull to remove array elements; unify $push to always create
  a missing array (MariaDB previously nulled the whole column).
- Map $set/$unset/$push/$pull onto MongoDB's native update operators
  instead of writing the operator object into the document as literal
  data; falls back to an aggregation pipeline when a path is touched by
  more than one operator group, in the same $pull->$set->$push->$unset
  order the SQL dialects apply.
- Require `distance` on vector index types (hnsw/ivfflat/vector) and
  reject it on every other type - omitting/adding it silently changed
  generated DDL.
- Fix JSON dot-path and $elemMatch bugs: MySQL dot-paths never worked at
  runtime, MariaDB array operators emitted invalid SQL, SQLite $all never
  matched string elements, typed scalar comparisons (numbers/booleans)
  were inconsistent across engines, and $elemMatch's plain-equality form
  skipped the numeric cast and turned `null` into `= NULL`.
- Fix $includes rendering as ILIKE instead of LIKE on PostgreSQL/
  CockroachDB, and PostgreSQL full-text search failing on multi-word
  queries (to_tsquery -> websearch_to_tsquery).
- Simplify JSON dialect internals: unify jsonCast/jsonScalarParam, extract
  pure builders into dialect/jsonSql.ts, add a single jsonCompareMode
  classifier. Share the JSON-update test matrix and MySQL/MariaDB spec
  bodies across dialect specs. Unify vector types into type/vector.ts and
  close a type hole in IndexTypeOptions.

Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>

3396 of 3751 branches covered (90.54%)

Branch coverage included in aggregate %.

208 of 214 new or added lines in 14 files covered. (97.2%)

5775 of 5901 relevant lines covered (97.86%)

721.91 hits per line