Debian Codegraph @

mysql-test/suite/innodb/r/undo_log_temp_table_debug.result

raw
1 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* table .* does not exist "
2 "in the InnoDB internal");
3 call mtr.add_suppression("Found .* prepared XA transactions");
4 set global innodb_file_per_table = off;
5 # The use of temporary tables inside XA transactions is only permitted
6 # when xa_detach_on_prepare is OFF.
7 SET SESSION xa_detach_on_prepare = OFF;
8 create temporary table t1 (i int) engine=innodb;
9 create table t2 (i int) engine=innodb;
10 insert into t2 values (301);
11 xa start 'tx2';
12 insert into t1 values (2), (3);
13 insert into t2 values (202), (303);
14 select * from t1;
15 i
16 2
17 3
18 select * from t2;
19 i
20 301
21 202
22 303
23 xa end 'tx2';
24 set session debug="+d,ib_trx_crash_during_xa_prepare_step";
25 xa prepare 'tx2';
26 ERROR HY000: Lost connection to MySQL server during query
27 select * from t2;
28 i
29 301
30 drop table t2;
31 SET SESSION xa_detach_on_prepare = OLD_VALUE_xa_detach_on_prepare;
32 use test;
33 create temporary table t1
34 (a int, b char(100), c char(100)) engine = innodb;
35 create table t2
36 (a int, b char(100), c char(100)) engine = innodb;
37 create procedure populate_t1_t2()
38 begin
39 declare i int default 1;
40 while (i <= 50) DO
41 insert into t1 values (i, 'a', 'b');
42 insert into t2 values (i, 'a', 'b');
43 set i = i + 1;
44 end while;
45 end|
46 call populate_t1_t2;
47 begin;
48 call populate_t1_t2();
49 update t1 set a = a + 1;
50 update t2 set a = a + 1;
51 select count(*) from t1;
52 count(*)
53 100
54 select count(*) from t2;
55 count(*)
56 100
57 set session debug="+d,ib_trx_crash_during_commit";
58 commit;
59 ERROR HY000: Lost connection to MySQL server during query
60 # restart
61 select count(*) from t2;
62 count(*)
63 50
64 drop table t2;
65 drop procedure populate_t1_t2;
66 # restart: --innodb_rollback_segments=1
67 create table t (i int) engine=innodb;
68 insert into t values (1);
69 insert into t values (2);
70 create temporary table t2 (i int) engine=innodb;
71 insert into t values (1);
72 insert into t values (2);
73 drop table t;
74 drop table t2;
75 create procedure populate_t1_t2()
76 begin
77 declare i int default 1;
78 while (i <= 100) DO
79 insert into t1 values (i, 'a', 'b');
80 insert into t2 values (i, 'a', 'b');
81 set i = i + 1;
82 end while;
83 end|
84 create table t2
85 (a int, b char(100), c char(100)) engine = innodb;
86 create temporary table t1
87 (a int, b char(100), c char(100)) engine = innodb;
88 call populate_t1_t2();
89 select count(*) from t1;
90 count(*)
91 100
92 drop table t1;
93 create temporary table t1
94 (a int, b char(100), c char(100)) engine = innodb;
95 call populate_t1_t2();
96 commit;
97 select count(*) from t1;
98 count(*)
99 100
100 drop table t1;
101 drop table t2;
102 drop procedure populate_t1_t2;
103 # restart: --innodb_rollback_segments=1
104 create table t (i int) engine=innodb;
105 insert into t values (1);
106 insert into t values (2);
107 create temporary table t2 (i int) engine=innodb;
108 insert into t values (1);
109 insert into t values (2);
110 drop table t;
111 drop table t2;
112 # restart: --innodb_rollback_segments=8
113 create table t (i int) engine=innodb;
114 insert into t values (1);
115 insert into t values (2);
116 insert into t values (2);
117 insert into t values (2);
118 insert into t values (2);
119 create temporary table t2 (i int) engine=innodb;
120 insert into t values (1);
121 insert into t values (2);
122 insert into t values (2);
123 insert into t values (2);
124 insert into t values (2);
125 insert into t values (2);
126 drop table t;
127 drop table t2;
128 # restart: