3
--echo # Bug#43360 - Server crash with a simple multi-table update
6
--source include/have_debug.inc
7
--source include/have_innodb.inc
10
set session debug="+d,optimizer_innodb_icp";
13
a CHAR(2) NOT NULL PRIMARY KEY,
14
b VARCHAR(20) NOT NULL,
19
a CHAR(2) NOT NULL PRIMARY KEY,
20
b VARCHAR(20) NOT NULL,
26
('JA','Sun Microsystems'),
34
('MS','United States of America'),
35
('IB','North America'),
36
('GO','South America');
38
UPDATE t1,t2 SET t1.b=UPPER(t1.b) WHERE t1.b LIKE 'United%';