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/r/having.result | |
| 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/r/having.result')
| -rw-r--r-- | mysql-test/r/having.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/having.result b/mysql-test/r/having.result index 35a1358dd0c..379c2f83c78 100644 --- a/mysql-test/r/having.result +++ b/mysql-test/r/having.result @@ -128,6 +128,19 @@ id description c 1 test 0 2 test2 0 drop table t1,t2,t3; +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; +SUM(a) +2 +6 +4 +SELECT SUM(a) FROM t1 GROUP BY a HAVING SUM(a); +SUM(a) +2 +6 +4 +DROP TABLE t1; create table t1 (col1 int, col2 varchar(5), col_t1 int); create table t2 (col1 int, col2 varchar(5), col_t2 int); create table t3 (col1 int, col2 varchar(5), col_t3 int); |