rogerpadilla / uql / 29158059857

97%

push

github

feat(cockroachdb): add integration tests and full vector search support

Adds live-DB integration test coverage for CockroachDB (previously
untested), which surfaced and fixed several real bugs:

- upsertOne/upsertMany were completely broken (relied on Postgres's
  xmax system column, which CockroachDB doesn't have)
- auto-generated IDs used SERIAL (CockroachDB's unique_rowid()),
  producing values that overflow Number.MAX_SAFE_INTEGER and get
  silently corrupted as JS numbers; now uses a sequential IDENTITY
  column instead
- $text full-text search never worked; now generates
  to_tsvector/to_tsquery, which CockroachDB supports
- $merge/$push on a JSONB column via the Bun SQL driver could
  corrupt the value or throw, since CockroachDB didn't get the same
  wire-encoding fix Postgres has on that driver

Also adds full vector search support for CockroachDB: $sort/$vector
uses the same pgvector-compatible distance operators as Postgres,
and schema generation emits CockroachDB's native CREATE VECTOR INDEX
syntax.

Refactors the dialect hierarchy so CockroachDialect and
PostgresDialect share a common PgLikeSqlDialect base (mirroring the
existing MySqlLikeSqlDialect pattern) instead of CockroachDialect
extending PostgresDialect directly.

Also fixes MariaDB's upsert `created` detection on the Bun SQL
driver, which could report false on a fresh insert instead of
undefined.

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

3264 of 3613 branches covered (90.34%)

Branch coverage included in aggregate %.

115 of 118 new or added lines in 5 files covered. (97.46%)

5652 of 5776 relevant lines covered (97.85%)

460.82 hits per line