diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2011-11-02 13:48:41 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2011-11-02 13:48:41 +0400 |
| commit | 47861a657762feeb45ee6b8edea00033bbd0e8ca (patch) | |
| tree | 060d07487e32539e3edc12f1b5122969d112c6d6 /mysql-test/r/subselect4.result | |
| parent | 64986873252e6c4fff867407d1b2f92abe24ca88 (diff) | |
| download | mariadb-git-47861a657762feeb45ee6b8edea00033bbd0e8ca.tar.gz | |
Change the default @@optimizer_switch settings:
- semijoin=on
- firstmatch=on
- loosescan=on
Diffstat (limited to 'mysql-test/r/subselect4.result')
| -rw-r--r-- | mysql-test/r/subselect4.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/subselect4.result b/mysql-test/r/subselect4.result index 6c33f8a404c..ddf339ba1b5 100644 --- a/mysql-test/r/subselect4.result +++ b/mysql-test/r/subselect4.result @@ -2113,7 +2113,7 @@ CREATE TABLE t3 (a int, b int) ; INSERT INTO t3 VALUES (5,0),(7,0); CREATE TABLE t4 (a int); INSERT INTO t4 VALUES (2),(8); -set @@optimizer_switch='in_to_exists=on,materialization=off,subquery_cache=off'; +set @@optimizer_switch='semijoin=off,in_to_exists=on,materialization=off,subquery_cache=off'; SELECT * FROM t2 WHERE t2.b IN (SELECT b FROM t3 WHERE t3.a = t2.a AND a < SOME (SELECT * FROM t4)) OR ( t2.c > 242 ); |