maria-developers team mailing list archive

[worklog-noreply@xxxxxxxxxxxx]

-----------------------------------------------------------------------
                              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 <min/max>(<select_list>) ...)

Otherwise:

<LEFT> <comp> (MAX/MIN_SELECT <select_list> ...)

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)