summaryrefslogtreecommitdiff
path: root/mysql-test/r/metadata.result
diff options
context:
space:
mode:
authorSergey Glukhov <Sergey.Glukhov@sun.com>2010-03-19 13:09:22 +0400
committerSergey Glukhov <Sergey.Glukhov@sun.com>2010-03-19 13:09:22 +0400
commitad6e00e3b2b9bf26805c90cbd7655c6d2b20cab4 (patch)
treeaa4577efde3e75d5c6d58f04ef55f9605282d49d /mysql-test/r/metadata.result
parenta76b8f9a1d58991f58771043034308895b368549 (diff)
downloadmariadb-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