Problemsby IbisTrouble with DuckDB null
Databases5 posts from 5 people4d active+00 posts in the last 7 days, 2 the 7 days before (fading)
Posts per day
The posts behind it
5, newest firstAttempted to dereference shared_ptr that is NULL!### What happens? run these 3 sql in duckdb cli, Attempted to dereference shared_ptr that is NULL! ### To Reproduce ### OS: x86_64 ### DuckDB Version: v1.5.5 ### DuckDB Client: cli ### Hardware: _No response_ ### Full Name: singlespark6979 ### Affiliation: OBase ### Did you...duckdb/duckdb · singlespark6979Open ↗skewness() and kurtosis() return huge garbage instead of NULL for constant input once n >= 19### What happens `skewness()` returns huge garbage instead of `NULL` for constant input (variance 0) once the group has about 19 or more rows. For smaller groups the result is `NULL` as expected. The implementation accumulates raw sums of powers (`sum`, `sum_sqr`, `sum_cub`) in...duckdb/duckdb · h4nsmullerOpen ↗ManualVuln25 Null Dereference in PIVOT IN List Binding via Zero-Argument row() Function### What happens? In `TransformPivotInList` (`src/parser/peg/transformer/transform_select.cpp`, lines 469-497), the FUNCTION case checks whether the function name is "row" and then iterates over its child arguments. When `row()` is called with zero arguments, the loop body never...duckdb/duckdb · ylwango613Open ↗DuckDB: `HAVING` of `(φ IS TRUE) OR NOT (φ IS TRUE) AND …` is empty for a NULL `φ`, but the same boolean as `ref1` keeps the group### What happens? For a NULL boolean, `(TRY_CAST(c0 AS BOOLEAN) IS TRUE) OR NOT (TRY_CAST(c0 AS BOOLEAN) IS TRUE) AND …` is `TRUE` in the SELECT list. `HAVING` of that predicate drops the group. Filtering `WHERE ref1` on the same boolean as a derived column keeps the group. The...duckdb/duckdb · Manuel-Neuer11 repliesOpen ↗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/duckdb · hanke580Open ↗
Companies and products named
About this problem
Evidence
5 posts from 5 people in 1 place, about 1 a week over 28 days. Mostly on duckdb/duckdb.
Frustration Frustration 2 of 3· Seen on GitHub issues
How it was grouped
Posts about DuckDB with no known issue, sharing the word "null". First post Sep 17, 2026, latest Oct 14, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
Other DuckDB problems
DuckDB upgrades break working setupsDuckDB users keep filing bugsTrouble with DuckDB columnTrouble with DuckDB overflowDuckDB error messages are crypticTrouble with DuckDB internalTrouble with DuckDB valuesTrouble with DuckDB castTrouble with DuckDB resultDuckDB runs out of memoryDuckDB costs outgrow the value it givesDuckDB permissions are confusing and error-prone
History
rising to fading
steady to rising
fading to steady
steady to fading
Trouble with DuckDB null (3 posts)