diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2003-07-09 22:33:26 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2003-07-09 22:33:26 +0300 |
| commit | 628b5c39f8f05c36d5bdabc092e66723853e2070 (patch) | |
| tree | 699a2c0fb15472ee1f20521c1f61b1f0c12d44f9 /mysql-test/r/group_by.result | |
| parent | 9e386beadb2372ccef25827b582e4aabe5142670 (diff) | |
| download | mariadb-git-628b5c39f8f05c36d5bdabc092e66723853e2070.tar.gz | |
Test case for bug #807
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 67e6bec09f6..f89cb8a6792 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -585,4 +585,15 @@ select id, sum(qty) as sqty, count(qty) as cqty from t1 group by id having sum(q id sqty cqty 1 5 2 2 9 2 +select count(*), case interval(qty,2,3,4,5,6,7,8) when -1 then NULL when 0 then "zero" when 1 then "one" when 2 then "two" end as category from t1 group by category; +count(*) category +2 NULL +1 one +1 two +select count(*), interval(qty,2,3,4,5,6,7,8) as category from t1 group by category; +count(*) category +1 1 +1 2 +1 3 +1 4 drop table t1; |