summaryrefslogtreecommitdiff
path: root/mysql-test/t/olap.test
diff options
context:
space:
mode:
authorunknown <sergefp@mysql.com>2005-09-09 10:54:59 +0400
committerunknown <sergefp@mysql.com>2005-09-09 10:54:59 +0400
commit20994fec52db1d95b085704c424ef5d292c9a307 (patch)
treed061df624f7dfc9d9b60f22b9a9d7e570f0a819d /mysql-test/t/olap.test
parentcf0b4702f568ca76e78e1ac47e0e37e19f1b00f8 (diff)
parent213fa9cbc234c1a10e50f2bf53b2e1f520284034 (diff)
downloadmariadb-git-20994fec52db1d95b085704c424ef5d292c9a307.tar.gz
Merge 4.1->5.0
client/mysqlimport.c: Auto merged configure.in: Auto merged include/my_global.h: Auto merged mysql-test/r/connect.result: Auto merged mysql-test/r/func_gconcat.result: Auto merged mysql-test/t/connect.test: Auto merged mysql-test/t/func_gconcat.test: Auto merged ndb/src/kernel/blocks/backup/Backup.cpp: Auto merged ndb/src/kernel/blocks/backup/Backup.hpp: Auto merged ndb/src/kernel/main.cpp: Auto merged ndb/src/mgmsrv/MgmtSrvr.cpp: Auto merged ndb/src/mgmsrv/MgmtSrvr.hpp: Auto merged ndb/src/ndbapi/Makefile.am: Auto merged ndb/test/src/NdbBackup.cpp: Auto merged sql/item_cmpfunc.cc: Auto merged sql/item_cmpfunc.h: Auto merged sql/sql_select.cc: Auto merged
Diffstat (limited to 'mysql-test/t/olap.test')
-rw-r--r--mysql-test/t/olap.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/olap.test b/mysql-test/t/olap.test
index 2e09bc5b3a3..e7853ce43bb 100644
--- a/mysql-test/t/olap.test
+++ b/mysql-test/t/olap.test
@@ -251,6 +251,19 @@ SELECT IFNULL(a, 'TEST'), COALESCE(b, 'TEST') FROM t2
DROP TABLE t1,t2;
#
+
+DROP TABLE t1;
+
+#
+# Bug #11885: derived table 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);
+
+SELECT * FROM (SELECT a, a + 1, COUNT(*) FROM t1 GROUP BY a WITH ROLLUP) t;
+SELECT * FROM (SELECT a, LENGTH(a), COUNT(*) FROM t1 GROUP BY a WITH ROLLUP) t;
# Tests for bug #11639: ROLLUP over view executed through filesort
#