diff options
| author | Igor Babaev <igor@askmonty.org> | 2013-04-29 20:31:40 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2013-04-29 20:31:40 -0700 |
| commit | 86f43c30771cdfbb38f1a958de0e7f131451a988 (patch) | |
| tree | 6b2d12c8e8af0ae11fe7fde9844159d38b1956fb /mysql-test/r/subselect_sj2_mat.result | |
| parent | ea4a417a8d456e8e09b6b4306f22c7c20b3e594c (diff) | |
| download | mariadb-git-86f43c30771cdfbb38f1a958de0e7f131451a988.tar.gz | |
Fixed bug mdev-4274.
This bug was the result of incompleteness of the patch for bug mdev-4177.
When an OR condition is simplified to a single conjunct it is merged
into the embedding AND condition. Multiple equalities are also merged,
and any field item involved in those equality should acquire a pointer
to a the multiple equality formed by this merge.
Diffstat (limited to 'mysql-test/r/subselect_sj2_mat.result')
| -rw-r--r-- | mysql-test/r/subselect_sj2_mat.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/subselect_sj2_mat.result b/mysql-test/r/subselect_sj2_mat.result index bf5b95d2d8f..18e3f6ddd34 100644 --- a/mysql-test/r/subselect_sj2_mat.result +++ b/mysql-test/r/subselect_sj2_mat.result @@ -1380,7 +1380,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 2 MATERIALIZED t2 ALL NULL NULL NULL NULL 2 100.00 Using where 2 MATERIALIZED t3 hash_ALL NULL #hash#$hj 5 test.t2.i2 3 100.00 Using where; Using join buffer (flat, BNLH join) Warnings: -Note 1003 select `test`.`t1`.`i1` AS `i1` from `test`.`t1` semi join (`test`.`t2` join `test`.`t3`) where ((`test`.`t3`.`i3` = `test`.`t2`.`i2`) and (`test`.`t1`.`i1` = `test`.`t2`.`i2`) and (`test`.`t3`.`i3` > 0)) +Note 1003 select `test`.`t1`.`i1` AS `i1` from `test`.`t1` semi join (`test`.`t2` join `test`.`t3`) where ((`test`.`t3`.`i3` = `test`.`t2`.`i2`) and (`test`.`t1`.`i1` = `test`.`t2`.`i2`) and (`test`.`t2`.`i2` > 0)) SELECT * FROM t1 WHERE i1 IN (SELECT i3 FROM t2, t3 WHERE i3 > 0 AND i3 = i2 OR 1=2); i1 |