diff options
| author | Sinisa@sinisa.nasamreza.org <> | 2003-03-24 22:52:46 +0200 |
|---|---|---|
| committer | Sinisa@sinisa.nasamreza.org <> | 2003-03-24 22:52:46 +0200 |
| commit | 8c36b3b4ec667c8bf8e9b331e2ab7b83c30d6eb2 (patch) | |
| tree | 7390f1326facb58897c2b70cd6bcbc46949301f1 /mysql-test/t/having.test | |
| parent | 4b1a877b235775717afc0bb114bf5cc7bee0823f (diff) | |
| download | mariadb-git-8c36b3b4ec667c8bf8e9b331e2ab7b83c30d6eb2.tar.gz | |
A fix for bug #176
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; |