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/t/having.test | |
| 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/t/having.test')
| -rw-r--r-- | mysql-test/t/having.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/having.test b/mysql-test/t/having.test index 8dd7606d82b..fd972fea1ad 100644 --- a/mysql-test/t/having.test +++ b/mysql-test/t/having.test @@ -60,3 +60,7 @@ select Fld1, max(Fld2) from t1 group by Fld1 having max(Fld2) is not null; select Fld1, max(Fld2) from t1 group by Fld1 having avg(Fld2) is not null; select Fld1, max(Fld2) from t1 group by Fld1 having std(Fld2) is not null; 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; +drop table t1; |