diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2020-06-30 11:05:03 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2020-06-30 11:37:45 +0530 |
| commit | d3a2c2eac08f4f06ba15cfb354c80310f8c9755c (patch) | |
| tree | a3d3c3a05e6438dd6e657db5f336b1ed8f164d95 /mysql-test/main | |
| parent | baa60b590784c677dd52a94d0bd13c7ec628b740 (diff) | |
| download | mariadb-git-d3a2c2eac08f4f06ba15cfb354c80310f8c9755c.tar.gz | |
Make the test func_json deterministic
Diffstat (limited to 'mysql-test/main')
| -rw-r--r-- | mysql-test/main/func_json.result | 7 | ||||
| -rw-r--r-- | mysql-test/main/func_json.test | 4 |
2 files changed, 6 insertions, 5 deletions
diff --git a/mysql-test/main/func_json.result b/mysql-test/main/func_json.result index aa9c9cdc8b5..cffaf9702be 100644 --- a/mysql-test/main/func_json.result +++ b/mysql-test/main/func_json.result @@ -1332,13 +1332,14 @@ drop table t1; # CREATE TABLE t1 (e INT, a VARCHAR(255), v VARCHAR(255)); INSERT INTO t1 VALUES (0, 'a1', '1') , (0, 'a2', '2') , (1, 'b1', '3'); -EXPLAIN SELECT B.e, JSON_OBJECTAGG(B.a, B.v) FROM t1 A, t1 B GROUP BY B.e; +EXPLAIN SELECT B.e, JSON_OBJECTAGG(B.a, B.v) FROM t1 A, t1 B GROUP BY B.e, B.a; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE A ALL NULL NULL NULL NULL 3 Using temporary; Using filesort 1 SIMPLE B ALL NULL NULL NULL NULL 3 Using join buffer (flat, BNL join) -SELECT B.e, JSON_OBJECTAGG(B.a, B.v) FROM t1 A, t1 B GROUP BY B.e; +SELECT B.e, JSON_OBJECTAGG(B.a, B.v) FROM t1 A, t1 B GROUP BY B.e, B.a; e JSON_OBJECTAGG(B.a, B.v) -0 {"a1":"1", "a1":"1", "a1":"1", "a2":"2", "a2":"2", "a2":"2"} +0 {"a1":"1", "a1":"1", "a1":"1"} +0 {"a2":"2", "a2":"2", "a2":"2"} 1 {"b1":"3", "b1":"3", "b1":"3"} DROP TABLE t1; # diff --git a/mysql-test/main/func_json.test b/mysql-test/main/func_json.test index 75a118a808f..366a91e0cfd 100644 --- a/mysql-test/main/func_json.test +++ b/mysql-test/main/func_json.test @@ -833,8 +833,8 @@ drop table t1; CREATE TABLE t1 (e INT, a VARCHAR(255), v VARCHAR(255)); INSERT INTO t1 VALUES (0, 'a1', '1') , (0, 'a2', '2') , (1, 'b1', '3'); -EXPLAIN SELECT B.e, JSON_OBJECTAGG(B.a, B.v) FROM t1 A, t1 B GROUP BY B.e; -SELECT B.e, JSON_OBJECTAGG(B.a, B.v) FROM t1 A, t1 B GROUP BY B.e; +EXPLAIN SELECT B.e, JSON_OBJECTAGG(B.a, B.v) FROM t1 A, t1 B GROUP BY B.e, B.a; +SELECT B.e, JSON_OBJECTAGG(B.a, B.v) FROM t1 A, t1 B GROUP BY B.e, B.a; DROP TABLE t1; |