summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_json.result
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2016-12-24 10:51:43 +0400
committerAlexey Botchkov <holyfoot@askmonty.org>2016-12-24 10:51:43 +0400
commit4d10273b4fd4e4fa8c479bf23afdd0d01cb3b0b5 (patch)
treee3b18c85f03239cee0cdc5dadc6060f6439da9c9 /mysql-test/r/func_json.result
parentbbb3fb318ebeec4c5e5e932d9b20bd86def753e5 (diff)
downloadmariadb-git-4d10273b4fd4e4fa8c479bf23afdd0d01cb3b0b5.tar.gz
MDEV-11571 JSON_EXTRACT returns wrong results.
Array counter didn't increment after an item was found.
Diffstat (limited to 'mysql-test/r/func_json.result')
-rw-r--r--mysql-test/r/func_json.result3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/func_json.result b/mysql-test/r/func_json.result
index 460ff8fa1d2..cace2f985ac 100644
--- a/mysql-test/r/func_json.result
+++ b/mysql-test/r/func_json.result
@@ -209,6 +209,9 @@ json_extract('[10, 20, [{"a":3}, 30, 40]]', '$[2][*]')
select json_extract('1', '$');
json_extract('1', '$')
1
+select json_extract('[10, 20, [30, 40], 1, 10]', '$[1]');
+json_extract('[10, 20, [30, 40], 1, 10]', '$[1]')
+20
select json_insert('{"a":1, "b":{"c":1}, "d":[1, 2]}', '$.b.k1', 'word');
json_insert('{"a":1, "b":{"c":1}, "d":[1, 2]}', '$.b.k1', 'word')
{"a":1, "b":{"c":1, "k1":"word"}, "d":[1, 2]}