This site is here for historical purposes only. Do not add or edit tasks here!
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
<LEFT> <comp> (SELECT <min/max>(<select_list>) ...)
<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.