[Algebrizer/Rewriter] make OptimizeOption.remove_from_ default to true

zhouqingqing / qpmodel

A Relational Optimizer and Executor

MIT License

65 stars 18 forks source link

[Algebrizer/Rewriter] make OptimizeOption.remove_from_ default to true #113

Open zhouqingqing opened 4 years ago

zhouqingqing commented 4 years ago

This flag controls the behavior to remove redundant FROM (select from (select from a) b) after we fixed bugs with it, for example (aggregation from aggregation).

pkommoju commented 3 years ago

Removing remove_from is presenting problems when from contains union/intersect/except because outputs are not set for all except the first select.