Debian Codegraph @

mysql-test/suite/optimizer_unfixed_bugs/r/bug43360.result

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