summaryrefslogtreecommitdiff
path: root/mysql-test/main/group_by.result
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2018-05-15 13:38:01 +0300
committerMonty <monty@mariadb.org>2018-05-15 13:51:03 +0300
commit8a9048bcf3f3ef520a9c4654e2e21516c459e4fd (patch)
tree6b40fadfb22f0447e1aecb35ebc526cb023adce9 /mysql-test/main/group_by.result
parente7fc8cd683535c89556abaa6ad13873a40fde6a8 (diff)
downloadmariadb-git-8a9048bcf3f3ef520a9c4654e2e21516c459e4fd.tar.gz
MDEV-16170 Server crashes in Item_null_result::type_handler on SELECT with ROLLUP
Problem was that I in a previous patch enabled ifdef:ed code intended for 10.3 but that never worked. Reverted to original code
Diffstat (limited to 'mysql-test/main/group_by.result')
-rw-r--r--mysql-test/main/group_by.result11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/main/group_by.result b/mysql-test/main/group_by.result
index 62c659dd933..6f1887290c0 100644
--- a/mysql-test/main/group_by.result
+++ b/mysql-test/main/group_by.result
@@ -2832,3 +2832,14 @@ select distinct 1 from t1 group by a,b with rollup limit 1;
1
1
drop table t1;
+#
+# MDEV-16170
+# Server crashes in Item_null_result::type_handler on SELECT with ROLLUP
+#
+CREATE TABLE t1 (d DATE);
+INSERT INTO t1 VALUES ('2032-10-08');
+SELECT d != '2023-03-04' AS f, COUNT(*) FROM t1 GROUP BY d WITH ROLLUP;
+f COUNT(*)
+1 1
+NULL 1
+DROP TABLE t1;