diff options
Diffstat (limited to 'mysql-test/t/explain_json.test')
| -rw-r--r-- | mysql-test/t/explain_json.test | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/t/explain_json.test b/mysql-test/t/explain_json.test index ed0cfdaf1eb..2f5c24ab5a5 100644 --- a/mysql-test/t/explain_json.test +++ b/mysql-test/t/explain_json.test @@ -105,6 +105,15 @@ tbl2 where cnt=tbl2.a; --echo # explain format=json select * from t1 where a in (select max(a) from t1 group by b); -drop table t1; + +--echo # +--echo # Semi-join Materialization +--echo # +create table t2 like t1; +insert into t2 select * from t1; +explain format=json +select * from t1,t2 where t1.a in ( select a from t0); + +drop table t1,t2; drop table t0; |