diff options
| author | Michael Widenius <monty@askmonty.org> | 2011-05-16 15:07:04 +0300 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2011-05-16 15:07:04 +0300 |
| commit | 8543621fa0f4a3c4102ac8f799888ef79e2e1dcf (patch) | |
| tree | 29e8f301ef929cfe1c00eec9dee265aa0acaa350 /mysql-test/t/func_group.test | |
| parent | f458e198c0bea67c6a3787738108bbfb139639bd (diff) | |
| parent | bcee6652c6052cabd67f8d30c14e162235749d38 (diff) | |
| download | mariadb-git-8543621fa0f4a3c4102ac8f799888ef79e2e1dcf.tar.gz | |
Merge with 5.3 main
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 85ebc92d6c3..19f87fae3d2 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -1163,6 +1163,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 @@ -1210,10 +1213,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 @@ -1272,6 +1271,8 @@ HAVING ('m') IN ( SELECT v FROM t2); +set @@optimizer_switch=@save_optimizer_switch; + --echo # --echo # Cleanup for BUG#46680 --echo # |