summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_group.result
diff options
context:
space:
mode:
authorunknown <sanja@askmonty.org>2011-09-05 09:29:49 +0300
committerunknown <sanja@askmonty.org>2011-09-05 09:29:49 +0300
commit8b062c1fefd14cfa22e625d098b92c8ac3c1b28f (patch)
tree006bf37105248a919358cfe57a4c5ed2979bae78 /mysql-test/r/func_group.result
parent4338091967df9fcb4a2576e2f21302a75d4feb36 (diff)
downloadmariadb-git-8b062c1fefd14cfa22e625d098b92c8ac3c1b28f.tar.gz
Fix of LP BUG#780386.
ALL subquery should return TRUE if subquery rowa set is empty independently of left part. The problem was that Item_func_(eq,ne,gt,ge,lt,le) do not call execution of second argument if first is NULL no in this case subquery will not be executed and when Item_func_not_all calls any_value() of the subquery or aggregation function which report that there was rows. So for NULL < ALL (SELECT...) result was FALSE instead of TRUE. Fix is just swapping of arguments of Item_func_(eq,ne,gt,ge,lt,le) (with changing the operation if it is needed) so that result will be the same (for examole a < b is equal to b > a). This fix exploit the fact that first argument will be executed in any case.
Diffstat (limited to 'mysql-test/r/func_group.result')
0 files changed, 0 insertions, 0 deletions