diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2020-03-23 03:44:24 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2020-06-09 12:48:39 +0530 |
| commit | 8fae3d521d596a8e991360a03310c637587bfa75 (patch) | |
| tree | d8f47b9932251ecc3ce2876baeec86f71d95b02f /mysql-test/main | |
| parent | f968feed977bf6d684347308a36b7083175d6f55 (diff) | |
| download | mariadb-git-10.5-mdev22011.tar.gz | |
For JSON_ARRAYAGG with DISTINCT also store the null bytes for the record
inside the Unique object
Diffstat (limited to 'mysql-test/main')
| -rw-r--r-- | mysql-test/main/func_json.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/func_json.result b/mysql-test/main/func_json.result index c87a2998724..4ef60be9d8f 100644 --- a/mysql-test/main/func_json.result +++ b/mysql-test/main/func_json.result @@ -1160,13 +1160,13 @@ JSON_ARRAYAGG(DISTINCT a) [1,2,3] SELECT JSON_ARRAYAGG(DISTINCT b) FROM t1; JSON_ARRAYAGG(DISTINCT b) -["Hello","World","This","Will","Work","!",null] +[null,"!","Hello","This","Will","Work","World"] SELECT JSON_ARRAYAGG(DISTINCT a LIMIT 2) FROM t1; JSON_ARRAYAGG(DISTINCT a LIMIT 2) [1,2] SELECT JSON_ARRAYAGG(DISTINCT b LIMIT 2) FROM t1; JSON_ARRAYAGG(DISTINCT b LIMIT 2) -["Hello","World"] +[null,"!"] # # JSON aggregation # |