Known test gaps

Known test gaps Tests that exist but are skipped, and why. Each is skipped rather than asserted-to-pass so it cannot mask a real defect. Unfinished agent-written tests (2026-09-06) Eleven tests were written during a coverage push whose authoring agents were cut off mid-file by a rate limit. Their expectations were never reconciled against actual behaviour, so it is unknown whether each failure is a wrong expectation or a real bug. They are marked it.skip with an UNFINISHED: comment at the call site. File | Skipped | What to check | --- | --- | --- | tests/dialects/duckdb-builders.test.ts | 3 | [model, field] order pairs; dropPartition() child-table + metadata cleanup; whether RLS/security policies throw | tests/dialects/postgres-sql-builders.test.ts | 1 | createSequence schema-qualification and option ordering | tests/cli-io-prompt-keychain.test.ts | 7 | keychain backend selection (security vs secret-tool) — likely environment-dependent spawnSync stubbing rather than a product bug | To resolve one: run it, decide whether the expectation or the code is wrong, then either fix the expectation or file the bug and keep it skipped with a // BUG: note. Do not simply rewrite the assertion to match current output — that is how a silent defect gets frozen in. One test from the same batch was resolved: trino-builders.test.ts expected CREATE TABLE … "day" DATE from a column declared { type: 'DATEONLY' }. The product is correct — a raw string type is passed through verbatim by design, and DATEONLY is a DataTypes key, not a SQL type. The test now uses DataTypes.DATEONLY() and asserts DATE, which is what actually exercises the type mapper. Integration suites (pre-existing) 13 suites / 510 tests are gated on INTEGRATION=1 and need live services (PostgreSQL, MySQL, MariaDB, SQL Server, CockroachDB, ClickHouse, Oracle, Elasticsearch, Qdrant, etcd, InfluxDB, Neo4j, Weaviate, ArangoDB). Start them with npm run test:db:up, then npm run test:integration. They skip by design when docker is not running. Related reading Going further — the rest of the reference material