Edit File: bug13633383.result
# # Bug#13633383 63183: SMALL SORT_BUFFER_SIZE CRASH IN MERGE_BUFFERS # CREATE TABLE t1 ( `a` int(11) DEFAULT NULL, `col432` bit(8) DEFAULT NULL, `col433` multipoint DEFAULT NULL, `col434` polygon DEFAULT NULL, `col435` decimal(50,17) unsigned DEFAULT NULL, `col436` geometry NOT NULL, `col437` tinyblob NOT NULL, `col438` multipolygon DEFAULT NULL, `col439` mediumblob NOT NULL, `col440` tinyblob NOT NULL, `col441` double unsigned DEFAULT NULL ); CREATE TABLE t2 ( `a` multipoint DEFAULT NULL, `col460` date DEFAULT NULL, `col461` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `col462` date NOT NULL, `col463` varbinary(89) NOT NULL, `col464` year(4) DEFAULT NULL, `col465` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `col466` varchar(236) CHARACTER SET utf8 NOT NULL, `col467` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ); CREATE TABLE t3 ( `FTS_DOC_ID` bigint(20) unsigned NOT NULL, `col577` datetime DEFAULT NULL, `col579` bit(38) NOT NULL, `col580` varchar(93) NOT NULL, `col581` datetime DEFAULT NULL, `col583` multipolygon DEFAULT NULL, `col584` bit(47) NOT NULL ); set session sort_buffer_size= 32768; select col435 from t3 natural right outer join t1 natural right outer join t2 a left outer join t2 b on 1 group by repeat('a',10000) desc, repeat('a',10000) with rollup ; col435 0.00000000000000000 0.00000000000000000 0.00000000000000000 set session sort_buffer_size= default; DROP TABLE t1, t2, t3;
Back to File Manager