EVOLUTION-MANAGER

Edit File: bug43360.test

--echo # --echo # Bug#43360 - Server crash with a simple multi-table update --echo # --source include/have_debug.inc --source include/have_innodb.inc # crash requires this set session debug_dbug="+d,optimizer_innodb_icp"; CREATE TABLE t1 ( a CHAR(2) NOT NULL PRIMARY KEY, b VARCHAR(20) NOT NULL, KEY (b) ) ENGINE=InnoDB; CREATE TABLE t2 ( a CHAR(2) NOT NULL PRIMARY KEY, b VARCHAR(20) NOT NULL, KEY (b) ) ENGINE=InnoDB; INSERT INTO t1 VALUES ('AB','MySQLAB'), ('JA','Sun Microsystems'), ('MS','Microsoft'), ('IB','IBM- Inc.'), ('GO','Google Inc.'); INSERT IGNORE INTO t2 VALUES ('AB','Sweden'), ('JA','USA'), ('MS','United States of America'), ('IB','North America'), ('GO','South America'); UPDATE t1,t2 SET t1.b=UPPER(t1.b) WHERE t1.b LIKE 'United%'; SELECT * FROM t1; SELECT * FROM t2; DROP TABLE t1,t2;