19
25
) ENGINE=MyISAM DEFAULT CHARSET=latin1
21
27
create table t3 (j char(5));
22
create table t1 select 1 as i;;
23
create table t1 like t3;
24
ERROR 42S01: Table 't1' already exists
27
t1 CREATE TABLE `t1` (
28
`i` int(1) NOT NULL DEFAULT '0'
29
) ENGINE=MyISAM DEFAULT CHARSET=latin1
31
create table t1 select 1 as i;;
32
rename table t3 to t1;
33
ERROR 42S01: Table 't1' already exists
36
t1 CREATE TABLE `t1` (
37
`i` int(1) NOT NULL DEFAULT '0'
38
) ENGINE=MyISAM DEFAULT CHARSET=latin1
40
create table t1 select 1 as i;;
28
set debug_sync='create_table_select_before_create SIGNAL parked WAIT_FOR go';
29
create table t1 select 1 as i;;
30
set debug_sync='now WAIT_FOR parked';
31
create table t1 like t3;;
32
set debug_sync='now SIGNAL go';
33
ERROR 42S01: Table 't1' already exists
36
t1 CREATE TABLE `t1` (
37
`i` int(1) NOT NULL DEFAULT '0'
38
) ENGINE=MyISAM DEFAULT CHARSET=latin1
40
set debug_sync='create_table_select_before_create SIGNAL parked WAIT_FOR go';
41
create table t1 select 1 as i;;
42
set debug_sync='now WAIT_FOR parked';
43
rename table t3 to t1;;
44
set debug_sync='now SIGNAL go';
45
ERROR 42S01: Table 't1' already exists
48
t1 CREATE TABLE `t1` (
49
`i` int(1) NOT NULL DEFAULT '0'
50
) ENGINE=MyISAM DEFAULT CHARSET=latin1
52
set debug_sync='create_table_select_before_create SIGNAL parked WAIT_FOR go';
53
create table t1 select 1 as i;;
54
set debug_sync='now WAIT_FOR parked';
41
55
alter table t3 rename to t1;
42
56
ERROR 42S01: Table 't1' already exists
57
set debug_sync='now SIGNAL go';
43
58
show create table t1;
45
60
t1 CREATE TABLE `t1` (
46
61
`i` int(1) NOT NULL DEFAULT '0'
47
62
) ENGINE=MyISAM DEFAULT CHARSET=latin1
64
set debug_sync='create_table_select_before_create SIGNAL parked WAIT_FOR go';
49
65
create table t1 select 1 as i;;
66
set debug_sync='now WAIT_FOR parked';
50
67
alter table t3 rename to t1, add k int;
51
68
ERROR 42S01: Table 't1' already exists
69
set debug_sync='now SIGNAL go';
52
70
show create table t1;
54
72
t1 CREATE TABLE `t1` (
55
73
`i` int(1) NOT NULL DEFAULT '0'
56
74
) ENGINE=MyISAM DEFAULT CHARSET=latin1
58
set session debug="-d,sleep_create_select_before_create:+d,sleep_create_select_before_open";
59
create table t1 select 1 as i;;
61
create table t1 select 1 as i;;
62
rename table t1 to t2;
64
create table t1 select 1 as i;;
69
create table t1 select 1 as i;;
70
insert into t1 values (2);
77
create table t1 select 1 as i;;
78
create trigger t1_bi before insert on t1 for each row set @a:=1;
83
set session debug="-d,sleep_create_select_before_open:+d,sleep_create_select_before_lock";
84
create table t1 select 1 as i;;
86
create table t1 select 1 as i;;
87
rename table t1 to t2;
89
create table t1 select 1 as i;;
94
create table t1 select 1 as i;;
95
insert into t1 values (2);
102
create table t1 select 1 as i;;
103
create trigger t1_bi before insert on t1 for each row set @a:=1;
108
set session debug="-d,sleep_create_select_before_lock:+d,sleep_create_select_before_check_if_exists";
109
create table t1 (i int);
110
create table if not exists t1 select 1 as i;;
113
Note 1050 Table 't1' already exists
114
create table t1 (i int);
116
create table if not exists t1 select 1 as i;;
117
create trigger t1_bi before insert on t1 for each row set @a:=1;
119
Note 1050 Table 't1' already exists
127
set session debug="-d,sleep_create_select_before_check_if_exists";
128
create table t2 (a int);
129
create table t4 (b int);
134
create table t3 as select * from t4;;
135
create table t1 select * from t2, t3;;
139
show create table t1;
141
t1 CREATE TABLE `t1` (
142
`a` int(11) DEFAULT NULL,
143
`b` int(11) DEFAULT NULL
144
) ENGINE=MyISAM DEFAULT CHARSET=latin1
150
rename table t4 to t3;;
151
create table if not exists t1 select 1 as i from t2, t3;;
152
create table t5 (j int);
153
rename table t5 to t1;
156
Note 1050 Table 't1' already exists
159
show create table t1;
161
t1 CREATE TABLE `t1` (
162
`j` int(11) DEFAULT NULL
163
) ENGINE=MyISAM DEFAULT CHARSET=latin1
164
drop table t1, t2, t3;
76
set debug_sync='create_table_select_before_open SIGNAL parked WAIT_FOR go';
77
set debug_sync='create_table_select_before_open SIGNAL parked WAIT_FOR go';
78
create table t1 select 1 as i;;
79
set debug_sync='now WAIT_FOR parked';
81
set debug_sync='now SIGNAL go';
82
set debug_sync='create_table_select_before_create SIGNAL parked WAIT_FOR go';
83
create table t1 select 1 as i;;
84
set debug_sync='now WAIT_FOR parked';
85
rename table t1 to t2;;
86
set debug_sync='now SIGNAL go';
88
set debug_sync='create_table_select_before_create SIGNAL parked WAIT_FOR go';
89
create table t1 select 1 as i;;
90
set debug_sync='now WAIT_FOR parked';
92
set debug_sync='now SIGNAL go';
96
set debug_sync='create_table_select_before_create SIGNAL parked WAIT_FOR go';
97
create table t1 select 1 as i;;
98
set debug_sync='now WAIT_FOR parked';
99
insert into t1 values (2);;
100
set debug_sync='now SIGNAL go';
107
set debug_sync='create_table_select_before_create SIGNAL parked WAIT_FOR go';
108
create table t1 select 1 as i;;
109
set debug_sync='now WAIT_FOR parked';
110
create trigger t1_bi before insert on t1 for each row set @a:=1;;
111
set debug_sync='now SIGNAL go';
116
set debug_sync='create_table_select_before_lock SIGNAL parked WAIT_FOR go';
117
create table t1 select 1 as i;;
118
set debug_sync='now WAIT_FOR parked';
120
set debug_sync='now SIGNAL go';
121
set debug_sync='create_table_select_before_lock SIGNAL parked WAIT_FOR go';
122
create table t1 select 1 as i;;
123
set debug_sync='now WAIT_FOR parked';
124
rename table t1 to t2;;
125
set debug_sync='now SIGNAL go';
127
set debug_sync='create_table_select_before_lock SIGNAL parked WAIT_FOR go';
128
create table t1 select 1 as i;;
129
set debug_sync='now WAIT_FOR parked';
131
set debug_sync='now SIGNAL go';
135
set debug_sync='create_table_select_before_lock SIGNAL parked WAIT_FOR go';
136
create table t1 select 1 as i;;
137
set debug_sync='now WAIT_FOR parked';
138
insert into t1 values (2);;
139
set debug_sync='now SIGNAL go';
146
set debug_sync='create_table_select_before_lock SIGNAL parked WAIT_FOR go';
147
create table t1 select 1 as i;;
148
set debug_sync='now WAIT_FOR parked';
149
create trigger t1_bi before insert on t1 for each row set @a:=1;;
150
set debug_sync='now SIGNAL go';
155
set debug_sync='create_table_select_before_check_if_exists SIGNAL parked WAIT_FOR go';
156
create table if not exists t1 select 1 as i;;
157
set debug_sync='now WAIT_FOR parked';
159
set debug_sync='now SIGNAL go';
160
create table t1 (i int);
162
set debug_sync='create_table_select_before_check_if_exists SIGNAL parked WAIT_FOR go';
163
create table if not exists t1 select 1 as i;;
164
create trigger t1_bi before insert on t1 for each row set @a:=1;
166
Note 1050 Table 't1' already exists
165
173
drop table if exists t1,t2;
174
set debug_sync='RESET';
166
175
create table t1 (i int);
167
set session debug="+d,sleep_create_like_before_check_if_exists";
176
set debug_sync='create_table_like_after_open SIGNAL parked WAIT_FOR go';
169
178
create table t2 like t1;;
179
set debug_sync='now WAIT_FOR parked';
170
180
insert into t1 values (1);
182
set debug_sync='now SIGNAL go';
172
183
show create table t2;
173
184
Table Create Table
174
185
t2 CREATE TABLE `t2` (
178
189
show binlog events from <binlog_start>;
179
190
Log_name Pos Event_type Server_id End_log_pos Info
191
master-bin.000001 # Query # # BEGIN
180
192
master-bin.000001 # Query # # use `test`; insert into t1 values (1)
181
master-bin.000001 # Query # # use `test`; create table t2 like t1
182
master-bin.000001 # Query # # use `test`; drop table t1
183
master-bin.000001 # Query # # use `test`; drop table t2
184
create table t1 (i int);
185
set session debug="-d,sleep_create_like_before_check_if_exists:+d,sleep_create_like_before_copy";
186
create table t2 like t1;;
187
create table if not exists t2 (j int);
189
Note 1050 Table 't2' already exists
190
show create table t2;
192
t2 CREATE TABLE `t2` (
193
`i` int(11) DEFAULT NULL
194
) ENGINE=MyISAM DEFAULT CHARSET=latin1
197
create table t2 like t1;;
200
show binlog events from <binlog_start>;
201
Log_name Pos Event_type Server_id End_log_pos Info
202
master-bin.000001 # Query # # use `test`; create table t2 like t1
203
master-bin.000001 # Query # # use `test`; drop table t1
204
master-bin.000001 # Query # # use `test`; drop table t2
205
create table t1 (i int);
206
set session debug="-d,sleep_create_like_before_copy:+d,sleep_create_like_before_ha_create";
208
create table t2 like t1;;
209
insert into t2 values (1);
211
create table t2 like t1;;
213
create table t2 like t1;;
216
show binlog events from <binlog_start>;
217
Log_name Pos Event_type Server_id End_log_pos Info
218
master-bin.000001 # Query # # use `test`; create table t2 like t1
219
master-bin.000001 # Query # # use `test`; insert into t2 values (1)
220
master-bin.000001 # Query # # use `test`; drop table t2
221
master-bin.000001 # Query # # use `test`; create table t2 like t1
222
master-bin.000001 # Query # # use `test`; drop table t2
223
master-bin.000001 # Query # # use `test`; create table t2 like t1
224
master-bin.000001 # Query # # use `test`; drop table t1
225
master-bin.000001 # Query # # use `test`; drop table t2
226
create table t1 (i int);
227
set session debug="-d,sleep_create_like_before_ha_create:+d,sleep_create_like_before_binlogging";
229
create table t2 like t1;;
230
insert into t2 values (1);
232
create table t2 like t1;;
234
create table t2 like t1;;
237
show binlog events from <binlog_start>;
238
Log_name Pos Event_type Server_id End_log_pos Info
239
master-bin.000001 # Query # # use `test`; create table t2 like t1
240
master-bin.000001 # Query # # use `test`; insert into t2 values (1)
241
master-bin.000001 # Query # # use `test`; drop table t2
242
master-bin.000001 # Query # # use `test`; create table t2 like t1
243
master-bin.000001 # Query # # use `test`; drop table t2
244
master-bin.000001 # Query # # use `test`; create table t2 like t1
245
master-bin.000001 # Query # # use `test`; drop table t1
246
master-bin.000001 # Query # # use `test`; drop table t2
247
set session debug="-d,sleep_create_like_before_binlogging";
193
master-bin.000001 # Query # # COMMIT
194
master-bin.000001 # Query # # use `test`; create table t2 like t1
195
master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
196
master-bin.000001 # Query # # use `test`; DROP TABLE `t2` /* generated by server */
197
create table t1 (i int);
198
set debug_sync='create_table_like_before_binlog SIGNAL parked WAIT_FOR go';
200
create table t2 like t1;;
201
set debug_sync='now WAIT_FOR parked';
202
insert into t2 values (1);;
203
set debug_sync='now SIGNAL go';
205
set debug_sync='create_table_like_before_binlog SIGNAL parked WAIT_FOR go';
206
create table t2 like t1;;
207
set debug_sync='now WAIT_FOR parked';
209
set debug_sync='now SIGNAL go';
210
set debug_sync='create_table_like_before_binlog SIGNAL parked WAIT_FOR go';
211
create table t2 like t1;;
212
set debug_sync='now WAIT_FOR parked';
214
set debug_sync='now SIGNAL go';
216
set debug_sync='RESET';
217
show binlog events from <binlog_start>;
218
Log_name Pos Event_type Server_id End_log_pos Info
219
master-bin.000001 # Query # # use `test`; create table t2 like t1
220
master-bin.000001 # Query # # BEGIN
221
master-bin.000001 # Query # # use `test`; insert into t2 values (1)
222
master-bin.000001 # Query # # COMMIT
223
master-bin.000001 # Query # # use `test`; DROP TABLE `t2` /* generated by server */
224
master-bin.000001 # Query # # use `test`; create table t2 like t1
225
master-bin.000001 # Query # # use `test`; DROP TABLE `t2` /* generated by server */
226
master-bin.000001 # Query # # use `test`; create table t2 like t1
227
master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
228
master-bin.000001 # Query # # use `test`; DROP TABLE `t2` /* generated by server */