Data and AI struggles

2,114 problems · 377 companies

Databases

Trouble with DuckDB date

3 posts from 3 people3d activeSteady, +1 this week

Posts per day

Posts per day3 posts, Aug 28 to Nov 21

The posts behind it

GitHub issuesduckdb/duckdb · mrouvroy-floeNov 16

EXTRACT(YEAR FROM col) / date_part('year', col) filters are not turned into a range on col, unlike year(col)

### What happens? A filter `year(dt) = 2020` is rewritten into the range `dt >= '2020-01-01' AND dt <= '2020-12-31'` (MonotonePreimageRule), which is pushed into the scan and prunes row groups. The same filter written as `date_part('year', dt) = 2020` or `EXTRACT(YEAR FROM dt) =...

GitHub issuesduckdb/duckdb · prabh1512Nov 7

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...

GitHub issuesduckdb/duckdb · peterxcliAug 28

Week-based date parts fail with "Date out of range" on dates in the minimum year

### What happens? Week-based date parts fail with "Date out of range" on dates in the minimum representable year, even though the requested result is representable. `weekofyear`/`isoyear`/`yearweek` (and `date_trunc('year'/'quarter'/'month')`) materialize Jan 1 of the year as a...

1 replies

Companies and products named

3 posts
1 post
About this problem

Evidence

3 posts from 3 people in 1 place, about 1 a week over 81 days. Mostly on duckdb/duckdb. Tools named alongside: GitHub.

Frustration Frustration 0 of 3· Seen on GitHub issues

How it was grouped

Posts about DuckDB with no known issue, sharing the word "date". First post Aug 28, 2026, latest Nov 16, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method

Other DuckDB problems

DuckDB upgrades break working setups

55 posts from 42 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 12 posts from 11 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 21 posts from 16 people on GitHub issues.

DuckDB feels slow and laggy

3 posts from 3 people on GitHub issues, Reddit.

DuckDB queries run too slowly and are hard to tune

3 posts from 3 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 11 posts from 9 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.

DuckDB error messages are cryptic

12 posts from 8 people on GitHub issues.

Experiments on DuckDB are hard to reproduce and track

11 posts from 7 people on GitHub issues.

DuckDB users keep filing bugs

Top post: "Support duckdb 2", one of 10 posts from 9 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 7 posts from 7 people on GitHub issues.

History

Corroborated: 3 or more posts from 2 or more people or places.

Nov 21, 2026

Momentum went from fading to steady.

Nov 21, 2026

First seen with 1 post; the top post now: "Week-based date parts fail with Date out of range on dates in the minimum year".

Oct 15, 2026