diff options
| author | Varun Gupta <varunraiko1803@gmail.com> | 2017-12-30 10:18:22 +0530 |
|---|---|---|
| committer | Varun Gupta <varunraiko1803@gmail.com> | 2017-12-30 10:18:22 +0530 |
| commit | a118c20c8151a4e95f133b6d5bf92bafc7835e23 (patch) | |
| tree | b74a4d00cb0a8e07b631d3ca68c39baab52a1491 /mysql-test/t/explain_json.test | |
| parent | 8bcbcac053b96a39465e4651f51e625c37f94964 (diff) | |
| download | mariadb-git-a118c20c8151a4e95f133b6d5bf92bafc7835e23.tar.gz | |
MDEV-10844: EXPLAIN FORMAT=JSON doesn't show order direction for filesort
Currently explain format=json does not show the order direction of fields used during filesort.
This patch would remove this limitation
Diffstat (limited to 'mysql-test/t/explain_json.test')
| -rw-r--r-- | mysql-test/t/explain_json.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/explain_json.test b/mysql-test/t/explain_json.test index d253b8380e9..c3665b1818b 100644 --- a/mysql-test/t/explain_json.test +++ b/mysql-test/t/explain_json.test @@ -406,3 +406,14 @@ explain format=json select a, (select max(a) from t1 where t0.a<5 and t1.b<t0.a) from t0; drop table t0,t1; +--echo # +--echo # MDEV-10844: EXPLAIN FORMAT=JSON doesn't show order direction for filesort +--echo # + +create table t1 (a int, b int); +insert into t1 values (1,2),(3,4),(2,3); +explain format=json select * from t1 order by a, b desc; +explain format=json select * from t1 order by a desc, b desc; +explain format=json select * from t1 order by a desc, b ; +drop table t1; + |