diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2015-06-03 18:45:08 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2015-06-03 18:45:08 +0200 |
| commit | c79e98e4918635da126231224088c054a21917be (patch) | |
| tree | 69b4aa2e27876f1a3ac985a9f24d041c60d5b463 | |
| parent | 5d8cee44073025e5e9da44d7643583b0448c2b85 (diff) | |
| download | mariadb-git-c79e98e4918635da126231224088c054a21917be.tar.gz | |
MDEV-8085 main.group_by failed in buildbot
change the test case to be deterministic
(while still sufficient to test a bug)
| -rw-r--r-- | mysql-test/r/group_by.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/group_by.test | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 1518a2f8982..0b4973cc35b 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -2342,7 +2342,7 @@ DROP TABLE t1; create table t1 (a int, b int); insert into t1 values (1,11), (1,12), (2,22),(2,23), (4,44),(4,45); create table t2 (c int, d int); -insert into t2 values (1,11), (1,12), (2,22),(2,23), (4,44),(4,45); +insert into t2 values (1,11), (2,22), (4,44); select distinct a,sum(b), (select d from t2 where c=a order by max(b) limit 1) from t1 group by a order by max(b); a sum(b) (select d from t2 where c=a order by max(b) limit 1) 1 23 11 diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index e5beeef17fe..c94d27b1d16 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -1523,7 +1523,7 @@ DROP TABLE t1; create table t1 (a int, b int); insert into t1 values (1,11), (1,12), (2,22),(2,23), (4,44),(4,45); create table t2 (c int, d int); -insert into t2 values (1,11), (1,12), (2,22),(2,23), (4,44),(4,45); +insert into t2 values (1,11), (2,22), (4,44); select distinct a,sum(b), (select d from t2 where c=a order by max(b) limit 1) from t1 group by a order by max(b); drop table t1, t2; |