diff options
| author | monty@mashka.mysql.fi <> | 2003-05-13 10:54:07 +0300 |
|---|---|---|
| committer | monty@mashka.mysql.fi <> | 2003-05-13 10:54:07 +0300 |
| commit | 4bde719df7b67e8c42c16724af0e3eacb64c3757 (patch) | |
| tree | 911f869319dc53526bc2bb909aa87944db9d2696 /mysql-test/t/having.test | |
| parent | 5b7a86faec185e5d787586a35ee6866e12997836 (diff) | |
| download | mariadb-git-4bde719df7b67e8c42c16724af0e3eacb64c3757.tar.gz | |
Safety fix to enable RAID in max binaries
Better fix for format('nan')
Fix for HAVING COUNT(DISTINCT...)
Diffstat (limited to 'mysql-test/t/having.test')
| -rw-r--r-- | mysql-test/t/having.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/having.test b/mysql-test/t/having.test index fd972fea1ad..cb6fa85ffde 100644 --- a/mysql-test/t/having.test +++ b/mysql-test/t/having.test @@ -63,4 +63,6 @@ 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; +select sum(qty) as sqty from t1 group by id having count(id) > 0; +select sum(qty) as sqty from t1 group by id having count(distinct id) > 0; drop table t1; |