MDEV-11468 JSON_UNQUOTE returns incorrect results.

        Now return the argument's value when error.

2 files changed, 4 insertions, 0 deletions

diff --git a/mysql-test/r/func_json.result b/mysql-test/r/func_json.result
index 36430973fe7..df34e5b80bc 100644
--- a/mysql-test/r/func_json.result
+++ b/mysql-test/r/func_json.result
@@ -277,6 +277,9 @@ drop table t1;
 select json_unquote('"abc"');
 json_unquote('"abc"')
 abc
+select json_unquote('abc');
+json_unquote('abc')
+abc
 select json_object("a", json_object("b", "abcd"));
 json_object("a", json_object("b", "abcd"))
 {"a": {"b": "abcd"}}
diff --git a/mysql-test/t/func_json.test b/mysql-test/t/func_json.test
index 62853de6ad2..357f223f579 100644
--- a/mysql-test/t/func_json.test
+++ b/mysql-test/t/func_json.test
@@ -121,6 +121,7 @@ drop table t1;
 
 
 select json_unquote('"abc"');
+select json_unquote('abc');
 
 select json_object("a", json_object("b", "abcd"));
 select json_object("a", '{"b": "abcd"}');