Fixes a predicate-subset bug where and(eq, isNull) wasn’t recognized as a subset of an OR superset, which could leave LiveQuery stuck “not ready” when offline in on-demand mode; this is done by reordering isWhereSubsetInternal checks so OR handling happens before AND decomposition. It also improves debugging by isolating forceDisconnectAndRefresh in its own try/catch so failures aren’t mislabeled as snapshot request errors. Main concerns are logical-regression risk from changing evaluation order in subset checks (potentially affecting other predicate combinations) and ensuring the new error-handling path doesn’t mask actionable failures beyond the intended deadlock/refresh optimization case.

Tightens TypeScript typing for collection utilities across Electric, Trailbase, PowerSync, and local-only collections so utils retain their concrete types through createCollection (especially when handler callbacks like onInsert/onUpdate/onDelete are present), and adds type-level tests to prevent regressions. This improves developer experience and correctness by avoiding widened UtilsRecord types and enabling safer autocomplete/compile-time guarantees across adapters. Main concerns are potential breaking type changes for downstream consumers relying on the previous widened behavior, plus the risk that overload/inference tweaks could expose new edge-case typing conflicts across different collection config shapes despite tests passing.

Fixes a bug where like/ilike patterns using % and _ failed to match values containing newline characters by enabling the RegExp dotAll (s) flag, aligning behavior with SQL LIKE semantics. This improves correctness of query filtering and adds both unit and e2e coverage plus a patch changeset. Main concern is reliance on duplicated evaluateLike logic (fixed in two places) and ensuring dotAll flag support/consistency across all target JS runtimes; otherwise behavior could diverge or regress.

Fixes manual transaction support for local-only collections by adding a utils.acceptMutations(transaction) helper that correctly filters mutations by collection ID and synchronously confirms them so optimistic changes become durable. This resolves cases where manual transactions would silently drop local-only mutations after mutationFn completed, and adds test coverage for mixed/manual-transaction scenarios. Concerns: the new confirmation path writes mutations through sync synchronously and relies on stable collection IDs—calling acceptMutations at the wrong time or misuse across collections could lead to unexpected persistence or ordering/duplication edge cases, so the API needs careful documentation and usage discipline.

Fixes a query-optimizer bug where pushing single-source WHERE predicates into the nullable side of an outer join changed semantics, causing .where(({ r }) => isUndefined(r?.payload)) after a leftJoin to keep all left rows by stripping matched right rows to undefined instead of filtering them out. This restores correct post-join filtering behavior for LEFT/RIGHT/FULL joins, adds targeted regression tests, and should prevent incorrect query results in affected join+filter patterns. Main concern is that reducing predicate pushdown on nullable join sides could impact performance or alter plans for some queries, so it’s worth watching for optimizer regressions and ensuring coverage across more complex outer-join/filter combinations.

@tanstack/vue-db@0.0.104 is a patch release that updates its core dependency to @tanstack/db@0.5.27. This pulls in upstream bug fixes (notably around outer-join WHERE predicate semantics, local-only manual transaction persistence, and LIKE/ILIKE newline matching) and some typing improvements, so apps should see more correct query behavior and better TypeScript ergonomics without API changes in vue-db itself.

@tanstack/powersync-db-collection@0.1.31 is a patch release that makes the collection utils types more precise across localOnly, PowerSync, Trailbase, and Electric collections. This improves type safety and developer experience for users/integrators (better inference and fewer type mismatches) and also updates the dependency on @tanstack/db to v0.5.27.

@tanstack/svelte-db@0.1.70 is a patch release that updates its dependency on @tanstack/db to v0.5.27. This should bring in upstream fixes and improvements with no expected API changes for most users, but integrators may want to re-run tests to confirm behavior stays consistent.

@tanstack/offline-transactions@1.0.17 is a patch release that only updates dependencies, bumping @tanstack/db to 0.5.27. No direct feature changes are called out, but integrators may see fixes or internal improvements coming from the updated db package.

Patch release that tightens TypeScript typings for collection utilities across localOnly, PowerSync, Trailbase, and Electric collections, improving correctness and autocomplete for integrators. Also bumps dependencies, including @tanstack/db to 0.5.27, with no expected runtime behavior changes—primarily a type-safety/maintenance update.

@tanstack/query-db-collection@1.0.24 is a patch release that primarily updates internal dependencies, bumping @tanstack/db to 0.5.27. This should be a low-risk update for users and integrators, mainly bringing along upstream fixes and improvements without changing the public API.