diff options
| author | unknown <sergefp@mysql.com> | 2005-04-28 19:58:52 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2005-04-28 19:58:52 +0400 |
| commit | e26a93e99971a12b28344dcaa0ee7a023b946a49 (patch) | |
| tree | efc462a657d27e51fb6017c4b9721183f8637001 /mysql-test | |
| parent | b411128fa541123f5a2663448c9c6ce6b6091df1 (diff) | |
| parent | 7183076dcfffac42de55b5bb8862f13f2baa2b35 (diff) | |
| download | mariadb-git-e26a93e99971a12b28344dcaa0ee7a023b946a49.tar.gz | |
Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-4.1
into mysql.com:/home/psergey/mysql-4.1-bug9298
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/group_by.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/group_by.test | 7 |
2 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index a8766907fa5..b0c00a51722 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -702,3 +702,12 @@ c val-74 val-98 drop table t1,t2; +create table t1 (b int4 unsigned not null); +insert into t1 values(3000000000); +select * from t1; +b +3000000000 +select min(b) from t1; +min(b) +3000000000 +drop table t1; diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index 46e58cd00fd..fbd39019e6d 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -515,3 +515,10 @@ explain select c from t2 where a = 2 and b = 'val-2' group by c; select c from t2 where a = 2 and b = 'val-2' group by c; drop table t1,t2; +# Test for BUG#9298 "Wrong handling of int4 unsigned columns in GROUP functions" +# (the actual problem was with protocol code, not GROUP BY) +create table t1 (b int4 unsigned not null); +insert into t1 values(3000000000); +select * from t1; +select min(b) from t1; +drop table t1; |