Trouble with DuckDB json

Databases3 posts from 3 people3d active+11 post in the last 7 days, 1 the 7 days before (steady)

Posts per day3 posts, Sep 3 to Sep 25

The posts behind it

3, newest first

Post	Where	Date
VARIANT: UPDATE of a deeply nested value is quadratic in depth (15 s at 5,000 levels), and the JSON -> VARIANT cast segfaults at ~40,000## Summary Two things, both only with a `VARIANT` holding very deeply nested JSON. This is an esoteric input, no real document looks like it, but it is 10-80 KB of text that anyone who can send JSON to a service can send, and the second one takes the process down. A depth limit...duckdb/duckdbshreeve	duckdb/duckdbshreeve	Sep 214 days ago
Casting a VARIANT to JSON turns SQL NULL into the non-NULL string 'null'### What happens? Casting a `VARIANT` column to `JSON` does not preserve SQL NULL. A NULL row becomes the JSON literal `null`, whose text is the four-character string `'null'` - an ordinary non-NULL value to everything downstream. `count()` counts it, `IS NULL` does not find it,...duckdb/duckdbhanke580	duckdb/duckdbhanke580	Sep 178 days ago
json_serialize_sql rejects dynamic PIVOT statements### What happens? `json_serialize_sql()` cannot serialise a valid `PIVOT` query when its pivot values are discovered from the data. The `PIVOT` query executes successfully, but passing the same query to `json_serialize_sql()` returns: Specifying the pivot values explicitly (e.g....duckdb/duckdbdaverigby	duckdb/duckdbdaverigby1 reactions	Sep 33 weeks ago

Companies and products named

Company or product	Posts naming it
DuckDB	3
GitHub	1

About this problem

Evidence

3 posts from 3 people in 1 place, about 1 a week over 19 days. Mostly on duckdb/duckdb. Tools named alongside: GitHub.

Frustration Frustration 0 of 3· Seen on GitHub issues

How it was grouped

Posts about DuckDB with no known issue, sharing the word "json". First post Sep 3, 2026, latest Sep 21, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method

Posts per day

The posts behind it

Companies and products named

Rising problems by email