Trouble with DuckDB values
Databases5 posts from 5 people5d active+00 posts in the last 7 days, 1 the 7 days before (fading)
Posts per day
The posts behind it
5, newest firstPrepared statement returns no rows for a parameter filter over a partitioned window on a VALUES list### What happens? A prepared statement that filters on a parameter above a window partitioned by the same column returns 0 rows when the window reads a `VALUES` list. It should return one row. It returns the correct row with a literal instead of `$1`, with a table instead of...duckdb/duckdb · bullfightOpen ↗EXPLAIN (SQL) emits `VALUES ()` for a materialized relation whose columns are all pruned### What happens? `EXPLAIN (SQL)` produces SQL that does not parse when a materialized relation (a `LogicalColumnDataGet`, e.g. a `DESCRIBE` subquery) has all of its columns pruned. Each row is exported as an empty tuple, giving `VALUES ()`: Running the generated SQL fails: The...duckdb/duckdb · rustyconoverOpen ↗Parameterised statements against an attached quack catalog fail on 2.0-dev: remote_pushdown ships $1/? placeholders without values### What happens? `PREPARE` of any statement with parameters, against an attached quack catalog, fails: `Invalid Input Error: Values were not provided for the following parameters: 1, 2` Statements without parameters work. ### To Reproduce Shell 1, the server: Shell 2, the...duckdb/duckdb · dorzeyOpen ↗`FILL` returns different extrapolation results for `BIGINT` and `DOUBLE` when values decrease### What happens? `FILL` returns `-23` instead of `-9` when extrapolating a trailing `NULL` from the points `(1, 19)` and `(2, 5)`. This reproduces on both the latest stable release and the latest nightly build tested: - v1.5.5 (`d8cdaa33fd`) - v2.0.0-alpha42986 (`d4e72566aa`)...duckdb/duckdb · Yibo-Dong1 repliesOpen ↗Incorrect results: equal VARIANT values report different types depending on whether their row group was shredded### What happens? `variant_typeof(v)` and `CAST(v AS VARCHAR)` render an object's keys in *physical* storage order. That order differs between a shredded row group (keys sorted) and an unshredded one (keys in insertion order), so two rows holding **the same value** describe...duckdb/duckdb · hanke5801 repliesOpen ↗
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. Tools named alongside: Shell, AWS.
Frustration Frustration 0 of 3· Seen on GitHub issues
How it was grouped
Posts about DuckDB with no known issue, sharing the word "values". First post Sep 16, 2026, latest Oct 13, 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 nullTrouble with DuckDB castTrouble with DuckDB resultDuckDB runs out of memoryDuckDB costs outgrow the value it givesDuckDB permissions are confusing and error-prone
History
steady to fading
fading to steady
steady to fading
rising to steady
Trouble with DuckDB values (5 posts)