Data and AI struggles

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

Posts per day5 posts, Aug 31 to Oct 21

The posts behind it

5, newest first
GitHub issuesOct 13 8 days agoPrepared 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 ↗GitHub issuesOct 5 2 weeks agoEXPLAIN (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 ↗GitHub issuesOct 4 2 weeks agoParameterised 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 ↗GitHub issuesSep 22 4 weeks ago`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 ↗GitHub issuesSep 16 5 weeks agoIncorrect 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

History

MomentumOct 20, 2026steady to fading
MomentumOct 15, 2026fading to steady
MomentumOct 12, 2026steady to fading
MomentumOct 11, 2026rising to steady
AddedOct 7, 2026Trouble with DuckDB values (5 posts)