diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-12-02 14:16:02 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-12-02 14:16:02 +0200 |
| commit | 62399923d9a6348a232fbbc275135962f8bb25f3 (patch) | |
| tree | 255c146b75f6fe2ade4ac76591276a5c57a4ecdd /mysql-test | |
| parent | 533ab812d5724556deb8d31b82bdd3a8cb71cfaf (diff) | |
| download | mariadb-git-62399923d9a6348a232fbbc275135962f8bb25f3.tar.gz | |
Fix for sum_func IN (..)
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/group_by.result | 5 | ||||
| -rw-r--r-- | mysql-test/t/group_by.test | 2 |
2 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index b557d90f312..7b104996769 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -47,6 +47,11 @@ userid count(*) 3 3 2 1 1 2 +userid count(*) +3 3 +1 2 +userid count(*) +3 3 table type possible_keys key key_len ref rows Extra t1 range spID spID 5 NULL 2 where used; Using index; Using temporary table type possible_keys key key_len ref rows Extra diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index e4b7d659a8e..c3e4f34b0fa 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -235,6 +235,8 @@ CREATE TABLE t1 ( INSERT INTO t1 VALUES (1,1,1),(2,2,2),(2,1,1),(3,3,3),(4,3,3),(5,3,3); explain select userid,count(*) from t1 group by userid desc; select userid,count(*) from t1 group by userid desc; +select userid,count(*) from t1 group by userid desc having (count(*)+1) IN (4,3); +select userid,count(*) from t1 group by userid desc having 3 IN (1,COUNT(*)); explain select spid,count(*) from t1 where spid between 1 and 2 group by spid desc; explain select spid,count(*) from t1 where spid between 1 and 2 group by spid; select spid,count(*) from t1 where spid between 1 and 2 group by spid; |