shortcut for selection's execution when its filter contain correlated filter.
#12,723 建立於 2019年10月15日
倉庫指標
- 星標
- (40,090 顆星)
- PR 合併指標
- (平均合併 14天 4小時) (30 天內合併 346 個 PR)
描述
Feature Request
Is your feature request related to a problem? Please describe:
For normal selection not involved in Apply. The constant filter will be evaled during planning. So if one filter would filter out all data, it will be converted to TableDual during planning.
But if there's correlated column in filters, we would eval it in execution phase. Though it atually behaves like a constant in execution phase.
Describe the feature you'd like:
We could split the filters to two part and one part only contains filters containing constant and correlated column.
Then when calling the Next of SelectionExec for the first time. We eval these filters once. If it's false. Then we can break the execution early.
Describe alternatives you've considered:
Currently, no
Teachability, Documentation, Adoption, Migration Strategy: