Repository navigation
Regression: projection pushdown doesn't work as expected in DF50 #17513
Description
// t1 contains a,b
DF49
> explain select from t1 where t1.a > 1;
+--------------+----------------------------------+
| plan_type | plan |
+--------------+----------------------------------+
| logical_plan | Projection: |
| | Filter: t1.a > Int32(1) |
| | TableScan: t1 projection=[a] |
+--------------+----------------------------------+
1 row(s) fetched.
Elapsed 0.004 seconds.
DF50
> explain select from t1 where t1.a > 1;
+--------------+-----------------------------------+
| plan_type | plan |
+--------------+-----------------------------------+
| logical_plan | Filter: t1.a > Int32(1) |
| | TableScan: t1 projection=[a, b] |
+--------------+-----------------------------------+
1 row(s) fetched.
Elapsed 0.003 seconds.
Activity
adriangb commentedon Sep 11, 2025
I ran a bisect and found that #17295 introduced this bug
Fix regression in SELECT FROM syntax with WHERE clause
Fix regression: SELECT FROM syntax should return empty projection
Revert #17295 (Support from-first SQL syntax) (#17520)
Revert apache#17295 (Support from-first SQL syntax) (apache#17520)
Revert #17295 (Support from-first SQL syntax) (#17520) (#17544)
Revert apache#17295 (Support from-first SQL syntax) (apache#17520)