diff options
Diffstat (limited to 'mysql-test/main/subselect_sj.test')
| -rw-r--r-- | mysql-test/main/subselect_sj.test | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/subselect_sj.test b/mysql-test/main/subselect_sj.test index ed2d7c99ec2..3c046c6321c 100644 --- a/mysql-test/main/subselect_sj.test +++ b/mysql-test/main/subselect_sj.test @@ -2292,17 +2292,17 @@ INSERT INTO t1 VALUES CREATE TABLE t2 ( c INT, d INT, KEY(c) ); INSERT INTO t2 VALUES - (1,2),(2,1),(3,3),(4,2),(5,5),(6,3),(7,1); + (1,2),(2,1),(3,3),(4,2),(5,5),(6,3),(7,1),(11,11); analyze table t1,t2; explain SELECT a, b, d FROM t1, t2 WHERE ( b, d ) IN - ( SELECT b, d FROM t1, t2 WHERE b = c ); + ( SELECT b, d FROM t1 as t3, t2 as t4 WHERE b = c ); --sorted_result SELECT a, b, d FROM t1, t2 WHERE ( b, d ) IN - ( SELECT b, d FROM t1, t2 WHERE b = c ); + ( SELECT b, d FROM t1 as t3, t2 as t4 WHERE b = c ); DROP TABLE t1, t2; |