diff options
| author | unknown <igor@rurik.mysql.com> | 2005-03-17 21:47:46 -0800 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-03-17 21:47:46 -0800 |
| commit | 0f58efbd487dd1b82c6dd3b5e60304a168793eea (patch) | |
| tree | 94ab95bbdfd76062fef924f256214c261124b49a /mysql-test/r/olap.result | |
| parent | 7e9984b15657bd1a8cd7744ddbccdd071af8500f (diff) | |
| parent | ee2633a7e2d21b55d814d7f34fd47d229409e0e5 (diff) | |
| download | mariadb-git-0f58efbd487dd1b82c6dd3b5e60304a168793eea.tar.gz | |
Manual merge
BitKeeper/etc/logging_ok:
auto-union
mysql-test/r/olap.result:
Auto merged
sql/sql_select.cc:
Auto merged
BitKeeper/deleted/.del-isamchk.1.in~9d44303f6d951962:
Auto merged
BitKeeper/deleted/.del-isamlog.1.in~416d91adbf665b19:
Auto merged
Diffstat (limited to 'mysql-test/r/olap.result')
| -rw-r--r-- | mysql-test/r/olap.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/olap.result b/mysql-test/r/olap.result index b04cd6fd068..4863cb5b75e 100644 --- a/mysql-test/r/olap.result +++ b/mysql-test/r/olap.result @@ -379,3 +379,16 @@ a sum(b) 4 4 NULL 14 DROP TABLE t1; +CREATE TABLE t1 (a int, b int); +INSERT INTO t1 VALUES +(1,4), +(2,2), (2,2), +(4,1), (4,1), (4,1), (4,1), +(2,1), (2,1); +SELECT a, SUM(b) FROM t1 GROUP BY a WITH ROLLUP LIMIT 1; +a SUM(b) +1 4 +SELECT SQL_CALC_FOUND_ROWS a, SUM(b) FROM t1 GROUP BY a WITH ROLLUP LIMIT 1; +a SUM(b) +1 4 +DROP TABLE t1; |