diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2003-03-24 22:52:46 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2003-03-24 22:52:46 +0200 |
| commit | d99370dd1b2d5e85c36ed45a9f7758c3d2ebb35c (patch) | |
| tree | 7390f1326facb58897c2b70cd6bcbc46949301f1 /mysql-test/r/having.result | |
| parent | ae14fa140834396d1ede607989edcee2bdea5d7b (diff) | |
| download | mariadb-git-d99370dd1b2d5e85c36ed45a9f7758c3d2ebb35c.tar.gz | |
A fix for bug #176
code cleanup
mysql-test/r/having.result:
A test for the bug fix for bug #176
mysql-test/t/having.test:
A test for the bug fix for bug #176
sql/item.cc:
A for the bug #176
sql/item_func.cc:
Code cleanup
Diffstat (limited to 'mysql-test/r/having.result')
| -rw-r--r-- | mysql-test/r/having.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/having.result b/mysql-test/r/having.result index a33ce457176..f113eb6ed49 100644 --- a/mysql-test/r/having.result +++ b/mysql-test/r/having.result @@ -63,3 +63,10 @@ Fld1 max(Fld2) 1 20 3 50 drop table t1; +create table t1 (id int not null, qty int not null); +insert into t1 values (1,2),(1,3),(2,4),(2,5); +select id, sum(qty) as sqty from t1 group by id having sqty>2; +id sqty +1 5 +2 9 +drop table t1; |