You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The same query yields different results using bun:sqlite compared to better-sqlite3 on Node. The bun:sqlite result is wrong - it has mismatched values and keys. The query uses two left joins.
I don't think this is a bug in Bun, since the problem is caused by joined table column names overriding the original table column names. JS objects can't have the same key twice so the behavior is the same in bun:sqlite and better-sqlite3 when used directly, without Drizzle - the columns are overridden.
Drizzle seems to mitigate this behavior in better-sqlite3 driver, but it doesn't do that in bun:sqlite one.
What version of
drizzle-orm
are you using?0.30.10
What version of
drizzle-kit
are you using?No response
Describe the Bug
The same query yields different results using
bun:sqlite
compared tobetter-sqlite3
on Node. Thebun:sqlite
result is wrong - it has mismatched values and keys. The query uses two left joins.Reproduction: https://github.com/rev4324/drizzle-repro
Expected behavior
Both drivers should yield the same results.
Environment & setup
I'm using macOS 14.4.1 (23E224) ARM64.
The text was updated successfully, but these errors were encountered: