DuckDB fails to return valid structured output
2 posts from 2 people2d activeSteady, +1 this weekunverified
Posts per day
The posts behind it
Malformed JSON error message is invalid UTF-8 when the input is cut inside a multi-byte character
### What happens? When a JSON input over 50 bytes fails to parse, the error message includes its first 47 bytes. If byte 47 is in the middle of a multi-byte character, the message keeps only the first byte of that character, so the message is not valid UTF-8. In Python this...
Casting `variant_extract(v, 'k')` to JSON on a shredded VARIANT column parses the string instead of serializing it: `"true"` becomes the boolean `true`, `"x"` raises Malformed JSON
### What happens? On a VARIANT column whose row group has been **shredded** (at or above `variant_minimum_shredding_size`, default 30 000 rows), `variant_extract(v, 'k')::JSON` for a string-valued key returns the string's *contents parsed as JSON* rather than the string as a...
Companies and products named
About this problem
Evidence
2 posts from 2 people in 1 place, about 1 a week over 46 days. Mostly on duckdb/duckdb.
Frustration Frustration 0 of 3· Seen on GitHub issues
How it was grouped
Posts that state a pain and match the "structured-output" rule about DuckDB. First post Oct 3, 2026, latest Nov 17, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
The same problem elsewhere
Models fail to return valid structured output
19 posts from 17 people on GitHub issues.
Claude fails to return valid structured output
15 posts from 12 people on GitHub issues.
OpenAI fails to return valid structured output
12 posts from 12 people on GitHub issues, Hacker News.
Anthropic fails to return valid structured output
6 posts from 6 people on GitHub issues.
Codex fails to return valid structured output
6 posts from 3 people on GitHub issues.
LangChain fails to return valid structured output
5 posts from 4 people on GitHub issues.
LlamaIndex fails to return valid structured output
5 posts from 5 people on GitHub issues.
Model Context Protocol fails to return valid structured output
5 posts from 5 people on GitHub issues, Reddit.
vLLM fails to return valid structured output
5 posts from 5 people on GitHub issues.
Ollama fails to return valid structured output
4 posts from 3 people on GitHub issues.
Gemini fails to return valid structured output
4 posts from 4 people on GitHub issues, Reddit.
Mistral fails to return valid structured output
3 posts from 3 people on GitHub issues.
Other DuckDB problems
DuckDB upgrades break working setups
55 posts from 42 people on GitHub issues.
Trouble with DuckDB join
Top post: "Wrong result: join_elimination drops a LEFT JOIN below a LIMIT/OFFSET under a DISTINCT", one of 12 posts from 11 people on GitHub issues.
Trouble with DuckDB returns
Top post: "Segfault in `dense_rank() OVER ()` over a RIGHT_ANTI hash join that returns its unmatched rows", one of 21 posts from 16 people on GitHub issues.
DuckDB feels slow and laggy
3 posts from 3 people on GitHub issues, Reddit.
DuckDB queries run too slowly and are hard to tune
3 posts from 3 people on GitHub issues.
Trouble with DuckDB cast
Top post: "TRY_CAST of an empty BLOB to BIT escapes a non-fallible __cast and invalidates the database", one of 11 posts from 9 people on GitHub issues.
Trouble with DuckDB internal
Top post: "duckdb 2.0.0 fails to launch on BE: `INTERNAL Error: The time zone data is corrupt`", one of 20 posts from 12 people on GitHub issues.
DuckDB error messages are cryptic
12 posts from 8 people on GitHub issues.
Experiments on DuckDB are hard to reproduce and track
11 posts from 7 people on GitHub issues.
DuckDB users keep filing bugs
Top post: "Support duckdb 2", one of 10 posts from 9 people on GitHub issues.
Trouble with DuckDB column
Top post: "2.0 alpha: comparing a CASE/split_part result to a constant fails with BindBuiltinScalarFunction did not", one of 8 posts from 5 people on GitHub issues.
Trouble with DuckDB null
Top post: "DuckDB: `HAVING` of `(φ IS TRUE) OR NOT (φ IS TRUE) AND …` is empty for a NULL `φ`, but the same boolean as", one of 7 posts from 7 people on GitHub issues.
History