diff options
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 26fcc7463d6..78ea56c8090 100644 --- a/mysql-test/t/olap.test +++ b/mysql-test/t/olap.test @@ -265,4 +265,13 @@ SELECT type FROM v1 GROUP BY type WITH ROLLUP; EXPLAIN SELECT type FROM v1 GROUP BY type WITH ROLLUP; DROP VIEW v1; +# Test for bug #11543: ROLLUP query with a repeated column in GROUP BY +# + +CREATE TABLE t1 (a INT(10) NOT NULL, b INT(10) NOT NULL); +INSERT INTO t1 VALUES (1, 1); +INSERT INTO t1 VALUES (1, 2); + +SELECT a, b, a AS c, COUNT(*) AS count FROM t1 GROUP BY a, b, c WITH ROLLUP; + DROP TABLE t1; |