diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2020-06-15 22:51:21 +0400 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@askmonty.org> | 2020-06-15 22:51:21 +0400 |
| commit | 6c573a9146caa76807db1190e0747f5befb5b170 (patch) | |
| tree | a304df0f89fa87736623df6c313ff45fe093b526 /mysql-test/main/func_json.test | |
| parent | 30d41c8102c36af7551b3ae77e48efbeb6d7ecea (diff) | |
| download | mariadb-git-6c573a9146caa76807db1190e0747f5befb5b170.tar.gz | |
MDEV-22844 JSON_ARRAYAGG is limited by group_concat_max_len.
Warning message and function result fixed
Diffstat (limited to 'mysql-test/main/func_json.test')
| -rw-r--r-- | mysql-test/main/func_json.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/main/func_json.test b/mysql-test/main/func_json.test index 7e4c94d8061..1c6c940af0c 100644 --- a/mysql-test/main/func_json.test +++ b/mysql-test/main/func_json.test @@ -812,6 +812,14 @@ SELECT JSON_ARRAYAGG(a ORDER BY a DESC) FROM t1; SELECT JSON_ARRAYAGG(a ORDER BY a ASC) FROM t1; DROP TABLE t1; +set group_concat_max_len=64; +create table t1 (a varchar(254)); +insert into t1 values (concat('x64-', repeat('a', 60))); +insert into t1 values (concat('x64-', repeat('b', 60))); insert into t1 values (concat('x64-', repeat('c', 60))); +select json_arrayagg(a) from t1; +drop table t1; +SET group_concat_max_len= default; + --echo # --echo # End of 10.5 tests --echo # |