diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-05-24 18:34:34 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-05-24 18:34:34 +0300 |
| commit | 8ede7ccc821f02483b55d791c6d78811ee3d4026 (patch) | |
| tree | cb2013daa74d22af09447996856d0091a77bc408 /mysql-test/r/group_by.result | |
| parent | 4ab6c7c6a01d62a7f37b4cabcd212e4dfce275d0 (diff) | |
| download | mariadb-git-8ede7ccc821f02483b55d791c6d78811ee3d4026.tar.gz | |
Test re-grouping
BitKeeper/deleted/.del-sel000004.test~21904fbd1c95cb1:
Delete: mysql-test/t/sel000004.test
BitKeeper/deleted/.del-sel000004.result~4b5fbc60d0d9754f:
Delete: mysql-test/r/sel000004.result
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 2affdc1b653..aaa03f2668a 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -373,3 +373,23 @@ CONCAT(a, b) count(*) abcdef 1 hijklm 2 DROP TABLE t1; +drop table if exists t1; +create table t1 (One int unsigned, Two int unsigned, Three int unsigned, Four int unsigned); +insert into t1 values (1,2,1,4); +insert into t1 values (1,2,2,4); +insert into t1 values (1,2,3,4); +insert into t1 values (1,2,4,4); +insert into t1 values (1,1,1,4); +insert into t1 values (1,1,2,4); +insert into t1 values (1,1,3,4); +insert into t1 values (1,1,4,4); +insert into t1 values (1,3,1,4); +insert into t1 values (1,3,2,4); +insert into t1 values (1,3,3,4); +insert into t1 values (1,3,4,4); +select One, Two, sum(Four) from t1 group by One,Two; +One Two sum(Four) +1 1 16 +1 2 16 +1 3 16 +drop table if exists t1; |