diff options
author | Varun Gupta <varunraiko1803@gmail.com> | 2018-07-27 11:34:34 +0530 |
---|---|---|
committer | Varun Gupta <varunraiko1803@gmail.com> | 2018-07-27 11:34:34 +0530 |
commit | bd0b368119b48ffbb1e5ab3cd2887270c5c6840e (patch) | |
tree | 76e7e9ed294cc84f5fe64fe3a4b468c7d54a9d99 /mysql-test/t | |
parent | 37dee22d27c55c14f0be7005c3e5bdbb09e1fc92 (diff) | |
download | mariadb-git-bd0b368119b48ffbb1e5ab3cd2887270c5c6840e.tar.gz |
Fix added along with a test for a case missed in the patch for MDEV-16751
Diffstat (limited to 'mysql-test/t')
-rw-r--r-- | mysql-test/t/subselect_sj_mat.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_sj_mat.test b/mysql-test/t/subselect_sj_mat.test index 794545b53a7..c82c1e7acec 100644 --- a/mysql-test/t/subselect_sj_mat.test +++ b/mysql-test/t/subselect_sj_mat.test @@ -2221,4 +2221,13 @@ drop procedure prepare_data; set @@optimizer_switch= @save_optimizer_switch; drop table t1,t2,t3; +CREATE TABLE t1 ( id int NOT NULL, key(id)); +INSERT INTO t1 VALUES (11),(12),(13),(14),(15),(16),(17),(18),(19); +CREATE TABLE t2 (i1 int NOT NULL, i2 int NOT NULL); +INSERT INTO t2 VALUES (11,11),(12,12),(13,13); +CREATE VIEW v1 AS SELECT t2.i1 FROM t2 where t2.i1 = t2.i2; +explain SELECT 1 FROM t1 where t1.id IN (SELECT v1.i1 from v1); +SELECT 1 FROM t1 where t1.id IN (SELECT v1.i1 from v1); +drop table t1,t2; +drop view v1; --echo # End of 5.5 tests |