Problemsby GlyphTrouble with DuckDB timestamp
2 posts from 2 people2d activeSteady, +1 this weekunverified
Posts per day
The posts behind it
date_trunc(part, <timestamp col>) = <constant> near the end of the TIMESTAMP range fails with a conversion error (DateTruncSimplificationRule)
### What happens? `DateTruncSimplificationRule` (`src/optimizer/rule/date_trunc_simplification.cpp`) rewrites `date_trunc(part, x) = c` into `x >= date_trunc(part, c) AND x `, `>`, ` =`) are not affected. ### To Reproduce Returning `nullptr` (no rewrite) when the bound cannot be...
duckdb_from_timestamp throws through the C API for a finite timestamp created by make_timestamp
...range, or `duckdb_from_timestamp` returns instead of throwing. A C function has no way to report an error by throwing. From reading the source, the exception is the `ConversionException("Date out of range in timestamp conversion")` thrown by `Timestamp::Convert`...
Companies and products named
About this problem
Evidence
2 posts from 2 people in 1 place, about 1 a week over 30 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 "timestamp". First post Oct 9, 2026, latest Nov 7, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
Other DuckDB problems
DuckDB upgrades break working setups
45 posts from 35 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 20 posts from 12 people on GitHub issues.
Trouble with DuckDB returns
Top post: "Segfault in `dense_rank() OVER ()` over a RIGHT_ANTI hash join that returns its unmatched rows", one of 17 posts from 13 people on GitHub issues.
Experiments on DuckDB are hard to reproduce and track
10 posts from 6 people on GitHub issues.
Trouble with DuckDB join
Top post: "Wrong result: join_elimination drops a LEFT JOIN below a LIMIT/OFFSET under a DISTINCT", one of 8 posts from 7 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 9 posts from 7 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 15 posts from 11 people on GitHub issues.
DuckDB error messages are cryptic
12 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 8 posts from 5 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.
DuckDB costs outgrow the value it gives
5 posts from 5 people on GitHub issues.
History