diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2020-06-04 11:00:17 +0400 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@askmonty.org> | 2020-06-04 11:00:17 +0400 |
| commit | 07daf735422403d2336df65ccc3f808d76b28497 (patch) | |
| tree | 3dc85e5676715962a45c39dfcdd55de863767132 /mysql-test/main/func_json.test | |
| parent | bb47050e1fdc49aa56fb55c8c55ff81ba24d355b (diff) | |
| download | mariadb-git-07daf735422403d2336df65ccc3f808d76b28497.tar.gz | |
MDEV-22084 Squared brackets missing from JSON_ARRAYAGG when used in a view.
Item_func_groupconcat::print() should be fixed to work for the derived
classes.
Diffstat (limited to 'mysql-test/main/func_json.test')
| -rw-r--r-- | mysql-test/main/func_json.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/main/func_json.test b/mysql-test/main/func_json.test index 95d35d22d1e..40e69a61850 100644 --- a/mysql-test/main/func_json.test +++ b/mysql-test/main/func_json.test @@ -755,6 +755,10 @@ select json_objectagg(a, b) over () from (select 1 a, 2 b) t; SELECT JSON_ARRAYAGG(NULL) FROM (SELECT 1 AS t) AS A; SELECT JSON_ARRAYAGG("null") FROM (SELECT 1 AS t) AS A; +create view v as (select json_arrayagg(json_object("type", "permPeriod", "id", "asd")) as JSON_DATA); +select * from v; +drop view v; + --echo # --echo # End of 10.5 tests --echo # |