MDEV-13703 Illegal mix of collations for operation 'json_object' on

using JSON_UNQUOTE as an argument.

        The coercibility and repertoire should be set properly for the
        JSON_UNQUOTE.

1 files changed, 8 insertions, 0 deletions

diff --git a/mysql-test/t/func_json.test b/mysql-test/t/func_json.test
index bc20a2222df..702ee0ccb9a 100644
--- a/mysql-test/t/func_json.test
+++ b/mysql-test/t/func_json.test
@@ -164,6 +164,14 @@ drop table t1;
 
 select json_unquote('"abc"');
 select json_unquote('abc');
+#
+# MDEV-13703 Illegal mix of collations for operation 'json_object' on using JSON_UNQUOTE as an argument.
+#
+create table t1 (c VARCHAR(8)) DEFAULT CHARSET=latin1;
+insert into t1 values ('abc'),('def');
+ 
+select json_object('foo', json_unquote(json_object('bar', c)),'qux', c) as fld from t1;
+drop table t1;
 
 select json_object("a", json_object("b", "abcd"));
 select json_object("a", '{"b": "abcd"}');