TanStack/db @tanstack/db@0.5.27

on GitHub

Patch Changes

• fix(db): don't push WHERE clauses to nullable side of outer joins (#1254)

  The query optimizer incorrectly pushed single-source WHERE clauses into subqueries and collection index optimization for the nullable side of outer joins. This pre-filtered the data before the join, converting rows that should have been excluded by the WHERE into unmatched outer-join rows that incorrectly survived the residual filter.

• Fixed acceptMutations not persisting data in local-only collections with manual transactions. The mutation filter was comparing against a stale null collection reference instead of using the collection ID, causing all mutations to be silently dropped after the transaction's mutationFn resolved. (#1253)

• Fix like/ilike % and _ not matching newline characters (#1263)

• Make type of collection utils more precise for localOnly, PowerSync, Trailbase, and Electric collections (#1236)