Debian Codegraph @

mysql-test/suite/binlog/r/binlog_stm_binlog.result

raw
1 reset master;
2 create table t1 (a int, b int) engine=innodb;
3 begin;
4 insert into t1 values (1,2);
5 commit;
6 include/show_binlog_events.inc
7 Log_name Pos Event_type Server_id End_log_pos Info
8 master-bin.000001 # Gtid # # GTID #-#-#
9 master-bin.000001 # Query # # use `test`; create table t1 (a int, b int) engine=innodb
10 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
11 master-bin.000001 # Query # # use `test`; insert into t1 values (1,2)
12 master-bin.000001 # Xid # # COMMIT /* XID */
13 drop table t1;
14 drop table if exists t1, t2;
15 reset master;
16 create table t1 (a int) engine=innodb;
17 create table t2 (a int) engine=innodb;
18 begin;
19 insert t1 values (5);
20 commit;
21 begin;
22 insert t2 values (5);
23 commit;
24 include/show_binlog_events.inc
25 Log_name Pos Event_type Server_id End_log_pos Info
26 master-bin.000001 # Gtid # # GTID #-#-#
27 master-bin.000001 # Query # # use `test`; create table t1 (a int) engine=innodb
28 master-bin.000001 # Gtid # # GTID #-#-#
29 master-bin.000001 # Query # # use `test`; create table t2 (a int) engine=innodb
30 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
31 master-bin.000001 # Query # # use `test`; insert t1 values (5)
32 master-bin.000001 # Xid # # COMMIT /* XID */
33 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
34 master-bin.000001 # Query # # use `test`; insert t2 values (5)
35 master-bin.000001 # Xid # # COMMIT /* XID */
36 drop table t1,t2;
37 reset master;
38 create table t1 (n int) engine=innodb;
39 begin;
40 commit;
41 drop table t1;
42 include/show_binlog_events.inc
43 Log_name Pos Event_type Server_id End_log_pos Info
44 master-bin.000001 # Gtid # # GTID #-#-#
45 master-bin.000001 # Query # # use `test`; create table t1 (n int) engine=innodb
46 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
47 master-bin.000001 # Query # # use `test`; insert into t1 values(100 + 4)
48 master-bin.000001 # Query # # use `test`; insert into t1 values(99 + 4)
49 master-bin.000001 # Query # # use `test`; insert into t1 values(98 + 4)
50 master-bin.000001 # Query # # use `test`; insert into t1 values(97 + 4)
51 master-bin.000001 # Query # # use `test`; insert into t1 values(96 + 4)
52 master-bin.000001 # Query # # use `test`; insert into t1 values(95 + 4)
53 master-bin.000001 # Query # # use `test`; insert into t1 values(94 + 4)
54 master-bin.000001 # Query # # use `test`; insert into t1 values(93 + 4)
55 master-bin.000001 # Query # # use `test`; insert into t1 values(92 + 4)
56 master-bin.000001 # Query # # use `test`; insert into t1 values(91 + 4)
57 master-bin.000001 # Query # # use `test`; insert into t1 values(90 + 4)
58 master-bin.000001 # Query # # use `test`; insert into t1 values(89 + 4)
59 master-bin.000001 # Query # # use `test`; insert into t1 values(88 + 4)
60 master-bin.000001 # Query # # use `test`; insert into t1 values(87 + 4)
61 master-bin.000001 # Query # # use `test`; insert into t1 values(86 + 4)
62 master-bin.000001 # Query # # use `test`; insert into t1 values(85 + 4)
63 master-bin.000001 # Query # # use `test`; insert into t1 values(84 + 4)
64 master-bin.000001 # Query # # use `test`; insert into t1 values(83 + 4)
65 master-bin.000001 # Query # # use `test`; insert into t1 values(82 + 4)
66 master-bin.000001 # Query # # use `test`; insert into t1 values(81 + 4)
67 master-bin.000001 # Query # # use `test`; insert into t1 values(80 + 4)
68 master-bin.000001 # Query # # use `test`; insert into t1 values(79 + 4)
69 master-bin.000001 # Query # # use `test`; insert into t1 values(78 + 4)
70 master-bin.000001 # Query # # use `test`; insert into t1 values(77 + 4)
71 master-bin.000001 # Query # # use `test`; insert into t1 values(76 + 4)
72 master-bin.000001 # Query # # use `test`; insert into t1 values(75 + 4)
73 master-bin.000001 # Query # # use `test`; insert into t1 values(74 + 4)
74 master-bin.000001 # Query # # use `test`; insert into t1 values(73 + 4)
75 master-bin.000001 # Query # # use `test`; insert into t1 values(72 + 4)
76 master-bin.000001 # Query # # use `test`; insert into t1 values(71 + 4)
77 master-bin.000001 # Query # # use `test`; insert into t1 values(70 + 4)
78 master-bin.000001 # Query # # use `test`; insert into t1 values(69 + 4)
79 master-bin.000001 # Query # # use `test`; insert into t1 values(68 + 4)
80 master-bin.000001 # Query # # use `test`; insert into t1 values(67 + 4)
81 master-bin.000001 # Query # # use `test`; insert into t1 values(66 + 4)
82 master-bin.000001 # Query # # use `test`; insert into t1 values(65 + 4)
83 master-bin.000001 # Query # # use `test`; insert into t1 values(64 + 4)
84 master-bin.000001 # Query # # use `test`; insert into t1 values(63 + 4)
85 master-bin.000001 # Query # # use `test`; insert into t1 values(62 + 4)
86 master-bin.000001 # Query # # use `test`; insert into t1 values(61 + 4)
87 master-bin.000001 # Query # # use `test`; insert into t1 values(60 + 4)
88 master-bin.000001 # Query # # use `test`; insert into t1 values(59 + 4)
89 master-bin.000001 # Query # # use `test`; insert into t1 values(58 + 4)
90 master-bin.000001 # Query # # use `test`; insert into t1 values(57 + 4)
91 master-bin.000001 # Query # # use `test`; insert into t1 values(56 + 4)
92 master-bin.000001 # Query # # use `test`; insert into t1 values(55 + 4)
93 master-bin.000001 # Query # # use `test`; insert into t1 values(54 + 4)
94 master-bin.000001 # Query # # use `test`; insert into t1 values(53 + 4)
95 master-bin.000001 # Query # # use `test`; insert into t1 values(52 + 4)
96 master-bin.000001 # Query # # use `test`; insert into t1 values(51 + 4)
97 master-bin.000001 # Query # # use `test`; insert into t1 values(50 + 4)
98 master-bin.000001 # Query # # use `test`; insert into t1 values(49 + 4)
99 master-bin.000001 # Query # # use `test`; insert into t1 values(48 + 4)
100 master-bin.000001 # Query # # use `test`; insert into t1 values(47 + 4)
101 master-bin.000001 # Query # # use `test`; insert into t1 values(46 + 4)
102 master-bin.000001 # Query # # use `test`; insert into t1 values(45 + 4)
103 master-bin.000001 # Query # # use `test`; insert into t1 values(44 + 4)
104 master-bin.000001 # Query # # use `test`; insert into t1 values(43 + 4)
105 master-bin.000001 # Query # # use `test`; insert into t1 values(42 + 4)
106 master-bin.000001 # Query # # use `test`; insert into t1 values(41 + 4)
107 master-bin.000001 # Query # # use `test`; insert into t1 values(40 + 4)
108 master-bin.000001 # Query # # use `test`; insert into t1 values(39 + 4)
109 master-bin.000001 # Query # # use `test`; insert into t1 values(38 + 4)
110 master-bin.000001 # Query # # use `test`; insert into t1 values(37 + 4)
111 master-bin.000001 # Query # # use `test`; insert into t1 values(36 + 4)
112 master-bin.000001 # Query # # use `test`; insert into t1 values(35 + 4)
113 master-bin.000001 # Query # # use `test`; insert into t1 values(34 + 4)
114 master-bin.000001 # Query # # use `test`; insert into t1 values(33 + 4)
115 master-bin.000001 # Query # # use `test`; insert into t1 values(32 + 4)
116 master-bin.000001 # Query # # use `test`; insert into t1 values(31 + 4)
117 master-bin.000001 # Query # # use `test`; insert into t1 values(30 + 4)
118 master-bin.000001 # Query # # use `test`; insert into t1 values(29 + 4)
119 master-bin.000001 # Query # # use `test`; insert into t1 values(28 + 4)
120 master-bin.000001 # Query # # use `test`; insert into t1 values(27 + 4)
121 master-bin.000001 # Query # # use `test`; insert into t1 values(26 + 4)
122 master-bin.000001 # Query # # use `test`; insert into t1 values(25 + 4)
123 master-bin.000001 # Query # # use `test`; insert into t1 values(24 + 4)
124 master-bin.000001 # Query # # use `test`; insert into t1 values(23 + 4)
125 master-bin.000001 # Query # # use `test`; insert into t1 values(22 + 4)
126 master-bin.000001 # Query # # use `test`; insert into t1 values(21 + 4)
127 master-bin.000001 # Query # # use `test`; insert into t1 values(20 + 4)
128 master-bin.000001 # Query # # use `test`; insert into t1 values(19 + 4)
129 master-bin.000001 # Query # # use `test`; insert into t1 values(18 + 4)
130 master-bin.000001 # Query # # use `test`; insert into t1 values(17 + 4)
131 master-bin.000001 # Query # # use `test`; insert into t1 values(16 + 4)
132 master-bin.000001 # Query # # use `test`; insert into t1 values(15 + 4)
133 master-bin.000001 # Query # # use `test`; insert into t1 values(14 + 4)
134 master-bin.000001 # Query # # use `test`; insert into t1 values(13 + 4)
135 master-bin.000001 # Query # # use `test`; insert into t1 values(12 + 4)
136 master-bin.000001 # Query # # use `test`; insert into t1 values(11 + 4)
137 master-bin.000001 # Query # # use `test`; insert into t1 values(10 + 4)
138 master-bin.000001 # Query # # use `test`; insert into t1 values(9 + 4)
139 master-bin.000001 # Query # # use `test`; insert into t1 values(8 + 4)
140 master-bin.000001 # Query # # use `test`; insert into t1 values(7 + 4)
141 master-bin.000001 # Query # # use `test`; insert into t1 values(6 + 4)
142 master-bin.000001 # Query # # use `test`; insert into t1 values(5 + 4)
143 master-bin.000001 # Query # # use `test`; insert into t1 values(4 + 4)
144 master-bin.000001 # Query # # use `test`; insert into t1 values(3 + 4)
145 master-bin.000001 # Query # # use `test`; insert into t1 values(2 + 4)
146 master-bin.000001 # Query # # use `test`; insert into t1 values(1 + 4)
147 master-bin.000001 # Xid # # COMMIT /* XID */
148 master-bin.000001 # Rotate # # master-bin.000002;pos=POS
149 include/show_binlog_events.inc
150 Log_name Pos Event_type Server_id End_log_pos Info
151 master-bin.000002 # Binlog_checkpoint # # master-bin.000002
152 master-bin.000002 # Gtid # # GTID #-#-#
153 master-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
154 set @ac = @@autocommit;
155 set autocommit= 0;
156 reset master;
157 create table t1(n int) engine=innodb;
158 begin;
159 insert into t1 values (1);
160 insert into t1 values (2);
161 insert into t1 values (3);
162 commit;
163 drop table t1;
164 include/show_binlog_events.inc
165 Log_name Pos Event_type Server_id End_log_pos Info
166 master-bin.000001 # Gtid # # GTID #-#-#
167 master-bin.000001 # Query # # use `test`; create table t1(n int) engine=innodb
168 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
169 master-bin.000001 # Query # # use `test`; insert into t1 values (1)
170 master-bin.000001 # Query # # use `test`; insert into t1 values (2)
171 master-bin.000001 # Query # # use `test`; insert into t1 values (3)
172 master-bin.000001 # Xid # # COMMIT /* XID */
173 master-bin.000001 # Gtid # # GTID #-#-#
174 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
175 set @bcs = @@binlog_cache_size;
176 set global binlog_cache_size=4096;
177 reset master;
178 create table t1 (a int, b char(255)) engine=innodb;
179 flush global status;
180 show status like "binlog_cache_use";
181 Variable_name Value
182 Binlog_cache_use 0
183 *** the following must show the counter value = 1 ***
184 Variable_name Value
185 Binlog_cache_use 1
186 include/show_binlog_events.inc
187 Log_name Pos Event_type Server_id End_log_pos Info
188 master-bin.000001 # Gtid # # GTID #-#-#
189 master-bin.000001 # Query # # use `test`; create table t1 (a int, b char(255)) engine=innodb
190 master-bin.000001 # Gtid # # GTID #-#-#
191 master-bin.000001 # Query # # use `test`; flush global status
192 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
193 master-bin.000001 # Query # # use `test`; insert into t1 values( 100, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
194 master-bin.000001 # Query # # use `test`; insert into t1 values( 99, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
195 master-bin.000001 # Query # # use `test`; insert into t1 values( 98, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
196 master-bin.000001 # Query # # use `test`; insert into t1 values( 97, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
197 master-bin.000001 # Query # # use `test`; insert into t1 values( 96, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
198 master-bin.000001 # Query # # use `test`; insert into t1 values( 95, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
199 master-bin.000001 # Query # # use `test`; insert into t1 values( 94, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
200 master-bin.000001 # Query # # use `test`; insert into t1 values( 93, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
201 master-bin.000001 # Query # # use `test`; insert into t1 values( 92, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
202 master-bin.000001 # Query # # use `test`; insert into t1 values( 91, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
203 master-bin.000001 # Query # # use `test`; insert into t1 values( 90, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
204 master-bin.000001 # Query # # use `test`; insert into t1 values( 89, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
205 master-bin.000001 # Query # # use `test`; insert into t1 values( 88, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
206 master-bin.000001 # Query # # use `test`; insert into t1 values( 87, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
207 master-bin.000001 # Query # # use `test`; insert into t1 values( 86, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
208 master-bin.000001 # Query # # use `test`; insert into t1 values( 85, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
209 master-bin.000001 # Query # # use `test`; insert into t1 values( 84, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
210 master-bin.000001 # Query # # use `test`; insert into t1 values( 83, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
211 master-bin.000001 # Query # # use `test`; insert into t1 values( 82, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
212 master-bin.000001 # Query # # use `test`; insert into t1 values( 81, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
213 master-bin.000001 # Query # # use `test`; insert into t1 values( 80, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
214 master-bin.000001 # Query # # use `test`; insert into t1 values( 79, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
215 master-bin.000001 # Query # # use `test`; insert into t1 values( 78, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
216 master-bin.000001 # Query # # use `test`; insert into t1 values( 77, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
217 master-bin.000001 # Query # # use `test`; insert into t1 values( 76, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
218 master-bin.000001 # Query # # use `test`; insert into t1 values( 75, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
219 master-bin.000001 # Query # # use `test`; insert into t1 values( 74, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
220 master-bin.000001 # Query # # use `test`; insert into t1 values( 73, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
221 master-bin.000001 # Query # # use `test`; insert into t1 values( 72, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
222 master-bin.000001 # Query # # use `test`; insert into t1 values( 71, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
223 master-bin.000001 # Query # # use `test`; insert into t1 values( 70, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
224 master-bin.000001 # Query # # use `test`; insert into t1 values( 69, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
225 master-bin.000001 # Query # # use `test`; insert into t1 values( 68, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
226 master-bin.000001 # Query # # use `test`; insert into t1 values( 67, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
227 master-bin.000001 # Query # # use `test`; insert into t1 values( 66, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
228 master-bin.000001 # Query # # use `test`; insert into t1 values( 65, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
229 master-bin.000001 # Query # # use `test`; insert into t1 values( 64, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
230 master-bin.000001 # Query # # use `test`; insert into t1 values( 63, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
231 master-bin.000001 # Query # # use `test`; insert into t1 values( 62, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
232 master-bin.000001 # Query # # use `test`; insert into t1 values( 61, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
233 master-bin.000001 # Query # # use `test`; insert into t1 values( 60, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
234 master-bin.000001 # Query # # use `test`; insert into t1 values( 59, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
235 master-bin.000001 # Query # # use `test`; insert into t1 values( 58, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
236 master-bin.000001 # Query # # use `test`; insert into t1 values( 57, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
237 master-bin.000001 # Query # # use `test`; insert into t1 values( 56, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
238 master-bin.000001 # Query # # use `test`; insert into t1 values( 55, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
239 master-bin.000001 # Query # # use `test`; insert into t1 values( 54, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
240 master-bin.000001 # Query # # use `test`; insert into t1 values( 53, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
241 master-bin.000001 # Query # # use `test`; insert into t1 values( 52, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
242 master-bin.000001 # Query # # use `test`; insert into t1 values( 51, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
243 master-bin.000001 # Query # # use `test`; insert into t1 values( 50, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
244 master-bin.000001 # Query # # use `test`; insert into t1 values( 49, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
245 master-bin.000001 # Query # # use `test`; insert into t1 values( 48, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
246 master-bin.000001 # Query # # use `test`; insert into t1 values( 47, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
247 master-bin.000001 # Query # # use `test`; insert into t1 values( 46, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
248 master-bin.000001 # Query # # use `test`; insert into t1 values( 45, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
249 master-bin.000001 # Query # # use `test`; insert into t1 values( 44, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
250 master-bin.000001 # Query # # use `test`; insert into t1 values( 43, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
251 master-bin.000001 # Query # # use `test`; insert into t1 values( 42, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
252 master-bin.000001 # Query # # use `test`; insert into t1 values( 41, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
253 master-bin.000001 # Query # # use `test`; insert into t1 values( 40, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
254 master-bin.000001 # Query # # use `test`; insert into t1 values( 39, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
255 master-bin.000001 # Query # # use `test`; insert into t1 values( 38, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
256 master-bin.000001 # Query # # use `test`; insert into t1 values( 37, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
257 master-bin.000001 # Query # # use `test`; insert into t1 values( 36, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
258 master-bin.000001 # Query # # use `test`; insert into t1 values( 35, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
259 master-bin.000001 # Query # # use `test`; insert into t1 values( 34, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
260 master-bin.000001 # Query # # use `test`; insert into t1 values( 33, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
261 master-bin.000001 # Query # # use `test`; insert into t1 values( 32, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
262 master-bin.000001 # Query # # use `test`; insert into t1 values( 31, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
263 master-bin.000001 # Query # # use `test`; insert into t1 values( 30, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
264 master-bin.000001 # Query # # use `test`; insert into t1 values( 29, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
265 master-bin.000001 # Query # # use `test`; insert into t1 values( 28, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
266 master-bin.000001 # Query # # use `test`; insert into t1 values( 27, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
267 master-bin.000001 # Query # # use `test`; insert into t1 values( 26, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
268 master-bin.000001 # Query # # use `test`; insert into t1 values( 25, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
269 master-bin.000001 # Query # # use `test`; insert into t1 values( 24, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
270 master-bin.000001 # Query # # use `test`; insert into t1 values( 23, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
271 master-bin.000001 # Query # # use `test`; insert into t1 values( 22, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
272 master-bin.000001 # Query # # use `test`; insert into t1 values( 21, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
273 master-bin.000001 # Query # # use `test`; insert into t1 values( 20, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
274 master-bin.000001 # Query # # use `test`; insert into t1 values( 19, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
275 master-bin.000001 # Query # # use `test`; insert into t1 values( 18, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
276 master-bin.000001 # Query # # use `test`; insert into t1 values( 17, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
277 master-bin.000001 # Query # # use `test`; insert into t1 values( 16, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
278 master-bin.000001 # Query # # use `test`; insert into t1 values( 15, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
279 master-bin.000001 # Query # # use `test`; insert into t1 values( 14, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
280 master-bin.000001 # Query # # use `test`; insert into t1 values( 13, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
281 master-bin.000001 # Query # # use `test`; insert into t1 values( 12, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
282 master-bin.000001 # Query # # use `test`; insert into t1 values( 11, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
283 master-bin.000001 # Query # # use `test`; insert into t1 values( 10, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
284 master-bin.000001 # Query # # use `test`; insert into t1 values( 9, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
285 master-bin.000001 # Query # # use `test`; insert into t1 values( 8, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
286 master-bin.000001 # Query # # use `test`; insert into t1 values( 7, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
287 master-bin.000001 # Query # # use `test`; insert into t1 values( 6, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
288 master-bin.000001 # Query # # use `test`; insert into t1 values( 5, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
289 master-bin.000001 # Query # # use `test`; insert into t1 values( 4, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
290 master-bin.000001 # Query # # use `test`; insert into t1 values( 3, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
291 master-bin.000001 # Query # # use `test`; insert into t1 values( 2, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
292 master-bin.000001 # Query # # use `test`; insert into t1 values( 1, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
293 master-bin.000001 # Xid # # COMMIT /* XID */
294 master-bin.000001 # Rotate # # master-bin.000002;pos=POS
295 drop table t1;
296 set global binlog_cache_size=@bcs;
297 set session autocommit = @ac;
298 drop table if exists t1;
299 reset master;
300 create table t1 (a bigint unsigned, b bigint(20) unsigned);
301 prepare stmt from "insert into t1 values (?,?)";
302 set @a= 9999999999999999;
303 set @b= 14632475938453979136;
304 execute stmt using @a, @b;
305 deallocate prepare stmt;
306 drop table t1;
307 include/show_binlog_events.inc
308 Log_name Pos Event_type Server_id End_log_pos Info
309 master-bin.000001 # Gtid # # GTID #-#-#
310 master-bin.000001 # Query # # use `test`; create table t1 (a bigint unsigned, b bigint(20) unsigned)
311 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
312 master-bin.000001 # Query # # use `test`; insert into t1 values (9999999999999999,14632475938453979136)
313 master-bin.000001 # Query # # COMMIT
314 master-bin.000001 # Gtid # # GTID #-#-#
315 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
316 reset master;
317 CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
318 USE bug39182;
319 CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci)
320 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
321 CREATE PROCEDURE p1()
322 BEGIN
323 DECLARE s1 VARCHAR(255);
324 SET s1= "test";
325 CREATE TEMPORARY TABLE tmp1
326 SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%");
327 SELECT
328 COLLATION(NAME_CONST('s1', _utf8'test')) c1,
329 COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2,
330 COLLATION(s1) c3,
331 COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1,
332 COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2,
333 COERCIBILITY(s1) d3;
334 DROP TEMPORARY TABLE tmp1;
335 END//
336 CALL p1();
337 c1 c2 c3 d1 d2 d3
338 utf8mb3_uca1400_ai_ci utf8mb3_unicode_ci utf8mb3_unicode_ci 2 2 2
339 include/show_binlog_events.inc
340 Log_name Pos Event_type Server_id End_log_pos Info
341 master-bin.000001 # Gtid # # GTID #-#-#
342 master-bin.000001 # Query # # CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
343 master-bin.000001 # Gtid # # GTID #-#-#
344 master-bin.000001 # Query # # use `bug39182`; CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci)
345 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
346 master-bin.000001 # Gtid # # GTID #-#-#
347 master-bin.000001 # Query # # use `bug39182`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
348 BEGIN
349 DECLARE s1 VARCHAR(255);
350 SET s1= "test";
351 CREATE TEMPORARY TABLE tmp1
352 SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%");
353 SELECT
354 COLLATION(NAME_CONST('s1', _utf8'test')) c1,
355 COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2,
356 COLLATION(s1) c3,
357 COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1,
358 COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2,
359 COERCIBILITY(s1) d3;
360 DROP TEMPORARY TABLE tmp1;
361 END
362 master-bin.000001 # Gtid # # GTID #-#-#
363 master-bin.000001 # Query # # use `bug39182`; CREATE TEMPORARY TABLE tmp1
364 SELECT * FROM t1 WHERE a LIKE CONCAT("%", NAME_CONST('s1',_utf8mb3'test' COLLATE 'utf8mb3_unicode_ci'), "%")
365 master-bin.000001 # Gtid # # GTID #-#-#
366 master-bin.000001 # Query # # use `bug39182`; DROP TEMPORARY TABLE `tmp1` /* generated by server */
367 DROP PROCEDURE p1;
368 DROP TABLE t1;
369 DROP DATABASE bug39182;
370 USE test;
371 CREATE PROCEDURE p1(IN v1 INT)
372 BEGIN
373 CREATE TABLE t1 SELECT v1;
374 DROP TABLE t1;
375 END//
376 CREATE PROCEDURE p2()
377 BEGIN
378 DECLARE v1 INT;
379 CREATE TABLE t1 SELECT v1+1;
380 DROP TABLE t1;
381 END//
382 CREATE PROCEDURE p3(IN v1 INT)
383 BEGIN
384 CREATE TABLE t1 SELECT 1 FROM DUAL WHERE v1!=0;
385 DROP TABLE t1;
386 END//
387 CREATE PROCEDURE p4(IN v1 INT)
388 BEGIN
389 DECLARE v2 INT;
390 CREATE TABLE t1 SELECT 1, v1, v2;
391 DROP TABLE t1;
392 CREATE TABLE t1 SELECT 1, v1+1, v2;
393 DROP TABLE t1;
394 END//
395 CALL p1(1);
396 CALL p2();
397 CALL p3(0);
398 CALL p4(0);
399 DROP PROCEDURE p1;
400 DROP PROCEDURE p2;
401 DROP PROCEDURE p3;
402 DROP PROCEDURE p4;
403 End of 5.0 tests
404 reset master;
405 create table t1 (id tinyint auto_increment primary key);
406 insert into t1 values(5);
407 set insert_id=128;
408 insert into t1 values(null) /* Not binlogged */;
409 ERROR 22003: Out of range value for column 'id' at row 1
410 set insert_id=128;
411 insert ignore into t1 values(null) /* Insert 128 */;
412 Warnings:
413 Warning 167 Out of range value for column 'id' at row 1
414 set insert_id=5;
415 insert into t1 values(null) /* Not binlogged */;
416 ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
417 set insert_id=5;
418 insert ignore into t1 values(null) /* Insert 5 */;
419 Warnings:
420 Warning 1062 Duplicate entry '5' for key 'PRIMARY'
421 select * from t1;
422 id
423 5
424 drop table t1;
425 create table t1 (id tinyint auto_increment primary key) engine=myisam;
426 set insert_id=128;
427 insert into t1 values(5),(null) /* Insert_id 128 */;
428 ERROR 22003: Out of range value for column 'id' at row 2
429 set insert_id=128;
430 insert ignore into t1 values (4),(null) /* Insert_id 128 */;
431 Warnings:
432 Warning 167 Out of range value for column 'id' at row 2
433 set insert_id=5;
434 insert into t1 values(3),(null) /* Insert_id 5 */;
435 ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
436 set insert_id=5;
437 insert ignore into t1 values(2),(null) /* Insert_id 5 */;
438 Warnings:
439 Warning 1062 Duplicate entry '5' for key 'PRIMARY'
440 select * from t1 order by id;
441 id
442 2
443 3
444 4
445 5
446 drop table t1;
447 create table t1 (a int);
448 create table if not exists t2 select * from t1;
449 create temporary table tt1 (a int);
450 create table if not exists t3 like tt1;
451 USE mysql;
452 INSERT db SET host='localhost', user='@#@', db='Just a test';
453 UPDATE db SET db='Another db' WHERE host='localhost' AND user='@#@';
454 DELETE FROM db WHERE host='localhost' AND user='@#@';
455 use test;
456 include/show_binlog_events.inc
457 Log_name Pos Event_type Server_id End_log_pos Info
458 master-bin.000001 # Gtid # # GTID #-#-#
459 master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
460 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
461 master-bin.000001 # Query # # use `test`; insert into t1 values(5)
462 master-bin.000001 # Query # # COMMIT
463 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
464 master-bin.000001 # Intvar # # INSERT_ID=128
465 master-bin.000001 # Query # # use `test`; insert ignore into t1 values(null) /* Insert 128 */
466 master-bin.000001 # Query # # COMMIT
467 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
468 master-bin.000001 # Intvar # # INSERT_ID=5
469 master-bin.000001 # Query # # use `test`; insert ignore into t1 values(null) /* Insert 5 */
470 master-bin.000001 # Query # # COMMIT
471 master-bin.000001 # Gtid # # GTID #-#-#
472 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
473 master-bin.000001 # Gtid # # GTID #-#-#
474 master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key) engine=myisam
475 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
476 master-bin.000001 # Intvar # # INSERT_ID=128
477 master-bin.000001 # Query # # use `test`; insert into t1 values(5),(null) /* Insert_id 128 */
478 master-bin.000001 # Query # # COMMIT
479 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
480 master-bin.000001 # Intvar # # INSERT_ID=128
481 master-bin.000001 # Query # # use `test`; insert ignore into t1 values (4),(null) /* Insert_id 128 */
482 master-bin.000001 # Query # # COMMIT
483 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
484 master-bin.000001 # Intvar # # INSERT_ID=5
485 master-bin.000001 # Query # # use `test`; insert into t1 values(3),(null) /* Insert_id 5 */
486 master-bin.000001 # Query # # COMMIT
487 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
488 master-bin.000001 # Intvar # # INSERT_ID=5
489 master-bin.000001 # Query # # use `test`; insert ignore into t1 values(2),(null) /* Insert_id 5 */
490 master-bin.000001 # Query # # COMMIT
491 master-bin.000001 # Gtid # # GTID #-#-#
492 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
493 master-bin.000001 # Gtid # # GTID #-#-#
494 master-bin.000001 # Query # # use `test`; create table t1 (a int)
495 master-bin.000001 # Gtid # # GTID #-#-#
496 master-bin.000001 # Query # # use `test`; create table if not exists t2 select * from t1
497 master-bin.000001 # Gtid # # GTID #-#-#
498 master-bin.000001 # Query # # use `test`; create temporary table tt1 (a int)
499 master-bin.000001 # Gtid # # GTID #-#-#
500 master-bin.000001 # Query # # use `test`; create table if not exists t3 like tt1
501 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
502 master-bin.000001 # Query # # use `mysql`; INSERT db SET host='localhost', user='@#@', db='Just a test'
503 master-bin.000001 # Query # # COMMIT
504 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
505 master-bin.000001 # Query # # use `mysql`; UPDATE db SET db='Another db' WHERE host='localhost' AND user='@#@'
506 master-bin.000001 # Query # # COMMIT
507 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
508 master-bin.000001 # Query # # use `mysql`; DELETE FROM db WHERE host='localhost' AND user='@#@'
509 master-bin.000001 # Query # # COMMIT
510 master-bin.000001 # Rotate # # master-bin.000002;pos=POS
511 drop table t1,t2,t3,tt1;
512 reset master;
513 create table t1 (a int not null auto_increment, primary key (a)) engine=myisam;
514 insert /* before delayed */ delayed /* after delayed */ into t1 values (207);
515 insert /*! delayed */ into t1 values (null);
516 insert delayed into t1 values (300);
517 FLUSH TABLES;
518 include/show_binlog_events.inc
519 Log_name Pos Event_type Server_id End_log_pos Info
520 master-bin.000001 # Gtid # # GTID #-#-#
521 master-bin.000001 # Query # # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
522 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
523 master-bin.000001 # Table_map # # table_id: # (test.t1)
524 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
525 master-bin.000001 # Query # # COMMIT
526 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
527 master-bin.000001 # Table_map # # table_id: # (test.t1)
528 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
529 master-bin.000001 # Query # # COMMIT
530 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
531 master-bin.000001 # Table_map # # table_id: # (test.t1)
532 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
533 master-bin.000001 # Query # # COMMIT
534 master-bin.000001 # Gtid # # GTID #-#-#
535 master-bin.000001 # Query # # use `test`; FLUSH TABLES
536 RESET MASTER;
537 insert /* before delayed */ delayed /* after delayed */ into t1 values (null),(null),(null),(null);
538 insert /*! delayed */ into t1 values (null),(null),(400),(null);
539 select * from t1;
540 a
541 207
542 208
543 300
544 301
545 302
546 303
547 304
548 305
549 306
550 400
551 401
552 drop table t1;
553 reset master;
554 drop table if exists t3;
555 create table t3 (a int(11) NOT NULL AUTO_INCREMENT, b text, PRIMARY KEY (a) ) engine=innodb;
556 File master-bin.000001
557 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
558 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
559 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
560 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
561 *** show new binlog index after rotating ***
562 File master-bin.000002
563 drop table t3;
564 #
565 # Bug #45998: database crashes when running "create as select"
566 #
567 CREATE DATABASE test1;
568 USE test1;
569 DROP DATABASE test1;
570 CREATE TABLE test.t1(a int);
571 INSERT INTO test.t1 VALUES (1), (2);
572 CREATE TABLE test.t2 SELECT * FROM test.t1;
573 USE test;
574 DROP TABLES t1, t2;
575 connect fresh,localhost,root,,test;
576 connection fresh;
577 RESET MASTER;
578 CREATE TABLE t1 (a INT PRIMARY KEY);
579 BINLOG '
580 3u9kSA8KAAAAZgAAAGoAAAABAAQANS4xLjM1LW1hcmlhLWJldGExLWRlYnVnLWxvZwAAAAAAAAAA
581 AAAAAAAAAAAAAAAAAADe72RIEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
582 ';
583 INSERT INTO t1 VALUES (1);
584 BINLOG '
585 3u9kSBMUAAAAKQAAAJEBAAAAABoAAAAAAAAABHRlc3QAAnQxAAEDAAA=
586 3u9kSBcUAAAAIgAAALMBAAAQABoAAAAAAAEAAf/+AgAAAA==
587 ';
588 SHOW BINLOG EVENTS;
589 Log_name Pos Event_type Server_id End_log_pos Info
590 # # Format_desc 1 # Server ver: #, Binlog ver: #
591 # # Gtid_list 1 # []
592 # # Binlog_checkpoint 1 # master-bin.000001
593 # # Gtid 1 # GTID 0-1-1
594 # # Query 1 # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY)
595 # # Gtid 1 # BEGIN GTID 0-1-2
596 # # Query 1 # use `test`; INSERT INTO t1 VALUES (1)
597 # # Query 1 # COMMIT
598 # # Gtid 1 # BEGIN GTID 0-1-3
599 # # Annotate_rows 1 # BINLOG '
600 3u9kSBMUAAAAKQAAAJEBAAAAABoAAAAAAAAABHRlc3QAAnQxAAEDAAA=
601 3u9kSBcUAAAAIgAAALMBAAAQABoAAAAAAAEAAf/+AgAAAA==
602 '
603 # # Table_map 1 # table_id: # (test.t1)
604 # # Write_rows_v1 1 # table_id: # flags: STMT_END_F
605 # # Query 1 # COMMIT
606 DROP TABLE t1;
607
608 # BUG#54903 BINLOG statement toggles session variables
609 # ----------------------------------------------------------------------
610 # This test verify that BINLOG statement doesn't change current session's
611 # variables foreign_key_checks and unique_checks.
612
613 CREATE TABLE t1 (c1 INT KEY);
614 SET @@SESSION.foreign_key_checks= ON;
615 SET @@SESSION.unique_checks= ON;
616 # INSERT INTO t1 VALUES (1)
617 # foreign_key_checks=0 and unique_checks=0
618 BINLOG '
619 dfLtTBMBAAAAKQAAANcAAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
620 dfLtTBcBAAAAIgAAAPkAAAAAABcAAAAAAAcAAf/+AQAAAA==
621 ';
622 SELECT * FROM t1;
623 c1
624 1
625 # Their values should be ON
626 SHOW SESSION VARIABLES LIKE "foreign_key_checks";
627 Variable_name Value
628 foreign_key_checks ON
629 SHOW SESSION VARIABLES LIKE "unique_checks";
630 Variable_name Value
631 unique_checks ON
632
633 SET @@SESSION.foreign_key_checks= OFF;
634 SET @@SESSION.unique_checks= OFF;
635 # INSERT INTO t1 VALUES(2)
636 # foreign_key_checks=1 and unique_checks=1
637 BINLOG '
638 dfLtTBMBAAAAKQAAAKsBAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
639 dfLtTBcBAAAAIgAAAM0BAAAAABcAAAAAAAEAAf/+AgAAAA==
640 ';
641 SELECT * FROM t1;
642 c1
643 1
644 2
645 # Their values should be OFF
646 SHOW SESSION VARIABLES LIKE "foreign_key_checks";
647 Variable_name Value
648 foreign_key_checks OFF
649 SHOW SESSION VARIABLES LIKE "unique_checks";
650 Variable_name Value
651 unique_checks OFF
652 # INSERT INTO t1 VALUES(2)
653 # foreign_key_checks=1 and unique_checks=1
654 # It should not change current session's variables, even error happens
655 call mtr.add_suppression("BINLOG_BASE64_EVENT.*Could not execute Write_rows_v1 event on table test.t1; Duplicate entry .2. for key .PRIMARY., Error_code: 1062");
656 BINLOG '
657 dfLtTBMBAAAAKQAAAKsBAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
658 dfLtTBcBAAAAIgAAAM0BAAAAABcAAAAAAAEAAf/+AgAAAA==
659 ';
660 ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
661 SELECT * FROM t1;
662 c1
663 1
664 2
665 # Their values should be OFF
666 SHOW SESSION VARIABLES LIKE "foreign_key_checks";
667 Variable_name Value
668 foreign_key_checks OFF
669 SHOW SESSION VARIABLES LIKE "unique_checks";
670 Variable_name Value
671 unique_checks OFF
672 DROP TABLE t1;
673 disconnect fresh;
674 connection default;
675 #
676 # MDEV-25595 DROP part of failed CREATE OR REPLACE is not written into binary log
677 #
678 reset master;
679 create table t as select 1 as b, 2 as b;
680 ERROR 42S21: Duplicate column name 'b'
681 create table t (old_table_field int);
682 create or replace table t as select 1 as b, 2 as b;
683 ERROR 42S21: Duplicate column name 'b'
684 create or replace temporary table t as select 1 as b, 2 as b;
685 ERROR 42S21: Duplicate column name 'b'
686 create table t (new_table_field int);
687 include/show_binlog_events.inc
688 Log_name Pos Event_type Server_id End_log_pos Info
689 master-bin.000001 # Gtid # # GTID #-#-#
690 master-bin.000001 # Query # # use `test`; create table t (old_table_field int)
691 master-bin.000001 # Gtid # # GTID #-#-#
692 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `test`.`t`/* Generated to handle failed CREATE OR REPLACE */
693 master-bin.000001 # Gtid # # GTID #-#-#
694 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`t`/* Generated to handle failed CREATE OR REPLACE */
695 master-bin.000001 # Gtid # # GTID #-#-#
696 master-bin.000001 # Query # # use `test`; create table t (new_table_field int)
697 drop table t;