diff options
| author | unknown <igor@rurik.mysql.com> | 2005-09-08 15:45:31 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-09-08 15:45:31 -0700 |
| commit | 3f451df6bbb1f610834bce80eef1c13908d6fb43 (patch) | |
| tree | 26470107142ea65b4924efe53f57d9fd1dad688b /mysql-test/t/olap.test | |
| parent | 174156705eddfbcebe3d9184b35f7dd282efd42b (diff) | |
| download | mariadb-git-3f451df6bbb1f610834bce80eef1c13908d6fb43.tar.gz | |
olap.result, olap.test:
Added a test case with VIEW for bug #12885.
mysql-test/t/olap.test:
Added a test case with VIEW for bug #12885.
mysql-test/r/olap.result:
Added a test case with VIEW for bug #12885.
Diffstat (limited to 'mysql-test/t/olap.test')
| -rw-r--r-- | mysql-test/t/olap.test | 19 |
1 files changed, 17 insertions, 2 deletions
diff --git a/mysql-test/t/olap.test b/mysql-test/t/olap.test index 98dc3e5056b..3a6a5e46f37 100644 --- a/mysql-test/t/olap.test +++ b/mysql-test/t/olap.test @@ -263,8 +263,8 @@ SELECT a, b, a AS c, COUNT(*) AS count FROM t1 GROUP BY a, b, c WITH ROLLUP; DROP TABLE t1; # -# Bug #11885: derived table specified by a subquery with -# ROLLUP over expressions on not nullable group by attributes +# Bug #12885(1): derived table specified by a subquery with +# ROLLUP over expressions on not nullable group by attributes # CREATE TABLE t1 (a int(11) NOT NULL); @@ -294,4 +294,19 @@ EXPLAIN SELECT type FROM v1 GROUP BY type WITH ROLLUP; DROP VIEW v1; DROP TABLE t1; +# +# Bug #12885(2): view specified by a subquery with +# ROLLUP over expressions on not nullable group by attributes +# + +CREATE TABLE t1 (a int(11) NOT NULL); +INSERT INTO t1 VALUES (1),(2); +CREATE VIEW v1 AS + SELECT a, LENGTH(a), COUNT(*) FROM t1 GROUP BY a WITH ROLLUP; + +DESC v1; +SELECT * FROM v1; + +DROP VIEW v1; +DROP TABLE t1; |