diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2009-08-21 09:48:22 +0200 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2009-08-21 09:48:22 +0200 |
| commit | 9c1336801ec49f772f62bb3943432523c4f37aa9 (patch) | |
| tree | 4aa7b2ab6147aa0b667df260f55326a7328397a5 /mysql-test/t/table_elim.test | |
| parent | 3f5b4949003d0cc41646eefbb3d7e7d1021406ea (diff) | |
| download | mariadb-git-9c1336801ec49f772f62bb3943432523c4f37aa9.tar.gz | |
MWL#17: Table elimination
- More testcases
- Set correct dependencies for non-bound multi-equalities.
mysql-test/r/table_elim.result:
MWL#17: Table elimination
- More testcases
mysql-test/t/table_elim.test:
MWL#17: Table elimination
- More testcases
sql/opt_table_elimination.cc:
MWL#17: Table elimination
- Set correct dependencies for non-bound multi-equalities.
Diffstat (limited to 'mysql-test/t/table_elim.test')
| -rw-r--r-- | mysql-test/t/table_elim.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/table_elim.test b/mysql-test/t/table_elim.test index 6ef9731e212..f4ea009f09a 100644 --- a/mysql-test/t/table_elim.test +++ b/mysql-test/t/table_elim.test @@ -175,6 +175,17 @@ select t1.* from t1 left join ( t2 left join t3 on t3.pk=t2.col) on t2.col=t1.co explain select t1.*, t2.* from t1 left join (t2 left join t3 on t3.pk=t2.col) on t2.pk=t1.col; +explain select t1.* +from + t1 left join ( t2 left join t3 on t3.pk=t2.col or t3.pk=t2.col) + on t2.col=t1.col or t2.col=t1.col; + +explain select t1.*, t2.* +from + t1 left join + (t2 left join t3 on t3.pk=t2.col or t3.pk=t2.col) + on t2.pk=t1.col or t2.pk=t1.col; + drop table t1, t2, t3; --echo # |