Multi-table DELETE that uses innodb + index_merge/intersect may fail to delete rows
Bug #1006164 reported by
Sergey Petrunia
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
High
|
Sergey Petrunia |
Bug Description
Based on customer case, csc#250:
CREATE TABLE tbl (
id PRIMARY KEY,
key1 INT,
key2 INT,
KEY (key1),
KEY (key2) ) engine=innodb;
...
DELETE tbl FROM tbl WHERE key1=const1 AND key2=const2;
^^ this will delete fewer rows than it actually matches.
* Problem happens only with InnoDB (not with MyISAM)
* Setting "index_merge=off" fixes the problem.
* Using a non-multi-
Changed in maria: | |
status: | In Progress → Fix Committed |
To post a comment you must log in.
Doesn't occur in MariaDB 5.2, occurs in 5.3 and 5.5