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.test | |
| 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.test')
| -rw-r--r-- | mysql-test/main/func_json.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/main/func_json.test b/mysql-test/main/func_json.test index 1c6c940af0c..531f6cd758d 100644 --- a/mysql-test/main/func_json.test +++ b/mysql-test/main/func_json.test @@ -820,6 +820,12 @@ select json_arrayagg(a) from t1; 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; +drop table t1; + --echo # --echo # End of 10.5 tests --echo # |