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 | 3e5d156223e50f003928f01d96e2f6c75b1240f4 (patch) | |
| tree | 255c146b75f6fe2ade4ac76591276a5c57a4ecdd /mysql-test/t | |
| parent | 255ace8bfd36669a647debaf456f2ba22bba4bd1 (diff) | |
| download | mariadb-git-3e5d156223e50f003928f01d96e2f6c75b1240f4.tar.gz | |
Fix for sum_func IN (..)
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/group_by.test | 2 |
1 files changed, 2 insertions, 0 deletions
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; |