Data and AI struggles

2,114 problems · 377 companies

Data engineering

Bad data slips through DuckDB unnoticed

2 posts from 2 people2d activeSteady, +1 this weekunverified

Posts per day

Posts per day2 posts, Oct 1 to Nov 21

The posts behind it

GitHub issuesduckdb/duckdb · mustafahasankhanNov 18

ORDER BY ... NULLS FIRST with a second key and an OFFSET returns a wrong row

### What happens? `ORDER BY k NULLS FIRST, id DESC LIMIT 1 OFFSET n` returns a wrong row when the NULL values of `k` are in more than one row group and one of these row groups holds only NULL values. The row group pruner uses the `OFFSET` to skip whole row groups at the start of...

GitHub issuesduckdb/duckdb · ylwango613Oct 1

ManualVuln7 information_schema.check_constraints Returns Duplicate Rows for Multi-Column CHECK Constraints

### What happens? `information_schema.check_constraints` (`src/catalog/default/default_views.cpp` line 213) is defined with a subquery that calls `UNNEST(constraint_column_names)` over rows from `duckdb_constraints()` filtered to `constraint_type IN ('CHECK', 'NOT NULL')`. For...

1 replies

Companies and products named

2 posts
1 post
About this problem

Evidence

2 posts from 2 people in 1 place, about 1 a week over 49 days. Mostly on duckdb/duckdb. Tools named alongside: Atlan.

Frustration Frustration 0 of 3· Seen on GitHub issues

How it was grouped

Posts that state a pain and match the "data-quality" rule about DuckDB. First post Oct 1, 2026, latest Nov 18, 2026. Unverified: fewer than 3 posts, or one person or place only. Method

The same problem elsewhere

Bad data slips into production unnoticed

26 posts from 26 people on GitHub issues, Reddit, Stack Overflow.

Bad data slips through Polars unnoticed

4 posts from 4 people on GitHub issues, Reddit.

Bad data slips through Databricks unnoticed

3 posts from 3 people on Reddit.

Bad data slips through Snowflake unnoticed

3 posts from 3 people on Reddit, Hacker News.

Bad data slips through PostgreSQL unnoticed

3 posts from 3 people on Stack Overflow, GitHub issues.

Bad data slips through Apache Iceberg unnoticed

3 posts from 3 people on GitHub issues.

Bad data slips through Apache Spark unnoticed

2 posts from 2 people on GitHub issues. Unverified.

Bad data slips through Claude unnoticed

2 posts from 1 person on Reddit. Unverified.

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

First seen with 2 posts.

Nov 21, 2026