Trouble with DuckDB returns

Databases3 posts from 3 people3d active+00 posts in the last 7 days, 1 the 7 days before (fading)

Posts per day3 posts, Sep 22 to Oct 23

The posts behind it

3, newest first

GitHub issuesOct 13 Prepared 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 4 WHERE c1 ILIKE (CASE ...) is dropped by the optimizer and returns all rows### What happens? *Found by an automated fuzzing/triage agent; the repro is verified, but the analysis may be wrong.* The predicate `c1 ILIKE (CASE CAST(NULL AS BLOB) WHEN NULL THEN c1 END)` is dropped by the optimizer so `SELECT count(*) FROM t WHERE ...` returns 3 for a 3-row...duckdb/duckdb · suyZhongOpen ↗GitHub issuesSep 22 `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 ↗

Companies and products named

Named3 posts

DuckDB

About this problem

Evidence

3 posts from 3 people in 1 place, about 1 a week over 22 days. Mostly on duckdb/duckdb.

Frustration Frustration 0 of 3· Seen on GitHub issues

How it was grouped

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

Other DuckDB problems

Same product26 postsDuckDB upgrades break working setups Same product9 postsDuckDB error messages are cryptic Same product11 postsTrouble with DuckDB join Same product7 postsTrouble with DuckDB result Same product19 postsDuckDB users keep filing bugs Same product3 postsDuckDB lock-in makes switching costly Same product4 postsTrouble with DuckDB parquet Same product8 postsTrouble with DuckDB overflow Same product7 postsTrouble with DuckDB column Same product6 postsTrouble with DuckDB internal Same product5 postsTrouble with DuckDB null Same product4 postsDuckDB costs outgrow the value it gives

History

CorroborationOct 23, 2026unverified to corroborated

MomentumOct 11, 2026new to fading

AddedOct 7, 2026Trouble with DuckDB returns (1 post)