diff options
| author | unknown <timour@askmonty.org> | 2011-03-30 10:10:59 +0300 |
|---|---|---|
| committer | unknown <timour@askmonty.org> | 2011-03-30 10:10:59 +0300 |
| commit | 952556b3452d4a6893a678da88809b22e7f7a466 (patch) | |
| tree | 938de6db815840eb2038bdded942ab684e4673d0 /mysql-test/t/func_group.test | |
| parent | 9762b236d47e74f2f065c89a747c1a8d3444ed18 (diff) | |
| parent | 0737fb479f082c424881e79e4c358670176ebca2 (diff) | |
| download | mariadb-git-952556b3452d4a6893a678da88809b22e7f7a466.tar.gz | |
MWL#89
Merge 5.3 with 5.3-mwl89.
Diffstat (limited to 'mysql-test/t/func_group.test')
| -rw-r--r-- | mysql-test/t/func_group.test | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index 6e0a3fe2589..de06bd90f2b 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -1141,6 +1141,9 @@ INSERT INTO t1 VALUES (1,'c'),(2,NULL); INSERT INTO t2 VALUES (3,'m'),(4,NULL); INSERT INTO t3 VALUES (1,'n'); +set @save_optimizer_switch=@@optimizer_switch; +set @@optimizer_switch='materialization=on,in_to_exists=off,semijoin=off'; + --echo --echo # --echo # 1) Test that subquery materialization is setup for query with @@ -1188,10 +1191,6 @@ FROM t2); --echo # 3) Test that subquery materialization is setup for query with --echo # premature optimize() exit due to "Select tables optimized away" --echo # ---echo # NOTE: The result of this query is actually wrong; it should be NULL ---echo # See BUG#47762. Even so, the test case is still needed to test ---echo # that the HAVING subquery does not crash the server ---echo # SELECT MIN(pk) FROM t1 WHERE pk=NULL @@ -1250,6 +1249,8 @@ HAVING ('m') IN ( SELECT v FROM t2); +set @@optimizer_switch=@save_optimizer_switch; + --echo # --echo # Cleanup for BUG#46680 --echo # |