Skip to content
Problems.

Trouble with DuckDB results

Databases4 posts from 3 people3d active+11 post in the last 7 days, 1 the 7 days before (steady)

Posts per day

Posts per day4 posts, Aug 31 to Sep 25

The posts behind it

4, newest first
PostDate
`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/duckdbYibo-DongSep 223 days ago
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/duckdbhanke580Sep 169 days ago
Unexpected results when comparing a LIST column### What happens? *Found by an automated fuzzing/triage agent; the repro is verified, but the analysis may be wrong.* In a single LIST column, two identical values compared against the same constant return different answers. With rows `[]`, `[-2, -1]`, `[-2, -1]`, the predicate...duckdb/duckdbsuyZhongAug 313 weeks ago
Unexpected results when a sampled scan of an indexed column filtered by `IN (VALUES ...)`### What happens? On a 16384-row table with an index on `c1`, `TABLESAMPLE SYSTEM (10%) REPEATABLE (7)` returns 0 rows, and `WHERE c1 = true` over that sample also returns 0. The logically equivalent `WHERE c1 IN (VALUES (true))` returns 2048 - the count of matching rows in the...duckdb/duckdbsuyZhongAug 313 weeks ago

Companies and products named

Company or productPosts naming it
DuckDB4
About this problem

Evidence

4 posts from 3 people in 1 place, about 1 a week over 23 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 "results". First post Aug 31, 2026, latest Sep 22, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method

History

  • 2026-09-25 Added: Trouble with DuckDB results (4 posts)

Rising problems by email

Mondays: the problems in data, tech and AI that grew fastest that week.

Double opt-in. Unsubscribe any time.