Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
Columnstore depends on a number of handy rewrites that MDB does, namely outter to inner join rewrite, IN into EXISTS conversion for IN + subquery. However MCS doesn't tolerate full JOIN::optimize processing b/c of an internal limitation in JOIN processing(the join graph must be acyclic).
We need a new dedicated optimize() method in Select Handler that must replace JOIN::optimize() call. This method must be able to call dedicated functions that can apply rewrites listed above.
Attachments
Issue Links
- relates to
-
MDEV-23860 Move all optimization query re-writes from the prepare phase into the optimizer phase
- Closed