EVOLUTION-MANAGER

Edit File: bug43448.result

# # Bug#43448 - Server crashes on multi table delete with Innodb # set session debug_dbug="+d,optimizer_innodb_icp"; CREATE TABLE t1 ( id1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, t CHAR(12) ) ENGINE=InnoDB; CREATE TABLE t2 ( id2 INT NOT NULL, t CHAR(12) ) ENGINE=InnoDB; CREATE TABLE t3( id3 INT NOT NULL, t CHAR(12), INDEX(id3) ) ENGINE=InnoDB; SELECT COUNT(*) FROM t1 WHERE id1 > 90; COUNT(*) 10 SELECT COUNT(*) FROM t2 WHERE id2 > 90; COUNT(*) 50 SELECT COUNT(*) FROM t3 WHERE id3 > 90; COUNT(*) 500 DELETE t1, t2, t3 FROM t1, t2, t3 WHERE t1.id1 = t2.id2 AND t2.id2 = t3.id3 AND t1.id1 > 5; DROP TABLE t1, t2, t3;