Comment 4 for bug 780386
Revision history for this message
| Oleksandr "Sanja" Byelkin (sanja-byelkin) wrote Re: Diverging results with join_cache_level=0, join_cache_level=3 in maria-5.3 with ALL() subquery + NULLs | #4 |
The problem is that if left argument is NULL (or could be other) comporison function do not check right argument (subquery) so subquery which was not executed return false on query of empty set, but ALL subquery with empty set should alway return TRUE independently on left part.