Data and AI struggles

2,114 problems · 377 companies

Databases

Trouble with DuckDB count

3 posts from 2 people3d activeSteady, +1 this week

Posts per day

Posts per day3 posts, Sep 23 to Nov 21

The posts behind it

GitHub issuesduckdb/duckdb · maxdemarziNov 18

Pyodide/wasm: v2.0.0 hot paths call tiny non-inlined helpers that Emscripten binds through JS stubs (parse-only ~20x, count(distinct) ~1.7x slower than 1.5.4)

# What happens? Under Pyodide (a wasm side module built by `pyodide build` from duckdb-python `v2.0.0`), a number of DuckDB 2.0.0 hot paths are much slower than DuckDB 1.5.4 built the same way. Native 2.0.0 is not slower, so this is specific to the wasm side-module build. Same...

GitHub issuesduckdb/duckdb · ylwango613Oct 2

ManualVuln42 approx_top_k() Import State Accepts Out-of-Order Count Entries Violating Descending-Sort Invariant

### What happens? `ApproxTopKImportState` (`extension/core_functions/aggregate/holistic/approx_top_k.cpp` lines 479 to 548) validates only that the number of supplied values does not exceed the capacity and that the filter array has the correct size. It does not verify that the...

GitHub issuesduckdb/duckdb · ylwango613Sep 23

NewVuln11: OOB Write via COMPRESSION_COUNT Sentinel in SetDisabledCompressionMethods

### What happens? `CompressionFunctionSet::SetDisabledCompressionMethods()` in `src/function/compression_config.cpp` uses `COMPRESSION_COUNT` (value 16) as a sentinel for the `CompressionType` enum, but the guard switch in `src/main/settings/custom_settings.cpp` does not reject...

Companies and products named

3 posts
1 post
About this problem

Evidence

3 posts from 2 people in 1 place, about 1 a week over 57 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 "count". First post Sep 23, 2026, latest Nov 18, 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

First seen with 3 posts; the top post now: "Pyodide/wasm: v2.0.0 hot paths call tiny non-inlined helpers that Emscripten binds through JS stubs".

Nov 21, 2026