diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2010-04-06 00:16:45 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2010-04-06 00:16:45 +0400 |
| commit | 2775f80f7d287cb0ed478543bf135b9399f56d66 (patch) | |
| tree | a7cdf4eb98620b2921959eb94428dc3a02aac7c0 /mysql-test/t/subselect_mat.test | |
| parent | cb325eb2b2f738b63d162fb0d46cf335e4ae84a4 (diff) | |
| download | mariadb-git-2775f80f7d287cb0ed478543bf135b9399f56d66.tar.gz | |
MWL#90: Subqueries: Inside-out execution for non-semijoin materialized
subqueries that are AND-parts of the WHERE
- First code (needs cleanup).
Diffstat (limited to 'mysql-test/t/subselect_mat.test')
| -rw-r--r-- | mysql-test/t/subselect_mat.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_mat.test b/mysql-test/t/subselect_mat.test index 54b1b5e15f9..3e5f42a3a43 100644 --- a/mysql-test/t/subselect_mat.test +++ b/mysql-test/t/subselect_mat.test @@ -829,8 +829,12 @@ select min(a1) from t1 where 7 in (select b1 from t2); # This is the only correct result of all four queries. This difference is # filed as BUG#40037. set @@optimizer_switch='default,materialization=off'; +-- echo # with MariaDB and MWL#90, this particular case is solved: explain select min(a1) from t1 where 7 in (select b1 from t2); select min(a1) from t1 where 7 in (select b1 from t2); +-- echo # but when we go around MWL#90 code, the problem still shows up: +explain select min(a1) from t1 where 7 in (select b1 from t2) or 2> 4; +select min(a1) from t1 where 7 in (select b1 from t2) or 2> 4; drop table t1,t2; # |