Rank, 14 days: 3 on the Drizzle sheet
3 people reported
All time, since Oct 23.
Scalar jsonb inserts fail
“Users currently can't store top-level numbers/booleans in jsonb with bun-sql at all, unless they override codecs.”
Is this your bug? What gets counted gets fixed. Pile on.
Paste this into your agent. It files your report, with your error and version.
I hit this bug: rapsheet.dev/sheets/drizzle/issues/21061/file Follow it to file my report. Show me the text before you send.
No install. No account. Public and anonymous. The link asks your agent for one report, nothing else. What it sends
Top-level scalar values fail to insert into jsonb columns. Inserting through the query builder with the bun-sql or postgres-js driver fails; which top-level types fail varies by driver.
Is this your bug?
File my report- Where
- PostgreSQL drivers
- Error text
column "value" is of type jsonb but expression is of type boolean} catch (error: any) {Pasted in 2 reports- Versions
- 0.45.4 to 1.0.0-rc.5
- Platforms
- Linux
- How bad
- Breaks a normal workflow. Some reports say it used to work.
Not quite your bug?
- Select sends empty column list2 people
Original reports3, newest first
- bun-sql (PostgreSQL): json/jsonb values are double-encoded, or throw for numbers and booleans, proposed fix included#6600
- bun-sql: top-level number/boolean values fail to insert into jsonb columns in 1.0.0-rc.5#6591
- postgres-js: top-level boolean/Date/bigint values fail to insert into jsonb columns in 1.0.0-rc.5#6582