Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3.10
-
None
-
CentOS 7
Description
Server crash after execute simple but long WHERE IN query - crash.sql.
I tested it on the test database:
CREATE TABLE `test` (
`text` varchar(30) CHARACTER SET cp1250 COLLATE cp1250_czech_cs DEFAULT NULL,
`id` varbinary(16) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=binary;
ALTER TABLE `test`
ADD UNIQUE KEY `id` (`id`);
with some test data:
INSERT INTO `test` (`text`, `id`) VALUES
('332969.613019', 0x3131),
('332967.579999.580003', 0x3132),
('332967.579999.580002', 0x3133),
('332967.580000', 0x3134),
('332967.579999', 0x3135),
('abe', 0x3535),
('aaa', 0x33),
('zku', 0x3333),
('dddd', 0x3432343234),
('churu', 0x33353235),
('czrt', 0x333235);
After query I have got server crash - mysqld.log.
Attachments
Issue Links
- duplicates
-
MDEV-17222 Reproducible server crash in String_list::append_str or in Field_iterator_table::create_item
- Closed