Problemsby IbisTrouble with DuckDB filter
Databases2 posts from 2 people2d active+11 post in the last 7 days, 0 the 7 days before (steady)Unverified
Posts per day
The posts behind it
2, newest firstST_Intersects/ST_Contains/ST_Within lose row-group pruning with an IN or OR filter on 2.0### What happens? On 2.0, `ST_Intersects`, `ST_Contains` and `ST_Within` prune Parquet row groups through the new geometry statistics. If the query also has an `IN` list (or an `OR` of equalities) on another column, the spatial predicate is not pushed into the scan: it stays in...duckdb/duckdb · adonmOpen ↗2.0 preview: large literal IN filter is about 7.6x slower than 1.5.5 (plain CLI reproduction)### What happens? What happens? A SELECT with a 5,000-item literal IN list is substantially slower in the 2.0 preview than in 1.5.5. This reduces an embedded application's page-ID filtering pattern to one synthetic query over `range(10000)`. No application schema, client...duckdb/duckdb · radumg1 repliesOpen ↗
Companies and products named
About this problem
Evidence
2 posts from 2 people in 1 place, about 1 a week over 21 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 "filter". First post Oct 1, 2026, latest Oct 21, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
Other DuckDB problems
DuckDB upgrades break working setupsDuckDB error messages are crypticTrouble with DuckDB joinTrouble with DuckDB resultDuckDB users keep filing bugsDuckDB lock-in makes switching costlyTrouble with DuckDB parquetTrouble with DuckDB overflowTrouble with DuckDB columnTrouble with DuckDB internalTrouble with DuckDB nullDuckDB costs outgrow the value it gives
History
fading to steady
Trouble with DuckDB filter (1 post)