ANY / SOME
NULL literals allowed
Changed in: 2.0
Description
The ANY (or SOME) predicate now allows a NULL as the test value. Notice that this brings no practical benefits. In particular, a NULL test value will not be considered equal to a NULL in the subquery result set.
UNION as subselect
Changed in: 2.0
Description
The subselect in an ANY (or SOME) predicate may now also be a UNION.