1#
2# MDEV-15492: Subquery crash similar to MDEV-10050
3#
4SET @qcs.save= @@global.query_cache_size, @qct.save= @@global.query_cache_type;
5SET GLOBAL query_cache_size= 512*1024*1024, query_cache_type= ON;
6connect  con1,localhost,root,,test;
7CREATE TABLE t1 (a INT) ENGINE=InnoDB;
8CREATE TABLE t2 (b INT) ENGINE=InnoDB;
9CREATE VIEW v AS select a from t1 join t2;
10PREPARE stmt1 FROM "SELECT * FROM t1 WHERE a in (SELECT a FROM v)";
11connect  con2,localhost,root,,test;
12PREPARE stmt2 FROM "SELECT * FROM t1 WHERE a in (SELECT a FROM v)";
13EXECUTE stmt2;
14a
15connection con1;
16EXECUTE stmt1;
17a
18INSERT INTO t2 VALUES (0);
19EXECUTE stmt1;
20a
21START TRANSACTION;
22EXECUTE stmt1;
23a
24disconnect con1;
25disconnect con2;
26connection default;
27DROP VIEW v;
28DROP TABLE t1, t2;
29SET GLOBAL query_cache_size= @qcs.save, query_cache_type= @qct.save;
30