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/r/olap.result | |
| 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/r/olap.result')
| -rw-r--r-- | mysql-test/r/olap.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/olap.result b/mysql-test/r/olap.result index 65f7c649624..fef990297d9 100644 --- a/mysql-test/r/olap.result +++ b/mysql-test/r/olap.result @@ -529,3 +529,15 @@ a LENGTH(a) COUNT(*) 2 1 1 NULL NULL 2 DROP TABLE t1; +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; +a max(b) +NULL 2 +a 1 +NULL 2 +select distinct a, max(b) from t1 group by a with rollup; +a max(b) +NULL 2 +a 1 +drop table t1; |