diff options
| author | unknown <igor@olga.mysql.com> | 2007-03-10 02:47:47 -0800 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2007-03-10 02:47:47 -0800 |
| commit | 4d6ad7ac60a0b4b0c5f38f7d415430553f74279b (patch) | |
| tree | e27071ed704feb214dd2361601b8d647d15ca546 /mysql-test/r/olap.result | |
| parent | 52fb60dadf767690227afc6b7a7ec540e5b78be9 (diff) | |
| download | mariadb-git-4d6ad7ac60a0b4b0c5f38f7d415430553f74279b.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.
mysql-test/r/olap.result:
Added a test case for bug #26830.
mysql-test/t/olap.test:
Added a test case for bug #26830.
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; |