diff options
| author | unknown <igor@rurik.mysql.com> | 2006-01-07 23:10:08 -0800 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2006-01-07 23:10:08 -0800 |
| commit | 48c82418537a1b846b53ef9d19e359287e99e21b (patch) | |
| tree | 860a48ec0ef1950a47cf365a8f24faed709f698d /mysql-test/t/having.test | |
| parent | 312c2f4759514c6594e630e6d1237b8875022328 (diff) | |
| parent | 770e0e8118065a27c1e9583b1707864ab4c3120c (diff) | |
| download | mariadb-git-48c82418537a1b846b53ef9d19e359287e99e21b.tar.gz | |
Merge rurik.mysql.com:/home/igor/dev/mysql-4.1-0
into rurik.mysql.com:/home/igor/dev/mysql-5.0-0
mysql-test/t/having.test:
Auto merged
mysql-test/r/having.result:
Manual merge.
sql/sql_select.cc:
Manual merge.
Diffstat (limited to 'mysql-test/t/having.test')
| -rw-r--r-- | mysql-test/t/having.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/having.test b/mysql-test/t/having.test index fb223d2a9af..1cc894697f9 100644 --- a/mysql-test/t/having.test +++ b/mysql-test/t/having.test @@ -123,6 +123,18 @@ group by a.id, a.description having (a.description is not null) and (c=0); drop table t1,t2,t3; +# +# Bug #14274: HAVING clause containing only set function +# + +CREATE TABLE t1 (a int); +INSERT INTO t1 VALUES (3), (4), (1), (3), (1); + +SELECT SUM(a) FROM t1 GROUP BY a HAVING SUM(a)>0; +SELECT SUM(a) FROM t1 GROUP BY a HAVING SUM(a); + +DROP TABLE t1; + # End of 4.1 tests # |