diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2014-12-01 21:35:31 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2014-12-01 21:35:31 +0300 |
| commit | 753718c20194f9f04432a5657a661eb6e9440483 (patch) | |
| tree | 27da8760e0b7e436f3d3751049fb2b215cfc4912 /mysql-test/t/explain_json.test | |
| parent | c46eadb2b33ca152525a18d9b5425fedbef7f277 (diff) | |
| download | mariadb-git-753718c20194f9f04432a5657a661eb6e9440483.tar.gz | |
EXPLAIN FORMAT=JSON: support SJ-Materialization
- Switch Explain data structure from "flat" representation of
SJ-Materialization into nested one.
- Update functions that print tabular output to operate on the
nested structure.
- Add function to generate JSON output.
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; |