diff options
author | Alexey Botchkov <holyfoot@askmonty.org> | 2020-06-15 23:21:29 +0400 |
---|---|---|
committer | Alexey Botchkov <holyfoot@askmonty.org> | 2020-06-15 23:21:29 +0400 |
commit | e290e5a75d0c2b12133c2ed118e3bc9bd26a266d (patch) | |
tree | b78ba5f70ad319cffe8b61f1824bacfe892c5659 /mysql-test/main/func_json.result | |
parent | 6c573a9146caa76807db1190e0747f5befb5b170 (diff) | |
download | mariadb-git-e290e5a75d0c2b12133c2ed118e3bc9bd26a266d.tar.gz |
MDEV-22837 JSON_ARRAYAGG and JSON_OBJECTAGG treat JSON arguments as text.
Item_field::is_json_value() implemented.
Diffstat (limited to 'mysql-test/main/func_json.result')
-rw-r--r-- | mysql-test/main/func_json.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/main/func_json.result b/mysql-test/main/func_json.result index 1151d9761ea..b3d7a1d2ed1 100644 --- a/mysql-test/main/func_json.result +++ b/mysql-test/main/func_json.result @@ -1320,6 +1320,13 @@ Warnings: Warning 1260 Row 1 was cut by JSON_ARRAYAGG() drop table t1; SET group_concat_max_len= default; +create table t1 (col1 json); +insert into t1 values('{"color":"red", "size":1}' ); +insert into t1 values('{"color":"blue", "size":2}' ); +select JSON_ARRAYAGG(col1) from t1; +JSON_ARRAYAGG(col1) +[{"color":"red", "size":1},{"color":"blue", "size":2}] +drop table t1; # # End of 10.5 tests # |