Debian Codegraph @

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

raw
1 --echo #
2 --echo # Bug#43448 - Server crashes on multi table delete with Innodb
3 --echo #
4
5 --source include/have_debug.inc
6 --source include/have_innodb.inc
7 --source include/no_valgrind_without_big.inc
8
9 SET @saved_dbug = @@SESSION.debug_dbug;
10 # crash requires ICP support in InnoDB
11 set session debug_dbug="+d,optimizer_innodb_icp";
12
13 CREATE TABLE t1 (
14 id1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
15 t CHAR(12)
16 ) ENGINE=InnoDB;
17
18 CREATE TABLE t2 (
19 id2 INT NOT NULL,
20 t CHAR(12)
21 ) ENGINE=InnoDB;
22
23 CREATE TABLE t3(
24 id3 INT NOT NULL,
25 t CHAR(12),
26 INDEX(id3)
27 ) ENGINE=InnoDB;
28
29 disable_query_log;
30
31 begin;
32 let $1 = 100;
33 while ($1)
34 {
35 let $2 = 5;
36 eval INSERT INTO t1(t) VALUES ('$1');
37 while ($2)
38 {
39 eval INSERT INTO t2(id2,t) VALUES ($1,'$2');
40 let $3 = 10;
41 while ($3)
42 {
43 eval INSERT INTO t3(id3,t) VALUES ($1,'$2');
44 dec $3;
45 }
46 dec $2;
47 }
48 dec $1;
49 }
50 commit;
51
52 enable_query_log;
53
54 SELECT COUNT(*) FROM t1 WHERE id1 > 90;
55 SELECT COUNT(*) FROM t2 WHERE id2 > 90;
56 SELECT COUNT(*) FROM t3 WHERE id3 > 90;
57
58 DELETE t1, t2, t3
59 FROM t1, t2, t3
60 WHERE t1.id1 = t2.id2 AND t2.id2 = t3.id3 AND t1.id1 > 5;
61
62 DROP TABLE t1, t2, t3;
63 SET debug_dbug= @saved_dbug;