diff options
Diffstat (limited to 'mysql-test/main/subselect_exists2in.test')
| -rw-r--r-- | mysql-test/main/subselect_exists2in.test | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/main/subselect_exists2in.test b/mysql-test/main/subselect_exists2in.test index e70d643138b..bf884cc1fa9 100644 --- a/mysql-test/main/subselect_exists2in.test +++ b/mysql-test/main/subselect_exists2in.test @@ -238,13 +238,13 @@ group by a1,a2,b; drop table t1, t2, t3; -# -# LP BUG#901835 - incorrect semi-join conversion after exists2in -# +--echo # +--echo # LP BUG#901835 - incorrect semi-join conversion after exists2in +--echo # CREATE TABLE t1 ( a INT ); -INSERT INTO t1 VALUES (7),(0); +INSERT INTO t1 VALUES (7),(0),(100); CREATE TABLE t2 ( b INT ); -INSERT INTO t2 VALUES (0),(8); +INSERT INTO t2 VALUES (0),(8),(1000),(2000),(3000),(4000),(5000); SELECT * FROM t1 WHERE EXISTS ( SELECT * FROM t2 WHERE b = a ) @@ -562,7 +562,7 @@ set optimizer_switch='exists_to_in=on'; --echo # correct calculation of reserved items (postreview-fix) --echo # create table t1 (col1 int, col2 int, col3 int); -insert into t1 values (1,2,3),(2,3,4),(4,5,6); +insert into t1 values (1,2,3),(2,3,4),(4,5,6),(7,8,9); create table t2 as select * from t1; explain extended select * from t1 where exists (select col2 from t2 where t2.col1=t1.col1 and t2.col2=t1.col2); |