diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2017-10-06 09:28:33 +0400 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@askmonty.org> | 2017-10-06 09:28:33 +0400 |
| commit | a3ba8c3660aefa9bd7921f8183f13246bfb90432 (patch) | |
| tree | d969114e36ada1fcd90d65875c45b3d2a5556103 /mysql-test/r | |
| parent | 41e581b30b7c6466369f042a58b78c2a2820b3a9 (diff) | |
| download | mariadb-git-a3ba8c3660aefa9bd7921f8183f13246bfb90432.tar.gz | |
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.
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/func_json.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/func_json.result b/mysql-test/r/func_json.result index 06c3b3fc2c3..f1b710c3a86 100644 --- a/mysql-test/r/func_json.result +++ b/mysql-test/r/func_json.result @@ -405,6 +405,13 @@ abc select json_unquote('abc'); json_unquote('abc') abc +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; +fld +{"foo": "{\"bar\": \"abc\"}", "qux": "abc"} +{"foo": "{\"bar\": \"def\"}", "qux": "def"} +drop table t1; select json_object("a", json_object("b", "abcd")); json_object("a", json_object("b", "abcd")) {"a": {"b": "abcd"}} |