Debian Codegraph @

mysql-test/suite/optimizer_unfixed_bugs/t/bug43360.test

raw
1
2 --echo #
3 --echo # Bug#43360 - Server crash with a simple multi-table update
4 --echo #
5
6 --source include/have_debug.inc
7 --source include/have_innodb.inc
8
9 SET @saved_dbug = @@SESSION.debug_dbug;
10 # crash requires this
11 set session debug_dbug="+d,optimizer_innodb_icp";
12
13 CREATE TABLE t1 (
14 a CHAR(2) NOT NULL PRIMARY KEY,
15 b VARCHAR(20) NOT NULL,
16 KEY (b)
17 ) ENGINE=InnoDB;
18
19 CREATE TABLE t2 (
20 a CHAR(2) NOT NULL PRIMARY KEY,
21 b VARCHAR(20) NOT NULL,
22 KEY (b)
23 ) ENGINE=InnoDB;
24
25 INSERT INTO t1 VALUES
26 ('AB','MySQLAB'),
27 ('JA','Sun Microsystems'),
28 ('MS','Microsoft'),
29 ('IB','IBM- Inc.'),
30 ('GO','Google Inc.');
31
32 INSERT IGNORE INTO t2 VALUES
33 ('AB','Sweden'),
34 ('JA','USA'),
35 ('MS','United States of America'),
36 ('IB','North America'),
37 ('GO','South America');
38
39 UPDATE t1,t2 SET t1.b=UPPER(t1.b) WHERE t1.b LIKE 'United%';
40
41 SELECT * FROM t1;
42
43 SELECT * FROM t2;
44
45 DROP TABLE t1,t2;
46 SET debug_dbug= @saved_dbug;