Testing DuckDB pipelines and SQL is hard
2 posts from 2 people2d activeSteady, +1 this weekunverified
Posts per day
The posts behind it
ibis: empty tables fail column checks and nullable=False
**Describe the bug** With the ibis backend, validating a table with **zero rows** raises `SchemaError` for column checks and for non-nullable columns, even though no row can violate anything. The failure-case list in the error is empty. `isin` is used below as the minimal...
[Dependencies] Track DuckDB 2.0 compatibility for duckdb and motherduck extras
### Dependency compatibility gap Superset's `duckdb` extra still excludes DuckDB 2.0, including on current `master`. This also affects the `motherduck` extra because it delegates to `apache-superset[duckdb]`. Verified on 2026-10-22: | Superset source | Declared DuckDB...
Companies and products named
About this problem
Evidence
2 posts from 2 people in 2 places, about 1 a week over 9 days. Mostly on apache/superset, unionai-oss/pandera. Tools named alongside: pandas, Apache Superset, GitHub, PyPI.
Frustration Frustration 0 of 3· Seen on GitHub issues
How it was grouped
Posts that state a pain and match the "data-testing" rule about DuckDB. First post Oct 22, 2026, latest Oct 30, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
The same problem elsewhere
Testing data pipelines and SQL is hard
2 posts from 2 people on Reddit, GitHub issues. Unverified.
Other DuckDB problems
DuckDB upgrades break working setups
37 posts from 28 people on GitHub issues.
Experiments on DuckDB are hard to reproduce and track
6 posts from 4 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.
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 23 posts from 15 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 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.
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