summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2018-09-11 14:37:45 +0400
committerAlexey Botchkov <holyfoot@askmonty.org>2018-09-11 14:37:45 +0400
commitc8bb43a9385cdb7a27f0702742a8d1e08a85befd (patch)
treef4375293244135af1f4fd9cfcdbf30f1961749fb /mysql-test/r
parent4d9ec7cb6c83c571115bde59d72f02b494764755 (diff)
downloadmariadb-git-c8bb43a9385cdb7a27f0702742a8d1e08a85befd.tar.gz
MDEV-17121 JSON_ARRAY_APPEND.
Extra comma added to the result when an json array is empty.
Diffstat (limited to 'mysql-test/r')
-rw-r--r--mysql-test/r/func_json.result6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/func_json.result b/mysql-test/r/func_json.result
index e8b2fac4fb8..9c7a10625e3 100644
--- a/mysql-test/r/func_json.result
+++ b/mysql-test/r/func_json.result
@@ -790,3 +790,9 @@ JSON_SET('{}', '$.a', _utf8 0xC3B6, '$.b', _utf8 0xC3B6)
SELECT JSON_SET('{}', '$.a', _utf8 X'C3B6', '$.x', 1, '$.b', _utf8 X'C3B6');
JSON_SET('{}', '$.a', _utf8 X'C3B6', '$.x', 1, '$.b', _utf8 X'C3B6')
{"a": "ö", "x": 1, "b": "ö"}
+#
+# MDEV-17121 JSON_ARRAY_APPEND
+#
+select json_array_append('[ ]', '$', 'aue');
+json_array_append('[ ]', '$', 'aue')
+["aue"]