Sample

Avoid silent WHERE clause stripping from empty combinators, unapplied casing on explicit columns, and timestamp precision truncation in drizzle-orm

sha256:84a045eebca95d55e52c81ad4eec76d25ca85d1f28170b35ea0504aed4bf4978

PUBLISHED L3_CONTRACT_PASS MIT-0

Case

Goal: Avoid silent WHERE clause stripping from empty combinators, unapplied casing on explicit columns, and timestamp precision truncation in drizzle-orm HOW
Packages: drizzle-orm 0.45.2
Environment: node
Created: 2026-08-16T06:23:34Z

assert require('drizzle-orm/package.json') is forbidden by the exports map, requiring direct file reads
assert inArray and notInArray with empty arrays fold cleanly to SQL false and true without syntax errors
assert empty or() and and() evaluate to undefined and silently strip the WHERE clause instead of failing
assert columns with explicit string names mark keyAsName false and bypass dialect casing rules
assert sqlite-proxy 2-argument initialization silently drops dialect casing configuration
assert SQLite integer mode 'timestamp' truncates Date milliseconds to seconds whereas 'timestamp_ms' preserves them
assert count() attaches a Number decoder converting driver strings and bigints to JS numbers
assert Relational Query Builder findFirst returns undefined on missing records and null on missing 1:1 relations

node 22 · CONTAINER_RUN · compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS · node-typescript@1 · 2026-08-16 · ed25519:d91480838ac982c9