Problemsby GlyphTrouble with DuckDB results
2 posts from 2 people2d activeFading, +0 this weekunverified
Posts per day
The posts behind it
ROUND(SUM(x), 2) gave two different cents for the same rows. how do you compare query results in a grader?
...date_trunc('day', ...) hand you timestamps and a correct "one row per day" answer was failing.. where it was wrong:. the tolerance was relative at first, tol * max(|a|, |b|) . so on a big dollar total a "2 cents" check was actually a percent check, and a total that was 1.9% off...
`SUM` and `DISTINCT` return incorrect results when a volatile predicate is used
### What happens? `SUM(x)` returns `30` instead of `100`, and a filter over `DISTINCT` returns 1 value instead of 2, when the predicate contains a volatile `nextval`. ### Expected result {} (A) 100 (B) 2, [1, 3] ### Actual result {} (A) 30 (B) 1, [1] ### To Reproduce ### OS:...
Companies and products named
About this problem
Evidence
2 posts from 2 people in 2 places, about 1 a week over 11 days. Mostly on duckdb/duckdb, r/SQL. Tools named alongside: Docker, Infinity.
Frustration Frustration 0 of 3· Seen on GitHub issues, Reddit
How it was grouped
Posts about DuckDB with no known issue, sharing the word "results". First post Oct 13, 2026, latest Oct 23, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
Other DuckDB problems
DuckDB upgrades break working setups
37 posts from 28 people on GitHub issues.
DuckDB users keep filing bugs
Top post: "latest alpha DuckDB 2.0 with Quack server on Windows/Linux got `Authentication failed` since several days ago", one of 21 posts from 14 people on GitHub issues.
Trouble with DuckDB internal
Top post: "duckdb 2.0.0 fails to launch on BE: `INTERNAL Error: The time zone data is corrupt`", one of 14 posts from 7 people on GitHub issues.
DuckDB error messages are cryptic
11 posts from 7 people on GitHub issues.
Trouble with DuckDB returns
Top post: "Comparison simplification returns an incorrect result when a narrowing `DECIMAL` cast is used", one of 9 posts from 9 people on GitHub issues.
Trouble with DuckDB join
Top post: "Segfault in `dense_rank() OVER ()` over a RIGHT_ANTI hash join that returns its unmatched rows", one of 9 posts from 8 people on GitHub issues.
Trouble with DuckDB column
Top post: "2.0 alpha: comparing a CASE/split_part result to a constant fails with BindBuiltinScalarFunction did not", one of 7 posts from 5 people on GitHub issues.
Trouble with DuckDB cast
Top post: "TRY_CAST of an empty BLOB to BIT escapes a non-fallible __cast and invalidates the database", one of 7 posts from 6 people on GitHub issues.
Trouble with DuckDB null
Top post: "DuckDB: `HAVING` of `(φ IS TRUE) OR NOT (φ IS TRUE) AND …` is empty for a NULL `φ`, but the same boolean as", one of 6 posts from 6 people on GitHub issues.
Trouble with DuckDB values
Top post: "ManualVuln37 Unbounded Recursion in EncodeVariantValue Causes Stack Overflow via variant_comparator on Deeply", one of 6 posts from 6 people on GitHub issues.
Experiments on DuckDB are hard to reproduce and track
6 posts from 4 people on GitHub issues.
Trouble with DuckDB parquet
Top post: "External file cache range metadata grows for deleted local Parquet files in v1.5.6 despite buffer eviction", one of 5 posts from 5 people on GitHub issues.
History