diff options
| author | unknown <evgen@moonbone.local> | 2005-09-15 21:34:53 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-09-15 21:34:53 +0400 |
| commit | 4805236e2f04c5acf60bac87fb446e5df16133e0 (patch) | |
| tree | e75c84522fb1968923ca4057b2d99272b9e8670a /mysql-test/t/olap.test | |
| parent | c11974e678e6c4a5c4c9ebc98547a5f80e68f81d (diff) | |
| parent | 36d163d6cf1f4ce522e081c378129f9723760d15 (diff) | |
| download | mariadb-git-4805236e2f04c5acf60bac87fb446e5df16133e0.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-4.1
into moonbone.local:/work/12887-bug-4.1-mysql
Diffstat (limited to 'mysql-test/t/olap.test')
| -rw-r--r-- | mysql-test/t/olap.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/olap.test b/mysql-test/t/olap.test index 76c62d14621..4f9790b0de6 100644 --- a/mysql-test/t/olap.test +++ b/mysql-test/t/olap.test @@ -263,4 +263,13 @@ SELECT * FROM (SELECT a, LENGTH(a), COUNT(*) FROM t1 GROUP BY a WITH ROLLUP) t; DROP TABLE t1; +# +# Bug #12887 Distinct is not always applied after rollup +# +create table t1 ( a varchar(9), b int ); +insert into t1 values('a',1),(null,2); +select a, max(b) from t1 group by a with rollup; +select distinct a, max(b) from t1 group by a with rollup; +drop table t1; + # End of 4.1 tests |