diff options
| author | igor@olga.mysql.com <> | 2007-03-10 02:47:47 -0800 |
|---|---|---|
| committer | igor@olga.mysql.com <> | 2007-03-10 02:47:47 -0800 |
| commit | ec4593f59a6fabd69fdea20c2f77bb5c4c775eb6 (patch) | |
| tree | e27071ed704feb214dd2361601b8d647d15ca546 /mysql-test/r/olap.result | |
| parent | 9625f2e902224c0320042a30dbb951dafa41e1f8 (diff) | |
| download | mariadb-git-ec4593f59a6fabd69fdea20c2f77bb5c4c775eb6.tar.gz | |
Fixed bug #26830: a crash for the query with a subselect containing ROLLUP.
Crash happened because the function get_best_group_min_max detected
joins with ROLLUP incorrectly.
Diffstat (limited to 'mysql-test/r/olap.result')
| -rw-r--r-- | mysql-test/r/olap.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/olap.result b/mysql-test/r/olap.result index a392de613f8..91cd15295c3 100644 --- a/mysql-test/r/olap.result +++ b/mysql-test/r/olap.result @@ -645,3 +645,12 @@ a LENGTH(a) COUNT(*) NULL NULL 2 DROP VIEW v1; DROP TABLE t1; +CREATE TABLE t1 (a int, KEY (a)); +INSERT INTO t1 VALUES (3), (1), (4), (1), (3), (1), (1); +SELECT * FROM (SELECT a, SUM(a) FROM t1 GROUP BY a WITH ROLLUP) as t; +a SUM(a) +1 4 +3 6 +4 4 +NULL 14 +DROP TABLE t1; |