diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2014-12-06 20:33:25 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2014-12-06 20:33:25 +0300 |
| commit | 913b7672c5fe2db750a382685f0810d383b43faa (patch) | |
| tree | 98f8456628e218820a1e4bfd35b72d457682f7d1 /mysql-test/t/explain_json.test | |
| parent | db21fddc3740dfa48f3443751c48282467afac5e (diff) | |
| parent | eeef80d09f8045d99963a2bf2fa92595c55bb26d (diff) | |
| download | mariadb-git-913b7672c5fe2db750a382685f0810d383b43faa.tar.gz | |
Merge bb-10.1-explain-json into 10.1
Diffstat (limited to 'mysql-test/t/explain_json.test')
| -rw-r--r-- | mysql-test/t/explain_json.test | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/mysql-test/t/explain_json.test b/mysql-test/t/explain_json.test index b4f90392c53..a94833f86fc 100644 --- a/mysql-test/t/explain_json.test +++ b/mysql-test/t/explain_json.test @@ -2,7 +2,7 @@ # EXPLAIN FORMAT=JSON tests. These are tests developed for MariaDB. # --disable_warnings -drop table if exists t0,t1; +drop table if exists t0,t1,t2; --enable_warnings create table t0(a int); @@ -167,6 +167,24 @@ EXPLAIN FORMAT=JSON SELECT * FROM t1 AS outer_t1 WHERE a <> ALL ( SELECT a FROM DROP TABLE t1,t2; +--echo # +--echo # Join's constant expression +--echo # +create table t0(a int); +insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); + +create table t1(a int, b int); +insert into t1 select tbl1.a+10*tbl2.a, 1234 from t0 tbl1, t0 tbl2; + +explain format=json +select * from t0 +where + 20000 > all (select max(tbl1.a + tbl2.a) + from t1 tbl1, t1 tbl2 where tbl1.b=tbl2.b); + +drop table t1; +drop table t0; + --echo # --echo # MDEV-7264: Assertion `0' failed in subselect_engine::get_identifier() on EXPLAIN JSON --echo # |