diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2014-11-29 01:08:18 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2014-11-29 01:08:18 +0300 |
| commit | 0b5d989c894a14ebcb786940fafd025e31523d8b (patch) | |
| tree | d1798a98c1f8f89f9ab9000e2d5e9be4e3e7a845 /mysql-test/t | |
| parent | 2ac3b39e68bf6bf1b56e6eafd290c0a78368d0be (diff) | |
| download | mariadb-git-0b5d989c894a14ebcb786940fafd025e31523d8b.tar.gz | |
EXPLAIN FORMAT=JSON: Add support for non-merged semi-joins
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/explain_json.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/explain_json.test b/mysql-test/t/explain_json.test index 8631d85a323..6e3e8746e70 100644 --- a/mysql-test/t/explain_json.test +++ b/mysql-test/t/explain_json.test @@ -93,5 +93,11 @@ explain format=json select * from (select a, count(*) as cnt from t1 group by a) as tbl1, t1 as tbl2 where cnt=tbl2.a; +--echo # +--echo # Non-merged semi-join (aka JTBM) +--echo # +explain format=json +select * from t1 where a in (select max(a) from t1 group by b); +drop table t1; drop table t0; |