diff options
Diffstat (limited to 'mysql-test/r/subselect_no_exists_to_in.result')
-rw-r--r-- | mysql-test/r/subselect_no_exists_to_in.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_no_exists_to_in.result b/mysql-test/r/subselect_no_exists_to_in.result index 8bbe6e3cf70..87f33d1dbf4 100644 --- a/mysql-test/r/subselect_no_exists_to_in.result +++ b/mysql-test/r/subselect_no_exists_to_in.result @@ -7204,6 +7204,20 @@ f1 f2 f3 DROP TABLE t1, t2; SET NAMES default; End of 10.1 tests +# +# MDEV-12564: IN TO EXISTS transformation for rows after +# conversion an outer join to inner join +# +CREATE TABLE t ( +pk int PRIMARY KEY, i int NOT NULL, c varchar(8), KEY(c) +) ENGINE=MyISAM; +INSERT INTO t VALUES (1,10,'foo'),(2,20,'bar'); +SELECT * FROM t t1 RIGHT JOIN t t2 ON (t2.pk = t1.pk) +WHERE (t2.i, t2.pk) NOT IN ( SELECT t3.i, t3.i FROM t t3, t t4 ) AND t1.c = 'foo'; +pk i c pk i c +1 10 foo 1 10 foo +DROP TABLE t; +End of 10.2 tests set optimizer_switch=default; select @@optimizer_switch like '%exists_to_in=off%'; @@optimizer_switch like '%exists_to_in=off%' |