Optimizer rule support subqueryAlias #4381
Description
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
After we use subqueryAlias to replace alias in projection, we can find some optimizer rule don't support subqueryAlias.
It will cause some regression.
like #4333 (comment)
- push_projection
- push_limit
- push_filter
- .....
We need to support it, and add more UT and integration test for them.
Describe the solution you'd like
A clear and concise description of what you want to happen.
Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.
Additional context
Add any other context or screenshots about the feature request here.