[Maria-developers] WL#148 New (by Sanja): Move the transformations for inequality predicates with ALL/ANY subqueries from the prepare phase into the optimization phase.

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Move the transformations for inequality predicates with ALL/ANY subqueries from the prepare phase into the optimization phase. CREATION DATE..: Wed, 15 Sep 2010, 07:25 SUPERVISOR.....: Igor IMPLEMENTOR....: Sanja COPIES TO......: Monty CATEGORY.......: Server-Sprint TASK ID........: 148 (http://askmonty.org/worklog/?tid=148) VERSION........: Benchmarks-3.0 STATUS.........: Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 64 (hours remain) ORIG. ESTIMATE.: 64 PROGRESS NOTES: DESCRIPTION: Move the transformations for inequality predicates with ALL/ANY subqueries from the prepare phase into the optimization phase from preparation phase. It could be done in any place of the optimisation. Now there is 2 kind of the MAX/MIN optimisation for non-correlated subqueries: If it is possible (there is no aggregate functions in the subquery) ALL/ANY converted to <LEFT> <comp> (SELECT () ...) Otherwise: <LEFT> <comp> (MAX/MIN_SELECT ...) Where MAX/MIN_SELECT is special subquery which returns max or min result of all found by the subquery. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v4.0.0)