diff options
| author | unknown <igor@rurik.mysql.com> | 2006-10-18 17:24:33 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2006-10-18 17:24:33 -0700 |
| commit | 672b61c5757f2f9a78a0764d2809de52b724c691 (patch) | |
| tree | 52db139379159a04ab7150c97db964b4a3a925ce /mysql-test/t/group_min_max.test | |
| parent | b18b419b5a99456be4746b92cedf3c7e4cdbae44 (diff) | |
| download | mariadb-git-672b61c5757f2f9a78a0764d2809de52b724c691.tar.gz | |
Changed test case for bug 22342 to make it platform independent.
Diffstat (limited to 'mysql-test/t/group_min_max.test')
| -rw-r--r-- | mysql-test/t/group_min_max.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/t/group_min_max.test b/mysql-test/t/group_min_max.test index 9f3fb5ea51e..08f0f54df60 100644 --- a/mysql-test/t/group_min_max.test +++ b/mysql-test/t/group_min_max.test @@ -799,7 +799,7 @@ DROP TABLE t1,t2,t3,t4,t5,t6; # Bug#22342: No results returned for query using max and group by # CREATE TABLE t1 (a int, b int, PRIMARY KEY (a,b), KEY b (b)); -INSERT INTO t1 VALUES (1,1),(1,2); +INSERT INTO t1 VALUES (1,1),(1,2),(1,0),(1,3); explain SELECT MAX(b), a FROM t1 WHERE b < 2 AND a = 1 GROUP BY a; SELECT MAX(b), a FROM t1 WHERE b < 2 AND a = 1 GROUP BY a; |