diff options
Diffstat (limited to 'mysql-test/t/func_json.test')
| -rw-r--r-- | mysql-test/t/func_json.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/t/func_json.test b/mysql-test/t/func_json.test index c660cb14856..a34cede537c 100644 --- a/mysql-test/t/func_json.test +++ b/mysql-test/t/func_json.test @@ -360,3 +360,27 @@ select json_array(5,json_query('[1,2]','$')); SELECT JSON_ARRAY('1. ě 2. š 3. č 4. ř 5. ž 6. ý 7. á 8. í 9. é 10. ů 11. ú') AS json_data; SELECT JSON_OBJECT("user","Jožko Mrkvičká") as json_data; + +--echo # +--echo # Start of 10.3 tests +--echo # + +--echo # +--echo # MDEV-12854 Synchronize CREATE..SELECT data type and result set metadata data type for INT functions +--echo # + +--enable_metadata +--disable_ps_protocol + +SELECT + JSON_VALID('{"id": 1, "name": "Monty"}') AS json_valid, + JSON_EXISTS('{"key1":"xxxx", "key2":[1, 2, 3]}', "$.key2") AS json_exists, + JSON_CONTAINS('{"A": 0, "B": {"C": 1}, "D": 2}', '2', '$.A') AS ison_contains, + JSON_CONTAINS_PATH('{"A": 1, "B": [2], "C": [3, 4]}', 'one', '$.A', '$.D') AS json_contains_path; + +SELECT + JSON_LENGTH('{"a": 1, "b": {"c": 30}}') AS json_length, + JSON_DEPTH('[10, {"a": 20}]') AS json_depnth; + +--enable_ps_protocol +--disable_metadata |