[MDEV-11664] [5.5] Error: Freeing overrun buffer upon SELECTs with GROUP BY and ROLLUP Created: 2016-12-23  Updated: 2018-07-10  Resolved: 2018-07-10

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 5.5
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

Setting it to minor because queries are weird, and the problem is only reproducible on 5.5

CREATE TABLE t1 (i INT) ENGINE=MyISAM;
INSERT INTO t1 VALUES (2),(7),(2),(2),(4),(6),(6),(8),(4),(2),(8),(1),(NULL),(3),(2);
 
SELECT ( SELECT DISTINCT i FROM `t1` WHERE i GROUP BY @a := 1 WITH ROLLUP ) AS s1;
SELECT NULL FROM `t1` GROUP BY 'binary', LAST_DAY('2012-12-12') WITH ROLLUP;

5.5 ec6d8dadc01269451332e5b24b12a5350a2a4896

Error: Freeing overrun buffer  mysys/safemalloc.c:179, mysys/my_malloc.c:120, sql/filesort.cc:320, sql/sql_select.cc:19937, sql/sql_select.cc:2837, sql/sql_select.cc:3096, sql/sql_select.cc:319, sql/sql_parse.cc:4686
Allocated at sql/filesort.cc:219, sql/sql_select.cc:19937, sql/sql_select.cc:1888, sql/sql_select.cc:2402, sql/item_subselect.cc:3269, sql/item_subselect.cc:663, sql/item_subselect.cc:1244, sql/item.cc:6642



 Comments   
Comment by Elena Stepanova [ 2018-07-10 ]

Closing since it's a 5.5-only problem, not reproducible on 10.x.

Generated at Thu Feb 08 07:51:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.