diff options
| author | unknown <sanja@montyprogram.com> | 2012-05-11 09:35:46 +0300 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2012-05-11 09:35:46 +0300 |
| commit | f2cbc014d98a927ed7038f55a25c3d288de10f51 (patch) | |
| tree | bc83a9be2f43c9c49fb055526929d772940b17c7 /mysql-test/t/join_outer.test | |
| parent | 6fc863c7495d7715684918842b062bd6209b7d53 (diff) | |
| download | mariadb-git-f2cbc014d98a927ed7038f55a25c3d288de10f51.tar.gz | |
fix for LP bug#994392
The not_null_tables() of Item_func_not_all and Item_in_optimizer was inherited from
Item_func by mistake. It made the optimizer think that subquery
predicates with ALL/ANY/IN were null-rejecting. This could trigger invalid
conversions of outer joins into inner joins.
Diffstat (limited to 'mysql-test/t/join_outer.test')
| -rw-r--r-- | mysql-test/t/join_outer.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index 5e18f77c422..01f1980b4c1 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -1162,3 +1162,22 @@ DROP TABLE t1; --echo End of 5.1 tests + +--echo # +--echo # LP BUG#994392: Wrong result with RIGHT/LEFT JOIN and ALL subquery +--echo # predicate in WHERE condition. +--echo # + +CREATE TABLE t1(a INT); +INSERT INTO t1 VALUES(9); +CREATE TABLE t2(b INT); +INSERT INTO t2 VALUES(8); +CREATE TABLE t3(c INT); +INSERT INTO t3 VALUES(3); +SELECT * FROM t2 RIGHT JOIN t3 ON(c = b) WHERE b < ALL(SELECT a FROM t1 WHERE a <= 7); +SELECT * FROM t3 LEFT JOIN t2 ON(c = b) WHERE b < ALL(SELECT a FROM t1 WHERE a <= 7); +SELECT * FROM t2 RIGHT JOIN t3 ON(c = b) WHERE b not in (SELECT a FROM t1 WHERE a <= 7); +SELECT * FROM t3 LEFT JOIN t2 ON(c = b) WHERE b not in (SELECT a FROM t1 WHERE a <= 7); +drop table t1,t2,t3; + +--echo End of 5.2 tests |