summaryrefslogtreecommitdiff
path: root/mysql-test/main/group_by.result
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2020-03-30 18:52:17 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2020-03-30 19:07:25 +0300
commit37c14690fc6bc9237bdad9b8e26157d1174a49fc (patch)
tree490ab3103b3f2dbef654fdd860e891ccde87d93c /mysql-test/main/group_by.result
parentaae3f921adec9b9d1bff093c9a75a94e44f5c8d4 (diff)
parente2f1f88fa60680cb87833a7cceb172f5d436a804 (diff)
downloadmariadb-git-37c14690fc6bc9237bdad9b8e26157d1174a49fc.tar.gz
Merge 10.4 into 10.5
Diffstat (limited to 'mysql-test/main/group_by.result')
-rw-r--r--mysql-test/main/group_by.result15
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/main/group_by.result b/mysql-test/main/group_by.result
index 3a49c075ddd..a06c539f27b 100644
--- a/mysql-test/main/group_by.result
+++ b/mysql-test/main/group_by.result
@@ -2879,6 +2879,20 @@ GROUP BY REPEAT((BINARY pk), v1), AES_DECRYPT((@A := i1), 20852) WITH ROLLUP HAV
1
drop table t1;
#
+# MDEV-22019: Sig 11 in next_breadth_first_tab | max_sort_length setting + double
+# GROUP BY leads to crash
+#
+CALL mtr.add_suppression("Out of sort memory");
+CALL mtr.add_suppression("Sort aborted");
+SET @save_max_sort_length= @@max_sort_length;
+SET max_sort_length=2000000;
+SELECT * FROM information_schema.tables t JOIN information_schema.columns c
+ON t.table_schema=c.table_schema
+WHERE c.table_schema=(SELECT COUNT(*) FROM INFORMATION_SCHEMA.columns GROUP BY column_type)
+GROUP BY t.table_name;
+ERROR HY001: Out of sort memory, consider increasing server sort buffer size
+SET max_sort_length= @save_max_sort_length;
+#
# MDEV-16170
# Server crashes in Item_null_result::type_handler on SELECT with ROLLUP
#
@@ -2889,3 +2903,4 @@ f COUNT(*)
1 1
NULL 1
DROP TABLE t1;
+# End of 10.3 tests