Predicate pushdown fails when using qualified column references with aliases
Predicate pushdown fails when using qualified column references with aliases: a task in harbor-swesmith-rl-artifacts: Harbor SWE-Smith 强化学习数据产物 (Harbor dataset). I've discovered an issue with the predicate pushdown optimization when using qualified column references that match aliases in a…
The task
I've discovered an issue with the predicate pushdown optimization when using qualified column references that match aliases in a subquery. The optimizer fails to correctly replace aliases in predicates when the column reference includes a table qualifier.