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.