This PR improves the shared subplan (aka. common table expression) support to handle TPC-H query 15. There are two main updates:
Augmented SimpleCostModel to handle SharedSubplanReference physical plan node.
Revised SharedSubplanReference logical/physical plan nodes to avoid ExprId resolution collision when a same shared plan is referenced multiple times in a query.
This PR improves the shared subplan (aka. common table expression) support to handle TPC-H query 15. There are two main updates:
SimpleCostModel
to handleSharedSubplanReference
physical plan node.SharedSubplanReference
logical/physical plan nodes to avoidExprId
resolution collision when a same shared plan is referenced multiple times in a query.