diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2020-06-04 13:53:14 +0400 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@askmonty.org> | 2020-06-04 13:53:14 +0400 |
| commit | 74198384e140bfffb2cbf139ec02e4c91747fab8 (patch) | |
| tree | 5bfa5130d7fefcee01c36a817b398d34bf49d68b /mysql-test/main/func_json.test | |
| parent | 07daf735422403d2336df65ccc3f808d76b28497 (diff) | |
| download | mariadb-git-74198384e140bfffb2cbf139ec02e4c91747fab8.tar.gz | |
MDEV-21914 JSON_ARRAYAGG doesn't reject ORDER BY clause, but doesn't work either.
ORDER BY fixed for JSON_ARRAYAGG.
Diffstat (limited to 'mysql-test/main/func_json.test')
| -rw-r--r-- | mysql-test/main/func_json.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/main/func_json.test b/mysql-test/main/func_json.test index 40e69a61850..a0b65218978 100644 --- a/mysql-test/main/func_json.test +++ b/mysql-test/main/func_json.test @@ -759,6 +759,8 @@ create view v as (select json_arrayagg(json_object("type", "permPeriod", "id", " select * from v; drop view v; +select json_arrayagg(a order by a asc) from (select 1 a union select 2 a) t; + --echo # --echo # End of 10.5 tests --echo # |