Debian Codegraph @

mysql-test/suite/binlog_nogtid/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 binlog.000001 # Query # # use `test`; create table t1 (a int, b int) engine=innodb
9 binlog.000001 # Query # # BEGIN
10 binlog.000001 # Query # # use `test`; insert into t1 values (1,2)
11 binlog.000001 # Xid # # COMMIT /* XID */
12 drop table t1;
13 RESET MASTER;
14 create table t1 (a int) engine=innodb;
15 create table t2 (a int) engine=innodb;
16 begin;
17 insert t1 values (5);
18 commit;
19 begin;
20 insert t2 values (5);
21 commit;
22 include/show_binlog_events.inc
23 Log_name Pos Event_type Server_id End_log_pos Info
24 binlog.000001 # Query # # use `test`; create table t1 (a int) engine=innodb
25 binlog.000001 # Query # # use `test`; create table t2 (a int) engine=innodb
26 binlog.000001 # Query # # BEGIN
27 binlog.000001 # Query # # use `test`; insert t1 values (5)
28 binlog.000001 # Xid # # COMMIT /* XID */
29 binlog.000001 # Query # # BEGIN
30 binlog.000001 # Query # # use `test`; insert t2 values (5)
31 binlog.000001 # Xid # # COMMIT /* XID */
32 drop table t1,t2;
33 reset master;
34 create table t1 (n int) engine=innodb;
35 begin;
36 commit;
37 drop table t1;
38 include/show_binlog_events.inc
39 Log_name Pos Event_type Server_id End_log_pos Info
40 binlog.000001 # Query # # use `test`; create table t1 (n int) engine=innodb
41 binlog.000001 # Query # # BEGIN
42 binlog.000001 # Query # # use `test`; insert into t1 values(100 + 4)
43 binlog.000001 # Query # # use `test`; insert into t1 values(99 + 4)
44 binlog.000001 # Query # # use `test`; insert into t1 values(98 + 4)
45 binlog.000001 # Query # # use `test`; insert into t1 values(97 + 4)
46 binlog.000001 # Query # # use `test`; insert into t1 values(96 + 4)
47 binlog.000001 # Query # # use `test`; insert into t1 values(95 + 4)
48 binlog.000001 # Query # # use `test`; insert into t1 values(94 + 4)
49 binlog.000001 # Query # # use `test`; insert into t1 values(93 + 4)
50 binlog.000001 # Query # # use `test`; insert into t1 values(92 + 4)
51 binlog.000001 # Query # # use `test`; insert into t1 values(91 + 4)
52 binlog.000001 # Query # # use `test`; insert into t1 values(90 + 4)
53 binlog.000001 # Query # # use `test`; insert into t1 values(89 + 4)
54 binlog.000001 # Query # # use `test`; insert into t1 values(88 + 4)
55 binlog.000001 # Query # # use `test`; insert into t1 values(87 + 4)
56 binlog.000001 # Query # # use `test`; insert into t1 values(86 + 4)
57 binlog.000001 # Query # # use `test`; insert into t1 values(85 + 4)
58 binlog.000001 # Query # # use `test`; insert into t1 values(84 + 4)
59 binlog.000001 # Query # # use `test`; insert into t1 values(83 + 4)
60 binlog.000001 # Query # # use `test`; insert into t1 values(82 + 4)
61 binlog.000001 # Query # # use `test`; insert into t1 values(81 + 4)
62 binlog.000001 # Query # # use `test`; insert into t1 values(80 + 4)
63 binlog.000001 # Query # # use `test`; insert into t1 values(79 + 4)
64 binlog.000001 # Query # # use `test`; insert into t1 values(78 + 4)
65 binlog.000001 # Query # # use `test`; insert into t1 values(77 + 4)
66 binlog.000001 # Query # # use `test`; insert into t1 values(76 + 4)
67 binlog.000001 # Query # # use `test`; insert into t1 values(75 + 4)
68 binlog.000001 # Query # # use `test`; insert into t1 values(74 + 4)
69 binlog.000001 # Query # # use `test`; insert into t1 values(73 + 4)
70 binlog.000001 # Query # # use `test`; insert into t1 values(72 + 4)
71 binlog.000001 # Query # # use `test`; insert into t1 values(71 + 4)
72 binlog.000001 # Query # # use `test`; insert into t1 values(70 + 4)
73 binlog.000001 # Query # # use `test`; insert into t1 values(69 + 4)
74 binlog.000001 # Query # # use `test`; insert into t1 values(68 + 4)
75 binlog.000001 # Query # # use `test`; insert into t1 values(67 + 4)
76 binlog.000001 # Query # # use `test`; insert into t1 values(66 + 4)
77 binlog.000001 # Query # # use `test`; insert into t1 values(65 + 4)
78 binlog.000001 # Query # # use `test`; insert into t1 values(64 + 4)
79 binlog.000001 # Query # # use `test`; insert into t1 values(63 + 4)
80 binlog.000001 # Query # # use `test`; insert into t1 values(62 + 4)
81 binlog.000001 # Query # # use `test`; insert into t1 values(61 + 4)
82 binlog.000001 # Query # # use `test`; insert into t1 values(60 + 4)
83 binlog.000001 # Query # # use `test`; insert into t1 values(59 + 4)
84 binlog.000001 # Query # # use `test`; insert into t1 values(58 + 4)
85 binlog.000001 # Query # # use `test`; insert into t1 values(57 + 4)
86 binlog.000001 # Query # # use `test`; insert into t1 values(56 + 4)
87 binlog.000001 # Query # # use `test`; insert into t1 values(55 + 4)
88 binlog.000001 # Query # # use `test`; insert into t1 values(54 + 4)
89 binlog.000001 # Query # # use `test`; insert into t1 values(53 + 4)
90 binlog.000001 # Query # # use `test`; insert into t1 values(52 + 4)
91 binlog.000001 # Query # # use `test`; insert into t1 values(51 + 4)
92 binlog.000001 # Query # # use `test`; insert into t1 values(50 + 4)
93 binlog.000001 # Query # # use `test`; insert into t1 values(49 + 4)
94 binlog.000001 # Query # # use `test`; insert into t1 values(48 + 4)
95 binlog.000001 # Query # # use `test`; insert into t1 values(47 + 4)
96 binlog.000001 # Query # # use `test`; insert into t1 values(46 + 4)
97 binlog.000001 # Query # # use `test`; insert into t1 values(45 + 4)
98 binlog.000001 # Query # # use `test`; insert into t1 values(44 + 4)
99 binlog.000001 # Query # # use `test`; insert into t1 values(43 + 4)
100 binlog.000001 # Query # # use `test`; insert into t1 values(42 + 4)
101 binlog.000001 # Query # # use `test`; insert into t1 values(41 + 4)
102 binlog.000001 # Query # # use `test`; insert into t1 values(40 + 4)
103 binlog.000001 # Query # # use `test`; insert into t1 values(39 + 4)
104 binlog.000001 # Query # # use `test`; insert into t1 values(38 + 4)
105 binlog.000001 # Query # # use `test`; insert into t1 values(37 + 4)
106 binlog.000001 # Query # # use `test`; insert into t1 values(36 + 4)
107 binlog.000001 # Query # # use `test`; insert into t1 values(35 + 4)
108 binlog.000001 # Query # # use `test`; insert into t1 values(34 + 4)
109 binlog.000001 # Query # # use `test`; insert into t1 values(33 + 4)
110 binlog.000001 # Query # # use `test`; insert into t1 values(32 + 4)
111 binlog.000001 # Query # # use `test`; insert into t1 values(31 + 4)
112 binlog.000001 # Query # # use `test`; insert into t1 values(30 + 4)
113 binlog.000001 # Query # # use `test`; insert into t1 values(29 + 4)
114 binlog.000001 # Query # # use `test`; insert into t1 values(28 + 4)
115 binlog.000001 # Query # # use `test`; insert into t1 values(27 + 4)
116 binlog.000001 # Query # # use `test`; insert into t1 values(26 + 4)
117 binlog.000001 # Query # # use `test`; insert into t1 values(25 + 4)
118 binlog.000001 # Query # # use `test`; insert into t1 values(24 + 4)
119 binlog.000001 # Query # # use `test`; insert into t1 values(23 + 4)
120 binlog.000001 # Query # # use `test`; insert into t1 values(22 + 4)
121 binlog.000001 # Query # # use `test`; insert into t1 values(21 + 4)
122 binlog.000001 # Query # # use `test`; insert into t1 values(20 + 4)
123 binlog.000001 # Query # # use `test`; insert into t1 values(19 + 4)
124 binlog.000001 # Query # # use `test`; insert into t1 values(18 + 4)
125 binlog.000001 # Query # # use `test`; insert into t1 values(17 + 4)
126 binlog.000001 # Query # # use `test`; insert into t1 values(16 + 4)
127 binlog.000001 # Query # # use `test`; insert into t1 values(15 + 4)
128 binlog.000001 # Query # # use `test`; insert into t1 values(14 + 4)
129 binlog.000001 # Query # # use `test`; insert into t1 values(13 + 4)
130 binlog.000001 # Query # # use `test`; insert into t1 values(12 + 4)
131 binlog.000001 # Query # # use `test`; insert into t1 values(11 + 4)
132 binlog.000001 # Query # # use `test`; insert into t1 values(10 + 4)
133 binlog.000001 # Query # # use `test`; insert into t1 values(9 + 4)
134 binlog.000001 # Query # # use `test`; insert into t1 values(8 + 4)
135 binlog.000001 # Query # # use `test`; insert into t1 values(7 + 4)
136 binlog.000001 # Query # # use `test`; insert into t1 values(6 + 4)
137 binlog.000001 # Query # # use `test`; insert into t1 values(5 + 4)
138 binlog.000001 # Query # # use `test`; insert into t1 values(4 + 4)
139 binlog.000001 # Query # # use `test`; insert into t1 values(3 + 4)
140 binlog.000001 # Query # # use `test`; insert into t1 values(2 + 4)
141 binlog.000001 # Query # # use `test`; insert into t1 values(1 + 4)
142 binlog.000001 # Xid # # COMMIT /* XID */
143 binlog.000001 # Rotate # # binlog.000002;pos=POS
144 include/show_binlog_events.inc
145 Log_name Pos Event_type Server_id End_log_pos Info
146 binlog.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
147 set @ac = @@autocommit;
148 set autocommit= 0;
149 reset master;
150 create table t1(n int) engine=innodb;
151 begin;
152 insert into t1 values (1);
153 insert into t1 values (2);
154 insert into t1 values (3);
155 commit;
156 drop table t1;
157 include/show_binlog_events.inc
158 Log_name Pos Event_type Server_id End_log_pos Info
159 binlog.000001 # Query # # use `test`; create table t1(n int) engine=innodb
160 binlog.000001 # Query # # BEGIN
161 binlog.000001 # Query # # use `test`; insert into t1 values (1)
162 binlog.000001 # Query # # use `test`; insert into t1 values (2)
163 binlog.000001 # Query # # use `test`; insert into t1 values (3)
164 binlog.000001 # Xid # # COMMIT /* XID */
165 binlog.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
166 set @bcs = @@binlog_cache_size;
167 set global binlog_cache_size=4096;
168 reset master;
169 create table t1 (a int, b char(255)) engine=innodb;
170 flush status;
171 show status like "binlog_cache_use";
172 Variable_name Value
173 Binlog_cache_use 0
174 *** the following must show the counter value = 1 ***
175 Variable_name Value
176 Binlog_cache_use 1
177 include/show_binlog_events.inc
178 Log_name Pos Event_type Server_id End_log_pos Info
179 binlog.000001 # Query # # use `test`; create table t1 (a int, b char(255)) engine=innodb
180 binlog.000001 # Query # # use `test`; flush status
181 binlog.000001 # Query # # BEGIN
182 binlog.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' )
183 binlog.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' )
184 binlog.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' )
185 binlog.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' )
186 binlog.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' )
187 binlog.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' )
188 binlog.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' )
189 binlog.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' )
190 binlog.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' )
191 binlog.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' )
192 binlog.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' )
193 binlog.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' )
194 binlog.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' )
195 binlog.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' )
196 binlog.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' )
197 binlog.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' )
198 binlog.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' )
199 binlog.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' )
200 binlog.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' )
201 binlog.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' )
202 binlog.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' )
203 binlog.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' )
204 binlog.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' )
205 binlog.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' )
206 binlog.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' )
207 binlog.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' )
208 binlog.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' )
209 binlog.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' )
210 binlog.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' )
211 binlog.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' )
212 binlog.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' )
213 binlog.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' )
214 binlog.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' )
215 binlog.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' )
216 binlog.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' )
217 binlog.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' )
218 binlog.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' )
219 binlog.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' )
220 binlog.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' )
221 binlog.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' )
222 binlog.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' )
223 binlog.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' )
224 binlog.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' )
225 binlog.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' )
226 binlog.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' )
227 binlog.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' )
228 binlog.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' )
229 binlog.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' )
230 binlog.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' )
231 binlog.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' )
232 binlog.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' )
233 binlog.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' )
234 binlog.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' )
235 binlog.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' )
236 binlog.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' )
237 binlog.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' )
238 binlog.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' )
239 binlog.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' )
240 binlog.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' )
241 binlog.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' )
242 binlog.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' )
243 binlog.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' )
244 binlog.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' )
245 binlog.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' )
246 binlog.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' )
247 binlog.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' )
248 binlog.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' )
249 binlog.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' )
250 binlog.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' )
251 binlog.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' )
252 binlog.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' )
253 binlog.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' )
254 binlog.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' )
255 binlog.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' )
256 binlog.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' )
257 binlog.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' )
258 binlog.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' )
259 binlog.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' )
260 binlog.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' )
261 binlog.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' )
262 binlog.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' )
263 binlog.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' )
264 binlog.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' )
265 binlog.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' )
266 binlog.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' )
267 binlog.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' )
268 binlog.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' )
269 binlog.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' )
270 binlog.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' )
271 binlog.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' )
272 binlog.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' )
273 binlog.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' )
274 binlog.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' )
275 binlog.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' )
276 binlog.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' )
277 binlog.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' )
278 binlog.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' )
279 binlog.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' )
280 binlog.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' )
281 binlog.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' )
282 binlog.000001 # Xid # # COMMIT /* XID */
283 binlog.000001 # Rotate # # binlog.000002;pos=POS
284 drop table t1;
285 set global binlog_cache_size=@bcs;
286 set session autocommit = @ac;
287 drop table if exists t1;
288 reset master;
289 create table t1 (a bigint unsigned, b bigint(20) unsigned);
290 Warnings:
291 Warning 1681 Integer display width is deprecated and will be removed in a future release.
292 prepare stmt from "insert into t1 values (?,?)";
293 set @a= 9999999999999999;
294 set @b= 14632475938453979136;
295 execute stmt using @a, @b;
296 deallocate prepare stmt;
297 drop table t1;
298 include/show_binlog_events.inc
299 Log_name Pos Event_type Server_id End_log_pos Info
300 binlog.000001 # Query # # use `test`; create table t1 (a bigint unsigned, b bigint(20) unsigned)
301 binlog.000001 # Query # # BEGIN
302 binlog.000001 # Query # # use `test`; insert into t1 values (9999999999999999,14632475938453979136)
303 binlog.000001 # Xid # # COMMIT /* XID */
304 binlog.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
305 reset master;
306 CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
307 Warnings:
308 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
309 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
310 USE bug39182;
311 CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci)
312 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
313 Warnings:
314 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
315 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
316 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
317 CREATE PROCEDURE p1()
318 BEGIN
319 DECLARE s1 VARCHAR(255);
320 SET s1= "test";
321 CREATE TEMPORARY TABLE tmp1
322 SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%");
323 SELECT
324 COLLATION(NAME_CONST('s1', _utf8'test')) c1,
325 COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2,
326 COLLATION(s1) c3,
327 COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1,
328 COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2,
329 COERCIBILITY(s1) d3;
330 DROP TEMPORARY TABLE tmp1;
331 END//
332 Warnings:
333 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
334 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
335 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
336 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
337 CALL p1();
338 c1 c2 c3 d1 d2 d3
339 utf8mb3_general_ci utf8mb3_unicode_ci utf8mb3_unicode_ci 4 0 2
340 Warnings:
341 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
342 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
343 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
344 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
345 include/show_binlog_events.inc
346 Log_name Pos Event_type Server_id End_log_pos Info
347 binlog.000001 # Query # # CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
348 binlog.000001 # Query # # use `bug39182`; CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci)
349 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
350 binlog.000001 # Query # # use `bug39182`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
351 BEGIN
352 DECLARE s1 VARCHAR(255);
353 SET s1= "test";
354 CREATE TEMPORARY TABLE tmp1
355 SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%");
356 SELECT
357 COLLATION(NAME_CONST('s1', _utf8'test')) c1,
358 COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2,
359 COLLATION(s1) c3,
360 COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1,
361 COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2,
362 COERCIBILITY(s1) d3;
363 DROP TEMPORARY TABLE tmp1;
364 END
365 DROP PROCEDURE p1;
366 DROP TABLE t1;
367 DROP DATABASE bug39182;
368 USE test;
369 CREATE PROCEDURE p1(IN v1 INT)
370 BEGIN
371 CREATE TABLE t1 SELECT v1;
372 DROP TABLE t1;
373 END//
374 CREATE PROCEDURE p2()
375 BEGIN
376 DECLARE v1 INT;
377 CREATE TABLE t1 SELECT v1+1;
378 DROP TABLE t1;
379 END//
380 CREATE PROCEDURE p3(IN v1 INT)
381 BEGIN
382 CREATE TABLE t1 SELECT 1 FROM DUAL WHERE v1!=0;
383 DROP TABLE t1;
384 END//
385 CREATE PROCEDURE p4(IN v1 INT)
386 BEGIN
387 DECLARE v2 INT;
388 CREATE TABLE t1 SELECT 1, v1, v2;
389 DROP TABLE t1;
390 CREATE TABLE t1 SELECT 1, v1+1, v2;
391 DROP TABLE t1;
392 END//
393 CALL p1(1);
394 CALL p2();
395 CALL p3(0);
396 CALL p4(0);
397 DROP PROCEDURE p1;
398 DROP PROCEDURE p2;
399 DROP PROCEDURE p3;
400 DROP PROCEDURE p4;
401 End of 5.0 tests
402 reset master;
403 create table t1 (id tinyint auto_increment primary key);
404 set insert_id=128;
405 insert ignore into t1 values(null);
406 Warnings:
407 Warning 1264 Out of range value for column 'id' at row 1
408 select * from t1;
409 id
410 127
411 drop table t1;
412 create table t1 (a int);
413 create table if not exists t2 select * from t1;
414 create temporary table tt1 (a int);
415 create table if not exists t3 like tt1;
416 USE mysql;
417 INSERT IGNORE INTO user SET host='localhost', user='@#@', authentication_string='*1111111111111111111111111111111111111111';
418 UPDATE user SET authentication_string='*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' WHERE host='localhost' AND user='@#@';
419 DELETE FROM user WHERE host='localhost' AND user='@#@';
420 use test;
421 include/show_binlog_events.inc
422 Log_name Pos Event_type Server_id End_log_pos Info
423 binlog.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
424 binlog.000001 # Query # # BEGIN
425 binlog.000001 # Intvar # # INSERT_ID=127
426 binlog.000001 # Query # # use `test`; insert ignore into t1 values(null)
427 binlog.000001 # Xid # # COMMIT /* XID */
428 binlog.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
429 binlog.000001 # Query # # use `test`; create table t1 (a int)
430 binlog.000001 # Query # # use `test`; create table if not exists t2 select * from t1
431 binlog.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t3` (
432 `a` int DEFAULT NULL
433 ) ENGINE=InnoDB
434 binlog.000001 # Query # # BEGIN
435 binlog.000001 # Query # # use `mysql`; INSERT IGNORE INTO user SET host='localhost', user='@#@', authentication_string='*1111111111111111111111111111111111111111'
436 binlog.000001 # Xid # # COMMIT /* XID */
437 binlog.000001 # Query # # BEGIN
438 binlog.000001 # Query # # use `mysql`; UPDATE user SET authentication_string='*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' WHERE host='localhost' AND user='@#@'
439 binlog.000001 # Xid # # COMMIT /* XID */
440 binlog.000001 # Query # # BEGIN
441 binlog.000001 # Query # # use `mysql`; DELETE FROM user WHERE host='localhost' AND user='@#@'
442 binlog.000001 # Xid # # COMMIT /* XID */
443 drop table t1,t2,t3,tt1;
444 reset master;
445 drop table if exists t3;
446 create table t3 (a int(11) NOT NULL AUTO_INCREMENT, b text, PRIMARY KEY (a) ) engine=innodb;
447 Warnings:
448 Warning 1681 Integer display width is deprecated and will be removed in a future release.
449 File binlog.000001
450 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
451 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
452 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
453 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
454 *** show new binlog index after rotating ***
455 File binlog.000002
456 drop table t3;
457 RESET MASTER;
458 #
459 # Bug #45998: database crashes when running "create as select"
460 #
461 CREATE DATABASE test1;
462 USE test1;
463 DROP DATABASE test1;
464 CREATE TABLE test.t1(a int);
465 INSERT INTO test.t1 VALUES (1), (2);
466 CREATE TABLE test.t2 SELECT * FROM test.t1;
467 USE test;
468 DROP TABLES t1, t2;
469 RESET MASTER;
470 CREATE TABLE t1 (a INT PRIMARY KEY);
471 BINLOG '
472 3u9kSA8KAAAAZgAAAGoAAAABAAQANS4xLjM1LW1hcmlhLWJldGExLWRlYnVnLWxvZwAAAAAAAAAA
473 AAAAAAAAAAAAAAAAAADe72RIEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
474 ';
475 INSERT INTO t1 VALUES (1);
476 BINLOG '
477 3u9kSBMUAAAAKQAAAJEBAAAAABoAAAAAAAAABHRlc3QAAnQxAAEDAAA=
478 3u9kSBcUAAAAIgAAALMBAAAQABoAAAAAAAEAAf/+AgAAAA==
479 ';
480 include/show_binlog_events.inc
481 Log_name Pos Event_type Server_id End_log_pos Info
482 # # Query 1 # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY)
483 # # Query 1 # BEGIN
484 # # Query 1 # use `test`; INSERT INTO t1 VALUES (1)
485 # # Xid 1 # COMMIT /* XID */
486 # # Query 1 # BEGIN
487 # # Table_map 1 # table_id: # (test.t1)
488 # # Write_rows 1 # table_id: # flags: STMT_END_F
489 # # Xid 1 # COMMIT /* XID */
490 DROP TABLE t1;
491
492 # BUG#54903 BINLOG statement toggles session variables
493 # ----------------------------------------------------------------------
494 # This test verify that BINLOG statement doesn't change current session's
495 # variables foreign_key_checks and unique_checks.
496
497 CREATE TABLE t1 (c1 INT KEY);
498 SET @@SESSION.foreign_key_checks= ON;
499 SET @@SESSION.unique_checks= ON;
500 # INSERT INTO t1 VALUES (1)
501 # foreign_key_checks=0 and unique_checks=0
502 BINLOG '
503 dfLtTBMBAAAAKQAAANcAAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
504 dfLtTBcBAAAAIgAAAPkAAAAAABcAAAAAAAcAAf/+AQAAAA==
505 ';
506 SELECT * FROM t1;
507 c1
508 1
509 # Their values should be ON
510 SHOW SESSION VARIABLES LIKE "%_checks";
511 Variable_name Value
512 foreign_key_checks ON
513 unique_checks ON
514
515 SET @@SESSION.foreign_key_checks= OFF;
516 SET @@SESSION.unique_checks= OFF;
517 # INSERT INTO t1 VALUES(2)
518 # foreign_key_checks=1 and unique_checks=1
519 BINLOG '
520 dfLtTBMBAAAAKQAAAKsBAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
521 dfLtTBcBAAAAIgAAAM0BAAAAABcAAAAAAAEAAf/+AgAAAA==
522 ';
523 SELECT * FROM t1;
524 c1
525 1
526 2
527 # Their values should be OFF
528 SHOW SESSION VARIABLES LIKE "%_checks";
529 Variable_name Value
530 foreign_key_checks OFF
531 unique_checks OFF
532 # INSERT INTO t1 VALUES(2)
533 # foreign_key_checks=1 and unique_checks=1
534 # It should not change current session's variables, even error happens
535 call mtr.add_suppression("Replica SQL.*Could not execute Write_rows_v1 event on table test.t1; Duplicate entry .2. for key .t1.PRIMARY., Error_code: 1062");
536 BINLOG '
537 dfLtTBMBAAAAKQAAAKsBAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
538 dfLtTBcBAAAAIgAAAM0BAAAAABcAAAAAAAEAAf/+AgAAAA==
539 ';
540 ERROR 23000: Duplicate entry '2' for key 't1.PRIMARY'
541 SELECT * FROM t1;
542 c1
543 1
544 2
545 # Their values should be OFF
546 SHOW SESSION VARIABLES LIKE "%_checks";
547 Variable_name Value
548 foreign_key_checks OFF
549 unique_checks OFF
550 DROP TABLE t1;