diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-11-30 18:38:44 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-11-30 18:38:44 +0200 |
| commit | 50e61c5175846ebcc72e15444b20995234270ee3 (patch) | |
| tree | ecdcdc76ebb039cd85dc7270371846cbf9836648 /mysql-test | |
| parent | 7dc2b70f4960b201e0edfb8b92a565d71053acf4 (diff) | |
| download | mariadb-git-50e61c5175846ebcc72e15444b20995234270ee3.tar.gz | |
a fix for a bug with HAVING sum_func IN (...)
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/group_by.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/group_by.test | 1 |
2 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 200cbc29b08..b557d90f312 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -30,6 +30,13 @@ Documentation 0 Host communication 0 kkkkkkkkkkk lllllllllll 3 Test Procedures 0 +value description COUNT(bug_id) +BBBBBBBBBBBBB - conversion 2 +BBBBBBBBBBBBB - eeeeeeeee 0 +BBBBBBBBBBBBB - generic 2 +Documentation 0 +Host communication 0 +Test Procedures 0 1+1 a count(*) 2 a 0 1+1 a count(*) diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index dfbb2f325a9..e4b7d659a8e 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -206,6 +206,7 @@ INSERT INTO t2 VALUES ('Web Interface','AAAAAAAA-AAA','id0001','',''); INSERT INTO t2 VALUES ('Host communication','AAAAA','id0001','',''); select value,description,bug_id from t2 left join t1 on t2.program=t1.product and t2.value=t1.component where program="AAAAA"; select value,description,COUNT(bug_id) from t2 left join t1 on t2.program=t1.product and t2.value=t1.component where program="AAAAA" group by value; +select value,description,COUNT(bug_id) from t2 left join t1 on t2.program=t1.product and t2.value=t1.component where program="AAAAA" group by value having COUNT(bug_id) IN (0,2); drop table t1,t2; |