diff options
author | Varun Gupta <varun.gupta@mariadb.com> | 2020-01-03 22:54:28 +0530 |
---|---|---|
committer | Varun Gupta <varun.gupta@mariadb.com> | 2020-01-03 22:54:28 +0530 |
commit | 1adc559370cc53ca69e225739a942287eba1b974 (patch) | |
tree | 6792969b07ab33b75fb9dbc92f29780c5b119dba | |
parent | 4d7f0735067260bfc600c85e1574b7c708180fc2 (diff) | |
download | mariadb-git-1adc559370cc53ca69e225739a942287eba1b974.tar.gz |
Making group_by test stable
-rw-r--r-- | mysql-test/r/group_by.result | 6 | ||||
-rw-r--r-- | mysql-test/t/group_by.test | 2 |
2 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 9e50ba12db3..d135c196874 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -2796,15 +2796,15 @@ drop table t1; # MDEV-20922: Adding an order by changes the query results # CREATE TABLE t1(a int, b int); -INSERT INTO t1 values (1, 100), (2, 200), (3, 100), (4, 200); +INSERT INTO t1 values (1, 100), (2, 200), (3, 100), (4, 200), (5, 200); create view v1 as select a, b+1 as x from t1; SELECT x, COUNT(DISTINCT a) AS y FROM v1 GROUP BY x ORDER BY y; x y 101 2 -201 2 +201 3 SELECT b+1 AS x, COUNT(DISTINCT a) AS y FROM t1 GROUP BY x ORDER BY y; x y 101 2 -201 2 +201 3 drop view v1; drop table t1; diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index 71e29d55303..4cb4b32e8b8 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -1920,7 +1920,7 @@ drop table t1; --echo # CREATE TABLE t1(a int, b int); -INSERT INTO t1 values (1, 100), (2, 200), (3, 100), (4, 200); +INSERT INTO t1 values (1, 100), (2, 200), (3, 100), (4, 200), (5, 200); create view v1 as select a, b+1 as x from t1; |