diff options
author | unknown <sanja@askmonty.org> | 2011-09-05 09:29:49 +0300 |
---|---|---|
committer | unknown <sanja@askmonty.org> | 2011-09-05 09:29:49 +0300 |
commit | 8b062c1fefd14cfa22e625d098b92c8ac3c1b28f (patch) | |
tree | 006bf37105248a919358cfe57a4c5ed2979bae78 /mysql-test/r/func_group.result | |
parent | 4338091967df9fcb4a2576e2f21302a75d4feb36 (diff) | |
download | mariadb-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