Problemsby IbisTrouble with DuckDB join
Databases2 posts from 2 people2d active+00 posts in the last 7 days, 2 the 7 days before (fading)Unverified
Posts per day
The posts behind it
2, newest firstSelect-level USING SAMPLE over a join fails to bind after ToString/reparse round-trip### What happens? This query runs fine: But it fails with a Binder Error after a `ToString()` -> reparse round-trip, for example under `SET debug_verify_statement='reparse_statement'` (used by test/configs/verify_statement_to_string.json). ### To Reproduce ### OS: macOS arm64...duckdb/duckdb · gulugulubingOpen ↗Nested joins on d_date_sk = ss_sold_date_sk + k planned as cross product + filter (filter_pullup + join_order lose the equi-join); the flat form plans fine### What happens? A chain of INNER JOINs nested as subqueries, each joining the same dimension table on an equality with an arithmetic expression over the same fact column (`d.d_date_sk = ss_sold_date_sk + k`, a different `k` per level), is planned with the innermost join as a...duckdb/duckdb · h4nsmullerOpen ↗
Companies and products named
About this problem
Evidence
2 posts from 2 people in 1 place, about 2 a week over 6 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 "join". First post Oct 9, 2026, latest Oct 14, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
Other DuckDB problems
DuckDB upgrades break working setupsDuckDB users keep filing bugsTrouble with DuckDB columnTrouble with DuckDB overflowDuckDB error messages are crypticTrouble with DuckDB internalTrouble with DuckDB nullTrouble with DuckDB valuesTrouble with DuckDB castTrouble with DuckDB resultDuckDB runs out of memoryDuckDB costs outgrow the value it gives
History
steady to fading
new to steady
Trouble with DuckDB join (2 posts)