diff options
author | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-03-19 13:09:22 +0400 |
---|---|---|
committer | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-03-19 13:09:22 +0400 |
commit | ad6e00e3b2b9bf26805c90cbd7655c6d2b20cab4 (patch) | |
tree | aa4577efde3e75d5c6d58f04ef55f9605282d49d /mysql-test/r/metadata.result | |
parent | a76b8f9a1d58991f58771043034308895b368549 (diff) | |
download | mariadb-git-ad6e00e3b2b9bf26805c90cbd7655c6d2b20cab4.tar.gz |
Bug#51242 HAVING clause on table join produce incorrect results
The problem is that when we make conditon for
grouped result const part of condition is cut off.
It happens because some parts of 'having' condition
which refer to outer join become const after
make_join_statistics. These parts may be lost
during further having condition transformation
in JOIN::exec. The fix is adding 'having'
condition check for const tables after
make_join_statistics is performed.
mysql-test/r/having.result:
test case
mysql-test/t/having.test:
test result
sql/sql_select.cc:
added 'having' condition check for const tables
after make_join_statistics is performed.
Diffstat (limited to 'mysql-test/r/metadata.result')
0 files changed, 0 insertions, 0 deletions