diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2021-06-30 01:00:50 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2021-06-30 09:34:27 +0200 |
| commit | 8711adb7863b10fd868cc2b1c84c3416e715b539 (patch) | |
| tree | 9e057fa165121e8db52163c5f7a652872e8d29b0 /mysql-test/main/func_json.result | |
| parent | c8fb911e9cab909ccfbf2a75cb90af501c819f5b (diff) | |
| download | mariadb-git-8711adb7863b10fd868cc2b1c84c3416e715b539.tar.gz | |
fix JSON_ARRAYAGG not to over-quote json in joins
use metadata (in particular is_json() property) of the original
argument item, even if the actual argument was later replaced
with an Item_temptable_field
Diffstat (limited to 'mysql-test/main/func_json.result')
| -rw-r--r-- | mysql-test/main/func_json.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/func_json.result b/mysql-test/main/func_json.result index 0c242a886b7..a889cb228b7 100644 --- a/mysql-test/main/func_json.result +++ b/mysql-test/main/func_json.result @@ -1376,9 +1376,9 @@ SELECT t1.id, JSON_ARRAYAGG(JSON_OBJECT('id',t2.id)) as materials from t1 LEFT JOIN t2 on t1.id = t2.owner_id GROUP BY t1.id ORDER BY id; id materials -1 ["{\"id\": 1}","{\"id\": 2}"] -2 ["{\"id\": 3}"] -3 ["{\"id\": 4}"] +1 [{"id": 1},{"id": 2}] +2 [{"id": 3}] +3 [{"id": 4}] DROP TABLE t1; DROP TABLE t2; # |