summaryrefslogtreecommitdiff
path: root/storage/example
diff options
context:
space:
mode:
authorSergey Glukhov <Sergey.Glukhov@sun.com>2010-07-09 14:39:47 +0400
committerSergey Glukhov <Sergey.Glukhov@sun.com>2010-07-09 14:39:47 +0400
commit013136364c95b7bcc5a987dd301b042f31dab1f9 (patch)
tree2856c3cdebae0d619e3583ec3b8e82991deed42d /storage/example
parent625ae7185abcfc7042be225d4f8ef77806fc0803 (diff)
downloadmariadb-git-013136364c95b7bcc5a987dd301b042f31dab1f9.tar.gz
Bug#54416 MAX from JOIN with HAVING returning NULL with 5.1 and Empty set
The problem there is that HAVING condition evaluates const parts of condition despite the condition has references on aggregate functions. Table t1 became const tables after make_join_statistics and table1.pk = 1, HAVING is transformed into MAX(1) < 7 and taken away from HAVING. The fix is to skip evaluation of HAVING conts parts if HAVING condition has references on aggregate functions. mysql-test/r/having.result: test case mysql-test/t/having.test: test case sql/sql_select.cc: skip evaluation of HAVING conts parts if HAVING condition has references on aggregate functions.
Diffstat (limited to 'storage/example')
0 files changed, 0 insertions, 0 deletions