diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2017-09-12 11:20:30 +0400 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@askmonty.org> | 2017-09-12 11:20:30 +0400 |
| commit | 6352ec2184dc8e5744aed3f718fc635edb4b511f (patch) | |
| tree | 384d91f8b9745139274528db590fc01538726759 /mysql-test/r/func_json.result | |
| parent | 31774f0ede81d77d889061324930d3d0066c653a (diff) | |
| download | mariadb-git-6352ec2184dc8e5744aed3f718fc635edb4b511f.tar.gz | |
MDEV-12982 JSON_EXTRACT returns data for invalid JSON.
Let's check the validity to the end of the JSON.
Diffstat (limited to 'mysql-test/r/func_json.result')
| -rw-r--r-- | mysql-test/r/func_json.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/func_json.result b/mysql-test/r/func_json.result index aa8a2850a58..f89c5f1c71b 100644 --- a/mysql-test/r/func_json.result +++ b/mysql-test/r/func_json.result @@ -669,3 +669,8 @@ JSON_EXTRACT('{\"asdf\":true}', "$.\"asdf\"") = 1 select JSON_EXTRACT('{\"input1\":\"\\u00f6\"}', '$.\"input1\"'); JSON_EXTRACT('{\"input1\":\"\\u00f6\"}', '$.\"input1\"') "\u00f6" +select JSON_EXTRACT('{"foo": "bar" foobar foo invalid ', '$.foo'); +JSON_EXTRACT('{"foo": "bar" foobar foo invalid ', '$.foo') +NULL +Warnings: +Warning 4038 Syntax error in JSON text in argument 1 to function 'json_extract' at position 15 |