Debian Codegraph @

mysql-test/suite/binlog_nogtid/r/binlog_unsafe_stmt_capable_engine.result

raw
1 #### Setup tables ####
2 CREATE TABLE t0 (a VARCHAR(510));
3 CREATE TABLE t1 (a CHAR(100));
4 CREATE TABLE t2 (a CHAR(100));
5 CREATE TABLE ta0 (a CHAR(100));
6 CREATE TABLE ta1 (a CHAR(100));
7 CREATE TABLE ta2 (a CHAR(100));
8 CREATE TABLE autoinc_table (a INT PRIMARY KEY AUTO_INCREMENT);
9 CREATE TABLE data_table (a CHAR(100));
10 INSERT INTO data_table VALUES ('foo');
11 CREATE TABLE trigger_table_1 (a INT);
12 CREATE TABLE trigger_table_2 (a INT);
13 CREATE TABLE trigger_table_3 (a INT);
14 CREATE TABLE double_autoinc_table (a INT PRIMARY KEY AUTO_INCREMENT);
15 SET @old_debug= @@global.debug;
16 SET GLOBAL debug='+d,make_stmt_only_engines';
17 CREATE TRIGGER double_autoinc_trig
18 BEFORE INSERT ON double_autoinc_table FOR EACH ROW
19 BEGIN
20 INSERT INTO autoinc_table VALUES (NULL);
21 END|
22 CREATE FUNCTION multi_unsafe_func() RETURNS INT
23 BEGIN
24 INSERT INTO t0 VALUES(CONCAT(@@hostname, @@hostname));
25 INSERT INTO t0 VALUES(0);
26 INSERT INTO t0 VALUES(CONCAT(UUID(), @@hostname));
27 RETURN 1;
28 END|
29 CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "UDF_EXAMPLE_LIB";
30
31 ==== Testing UUID() unsafeness ====
32
33 Invoking function func_retval_1 returning value from unsafe UUID() function.
34 CREATE FUNCTION func_retval_1() RETURNS VARCHAR(100) BEGIN INSERT INTO ta1 VALUES (47); RETURN UUID(); END;
35 * binlog_format = STATEMENT: expect 1 warnings.
36 INSERT INTO t1 VALUES (func_retval_1());
37 Warnings:
38 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
39 include/assert.inc [There should be 1 warning(s)]
40 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
41 include/assert.inc [There should be 0 warning(s)]
42 include/assert.inc [Only two events should exist in the binary log]
43 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
44 Warnings:
45 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
46 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
47 Warnings:
48 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
49 * Invoke statement so that return value is discarded: expect no warning.
50 SELECT func_retval_1();
51
52 Invoking function func_retval_2 returning value from function func_retval_1 returning value from unsafe UUID() function.
53 CREATE FUNCTION func_retval_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); RETURN func_retval_1(); END;
54 * binlog_format = STATEMENT: expect 1 warnings.
55 INSERT INTO t2 VALUES (func_retval_2());
56 Warnings:
57 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
58 include/assert.inc [There should be 1 warning(s)]
59 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
60 include/assert.inc [There should be 0 warning(s)]
61 include/assert.inc [Only two events should exist in the binary log]
62 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
63 Warnings:
64 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
65 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
66 Warnings:
67 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
68 * Invoke statement so that return value is discarded: expect no warning.
69 SELECT func_retval_2();
70 DROP FUNCTION func_retval_2;
71
72 Invoking function func_sidef_2 invoking function func_retval_1 returning value from unsafe UUID() function.
73 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 VALUES (func_retval_1()); RETURN 0; END;
74 * binlog_format = STATEMENT: expect 1 warnings.
75 INSERT INTO t2 SELECT func_sidef_2();
76 Warnings:
77 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
78 include/assert.inc [There should be 1 warning(s)]
79 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
80 include/assert.inc [There should be 0 warning(s)]
81 include/assert.inc [Only two events should exist in the binary log]
82 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
83 Warnings:
84 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
85 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
86 Warnings:
87 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
88 DROP FUNCTION func_sidef_2;
89
90 Invoking procedure proc_2 invoking function func_retval_1 returning value from unsafe UUID() function.
91 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 VALUES (func_retval_1()); INSERT INTO ta2 VALUES (47); END;
92 * binlog_format = STATEMENT: expect 1 warnings.
93 CALL proc_2();
94 Warnings:
95 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
96 include/assert.inc [There should be 1 warning(s)]
97 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
98 include/assert.inc [There should be 0 warning(s)]
99 include/assert.inc [Only two events should exist in the binary log]
100 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
101 Warnings:
102 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
103 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
104 Warnings:
105 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
106 DROP PROCEDURE proc_2;
107
108 Invoking trigger trig_2 invoking function func_retval_1 returning value from unsafe UUID() function.
109 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 VALUES (func_retval_1()); END;
110 * binlog_format = STATEMENT: expect 1 warnings.
111 INSERT INTO trigger_table_2 VALUES (1);
112 Warnings:
113 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
114 include/assert.inc [There should be 1 warning(s)]
115 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
116 include/assert.inc [There should be 0 warning(s)]
117 include/assert.inc [Only two events should exist in the binary log]
118 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
119 Warnings:
120 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
121 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
122 Warnings:
123 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
124 DROP TRIGGER trig_2;
125
126 Invoking view view_retval_2 returning value from function func_retval_1 returning value from unsafe UUID() function.
127 CREATE VIEW view_retval_2 AS SELECT func_retval_1();
128 * binlog_format = STATEMENT: expect 1 warnings.
129 INSERT INTO t2 SELECT * FROM view_retval_2;
130 Warnings:
131 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
132 include/assert.inc [There should be 1 warning(s)]
133 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
134 include/assert.inc [There should be 0 warning(s)]
135 include/assert.inc [Only two events should exist in the binary log]
136 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
137 Warnings:
138 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
139 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
140 Warnings:
141 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
142 * Invoke statement so that return value is discarded: expect no warning.
143 SELECT * FROM view_retval_2;
144 DROP VIEW view_retval_2;
145
146 Invoking prepared statement prep_2 invoking function func_retval_1 returning value from unsafe UUID() function.
147 PREPARE prep_2 FROM "INSERT INTO t1 VALUES (func_retval_1())";
148 * binlog_format = STATEMENT: expect 1 warnings.
149 EXECUTE prep_2;
150 Warnings:
151 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
152 include/assert.inc [There should be 1 warning(s)]
153 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
154 include/assert.inc [There should be 0 warning(s)]
155 include/assert.inc [Only two events should exist in the binary log]
156 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
157 Warnings:
158 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
159 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
160 Warnings:
161 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
162 DROP PREPARE prep_2;
163 DROP FUNCTION func_retval_1;
164
165 Invoking function func_sidef_1 invoking unsafe UUID() function.
166 CREATE FUNCTION func_sidef_1() RETURNS VARCHAR(100) BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO t0 VALUES (UUID()); RETURN 0; END;
167 * binlog_format = STATEMENT: expect 1 warnings.
168 INSERT INTO t1 SELECT func_sidef_1();
169 Warnings:
170 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
171 include/assert.inc [There should be 1 warning(s)]
172 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
173 include/assert.inc [There should be 0 warning(s)]
174 include/assert.inc [Only two events should exist in the binary log]
175 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
176 Warnings:
177 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
178 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
179 Warnings:
180 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
181
182 Invoking function func_sidef_2 invoking function func_sidef_1 invoking unsafe UUID() function.
183 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); RETURN 0; END;
184 * binlog_format = STATEMENT: expect 1 warnings.
185 INSERT INTO t2 SELECT func_sidef_2();
186 Warnings:
187 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
188 include/assert.inc [There should be 1 warning(s)]
189 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
190 include/assert.inc [There should be 0 warning(s)]
191 include/assert.inc [Only two events should exist in the binary log]
192 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
193 Warnings:
194 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
195 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
196 Warnings:
197 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
198 DROP FUNCTION func_sidef_2;
199
200 Invoking procedure proc_2 invoking function func_sidef_1 invoking unsafe UUID() function.
201 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 SELECT func_sidef_1(); INSERT INTO ta2 VALUES (47); END;
202 * binlog_format = STATEMENT: expect 1 warnings.
203 CALL proc_2();
204 Warnings:
205 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
206 include/assert.inc [There should be 1 warning(s)]
207 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
208 include/assert.inc [There should be 0 warning(s)]
209 include/assert.inc [Only two events should exist in the binary log]
210 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
211 Warnings:
212 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
213 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
214 Warnings:
215 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
216 DROP PROCEDURE proc_2;
217
218 Invoking trigger trig_2 invoking function func_sidef_1 invoking unsafe UUID() function.
219 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); END;
220 * binlog_format = STATEMENT: expect 1 warnings.
221 INSERT INTO trigger_table_2 VALUES (1);
222 Warnings:
223 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
224 include/assert.inc [There should be 1 warning(s)]
225 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
226 include/assert.inc [There should be 0 warning(s)]
227 include/assert.inc [Only two events should exist in the binary log]
228 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
229 Warnings:
230 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
231 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
232 Warnings:
233 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
234 DROP TRIGGER trig_2;
235
236 Invoking view view_sidef_2 invoking function func_sidef_1 invoking unsafe UUID() function.
237 CREATE VIEW view_sidef_2 AS SELECT func_sidef_1();
238 * binlog_format = STATEMENT: expect 1 warnings.
239 INSERT INTO t2 SELECT * FROM view_sidef_2;
240 Warnings:
241 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
242 include/assert.inc [There should be 1 warning(s)]
243 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
244 include/assert.inc [There should be 0 warning(s)]
245 include/assert.inc [Only two events should exist in the binary log]
246 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
247 Warnings:
248 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
249 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
250 Warnings:
251 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
252 DROP VIEW view_sidef_2;
253
254 Invoking prepared statement prep_2 invoking function func_sidef_1 invoking unsafe UUID() function.
255 PREPARE prep_2 FROM "INSERT INTO t1 SELECT func_sidef_1()";
256 * binlog_format = STATEMENT: expect 1 warnings.
257 EXECUTE prep_2;
258 Warnings:
259 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
260 include/assert.inc [There should be 1 warning(s)]
261 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
262 include/assert.inc [There should be 0 warning(s)]
263 include/assert.inc [Only two events should exist in the binary log]
264 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
265 Warnings:
266 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
267 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
268 Warnings:
269 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
270 DROP PREPARE prep_2;
271 DROP FUNCTION func_sidef_1;
272
273 Invoking procedure proc_1 invoking unsafe UUID() function.
274 CREATE PROCEDURE proc_1() BEGIN INSERT INTO t0 VALUES (UUID()); INSERT INTO ta1 VALUES (47); END;
275 * binlog_format = STATEMENT: expect 1 warnings.
276 CALL proc_1();
277 Warnings:
278 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
279 include/assert.inc [There should be 1 warning(s)]
280 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
281 include/assert.inc [There should be 0 warning(s)]
282 include/assert.inc [Only two events should exist in the binary log]
283 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
284 Warnings:
285 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
286 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
287 Warnings:
288 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
289
290 Invoking function func_sidef_2 invoking procedure proc_1 invoking unsafe UUID() function.
291 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); RETURN 0; END;
292 * binlog_format = STATEMENT: expect 1 warnings.
293 INSERT INTO t2 SELECT func_sidef_2();
294 Warnings:
295 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
296 include/assert.inc [There should be 1 warning(s)]
297 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
298 include/assert.inc [There should be 0 warning(s)]
299 include/assert.inc [Only two events should exist in the binary log]
300 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
301 Warnings:
302 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
303 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
304 Warnings:
305 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
306 DROP FUNCTION func_sidef_2;
307
308 Invoking procedure proc_2 invoking procedure proc_1 invoking unsafe UUID() function.
309 CREATE PROCEDURE proc_2() BEGIN CALL proc_1(); INSERT INTO ta2 VALUES (47); END;
310 * binlog_format = STATEMENT: expect 1 warnings.
311 CALL proc_2();
312 Warnings:
313 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
314 include/assert.inc [There should be 1 warning(s)]
315 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
316 include/assert.inc [There should be 0 warning(s)]
317 include/assert.inc [Only two events should exist in the binary log]
318 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
319 Warnings:
320 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
321 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
322 Warnings:
323 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
324 DROP PROCEDURE proc_2;
325
326 Invoking trigger trig_2 invoking procedure proc_1 invoking unsafe UUID() function.
327 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); END;
328 * binlog_format = STATEMENT: expect 1 warnings.
329 INSERT INTO trigger_table_2 VALUES (1);
330 Warnings:
331 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
332 include/assert.inc [There should be 1 warning(s)]
333 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
334 include/assert.inc [There should be 0 warning(s)]
335 include/assert.inc [Only two events should exist in the binary log]
336 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
337 Warnings:
338 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
339 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
340 Warnings:
341 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
342 DROP TRIGGER trig_2;
343
344 Invoking prepared statement prep_2 invoking procedure proc_1 invoking unsafe UUID() function.
345 PREPARE prep_2 FROM "CALL proc_1()";
346 * binlog_format = STATEMENT: expect 1 warnings.
347 EXECUTE prep_2;
348 Warnings:
349 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
350 include/assert.inc [There should be 1 warning(s)]
351 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
352 include/assert.inc [There should be 0 warning(s)]
353 include/assert.inc [Only two events should exist in the binary log]
354 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
355 Warnings:
356 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
357 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
358 Warnings:
359 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
360 DROP PREPARE prep_2;
361 DROP PROCEDURE proc_1;
362
363 Invoking trigger trig_1 invoking unsafe UUID() function.
364 CREATE TRIGGER trig_1 BEFORE INSERT ON trigger_table_1 FOR EACH ROW BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO t0 VALUES (UUID()); END;
365 * binlog_format = STATEMENT: expect 1 warnings.
366 INSERT INTO trigger_table_1 VALUES (1);
367 Warnings:
368 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
369 include/assert.inc [There should be 1 warning(s)]
370 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
371 include/assert.inc [There should be 0 warning(s)]
372 include/assert.inc [Only two events should exist in the binary log]
373 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
374 Warnings:
375 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
376 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
377 Warnings:
378 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
379
380 Invoking function func_sidef_2 invoking trigger trig_1 invoking unsafe UUID() function.
381 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); RETURN 0; END;
382 * binlog_format = STATEMENT: expect 1 warnings.
383 INSERT INTO t2 SELECT func_sidef_2();
384 Warnings:
385 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
386 include/assert.inc [There should be 1 warning(s)]
387 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
388 include/assert.inc [There should be 0 warning(s)]
389 include/assert.inc [Only two events should exist in the binary log]
390 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
391 Warnings:
392 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
393 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
394 Warnings:
395 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
396 DROP FUNCTION func_sidef_2;
397
398 Invoking procedure proc_2 invoking trigger trig_1 invoking unsafe UUID() function.
399 CREATE PROCEDURE proc_2() BEGIN INSERT INTO trigger_table_1 VALUES (1); INSERT INTO ta2 VALUES (47); END;
400 * binlog_format = STATEMENT: expect 1 warnings.
401 CALL proc_2();
402 Warnings:
403 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
404 include/assert.inc [There should be 1 warning(s)]
405 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
406 include/assert.inc [There should be 0 warning(s)]
407 include/assert.inc [Only two events should exist in the binary log]
408 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
409 Warnings:
410 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
411 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
412 Warnings:
413 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
414 DROP PROCEDURE proc_2;
415
416 Invoking trigger trig_2 invoking trigger trig_1 invoking unsafe UUID() function.
417 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); END;
418 * binlog_format = STATEMENT: expect 1 warnings.
419 INSERT INTO trigger_table_2 VALUES (1);
420 Warnings:
421 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
422 include/assert.inc [There should be 1 warning(s)]
423 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
424 include/assert.inc [There should be 0 warning(s)]
425 include/assert.inc [Only two events should exist in the binary log]
426 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
427 Warnings:
428 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
429 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
430 Warnings:
431 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
432 DROP TRIGGER trig_2;
433
434 Invoking prepared statement prep_2 invoking trigger trig_1 invoking unsafe UUID() function.
435 PREPARE prep_2 FROM "INSERT INTO trigger_table_1 VALUES (1)";
436 * binlog_format = STATEMENT: expect 1 warnings.
437 EXECUTE prep_2;
438 Warnings:
439 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
440 include/assert.inc [There should be 1 warning(s)]
441 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
442 include/assert.inc [There should be 0 warning(s)]
443 include/assert.inc [Only two events should exist in the binary log]
444 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
445 Warnings:
446 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
447 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
448 Warnings:
449 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
450 DROP PREPARE prep_2;
451 DROP TRIGGER trig_1;
452
453 Invoking view view_retval_1 returning value from unsafe UUID() function.
454 CREATE VIEW view_retval_1 AS SELECT UUID();
455 * binlog_format = STATEMENT: expect 1 warnings.
456 INSERT INTO t1 SELECT * FROM view_retval_1;
457 Warnings:
458 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
459 include/assert.inc [There should be 1 warning(s)]
460 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
461 include/assert.inc [There should be 0 warning(s)]
462 include/assert.inc [Only two events should exist in the binary log]
463 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
464 Warnings:
465 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
466 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
467 Warnings:
468 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
469 * Invoke statement so that return value is discarded: expect no warning.
470 SELECT * FROM view_retval_1;
471
472 Invoking function func_sidef_2 invoking view view_retval_1 returning value from unsafe UUID() function.
473 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT * FROM view_retval_1; RETURN 0; END;
474 * binlog_format = STATEMENT: expect 1 warnings.
475 INSERT INTO t2 SELECT func_sidef_2();
476 Warnings:
477 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
478 include/assert.inc [There should be 1 warning(s)]
479 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
480 include/assert.inc [There should be 0 warning(s)]
481 include/assert.inc [Only two events should exist in the binary log]
482 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
483 Warnings:
484 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
485 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
486 Warnings:
487 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
488 DROP FUNCTION func_sidef_2;
489
490 Invoking procedure proc_2 invoking view view_retval_1 returning value from unsafe UUID() function.
491 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 SELECT * FROM view_retval_1; INSERT INTO ta2 VALUES (47); END;
492 * binlog_format = STATEMENT: expect 1 warnings.
493 CALL proc_2();
494 Warnings:
495 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
496 include/assert.inc [There should be 1 warning(s)]
497 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
498 include/assert.inc [There should be 0 warning(s)]
499 include/assert.inc [Only two events should exist in the binary log]
500 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
501 Warnings:
502 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
503 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
504 Warnings:
505 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
506 DROP PROCEDURE proc_2;
507
508 Invoking trigger trig_2 invoking view view_retval_1 returning value from unsafe UUID() function.
509 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT * FROM view_retval_1; END;
510 * binlog_format = STATEMENT: expect 1 warnings.
511 INSERT INTO trigger_table_2 VALUES (1);
512 Warnings:
513 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
514 include/assert.inc [There should be 1 warning(s)]
515 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
516 include/assert.inc [There should be 0 warning(s)]
517 include/assert.inc [Only two events should exist in the binary log]
518 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
519 Warnings:
520 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
521 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
522 Warnings:
523 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
524 DROP TRIGGER trig_2;
525
526 Invoking view view_retval_2 returning value from view view_retval_1 returning value from unsafe UUID() function.
527 CREATE VIEW view_retval_2 AS SELECT * FROM view_retval_1;
528 * binlog_format = STATEMENT: expect 1 warnings.
529 INSERT INTO t2 SELECT * FROM view_retval_2;
530 Warnings:
531 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
532 include/assert.inc [There should be 1 warning(s)]
533 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
534 include/assert.inc [There should be 0 warning(s)]
535 include/assert.inc [Only two events should exist in the binary log]
536 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
537 Warnings:
538 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
539 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
540 Warnings:
541 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
542 * Invoke statement so that return value is discarded: expect no warning.
543 SELECT * FROM view_retval_2;
544 DROP VIEW view_retval_2;
545
546 Invoking prepared statement prep_2 invoking view view_retval_1 returning value from unsafe UUID() function.
547 PREPARE prep_2 FROM "INSERT INTO t1 SELECT * FROM view_retval_1";
548 * binlog_format = STATEMENT: expect 1 warnings.
549 EXECUTE prep_2;
550 Warnings:
551 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
552 include/assert.inc [There should be 1 warning(s)]
553 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
554 include/assert.inc [There should be 0 warning(s)]
555 include/assert.inc [Only two events should exist in the binary log]
556 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
557 Warnings:
558 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
559 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
560 Warnings:
561 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
562 DROP PREPARE prep_2;
563 DROP VIEW view_retval_1;
564
565 Invoking prepared statement prep_1 invoking unsafe UUID() function.
566 PREPARE prep_1 FROM "INSERT INTO t0 VALUES (UUID())";
567 * binlog_format = STATEMENT: expect 1 warnings.
568 EXECUTE prep_1;
569 Warnings:
570 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
571 include/assert.inc [There should be 1 warning(s)]
572 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
573 include/assert.inc [There should be 0 warning(s)]
574 include/assert.inc [Only two events should exist in the binary log]
575 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
576 Warnings:
577 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
578 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
579 Warnings:
580 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
581 DROP PREPARE prep_1;
582
583 Invoking unsafe UUID() function.
584 * binlog_format = STATEMENT: expect 1 warnings.
585 INSERT INTO t0 VALUES (UUID());
586 Warnings:
587 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
588 include/assert.inc [There should be 1 warning(s)]
589 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
590 include/assert.inc [There should be 0 warning(s)]
591 include/assert.inc [Only two events should exist in the binary log]
592 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
593 Warnings:
594 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
595 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system function that may return a different value on the replica.
596 Warnings:
597 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
598 * Invoke statement so that return value is discarded: expect no warning.
599 SELECT UUID();
600
601 ==== Testing @@hostname unsafeness ====
602
603 Invoking function func_retval_1 returning value from unsafe @@hostname variable.
604 CREATE FUNCTION func_retval_1() RETURNS VARCHAR(100) BEGIN INSERT INTO ta1 VALUES (47); RETURN @@hostname; END;
605 * binlog_format = STATEMENT: expect 1 warnings.
606 INSERT INTO t1 VALUES (func_retval_1());
607 Warnings:
608 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
609 include/assert.inc [There should be 1 warning(s)]
610 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
611 include/assert.inc [There should be 0 warning(s)]
612 include/assert.inc [Only two events should exist in the binary log]
613 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
614 Warnings:
615 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
616 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
617 Warnings:
618 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
619 * Invoke statement so that return value is discarded: expect no warning.
620 SELECT func_retval_1();
621
622 Invoking function func_retval_2 returning value from function func_retval_1 returning value from unsafe @@hostname variable.
623 CREATE FUNCTION func_retval_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); RETURN func_retval_1(); END;
624 * binlog_format = STATEMENT: expect 1 warnings.
625 INSERT INTO t2 VALUES (func_retval_2());
626 Warnings:
627 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
628 include/assert.inc [There should be 1 warning(s)]
629 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
630 include/assert.inc [There should be 0 warning(s)]
631 include/assert.inc [Only two events should exist in the binary log]
632 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
633 Warnings:
634 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
635 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
636 Warnings:
637 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
638 * Invoke statement so that return value is discarded: expect no warning.
639 SELECT func_retval_2();
640 DROP FUNCTION func_retval_2;
641
642 Invoking function func_sidef_2 invoking function func_retval_1 returning value from unsafe @@hostname variable.
643 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 VALUES (func_retval_1()); RETURN 0; END;
644 * binlog_format = STATEMENT: expect 1 warnings.
645 INSERT INTO t2 SELECT func_sidef_2();
646 Warnings:
647 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
648 include/assert.inc [There should be 1 warning(s)]
649 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
650 include/assert.inc [There should be 0 warning(s)]
651 include/assert.inc [Only two events should exist in the binary log]
652 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
653 Warnings:
654 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
655 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
656 Warnings:
657 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
658 DROP FUNCTION func_sidef_2;
659
660 Invoking procedure proc_2 invoking function func_retval_1 returning value from unsafe @@hostname variable.
661 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 VALUES (func_retval_1()); INSERT INTO ta2 VALUES (47); END;
662 * binlog_format = STATEMENT: expect 1 warnings.
663 CALL proc_2();
664 Warnings:
665 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
666 include/assert.inc [There should be 1 warning(s)]
667 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
668 include/assert.inc [There should be 0 warning(s)]
669 include/assert.inc [Only two events should exist in the binary log]
670 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
671 Warnings:
672 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
673 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
674 Warnings:
675 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
676 DROP PROCEDURE proc_2;
677
678 Invoking trigger trig_2 invoking function func_retval_1 returning value from unsafe @@hostname variable.
679 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 VALUES (func_retval_1()); END;
680 * binlog_format = STATEMENT: expect 1 warnings.
681 INSERT INTO trigger_table_2 VALUES (1);
682 Warnings:
683 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
684 include/assert.inc [There should be 1 warning(s)]
685 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
686 include/assert.inc [There should be 0 warning(s)]
687 include/assert.inc [Only two events should exist in the binary log]
688 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
689 Warnings:
690 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
691 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
692 Warnings:
693 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
694 DROP TRIGGER trig_2;
695
696 Invoking view view_retval_2 returning value from function func_retval_1 returning value from unsafe @@hostname variable.
697 CREATE VIEW view_retval_2 AS SELECT func_retval_1();
698 * binlog_format = STATEMENT: expect 1 warnings.
699 INSERT INTO t2 SELECT * FROM view_retval_2;
700 Warnings:
701 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
702 include/assert.inc [There should be 1 warning(s)]
703 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
704 include/assert.inc [There should be 0 warning(s)]
705 include/assert.inc [Only two events should exist in the binary log]
706 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
707 Warnings:
708 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
709 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
710 Warnings:
711 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
712 * Invoke statement so that return value is discarded: expect no warning.
713 SELECT * FROM view_retval_2;
714 DROP VIEW view_retval_2;
715
716 Invoking prepared statement prep_2 invoking function func_retval_1 returning value from unsafe @@hostname variable.
717 PREPARE prep_2 FROM "INSERT INTO t1 VALUES (func_retval_1())";
718 * binlog_format = STATEMENT: expect 1 warnings.
719 EXECUTE prep_2;
720 Warnings:
721 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
722 include/assert.inc [There should be 1 warning(s)]
723 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
724 include/assert.inc [There should be 0 warning(s)]
725 include/assert.inc [Only two events should exist in the binary log]
726 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
727 Warnings:
728 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
729 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
730 Warnings:
731 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
732 DROP PREPARE prep_2;
733 DROP FUNCTION func_retval_1;
734
735 Invoking function func_sidef_1 invoking unsafe @@hostname variable.
736 CREATE FUNCTION func_sidef_1() RETURNS VARCHAR(100) BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO t0 VALUES (@@hostname); RETURN 0; END;
737 * binlog_format = STATEMENT: expect 1 warnings.
738 INSERT INTO t1 SELECT func_sidef_1();
739 Warnings:
740 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
741 include/assert.inc [There should be 1 warning(s)]
742 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
743 include/assert.inc [There should be 0 warning(s)]
744 include/assert.inc [Only two events should exist in the binary log]
745 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
746 Warnings:
747 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
748 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
749 Warnings:
750 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
751
752 Invoking function func_sidef_2 invoking function func_sidef_1 invoking unsafe @@hostname variable.
753 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); RETURN 0; END;
754 * binlog_format = STATEMENT: expect 1 warnings.
755 INSERT INTO t2 SELECT func_sidef_2();
756 Warnings:
757 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
758 include/assert.inc [There should be 1 warning(s)]
759 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
760 include/assert.inc [There should be 0 warning(s)]
761 include/assert.inc [Only two events should exist in the binary log]
762 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
763 Warnings:
764 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
765 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
766 Warnings:
767 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
768 DROP FUNCTION func_sidef_2;
769
770 Invoking procedure proc_2 invoking function func_sidef_1 invoking unsafe @@hostname variable.
771 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 SELECT func_sidef_1(); INSERT INTO ta2 VALUES (47); END;
772 * binlog_format = STATEMENT: expect 1 warnings.
773 CALL proc_2();
774 Warnings:
775 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
776 include/assert.inc [There should be 1 warning(s)]
777 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
778 include/assert.inc [There should be 0 warning(s)]
779 include/assert.inc [Only two events should exist in the binary log]
780 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
781 Warnings:
782 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
783 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
784 Warnings:
785 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
786 DROP PROCEDURE proc_2;
787
788 Invoking trigger trig_2 invoking function func_sidef_1 invoking unsafe @@hostname variable.
789 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); END;
790 * binlog_format = STATEMENT: expect 1 warnings.
791 INSERT INTO trigger_table_2 VALUES (1);
792 Warnings:
793 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
794 include/assert.inc [There should be 1 warning(s)]
795 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
796 include/assert.inc [There should be 0 warning(s)]
797 include/assert.inc [Only two events should exist in the binary log]
798 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
799 Warnings:
800 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
801 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
802 Warnings:
803 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
804 DROP TRIGGER trig_2;
805
806 Invoking view view_sidef_2 invoking function func_sidef_1 invoking unsafe @@hostname variable.
807 CREATE VIEW view_sidef_2 AS SELECT func_sidef_1();
808 * binlog_format = STATEMENT: expect 1 warnings.
809 INSERT INTO t2 SELECT * FROM view_sidef_2;
810 Warnings:
811 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
812 include/assert.inc [There should be 1 warning(s)]
813 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
814 include/assert.inc [There should be 0 warning(s)]
815 include/assert.inc [Only two events should exist in the binary log]
816 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
817 Warnings:
818 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
819 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
820 Warnings:
821 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
822 DROP VIEW view_sidef_2;
823
824 Invoking prepared statement prep_2 invoking function func_sidef_1 invoking unsafe @@hostname variable.
825 PREPARE prep_2 FROM "INSERT INTO t1 SELECT func_sidef_1()";
826 * binlog_format = STATEMENT: expect 1 warnings.
827 EXECUTE prep_2;
828 Warnings:
829 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
830 include/assert.inc [There should be 1 warning(s)]
831 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
832 include/assert.inc [There should be 0 warning(s)]
833 include/assert.inc [Only two events should exist in the binary log]
834 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
835 Warnings:
836 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
837 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
838 Warnings:
839 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
840 DROP PREPARE prep_2;
841 DROP FUNCTION func_sidef_1;
842
843 Invoking procedure proc_1 invoking unsafe @@hostname variable.
844 CREATE PROCEDURE proc_1() BEGIN INSERT INTO t0 VALUES (@@hostname); INSERT INTO ta1 VALUES (47); END;
845 * binlog_format = STATEMENT: expect 1 warnings.
846 CALL proc_1();
847 Warnings:
848 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
849 include/assert.inc [There should be 1 warning(s)]
850 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
851 include/assert.inc [There should be 0 warning(s)]
852 include/assert.inc [Only two events should exist in the binary log]
853 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
854 Warnings:
855 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
856 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
857 Warnings:
858 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
859
860 Invoking function func_sidef_2 invoking procedure proc_1 invoking unsafe @@hostname variable.
861 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); RETURN 0; END;
862 * binlog_format = STATEMENT: expect 1 warnings.
863 INSERT INTO t2 SELECT func_sidef_2();
864 Warnings:
865 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
866 include/assert.inc [There should be 1 warning(s)]
867 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
868 include/assert.inc [There should be 0 warning(s)]
869 include/assert.inc [Only two events should exist in the binary log]
870 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
871 Warnings:
872 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
873 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
874 Warnings:
875 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
876 DROP FUNCTION func_sidef_2;
877
878 Invoking procedure proc_2 invoking procedure proc_1 invoking unsafe @@hostname variable.
879 CREATE PROCEDURE proc_2() BEGIN CALL proc_1(); INSERT INTO ta2 VALUES (47); END;
880 * binlog_format = STATEMENT: expect 1 warnings.
881 CALL proc_2();
882 Warnings:
883 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
884 include/assert.inc [There should be 1 warning(s)]
885 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
886 include/assert.inc [There should be 0 warning(s)]
887 include/assert.inc [Only two events should exist in the binary log]
888 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
889 Warnings:
890 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
891 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
892 Warnings:
893 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
894 DROP PROCEDURE proc_2;
895
896 Invoking trigger trig_2 invoking procedure proc_1 invoking unsafe @@hostname variable.
897 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); END;
898 * binlog_format = STATEMENT: expect 1 warnings.
899 INSERT INTO trigger_table_2 VALUES (1);
900 Warnings:
901 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
902 include/assert.inc [There should be 1 warning(s)]
903 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
904 include/assert.inc [There should be 0 warning(s)]
905 include/assert.inc [Only two events should exist in the binary log]
906 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
907 Warnings:
908 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
909 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
910 Warnings:
911 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
912 DROP TRIGGER trig_2;
913
914 Invoking prepared statement prep_2 invoking procedure proc_1 invoking unsafe @@hostname variable.
915 PREPARE prep_2 FROM "CALL proc_1()";
916 * binlog_format = STATEMENT: expect 1 warnings.
917 EXECUTE prep_2;
918 Warnings:
919 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
920 include/assert.inc [There should be 1 warning(s)]
921 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
922 include/assert.inc [There should be 0 warning(s)]
923 include/assert.inc [Only two events should exist in the binary log]
924 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
925 Warnings:
926 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
927 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
928 Warnings:
929 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
930 DROP PREPARE prep_2;
931 DROP PROCEDURE proc_1;
932
933 Invoking trigger trig_1 invoking unsafe @@hostname variable.
934 CREATE TRIGGER trig_1 BEFORE INSERT ON trigger_table_1 FOR EACH ROW BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO t0 VALUES (@@hostname); END;
935 * binlog_format = STATEMENT: expect 1 warnings.
936 INSERT INTO trigger_table_1 VALUES (1);
937 Warnings:
938 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
939 include/assert.inc [There should be 1 warning(s)]
940 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
941 include/assert.inc [There should be 0 warning(s)]
942 include/assert.inc [Only two events should exist in the binary log]
943 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
944 Warnings:
945 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
946 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
947 Warnings:
948 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
949
950 Invoking function func_sidef_2 invoking trigger trig_1 invoking unsafe @@hostname variable.
951 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); RETURN 0; END;
952 * binlog_format = STATEMENT: expect 1 warnings.
953 INSERT INTO t2 SELECT func_sidef_2();
954 Warnings:
955 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
956 include/assert.inc [There should be 1 warning(s)]
957 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
958 include/assert.inc [There should be 0 warning(s)]
959 include/assert.inc [Only two events should exist in the binary log]
960 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
961 Warnings:
962 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
963 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
964 Warnings:
965 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
966 DROP FUNCTION func_sidef_2;
967
968 Invoking procedure proc_2 invoking trigger trig_1 invoking unsafe @@hostname variable.
969 CREATE PROCEDURE proc_2() BEGIN INSERT INTO trigger_table_1 VALUES (1); INSERT INTO ta2 VALUES (47); END;
970 * binlog_format = STATEMENT: expect 1 warnings.
971 CALL proc_2();
972 Warnings:
973 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
974 include/assert.inc [There should be 1 warning(s)]
975 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
976 include/assert.inc [There should be 0 warning(s)]
977 include/assert.inc [Only two events should exist in the binary log]
978 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
979 Warnings:
980 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
981 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
982 Warnings:
983 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
984 DROP PROCEDURE proc_2;
985
986 Invoking trigger trig_2 invoking trigger trig_1 invoking unsafe @@hostname variable.
987 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); END;
988 * binlog_format = STATEMENT: expect 1 warnings.
989 INSERT INTO trigger_table_2 VALUES (1);
990 Warnings:
991 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
992 include/assert.inc [There should be 1 warning(s)]
993 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
994 include/assert.inc [There should be 0 warning(s)]
995 include/assert.inc [Only two events should exist in the binary log]
996 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
997 Warnings:
998 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
999 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
1000 Warnings:
1001 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1002 DROP TRIGGER trig_2;
1003
1004 Invoking prepared statement prep_2 invoking trigger trig_1 invoking unsafe @@hostname variable.
1005 PREPARE prep_2 FROM "INSERT INTO trigger_table_1 VALUES (1)";
1006 * binlog_format = STATEMENT: expect 1 warnings.
1007 EXECUTE prep_2;
1008 Warnings:
1009 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
1010 include/assert.inc [There should be 1 warning(s)]
1011 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1012 include/assert.inc [There should be 0 warning(s)]
1013 include/assert.inc [Only two events should exist in the binary log]
1014 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1015 Warnings:
1016 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1017 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
1018 Warnings:
1019 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1020 DROP PREPARE prep_2;
1021 DROP TRIGGER trig_1;
1022
1023 Invoking prepared statement prep_1 invoking unsafe @@hostname variable.
1024 PREPARE prep_1 FROM "INSERT INTO t0 VALUES (@@hostname)";
1025 * binlog_format = STATEMENT: expect 1 warnings.
1026 EXECUTE prep_1;
1027 Warnings:
1028 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
1029 include/assert.inc [There should be 1 warning(s)]
1030 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1031 include/assert.inc [There should be 0 warning(s)]
1032 include/assert.inc [Only two events should exist in the binary log]
1033 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1034 Warnings:
1035 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1036 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
1037 Warnings:
1038 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1039 DROP PREPARE prep_1;
1040
1041 Invoking unsafe @@hostname variable.
1042 * binlog_format = STATEMENT: expect 1 warnings.
1043 INSERT INTO t0 VALUES (@@hostname);
1044 Warnings:
1045 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
1046 include/assert.inc [There should be 1 warning(s)]
1047 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1048 include/assert.inc [There should be 0 warning(s)]
1049 include/assert.inc [Only two events should exist in the binary log]
1050 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1051 Warnings:
1052 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1053 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
1054 Warnings:
1055 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1056
1057 ==== Testing SELECT...LIMIT unsafeness ====
1058
1059 Invoking function func_sidef_1 invoking unsafe SELECT...LIMIT statement.
1060 CREATE FUNCTION func_sidef_1() RETURNS VARCHAR(100) BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO t0 SELECT * FROM data_table LIMIT 1; RETURN 0; END;
1061 * binlog_format = STATEMENT: expect 1 warnings.
1062 INSERT INTO t1 SELECT func_sidef_1();
1063 Warnings:
1064 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1065 include/assert.inc [There should be 1 warning(s)]
1066 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1067 include/assert.inc [There should be 0 warning(s)]
1068 include/assert.inc [Only two events should exist in the binary log]
1069 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1070 Warnings:
1071 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1072 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1073 Warnings:
1074 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1075
1076 Invoking function func_sidef_2 invoking function func_sidef_1 invoking unsafe SELECT...LIMIT statement.
1077 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); RETURN 0; END;
1078 * binlog_format = STATEMENT: expect 1 warnings.
1079 INSERT INTO t2 SELECT func_sidef_2();
1080 Warnings:
1081 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1082 include/assert.inc [There should be 1 warning(s)]
1083 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1084 include/assert.inc [There should be 0 warning(s)]
1085 include/assert.inc [Only two events should exist in the binary log]
1086 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1087 Warnings:
1088 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1089 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1090 Warnings:
1091 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1092 DROP FUNCTION func_sidef_2;
1093
1094 Invoking procedure proc_2 invoking function func_sidef_1 invoking unsafe SELECT...LIMIT statement.
1095 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 SELECT func_sidef_1(); INSERT INTO ta2 VALUES (47); END;
1096 * binlog_format = STATEMENT: expect 1 warnings.
1097 CALL proc_2();
1098 Warnings:
1099 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1100 include/assert.inc [There should be 1 warning(s)]
1101 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1102 include/assert.inc [There should be 0 warning(s)]
1103 include/assert.inc [Only two events should exist in the binary log]
1104 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1105 Warnings:
1106 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1107 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1108 Warnings:
1109 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1110 DROP PROCEDURE proc_2;
1111
1112 Invoking trigger trig_2 invoking function func_sidef_1 invoking unsafe SELECT...LIMIT statement.
1113 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); END;
1114 * binlog_format = STATEMENT: expect 1 warnings.
1115 INSERT INTO trigger_table_2 VALUES (1);
1116 Warnings:
1117 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1118 include/assert.inc [There should be 1 warning(s)]
1119 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1120 include/assert.inc [There should be 0 warning(s)]
1121 include/assert.inc [Only two events should exist in the binary log]
1122 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1123 Warnings:
1124 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1125 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1126 Warnings:
1127 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1128 DROP TRIGGER trig_2;
1129
1130 Invoking view view_sidef_2 invoking function func_sidef_1 invoking unsafe SELECT...LIMIT statement.
1131 CREATE VIEW view_sidef_2 AS SELECT func_sidef_1();
1132 * binlog_format = STATEMENT: expect 1 warnings.
1133 INSERT INTO t2 SELECT * FROM view_sidef_2;
1134 Warnings:
1135 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1136 include/assert.inc [There should be 1 warning(s)]
1137 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1138 include/assert.inc [There should be 0 warning(s)]
1139 include/assert.inc [Only two events should exist in the binary log]
1140 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1141 Warnings:
1142 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1143 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1144 Warnings:
1145 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1146 DROP VIEW view_sidef_2;
1147
1148 Invoking prepared statement prep_2 invoking function func_sidef_1 invoking unsafe SELECT...LIMIT statement.
1149 PREPARE prep_2 FROM "INSERT INTO t1 SELECT func_sidef_1()";
1150 * binlog_format = STATEMENT: expect 1 warnings.
1151 EXECUTE prep_2;
1152 Warnings:
1153 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1154 include/assert.inc [There should be 1 warning(s)]
1155 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1156 include/assert.inc [There should be 0 warning(s)]
1157 include/assert.inc [Only two events should exist in the binary log]
1158 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1159 Warnings:
1160 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1161 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1162 Warnings:
1163 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1164 DROP PREPARE prep_2;
1165 DROP FUNCTION func_sidef_1;
1166
1167 Invoking procedure proc_1 invoking unsafe SELECT...LIMIT statement.
1168 CREATE PROCEDURE proc_1() BEGIN INSERT INTO t0 SELECT * FROM data_table LIMIT 1; INSERT INTO ta1 VALUES (47); END;
1169 * binlog_format = STATEMENT: expect 1 warnings.
1170 CALL proc_1();
1171 Warnings:
1172 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1173 include/assert.inc [There should be 1 warning(s)]
1174 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1175 include/assert.inc [There should be 0 warning(s)]
1176 include/assert.inc [Only two events should exist in the binary log]
1177 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1178 Warnings:
1179 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1180 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1181 Warnings:
1182 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1183
1184 Invoking function func_sidef_2 invoking procedure proc_1 invoking unsafe SELECT...LIMIT statement.
1185 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); RETURN 0; END;
1186 * binlog_format = STATEMENT: expect 1 warnings.
1187 INSERT INTO t2 SELECT func_sidef_2();
1188 Warnings:
1189 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1190 include/assert.inc [There should be 1 warning(s)]
1191 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1192 include/assert.inc [There should be 0 warning(s)]
1193 include/assert.inc [Only two events should exist in the binary log]
1194 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1195 Warnings:
1196 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1197 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1198 Warnings:
1199 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1200 DROP FUNCTION func_sidef_2;
1201
1202 Invoking procedure proc_2 invoking procedure proc_1 invoking unsafe SELECT...LIMIT statement.
1203 CREATE PROCEDURE proc_2() BEGIN CALL proc_1(); INSERT INTO ta2 VALUES (47); END;
1204 * binlog_format = STATEMENT: expect 1 warnings.
1205 CALL proc_2();
1206 Warnings:
1207 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1208 include/assert.inc [There should be 1 warning(s)]
1209 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1210 include/assert.inc [There should be 0 warning(s)]
1211 include/assert.inc [Only two events should exist in the binary log]
1212 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1213 Warnings:
1214 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1215 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1216 Warnings:
1217 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1218 DROP PROCEDURE proc_2;
1219
1220 Invoking trigger trig_2 invoking procedure proc_1 invoking unsafe SELECT...LIMIT statement.
1221 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); END;
1222 * binlog_format = STATEMENT: expect 1 warnings.
1223 INSERT INTO trigger_table_2 VALUES (1);
1224 Warnings:
1225 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1226 include/assert.inc [There should be 1 warning(s)]
1227 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1228 include/assert.inc [There should be 0 warning(s)]
1229 include/assert.inc [Only two events should exist in the binary log]
1230 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1231 Warnings:
1232 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1233 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1234 Warnings:
1235 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1236 DROP TRIGGER trig_2;
1237
1238 Invoking prepared statement prep_2 invoking procedure proc_1 invoking unsafe SELECT...LIMIT statement.
1239 PREPARE prep_2 FROM "CALL proc_1()";
1240 * binlog_format = STATEMENT: expect 1 warnings.
1241 EXECUTE prep_2;
1242 Warnings:
1243 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1244 include/assert.inc [There should be 1 warning(s)]
1245 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1246 include/assert.inc [There should be 0 warning(s)]
1247 include/assert.inc [Only two events should exist in the binary log]
1248 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1249 Warnings:
1250 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1251 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1252 Warnings:
1253 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1254 DROP PREPARE prep_2;
1255 DROP PROCEDURE proc_1;
1256
1257 Invoking trigger trig_1 invoking unsafe SELECT...LIMIT statement.
1258 CREATE TRIGGER trig_1 BEFORE INSERT ON trigger_table_1 FOR EACH ROW BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO t0 SELECT * FROM data_table LIMIT 1; END;
1259 * binlog_format = STATEMENT: expect 1 warnings.
1260 INSERT INTO trigger_table_1 VALUES (1);
1261 Warnings:
1262 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1263 include/assert.inc [There should be 1 warning(s)]
1264 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1265 include/assert.inc [There should be 0 warning(s)]
1266 include/assert.inc [Only two events should exist in the binary log]
1267 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1268 Warnings:
1269 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1270 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1271 Warnings:
1272 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1273
1274 Invoking function func_sidef_2 invoking trigger trig_1 invoking unsafe SELECT...LIMIT statement.
1275 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); RETURN 0; END;
1276 * binlog_format = STATEMENT: expect 1 warnings.
1277 INSERT INTO t2 SELECT func_sidef_2();
1278 Warnings:
1279 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1280 include/assert.inc [There should be 1 warning(s)]
1281 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1282 include/assert.inc [There should be 0 warning(s)]
1283 include/assert.inc [Only two events should exist in the binary log]
1284 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1285 Warnings:
1286 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1287 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1288 Warnings:
1289 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1290 DROP FUNCTION func_sidef_2;
1291
1292 Invoking procedure proc_2 invoking trigger trig_1 invoking unsafe SELECT...LIMIT statement.
1293 CREATE PROCEDURE proc_2() BEGIN INSERT INTO trigger_table_1 VALUES (1); INSERT INTO ta2 VALUES (47); END;
1294 * binlog_format = STATEMENT: expect 1 warnings.
1295 CALL proc_2();
1296 Warnings:
1297 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1298 include/assert.inc [There should be 1 warning(s)]
1299 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1300 include/assert.inc [There should be 0 warning(s)]
1301 include/assert.inc [Only two events should exist in the binary log]
1302 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1303 Warnings:
1304 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1305 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1306 Warnings:
1307 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1308 DROP PROCEDURE proc_2;
1309
1310 Invoking trigger trig_2 invoking trigger trig_1 invoking unsafe SELECT...LIMIT statement.
1311 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); END;
1312 * binlog_format = STATEMENT: expect 1 warnings.
1313 INSERT INTO trigger_table_2 VALUES (1);
1314 Warnings:
1315 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1316 include/assert.inc [There should be 1 warning(s)]
1317 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1318 include/assert.inc [There should be 0 warning(s)]
1319 include/assert.inc [Only two events should exist in the binary log]
1320 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1321 Warnings:
1322 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1323 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1324 Warnings:
1325 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1326 DROP TRIGGER trig_2;
1327
1328 Invoking prepared statement prep_2 invoking trigger trig_1 invoking unsafe SELECT...LIMIT statement.
1329 PREPARE prep_2 FROM "INSERT INTO trigger_table_1 VALUES (1)";
1330 * binlog_format = STATEMENT: expect 1 warnings.
1331 EXECUTE prep_2;
1332 Warnings:
1333 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1334 include/assert.inc [There should be 1 warning(s)]
1335 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1336 include/assert.inc [There should be 0 warning(s)]
1337 include/assert.inc [Only two events should exist in the binary log]
1338 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1339 Warnings:
1340 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1341 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1342 Warnings:
1343 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1344 DROP PREPARE prep_2;
1345 DROP TRIGGER trig_1;
1346
1347 Invoking view view_retval_1 returning value from unsafe SELECT...LIMIT statement.
1348 CREATE VIEW view_retval_1 AS SELECT * FROM data_table LIMIT 1;
1349 * binlog_format = STATEMENT: expect 1 warnings.
1350 INSERT INTO t1 SELECT * FROM view_retval_1;
1351 Warnings:
1352 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1353 include/assert.inc [There should be 1 warning(s)]
1354 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1355 include/assert.inc [There should be 0 warning(s)]
1356 include/assert.inc [Only two events should exist in the binary log]
1357 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1358 Warnings:
1359 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1360 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1361 Warnings:
1362 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1363 * Invoke statement so that return value is discarded: expect no warning.
1364 SELECT * FROM view_retval_1;
1365
1366 Invoking function func_sidef_2 invoking view view_retval_1 returning value from unsafe SELECT...LIMIT statement.
1367 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT * FROM view_retval_1; RETURN 0; END;
1368 * binlog_format = STATEMENT: expect 1 warnings.
1369 INSERT INTO t2 SELECT func_sidef_2();
1370 Warnings:
1371 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1372 include/assert.inc [There should be 1 warning(s)]
1373 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1374 include/assert.inc [There should be 0 warning(s)]
1375 include/assert.inc [Only two events should exist in the binary log]
1376 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1377 Warnings:
1378 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1379 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1380 Warnings:
1381 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1382 DROP FUNCTION func_sidef_2;
1383
1384 Invoking procedure proc_2 invoking view view_retval_1 returning value from unsafe SELECT...LIMIT statement.
1385 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 SELECT * FROM view_retval_1; INSERT INTO ta2 VALUES (47); END;
1386 * binlog_format = STATEMENT: expect 1 warnings.
1387 CALL proc_2();
1388 Warnings:
1389 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1390 include/assert.inc [There should be 1 warning(s)]
1391 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1392 include/assert.inc [There should be 0 warning(s)]
1393 include/assert.inc [Only two events should exist in the binary log]
1394 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1395 Warnings:
1396 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1397 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1398 Warnings:
1399 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1400 DROP PROCEDURE proc_2;
1401
1402 Invoking trigger trig_2 invoking view view_retval_1 returning value from unsafe SELECT...LIMIT statement.
1403 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT * FROM view_retval_1; END;
1404 * binlog_format = STATEMENT: expect 1 warnings.
1405 INSERT INTO trigger_table_2 VALUES (1);
1406 Warnings:
1407 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1408 include/assert.inc [There should be 1 warning(s)]
1409 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1410 include/assert.inc [There should be 0 warning(s)]
1411 include/assert.inc [Only two events should exist in the binary log]
1412 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1413 Warnings:
1414 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1415 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1416 Warnings:
1417 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1418 DROP TRIGGER trig_2;
1419
1420 Invoking view view_retval_2 returning value from view view_retval_1 returning value from unsafe SELECT...LIMIT statement.
1421 CREATE VIEW view_retval_2 AS SELECT * FROM view_retval_1;
1422 * binlog_format = STATEMENT: expect 1 warnings.
1423 INSERT INTO t2 SELECT * FROM view_retval_2;
1424 Warnings:
1425 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1426 include/assert.inc [There should be 1 warning(s)]
1427 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1428 include/assert.inc [There should be 0 warning(s)]
1429 include/assert.inc [Only two events should exist in the binary log]
1430 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1431 Warnings:
1432 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1433 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1434 Warnings:
1435 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1436 * Invoke statement so that return value is discarded: expect no warning.
1437 SELECT * FROM view_retval_2;
1438 DROP VIEW view_retval_2;
1439
1440 Invoking prepared statement prep_2 invoking view view_retval_1 returning value from unsafe SELECT...LIMIT statement.
1441 PREPARE prep_2 FROM "INSERT INTO t1 SELECT * FROM view_retval_1";
1442 * binlog_format = STATEMENT: expect 1 warnings.
1443 EXECUTE prep_2;
1444 Warnings:
1445 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1446 include/assert.inc [There should be 1 warning(s)]
1447 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1448 include/assert.inc [There should be 0 warning(s)]
1449 include/assert.inc [Only two events should exist in the binary log]
1450 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1451 Warnings:
1452 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1453 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1454 Warnings:
1455 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1456 DROP PREPARE prep_2;
1457 DROP VIEW view_retval_1;
1458
1459 Invoking prepared statement prep_1 invoking unsafe SELECT...LIMIT statement.
1460 PREPARE prep_1 FROM "INSERT INTO t0 SELECT * FROM data_table LIMIT 1";
1461 * binlog_format = STATEMENT: expect 1 warnings.
1462 EXECUTE prep_1;
1463 Warnings:
1464 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1465 include/assert.inc [There should be 1 warning(s)]
1466 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1467 include/assert.inc [There should be 0 warning(s)]
1468 include/assert.inc [Only two events should exist in the binary log]
1469 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1470 Warnings:
1471 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1472 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1473 Warnings:
1474 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1475 DROP PREPARE prep_1;
1476
1477 Invoking unsafe SELECT...LIMIT statement.
1478 * binlog_format = STATEMENT: expect 1 warnings.
1479 INSERT INTO t0 SELECT * FROM data_table LIMIT 1;
1480 Warnings:
1481 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1482 include/assert.inc [There should be 1 warning(s)]
1483 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1484 include/assert.inc [There should be 0 warning(s)]
1485 include/assert.inc [Only two events should exist in the binary log]
1486 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1487 Warnings:
1488 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1489 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
1490 Warnings:
1491 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1492 * Invoke statement so that return value is discarded: expect no warning.
1493 SELECT * FROM data_table LIMIT 1;
1494
1495 ==== Testing unsafeness of insert of two autoinc values ====
1496
1497 Invoking function func_sidef_1 invoking unsafe update of two autoinc columns.
1498 CREATE FUNCTION func_sidef_1() RETURNS VARCHAR(100) BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO double_autoinc_table VALUES (NULL); RETURN 0; END;
1499 * binlog_format = STATEMENT: expect 1 warnings.
1500 INSERT INTO t1 SELECT func_sidef_1();
1501 Warnings:
1502 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1503 include/assert.inc [There should be 1 warning(s)]
1504 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1505 include/assert.inc [There should be 0 warning(s)]
1506 include/assert.inc [Only two events should exist in the binary log]
1507 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1508 Warnings:
1509 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1510 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1511 Warnings:
1512 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1513
1514 Invoking function func_sidef_2 invoking function func_sidef_1 invoking unsafe update of two autoinc columns.
1515 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); RETURN 0; END;
1516 * binlog_format = STATEMENT: expect 1 warnings.
1517 INSERT INTO t2 SELECT func_sidef_2();
1518 Warnings:
1519 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1520 include/assert.inc [There should be 1 warning(s)]
1521 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1522 include/assert.inc [There should be 0 warning(s)]
1523 include/assert.inc [Only two events should exist in the binary log]
1524 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1525 Warnings:
1526 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1527 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1528 Warnings:
1529 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1530 DROP FUNCTION func_sidef_2;
1531
1532 Invoking procedure proc_2 invoking function func_sidef_1 invoking unsafe update of two autoinc columns.
1533 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 SELECT func_sidef_1(); INSERT INTO ta2 VALUES (47); END;
1534 * binlog_format = STATEMENT: expect 1 warnings.
1535 CALL proc_2();
1536 Warnings:
1537 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1538 include/assert.inc [There should be 1 warning(s)]
1539 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1540 include/assert.inc [There should be 0 warning(s)]
1541 include/assert.inc [Only two events should exist in the binary log]
1542 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1543 Warnings:
1544 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1545 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1546 Warnings:
1547 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1548 DROP PROCEDURE proc_2;
1549
1550 Invoking trigger trig_2 invoking function func_sidef_1 invoking unsafe update of two autoinc columns.
1551 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); END;
1552 * binlog_format = STATEMENT: expect 1 warnings.
1553 INSERT INTO trigger_table_2 VALUES (1);
1554 Warnings:
1555 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1556 include/assert.inc [There should be 1 warning(s)]
1557 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1558 include/assert.inc [There should be 0 warning(s)]
1559 include/assert.inc [Only two events should exist in the binary log]
1560 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1561 Warnings:
1562 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1563 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1564 Warnings:
1565 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1566 DROP TRIGGER trig_2;
1567
1568 Invoking view view_sidef_2 invoking function func_sidef_1 invoking unsafe update of two autoinc columns.
1569 CREATE VIEW view_sidef_2 AS SELECT func_sidef_1();
1570 * binlog_format = STATEMENT: expect 1 warnings.
1571 INSERT INTO t2 SELECT * FROM view_sidef_2;
1572 Warnings:
1573 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1574 include/assert.inc [There should be 1 warning(s)]
1575 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1576 include/assert.inc [There should be 0 warning(s)]
1577 include/assert.inc [Only two events should exist in the binary log]
1578 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1579 Warnings:
1580 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1581 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1582 Warnings:
1583 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1584 DROP VIEW view_sidef_2;
1585
1586 Invoking prepared statement prep_2 invoking function func_sidef_1 invoking unsafe update of two autoinc columns.
1587 PREPARE prep_2 FROM "INSERT INTO t1 SELECT func_sidef_1()";
1588 * binlog_format = STATEMENT: expect 1 warnings.
1589 EXECUTE prep_2;
1590 Warnings:
1591 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1592 include/assert.inc [There should be 1 warning(s)]
1593 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1594 include/assert.inc [There should be 0 warning(s)]
1595 include/assert.inc [Only two events should exist in the binary log]
1596 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1597 Warnings:
1598 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1599 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1600 Warnings:
1601 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1602 DROP PREPARE prep_2;
1603 DROP FUNCTION func_sidef_1;
1604
1605 Invoking procedure proc_1 invoking unsafe update of two autoinc columns.
1606 CREATE PROCEDURE proc_1() BEGIN INSERT INTO double_autoinc_table VALUES (NULL); INSERT INTO ta1 VALUES (47); END;
1607 * binlog_format = STATEMENT: expect 1 warnings.
1608 CALL proc_1();
1609 Warnings:
1610 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1611 include/assert.inc [There should be 1 warning(s)]
1612 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1613 include/assert.inc [There should be 0 warning(s)]
1614 include/assert.inc [Only two events should exist in the binary log]
1615 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1616 Warnings:
1617 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1618 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1619 Warnings:
1620 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1621
1622 Invoking function func_sidef_2 invoking procedure proc_1 invoking unsafe update of two autoinc columns.
1623 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); RETURN 0; END;
1624 * binlog_format = STATEMENT: expect 1 warnings.
1625 INSERT INTO t2 SELECT func_sidef_2();
1626 Warnings:
1627 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1628 include/assert.inc [There should be 1 warning(s)]
1629 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1630 include/assert.inc [There should be 0 warning(s)]
1631 include/assert.inc [Only two events should exist in the binary log]
1632 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1633 Warnings:
1634 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1635 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1636 Warnings:
1637 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1638 DROP FUNCTION func_sidef_2;
1639
1640 Invoking procedure proc_2 invoking procedure proc_1 invoking unsafe update of two autoinc columns.
1641 CREATE PROCEDURE proc_2() BEGIN CALL proc_1(); INSERT INTO ta2 VALUES (47); END;
1642 * binlog_format = STATEMENT: expect 1 warnings.
1643 CALL proc_2();
1644 Warnings:
1645 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1646 include/assert.inc [There should be 1 warning(s)]
1647 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1648 include/assert.inc [There should be 0 warning(s)]
1649 include/assert.inc [Only two events should exist in the binary log]
1650 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1651 Warnings:
1652 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1653 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1654 Warnings:
1655 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1656 DROP PROCEDURE proc_2;
1657
1658 Invoking trigger trig_2 invoking procedure proc_1 invoking unsafe update of two autoinc columns.
1659 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); END;
1660 * binlog_format = STATEMENT: expect 1 warnings.
1661 INSERT INTO trigger_table_2 VALUES (1);
1662 Warnings:
1663 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1664 include/assert.inc [There should be 1 warning(s)]
1665 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1666 include/assert.inc [There should be 0 warning(s)]
1667 include/assert.inc [Only two events should exist in the binary log]
1668 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1669 Warnings:
1670 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1671 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1672 Warnings:
1673 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1674 DROP TRIGGER trig_2;
1675
1676 Invoking prepared statement prep_2 invoking procedure proc_1 invoking unsafe update of two autoinc columns.
1677 PREPARE prep_2 FROM "CALL proc_1()";
1678 * binlog_format = STATEMENT: expect 1 warnings.
1679 EXECUTE prep_2;
1680 Warnings:
1681 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1682 include/assert.inc [There should be 1 warning(s)]
1683 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1684 include/assert.inc [There should be 0 warning(s)]
1685 include/assert.inc [Only two events should exist in the binary log]
1686 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1687 Warnings:
1688 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1689 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1690 Warnings:
1691 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1692 DROP PREPARE prep_2;
1693 DROP PROCEDURE proc_1;
1694
1695 Invoking trigger trig_1 invoking unsafe update of two autoinc columns.
1696 CREATE TRIGGER trig_1 BEFORE INSERT ON trigger_table_1 FOR EACH ROW BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO double_autoinc_table VALUES (NULL); END;
1697 * binlog_format = STATEMENT: expect 1 warnings.
1698 INSERT INTO trigger_table_1 VALUES (1);
1699 Warnings:
1700 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1701 include/assert.inc [There should be 1 warning(s)]
1702 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1703 include/assert.inc [There should be 0 warning(s)]
1704 include/assert.inc [Only two events should exist in the binary log]
1705 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1706 Warnings:
1707 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1708 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1709 Warnings:
1710 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1711
1712 Invoking function func_sidef_2 invoking trigger trig_1 invoking unsafe update of two autoinc columns.
1713 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); RETURN 0; END;
1714 * binlog_format = STATEMENT: expect 1 warnings.
1715 INSERT INTO t2 SELECT func_sidef_2();
1716 Warnings:
1717 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1718 include/assert.inc [There should be 1 warning(s)]
1719 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1720 include/assert.inc [There should be 0 warning(s)]
1721 include/assert.inc [Only two events should exist in the binary log]
1722 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1723 Warnings:
1724 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1725 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1726 Warnings:
1727 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1728 DROP FUNCTION func_sidef_2;
1729
1730 Invoking procedure proc_2 invoking trigger trig_1 invoking unsafe update of two autoinc columns.
1731 CREATE PROCEDURE proc_2() BEGIN INSERT INTO trigger_table_1 VALUES (1); INSERT INTO ta2 VALUES (47); END;
1732 * binlog_format = STATEMENT: expect 1 warnings.
1733 CALL proc_2();
1734 Warnings:
1735 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1736 include/assert.inc [There should be 1 warning(s)]
1737 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1738 include/assert.inc [There should be 0 warning(s)]
1739 include/assert.inc [Only two events should exist in the binary log]
1740 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1741 Warnings:
1742 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1743 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1744 Warnings:
1745 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1746 DROP PROCEDURE proc_2;
1747
1748 Invoking trigger trig_2 invoking trigger trig_1 invoking unsafe update of two autoinc columns.
1749 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); END;
1750 * binlog_format = STATEMENT: expect 1 warnings.
1751 INSERT INTO trigger_table_2 VALUES (1);
1752 Warnings:
1753 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1754 include/assert.inc [There should be 1 warning(s)]
1755 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1756 include/assert.inc [There should be 0 warning(s)]
1757 include/assert.inc [Only two events should exist in the binary log]
1758 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1759 Warnings:
1760 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1761 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1762 Warnings:
1763 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1764 DROP TRIGGER trig_2;
1765
1766 Invoking prepared statement prep_2 invoking trigger trig_1 invoking unsafe update of two autoinc columns.
1767 PREPARE prep_2 FROM "INSERT INTO trigger_table_1 VALUES (1)";
1768 * binlog_format = STATEMENT: expect 1 warnings.
1769 EXECUTE prep_2;
1770 Warnings:
1771 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1772 include/assert.inc [There should be 1 warning(s)]
1773 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1774 include/assert.inc [There should be 0 warning(s)]
1775 include/assert.inc [Only two events should exist in the binary log]
1776 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1777 Warnings:
1778 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1779 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1780 Warnings:
1781 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1782 DROP PREPARE prep_2;
1783 DROP TRIGGER trig_1;
1784
1785 Invoking prepared statement prep_1 invoking unsafe update of two autoinc columns.
1786 PREPARE prep_1 FROM "INSERT INTO double_autoinc_table VALUES (NULL)";
1787 * binlog_format = STATEMENT: expect 1 warnings.
1788 EXECUTE prep_1;
1789 Warnings:
1790 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1791 include/assert.inc [There should be 1 warning(s)]
1792 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1793 include/assert.inc [There should be 0 warning(s)]
1794 include/assert.inc [Only two events should exist in the binary log]
1795 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1796 Warnings:
1797 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1798 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1799 Warnings:
1800 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1801 DROP PREPARE prep_1;
1802
1803 Invoking unsafe update of two autoinc columns.
1804 * binlog_format = STATEMENT: expect 1 warnings.
1805 INSERT INTO double_autoinc_table VALUES (NULL);
1806 Warnings:
1807 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1808 include/assert.inc [There should be 1 warning(s)]
1809 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1810 include/assert.inc [There should be 0 warning(s)]
1811 include/assert.inc [Only two events should exist in the binary log]
1812 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1813 Warnings:
1814 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1815 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.
1816 Warnings:
1817 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1818
1819 ==== Testing unsafeness of UDF's ====
1820
1821 Invoking function func_retval_1 returning value from unsafe UDF.
1822 CREATE FUNCTION func_retval_1() RETURNS VARCHAR(100) BEGIN INSERT INTO ta1 VALUES (47); RETURN myfunc_int(10); END;
1823 * binlog_format = STATEMENT: expect 1 warnings.
1824 INSERT INTO t1 VALUES (func_retval_1());
1825 Warnings:
1826 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1827 include/assert.inc [There should be 1 warning(s)]
1828 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1829 include/assert.inc [There should be 0 warning(s)]
1830 include/assert.inc [Only two events should exist in the binary log]
1831 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1832 Warnings:
1833 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1834 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1835 Warnings:
1836 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1837 * Invoke statement so that return value is discarded: expect no warning.
1838 SELECT func_retval_1();
1839
1840 Invoking function func_retval_2 returning value from function func_retval_1 returning value from unsafe UDF.
1841 CREATE FUNCTION func_retval_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); RETURN func_retval_1(); END;
1842 * binlog_format = STATEMENT: expect 1 warnings.
1843 INSERT INTO t2 VALUES (func_retval_2());
1844 Warnings:
1845 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1846 include/assert.inc [There should be 1 warning(s)]
1847 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1848 include/assert.inc [There should be 0 warning(s)]
1849 include/assert.inc [Only two events should exist in the binary log]
1850 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1851 Warnings:
1852 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1853 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1854 Warnings:
1855 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1856 * Invoke statement so that return value is discarded: expect no warning.
1857 SELECT func_retval_2();
1858 DROP FUNCTION func_retval_2;
1859
1860 Invoking function func_sidef_2 invoking function func_retval_1 returning value from unsafe UDF.
1861 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 VALUES (func_retval_1()); RETURN 0; END;
1862 * binlog_format = STATEMENT: expect 1 warnings.
1863 INSERT INTO t2 SELECT func_sidef_2();
1864 Warnings:
1865 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1866 include/assert.inc [There should be 1 warning(s)]
1867 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1868 include/assert.inc [There should be 0 warning(s)]
1869 include/assert.inc [Only two events should exist in the binary log]
1870 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1871 Warnings:
1872 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1873 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1874 Warnings:
1875 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1876 DROP FUNCTION func_sidef_2;
1877
1878 Invoking procedure proc_2 invoking function func_retval_1 returning value from unsafe UDF.
1879 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 VALUES (func_retval_1()); INSERT INTO ta2 VALUES (47); END;
1880 * binlog_format = STATEMENT: expect 1 warnings.
1881 CALL proc_2();
1882 Warnings:
1883 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1884 include/assert.inc [There should be 1 warning(s)]
1885 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1886 include/assert.inc [There should be 0 warning(s)]
1887 include/assert.inc [Only two events should exist in the binary log]
1888 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1889 Warnings:
1890 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1891 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1892 Warnings:
1893 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1894 DROP PROCEDURE proc_2;
1895
1896 Invoking trigger trig_2 invoking function func_retval_1 returning value from unsafe UDF.
1897 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 VALUES (func_retval_1()); END;
1898 * binlog_format = STATEMENT: expect 1 warnings.
1899 INSERT INTO trigger_table_2 VALUES (1);
1900 Warnings:
1901 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1902 include/assert.inc [There should be 1 warning(s)]
1903 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1904 include/assert.inc [There should be 0 warning(s)]
1905 include/assert.inc [Only two events should exist in the binary log]
1906 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1907 Warnings:
1908 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1909 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1910 Warnings:
1911 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1912 DROP TRIGGER trig_2;
1913
1914 Invoking view view_retval_2 returning value from function func_retval_1 returning value from unsafe UDF.
1915 CREATE VIEW view_retval_2 AS SELECT func_retval_1();
1916 * binlog_format = STATEMENT: expect 1 warnings.
1917 INSERT INTO t2 SELECT * FROM view_retval_2;
1918 Warnings:
1919 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1920 include/assert.inc [There should be 1 warning(s)]
1921 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1922 include/assert.inc [There should be 0 warning(s)]
1923 include/assert.inc [Only two events should exist in the binary log]
1924 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1925 Warnings:
1926 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1927 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1928 Warnings:
1929 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1930 * Invoke statement so that return value is discarded: expect no warning.
1931 SELECT * FROM view_retval_2;
1932 DROP VIEW view_retval_2;
1933
1934 Invoking prepared statement prep_2 invoking function func_retval_1 returning value from unsafe UDF.
1935 PREPARE prep_2 FROM "INSERT INTO t1 VALUES (func_retval_1())";
1936 * binlog_format = STATEMENT: expect 1 warnings.
1937 EXECUTE prep_2;
1938 Warnings:
1939 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1940 include/assert.inc [There should be 1 warning(s)]
1941 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1942 include/assert.inc [There should be 0 warning(s)]
1943 include/assert.inc [Only two events should exist in the binary log]
1944 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1945 Warnings:
1946 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1947 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1948 Warnings:
1949 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1950 DROP PREPARE prep_2;
1951 DROP FUNCTION func_retval_1;
1952
1953 Invoking function func_sidef_1 invoking unsafe UDF.
1954 CREATE FUNCTION func_sidef_1() RETURNS VARCHAR(100) BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO t0 VALUES (myfunc_int(10)); RETURN 0; END;
1955 * binlog_format = STATEMENT: expect 1 warnings.
1956 INSERT INTO t1 SELECT func_sidef_1();
1957 Warnings:
1958 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1959 include/assert.inc [There should be 1 warning(s)]
1960 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1961 include/assert.inc [There should be 0 warning(s)]
1962 include/assert.inc [Only two events should exist in the binary log]
1963 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1964 Warnings:
1965 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1966 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1967 Warnings:
1968 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1969
1970 Invoking function func_sidef_2 invoking function func_sidef_1 invoking unsafe UDF.
1971 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); RETURN 0; END;
1972 * binlog_format = STATEMENT: expect 1 warnings.
1973 INSERT INTO t2 SELECT func_sidef_2();
1974 Warnings:
1975 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1976 include/assert.inc [There should be 1 warning(s)]
1977 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1978 include/assert.inc [There should be 0 warning(s)]
1979 include/assert.inc [Only two events should exist in the binary log]
1980 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1981 Warnings:
1982 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1983 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1984 Warnings:
1985 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1986 DROP FUNCTION func_sidef_2;
1987
1988 Invoking procedure proc_2 invoking function func_sidef_1 invoking unsafe UDF.
1989 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 SELECT func_sidef_1(); INSERT INTO ta2 VALUES (47); END;
1990 * binlog_format = STATEMENT: expect 1 warnings.
1991 CALL proc_2();
1992 Warnings:
1993 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
1994 include/assert.inc [There should be 1 warning(s)]
1995 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
1996 include/assert.inc [There should be 0 warning(s)]
1997 include/assert.inc [Only two events should exist in the binary log]
1998 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
1999 Warnings:
2000 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2001 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2002 Warnings:
2003 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2004 DROP PROCEDURE proc_2;
2005
2006 Invoking trigger trig_2 invoking function func_sidef_1 invoking unsafe UDF.
2007 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); END;
2008 * binlog_format = STATEMENT: expect 1 warnings.
2009 INSERT INTO trigger_table_2 VALUES (1);
2010 Warnings:
2011 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2012 include/assert.inc [There should be 1 warning(s)]
2013 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2014 include/assert.inc [There should be 0 warning(s)]
2015 include/assert.inc [Only two events should exist in the binary log]
2016 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2017 Warnings:
2018 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2019 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2020 Warnings:
2021 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2022 DROP TRIGGER trig_2;
2023
2024 Invoking view view_sidef_2 invoking function func_sidef_1 invoking unsafe UDF.
2025 CREATE VIEW view_sidef_2 AS SELECT func_sidef_1();
2026 * binlog_format = STATEMENT: expect 1 warnings.
2027 INSERT INTO t2 SELECT * FROM view_sidef_2;
2028 Warnings:
2029 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2030 include/assert.inc [There should be 1 warning(s)]
2031 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2032 include/assert.inc [There should be 0 warning(s)]
2033 include/assert.inc [Only two events should exist in the binary log]
2034 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2035 Warnings:
2036 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2037 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2038 Warnings:
2039 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2040 DROP VIEW view_sidef_2;
2041
2042 Invoking prepared statement prep_2 invoking function func_sidef_1 invoking unsafe UDF.
2043 PREPARE prep_2 FROM "INSERT INTO t1 SELECT func_sidef_1()";
2044 * binlog_format = STATEMENT: expect 1 warnings.
2045 EXECUTE prep_2;
2046 Warnings:
2047 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2048 include/assert.inc [There should be 1 warning(s)]
2049 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2050 include/assert.inc [There should be 0 warning(s)]
2051 include/assert.inc [Only two events should exist in the binary log]
2052 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2053 Warnings:
2054 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2055 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2056 Warnings:
2057 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2058 DROP PREPARE prep_2;
2059 DROP FUNCTION func_sidef_1;
2060
2061 Invoking procedure proc_1 invoking unsafe UDF.
2062 CREATE PROCEDURE proc_1() BEGIN INSERT INTO t0 VALUES (myfunc_int(10)); INSERT INTO ta1 VALUES (47); END;
2063 * binlog_format = STATEMENT: expect 1 warnings.
2064 CALL proc_1();
2065 Warnings:
2066 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2067 include/assert.inc [There should be 1 warning(s)]
2068 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2069 include/assert.inc [There should be 0 warning(s)]
2070 include/assert.inc [Only two events should exist in the binary log]
2071 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2072 Warnings:
2073 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2074 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2075 Warnings:
2076 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2077
2078 Invoking function func_sidef_2 invoking procedure proc_1 invoking unsafe UDF.
2079 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); RETURN 0; END;
2080 * binlog_format = STATEMENT: expect 1 warnings.
2081 INSERT INTO t2 SELECT func_sidef_2();
2082 Warnings:
2083 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2084 include/assert.inc [There should be 1 warning(s)]
2085 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2086 include/assert.inc [There should be 0 warning(s)]
2087 include/assert.inc [Only two events should exist in the binary log]
2088 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2089 Warnings:
2090 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2091 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2092 Warnings:
2093 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2094 DROP FUNCTION func_sidef_2;
2095
2096 Invoking procedure proc_2 invoking procedure proc_1 invoking unsafe UDF.
2097 CREATE PROCEDURE proc_2() BEGIN CALL proc_1(); INSERT INTO ta2 VALUES (47); END;
2098 * binlog_format = STATEMENT: expect 1 warnings.
2099 CALL proc_2();
2100 Warnings:
2101 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2102 include/assert.inc [There should be 1 warning(s)]
2103 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2104 include/assert.inc [There should be 0 warning(s)]
2105 include/assert.inc [Only two events should exist in the binary log]
2106 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2107 Warnings:
2108 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2109 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2110 Warnings:
2111 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2112 DROP PROCEDURE proc_2;
2113
2114 Invoking trigger trig_2 invoking procedure proc_1 invoking unsafe UDF.
2115 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); END;
2116 * binlog_format = STATEMENT: expect 1 warnings.
2117 INSERT INTO trigger_table_2 VALUES (1);
2118 Warnings:
2119 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2120 include/assert.inc [There should be 1 warning(s)]
2121 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2122 include/assert.inc [There should be 0 warning(s)]
2123 include/assert.inc [Only two events should exist in the binary log]
2124 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2125 Warnings:
2126 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2127 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2128 Warnings:
2129 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2130 DROP TRIGGER trig_2;
2131
2132 Invoking prepared statement prep_2 invoking procedure proc_1 invoking unsafe UDF.
2133 PREPARE prep_2 FROM "CALL proc_1()";
2134 * binlog_format = STATEMENT: expect 1 warnings.
2135 EXECUTE prep_2;
2136 Warnings:
2137 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2138 include/assert.inc [There should be 1 warning(s)]
2139 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2140 include/assert.inc [There should be 0 warning(s)]
2141 include/assert.inc [Only two events should exist in the binary log]
2142 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2143 Warnings:
2144 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2145 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2146 Warnings:
2147 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2148 DROP PREPARE prep_2;
2149 DROP PROCEDURE proc_1;
2150
2151 Invoking trigger trig_1 invoking unsafe UDF.
2152 CREATE TRIGGER trig_1 BEFORE INSERT ON trigger_table_1 FOR EACH ROW BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO t0 VALUES (myfunc_int(10)); END;
2153 * binlog_format = STATEMENT: expect 1 warnings.
2154 INSERT INTO trigger_table_1 VALUES (1);
2155 Warnings:
2156 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2157 include/assert.inc [There should be 1 warning(s)]
2158 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2159 include/assert.inc [There should be 0 warning(s)]
2160 include/assert.inc [Only two events should exist in the binary log]
2161 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2162 Warnings:
2163 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2164 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2165 Warnings:
2166 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2167
2168 Invoking function func_sidef_2 invoking trigger trig_1 invoking unsafe UDF.
2169 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); RETURN 0; END;
2170 * binlog_format = STATEMENT: expect 1 warnings.
2171 INSERT INTO t2 SELECT func_sidef_2();
2172 Warnings:
2173 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2174 include/assert.inc [There should be 1 warning(s)]
2175 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2176 include/assert.inc [There should be 0 warning(s)]
2177 include/assert.inc [Only two events should exist in the binary log]
2178 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2179 Warnings:
2180 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2181 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2182 Warnings:
2183 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2184 DROP FUNCTION func_sidef_2;
2185
2186 Invoking procedure proc_2 invoking trigger trig_1 invoking unsafe UDF.
2187 CREATE PROCEDURE proc_2() BEGIN INSERT INTO trigger_table_1 VALUES (1); INSERT INTO ta2 VALUES (47); END;
2188 * binlog_format = STATEMENT: expect 1 warnings.
2189 CALL proc_2();
2190 Warnings:
2191 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2192 include/assert.inc [There should be 1 warning(s)]
2193 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2194 include/assert.inc [There should be 0 warning(s)]
2195 include/assert.inc [Only two events should exist in the binary log]
2196 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2197 Warnings:
2198 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2199 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2200 Warnings:
2201 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2202 DROP PROCEDURE proc_2;
2203
2204 Invoking trigger trig_2 invoking trigger trig_1 invoking unsafe UDF.
2205 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); END;
2206 * binlog_format = STATEMENT: expect 1 warnings.
2207 INSERT INTO trigger_table_2 VALUES (1);
2208 Warnings:
2209 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2210 include/assert.inc [There should be 1 warning(s)]
2211 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2212 include/assert.inc [There should be 0 warning(s)]
2213 include/assert.inc [Only two events should exist in the binary log]
2214 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2215 Warnings:
2216 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2217 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2218 Warnings:
2219 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2220 DROP TRIGGER trig_2;
2221
2222 Invoking prepared statement prep_2 invoking trigger trig_1 invoking unsafe UDF.
2223 PREPARE prep_2 FROM "INSERT INTO trigger_table_1 VALUES (1)";
2224 * binlog_format = STATEMENT: expect 1 warnings.
2225 EXECUTE prep_2;
2226 Warnings:
2227 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2228 include/assert.inc [There should be 1 warning(s)]
2229 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2230 include/assert.inc [There should be 0 warning(s)]
2231 include/assert.inc [Only two events should exist in the binary log]
2232 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2233 Warnings:
2234 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2235 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2236 Warnings:
2237 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2238 DROP PREPARE prep_2;
2239 DROP TRIGGER trig_1;
2240
2241 Invoking view view_sidef_1 invoking unsafe UDF.
2242 CREATE VIEW view_sidef_1 AS SELECT myfunc_int(10);
2243 * binlog_format = STATEMENT: expect 1 warnings.
2244 INSERT INTO t1 SELECT * FROM view_sidef_1;
2245 Warnings:
2246 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2247 include/assert.inc [There should be 1 warning(s)]
2248 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2249 include/assert.inc [There should be 0 warning(s)]
2250 include/assert.inc [Only two events should exist in the binary log]
2251 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2252 Warnings:
2253 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2254 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2255 Warnings:
2256 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2257
2258 Invoking function func_sidef_2 invoking view view_sidef_1 invoking unsafe UDF.
2259 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT * FROM view_sidef_1; RETURN 0; END;
2260 * binlog_format = STATEMENT: expect 1 warnings.
2261 INSERT INTO t2 SELECT func_sidef_2();
2262 Warnings:
2263 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2264 include/assert.inc [There should be 1 warning(s)]
2265 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2266 include/assert.inc [There should be 0 warning(s)]
2267 include/assert.inc [Only two events should exist in the binary log]
2268 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2269 Warnings:
2270 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2271 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2272 Warnings:
2273 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2274 DROP FUNCTION func_sidef_2;
2275
2276 Invoking procedure proc_2 invoking view view_sidef_1 invoking unsafe UDF.
2277 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 SELECT * FROM view_sidef_1; INSERT INTO ta2 VALUES (47); END;
2278 * binlog_format = STATEMENT: expect 1 warnings.
2279 CALL proc_2();
2280 Warnings:
2281 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2282 include/assert.inc [There should be 1 warning(s)]
2283 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2284 include/assert.inc [There should be 0 warning(s)]
2285 include/assert.inc [Only two events should exist in the binary log]
2286 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2287 Warnings:
2288 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2289 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2290 Warnings:
2291 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2292 DROP PROCEDURE proc_2;
2293
2294 Invoking trigger trig_2 invoking view view_sidef_1 invoking unsafe UDF.
2295 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT * FROM view_sidef_1; END;
2296 * binlog_format = STATEMENT: expect 1 warnings.
2297 INSERT INTO trigger_table_2 VALUES (1);
2298 Warnings:
2299 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2300 include/assert.inc [There should be 1 warning(s)]
2301 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2302 include/assert.inc [There should be 0 warning(s)]
2303 include/assert.inc [Only two events should exist in the binary log]
2304 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2305 Warnings:
2306 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2307 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2308 Warnings:
2309 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2310 DROP TRIGGER trig_2;
2311
2312 Invoking view view_sidef_2 invoking view view_sidef_1 invoking unsafe UDF.
2313 CREATE VIEW view_sidef_2 AS SELECT * FROM view_sidef_1;
2314 * binlog_format = STATEMENT: expect 1 warnings.
2315 INSERT INTO t2 SELECT * FROM view_sidef_2;
2316 Warnings:
2317 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2318 include/assert.inc [There should be 1 warning(s)]
2319 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2320 include/assert.inc [There should be 0 warning(s)]
2321 include/assert.inc [Only two events should exist in the binary log]
2322 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2323 Warnings:
2324 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2325 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2326 Warnings:
2327 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2328 DROP VIEW view_sidef_2;
2329
2330 Invoking prepared statement prep_2 invoking view view_sidef_1 invoking unsafe UDF.
2331 PREPARE prep_2 FROM "INSERT INTO t1 SELECT * FROM view_sidef_1";
2332 * binlog_format = STATEMENT: expect 1 warnings.
2333 EXECUTE prep_2;
2334 Warnings:
2335 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2336 include/assert.inc [There should be 1 warning(s)]
2337 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2338 include/assert.inc [There should be 0 warning(s)]
2339 include/assert.inc [Only two events should exist in the binary log]
2340 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2341 Warnings:
2342 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2343 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2344 Warnings:
2345 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2346 DROP PREPARE prep_2;
2347 DROP VIEW view_sidef_1;
2348
2349 Invoking prepared statement prep_1 invoking unsafe UDF.
2350 PREPARE prep_1 FROM "INSERT INTO t0 VALUES (myfunc_int(10))";
2351 * binlog_format = STATEMENT: expect 1 warnings.
2352 EXECUTE prep_1;
2353 Warnings:
2354 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2355 include/assert.inc [There should be 1 warning(s)]
2356 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2357 include/assert.inc [There should be 0 warning(s)]
2358 include/assert.inc [Only two events should exist in the binary log]
2359 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2360 Warnings:
2361 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2362 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2363 Warnings:
2364 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2365 DROP PREPARE prep_1;
2366
2367 Invoking unsafe UDF.
2368 * binlog_format = STATEMENT: expect 1 warnings.
2369 INSERT INTO t0 VALUES (myfunc_int(10));
2370 Warnings:
2371 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2372 include/assert.inc [There should be 1 warning(s)]
2373 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2374 include/assert.inc [There should be 0 warning(s)]
2375 include/assert.inc [Only two events should exist in the binary log]
2376 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2377 Warnings:
2378 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2379 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a UDF which may not return the same value on the replica.
2380 Warnings:
2381 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2382
2383 ==== Testing unsafeness of access to mysql.general_log ====
2384
2385 Invoking function func_sidef_1 invoking unsafe use of mysql.general_log.
2386 CREATE FUNCTION func_sidef_1() RETURNS VARCHAR(100) BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO t0 SELECT COUNT(*) FROM mysql.general_log; RETURN 0; END;
2387 * binlog_format = STATEMENT: expect 1 warnings.
2388 INSERT INTO t1 SELECT func_sidef_1();
2389 Warnings:
2390 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2391 include/assert.inc [There should be 1 warning(s)]
2392 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2393 include/assert.inc [There should be 0 warning(s)]
2394 include/assert.inc [Only two events should exist in the binary log]
2395 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2396 Warnings:
2397 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2398 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2399 Warnings:
2400 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2401
2402 Invoking function func_sidef_2 invoking function func_sidef_1 invoking unsafe use of mysql.general_log.
2403 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); RETURN 0; END;
2404 * binlog_format = STATEMENT: expect 1 warnings.
2405 INSERT INTO t2 SELECT func_sidef_2();
2406 Warnings:
2407 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2408 include/assert.inc [There should be 1 warning(s)]
2409 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2410 include/assert.inc [There should be 0 warning(s)]
2411 include/assert.inc [Only two events should exist in the binary log]
2412 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2413 Warnings:
2414 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2415 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2416 Warnings:
2417 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2418 DROP FUNCTION func_sidef_2;
2419
2420 Invoking procedure proc_2 invoking function func_sidef_1 invoking unsafe use of mysql.general_log.
2421 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 SELECT func_sidef_1(); INSERT INTO ta2 VALUES (47); END;
2422 * binlog_format = STATEMENT: expect 1 warnings.
2423 CALL proc_2();
2424 Warnings:
2425 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2426 include/assert.inc [There should be 1 warning(s)]
2427 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2428 include/assert.inc [There should be 0 warning(s)]
2429 include/assert.inc [Only two events should exist in the binary log]
2430 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2431 Warnings:
2432 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2433 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2434 Warnings:
2435 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2436 DROP PROCEDURE proc_2;
2437
2438 Invoking trigger trig_2 invoking function func_sidef_1 invoking unsafe use of mysql.general_log.
2439 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); END;
2440 * binlog_format = STATEMENT: expect 1 warnings.
2441 INSERT INTO trigger_table_2 VALUES (1);
2442 Warnings:
2443 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2444 include/assert.inc [There should be 1 warning(s)]
2445 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2446 include/assert.inc [There should be 0 warning(s)]
2447 include/assert.inc [Only two events should exist in the binary log]
2448 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2449 Warnings:
2450 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2451 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2452 Warnings:
2453 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2454 DROP TRIGGER trig_2;
2455
2456 Invoking view view_sidef_2 invoking function func_sidef_1 invoking unsafe use of mysql.general_log.
2457 CREATE VIEW view_sidef_2 AS SELECT func_sidef_1();
2458 * binlog_format = STATEMENT: expect 1 warnings.
2459 INSERT INTO t2 SELECT * FROM view_sidef_2;
2460 Warnings:
2461 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2462 include/assert.inc [There should be 1 warning(s)]
2463 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2464 include/assert.inc [There should be 0 warning(s)]
2465 include/assert.inc [Only two events should exist in the binary log]
2466 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2467 Warnings:
2468 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2469 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2470 Warnings:
2471 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2472 DROP VIEW view_sidef_2;
2473
2474 Invoking prepared statement prep_2 invoking function func_sidef_1 invoking unsafe use of mysql.general_log.
2475 PREPARE prep_2 FROM "INSERT INTO t1 SELECT func_sidef_1()";
2476 * binlog_format = STATEMENT: expect 1 warnings.
2477 EXECUTE prep_2;
2478 Warnings:
2479 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2480 include/assert.inc [There should be 1 warning(s)]
2481 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2482 include/assert.inc [There should be 0 warning(s)]
2483 include/assert.inc [Only two events should exist in the binary log]
2484 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2485 Warnings:
2486 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2487 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2488 Warnings:
2489 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2490 DROP PREPARE prep_2;
2491 DROP FUNCTION func_sidef_1;
2492
2493 Invoking procedure proc_1 invoking unsafe use of mysql.general_log.
2494 CREATE PROCEDURE proc_1() BEGIN INSERT INTO t0 SELECT COUNT(*) FROM mysql.general_log; INSERT INTO ta1 VALUES (47); END;
2495 * binlog_format = STATEMENT: expect 1 warnings.
2496 CALL proc_1();
2497 Warnings:
2498 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2499 include/assert.inc [There should be 1 warning(s)]
2500 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2501 include/assert.inc [There should be 0 warning(s)]
2502 include/assert.inc [Only two events should exist in the binary log]
2503 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2504 Warnings:
2505 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2506 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2507 Warnings:
2508 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2509
2510 Invoking function func_sidef_2 invoking procedure proc_1 invoking unsafe use of mysql.general_log.
2511 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); RETURN 0; END;
2512 * binlog_format = STATEMENT: expect 1 warnings.
2513 INSERT INTO t2 SELECT func_sidef_2();
2514 Warnings:
2515 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2516 include/assert.inc [There should be 1 warning(s)]
2517 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2518 include/assert.inc [There should be 0 warning(s)]
2519 include/assert.inc [Only two events should exist in the binary log]
2520 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2521 Warnings:
2522 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2523 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2524 Warnings:
2525 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2526 DROP FUNCTION func_sidef_2;
2527
2528 Invoking procedure proc_2 invoking procedure proc_1 invoking unsafe use of mysql.general_log.
2529 CREATE PROCEDURE proc_2() BEGIN CALL proc_1(); INSERT INTO ta2 VALUES (47); END;
2530 * binlog_format = STATEMENT: expect 1 warnings.
2531 CALL proc_2();
2532 Warnings:
2533 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2534 include/assert.inc [There should be 1 warning(s)]
2535 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2536 include/assert.inc [There should be 0 warning(s)]
2537 include/assert.inc [Only two events should exist in the binary log]
2538 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2539 Warnings:
2540 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2541 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2542 Warnings:
2543 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2544 DROP PROCEDURE proc_2;
2545
2546 Invoking trigger trig_2 invoking procedure proc_1 invoking unsafe use of mysql.general_log.
2547 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); END;
2548 * binlog_format = STATEMENT: expect 1 warnings.
2549 INSERT INTO trigger_table_2 VALUES (1);
2550 Warnings:
2551 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2552 include/assert.inc [There should be 1 warning(s)]
2553 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2554 include/assert.inc [There should be 0 warning(s)]
2555 include/assert.inc [Only two events should exist in the binary log]
2556 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2557 Warnings:
2558 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2559 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2560 Warnings:
2561 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2562 DROP TRIGGER trig_2;
2563
2564 Invoking prepared statement prep_2 invoking procedure proc_1 invoking unsafe use of mysql.general_log.
2565 PREPARE prep_2 FROM "CALL proc_1()";
2566 * binlog_format = STATEMENT: expect 1 warnings.
2567 EXECUTE prep_2;
2568 Warnings:
2569 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2570 include/assert.inc [There should be 1 warning(s)]
2571 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2572 include/assert.inc [There should be 0 warning(s)]
2573 include/assert.inc [Only two events should exist in the binary log]
2574 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2575 Warnings:
2576 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2577 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2578 Warnings:
2579 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2580 DROP PREPARE prep_2;
2581 DROP PROCEDURE proc_1;
2582
2583 Invoking trigger trig_1 invoking unsafe use of mysql.general_log.
2584 CREATE TRIGGER trig_1 BEFORE INSERT ON trigger_table_1 FOR EACH ROW BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO t0 SELECT COUNT(*) FROM mysql.general_log; END;
2585 * binlog_format = STATEMENT: expect 1 warnings.
2586 INSERT INTO trigger_table_1 VALUES (1);
2587 Warnings:
2588 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2589 include/assert.inc [There should be 1 warning(s)]
2590 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2591 include/assert.inc [There should be 0 warning(s)]
2592 include/assert.inc [Only two events should exist in the binary log]
2593 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2594 Warnings:
2595 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2596 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2597 Warnings:
2598 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2599
2600 Invoking function func_sidef_2 invoking trigger trig_1 invoking unsafe use of mysql.general_log.
2601 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); RETURN 0; END;
2602 * binlog_format = STATEMENT: expect 1 warnings.
2603 INSERT INTO t2 SELECT func_sidef_2();
2604 Warnings:
2605 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2606 include/assert.inc [There should be 1 warning(s)]
2607 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2608 include/assert.inc [There should be 0 warning(s)]
2609 include/assert.inc [Only two events should exist in the binary log]
2610 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2611 Warnings:
2612 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2613 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2614 Warnings:
2615 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2616 DROP FUNCTION func_sidef_2;
2617
2618 Invoking procedure proc_2 invoking trigger trig_1 invoking unsafe use of mysql.general_log.
2619 CREATE PROCEDURE proc_2() BEGIN INSERT INTO trigger_table_1 VALUES (1); INSERT INTO ta2 VALUES (47); END;
2620 * binlog_format = STATEMENT: expect 1 warnings.
2621 CALL proc_2();
2622 Warnings:
2623 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2624 include/assert.inc [There should be 1 warning(s)]
2625 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2626 include/assert.inc [There should be 0 warning(s)]
2627 include/assert.inc [Only two events should exist in the binary log]
2628 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2629 Warnings:
2630 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2631 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2632 Warnings:
2633 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2634 DROP PROCEDURE proc_2;
2635
2636 Invoking trigger trig_2 invoking trigger trig_1 invoking unsafe use of mysql.general_log.
2637 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); END;
2638 * binlog_format = STATEMENT: expect 1 warnings.
2639 INSERT INTO trigger_table_2 VALUES (1);
2640 Warnings:
2641 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2642 include/assert.inc [There should be 1 warning(s)]
2643 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2644 include/assert.inc [There should be 0 warning(s)]
2645 include/assert.inc [Only two events should exist in the binary log]
2646 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2647 Warnings:
2648 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2649 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2650 Warnings:
2651 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2652 DROP TRIGGER trig_2;
2653
2654 Invoking prepared statement prep_2 invoking trigger trig_1 invoking unsafe use of mysql.general_log.
2655 PREPARE prep_2 FROM "INSERT INTO trigger_table_1 VALUES (1)";
2656 * binlog_format = STATEMENT: expect 1 warnings.
2657 EXECUTE prep_2;
2658 Warnings:
2659 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2660 include/assert.inc [There should be 1 warning(s)]
2661 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2662 include/assert.inc [There should be 0 warning(s)]
2663 include/assert.inc [Only two events should exist in the binary log]
2664 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2665 Warnings:
2666 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2667 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2668 Warnings:
2669 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2670 DROP PREPARE prep_2;
2671 DROP TRIGGER trig_1;
2672
2673 Invoking view view_retval_1 returning value from unsafe use of mysql.general_log.
2674 CREATE VIEW view_retval_1 AS SELECT COUNT(*) FROM mysql.general_log;
2675 * binlog_format = STATEMENT: expect 1 warnings.
2676 INSERT INTO t1 SELECT * FROM view_retval_1;
2677 Warnings:
2678 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2679 include/assert.inc [There should be 1 warning(s)]
2680 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2681 include/assert.inc [There should be 0 warning(s)]
2682 include/assert.inc [Only two events should exist in the binary log]
2683 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2684 Warnings:
2685 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2686 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2687 Warnings:
2688 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2689 * Invoke statement so that return value is discarded: expect no warning.
2690 SELECT * FROM view_retval_1;
2691
2692 Invoking function func_sidef_2 invoking view view_retval_1 returning value from unsafe use of mysql.general_log.
2693 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT * FROM view_retval_1; RETURN 0; END;
2694 * binlog_format = STATEMENT: expect 1 warnings.
2695 INSERT INTO t2 SELECT func_sidef_2();
2696 Warnings:
2697 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2698 include/assert.inc [There should be 1 warning(s)]
2699 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2700 include/assert.inc [There should be 0 warning(s)]
2701 include/assert.inc [Only two events should exist in the binary log]
2702 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2703 Warnings:
2704 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2705 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2706 Warnings:
2707 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2708 DROP FUNCTION func_sidef_2;
2709
2710 Invoking procedure proc_2 invoking view view_retval_1 returning value from unsafe use of mysql.general_log.
2711 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 SELECT * FROM view_retval_1; INSERT INTO ta2 VALUES (47); END;
2712 * binlog_format = STATEMENT: expect 1 warnings.
2713 CALL proc_2();
2714 Warnings:
2715 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2716 include/assert.inc [There should be 1 warning(s)]
2717 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2718 include/assert.inc [There should be 0 warning(s)]
2719 include/assert.inc [Only two events should exist in the binary log]
2720 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2721 Warnings:
2722 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2723 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2724 Warnings:
2725 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2726 DROP PROCEDURE proc_2;
2727
2728 Invoking trigger trig_2 invoking view view_retval_1 returning value from unsafe use of mysql.general_log.
2729 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT * FROM view_retval_1; END;
2730 * binlog_format = STATEMENT: expect 1 warnings.
2731 INSERT INTO trigger_table_2 VALUES (1);
2732 Warnings:
2733 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2734 include/assert.inc [There should be 1 warning(s)]
2735 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2736 include/assert.inc [There should be 0 warning(s)]
2737 include/assert.inc [Only two events should exist in the binary log]
2738 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2739 Warnings:
2740 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2741 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2742 Warnings:
2743 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2744 DROP TRIGGER trig_2;
2745
2746 Invoking view view_retval_2 returning value from view view_retval_1 returning value from unsafe use of mysql.general_log.
2747 CREATE VIEW view_retval_2 AS SELECT * FROM view_retval_1;
2748 * binlog_format = STATEMENT: expect 1 warnings.
2749 INSERT INTO t2 SELECT * FROM view_retval_2;
2750 Warnings:
2751 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2752 include/assert.inc [There should be 1 warning(s)]
2753 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2754 include/assert.inc [There should be 0 warning(s)]
2755 include/assert.inc [Only two events should exist in the binary log]
2756 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2757 Warnings:
2758 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2759 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2760 Warnings:
2761 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2762 * Invoke statement so that return value is discarded: expect no warning.
2763 SELECT * FROM view_retval_2;
2764 DROP VIEW view_retval_2;
2765
2766 Invoking prepared statement prep_2 invoking view view_retval_1 returning value from unsafe use of mysql.general_log.
2767 PREPARE prep_2 FROM "INSERT INTO t1 SELECT * FROM view_retval_1";
2768 * binlog_format = STATEMENT: expect 1 warnings.
2769 EXECUTE prep_2;
2770 Warnings:
2771 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2772 include/assert.inc [There should be 1 warning(s)]
2773 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2774 include/assert.inc [There should be 0 warning(s)]
2775 include/assert.inc [Only two events should exist in the binary log]
2776 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2777 Warnings:
2778 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2779 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2780 Warnings:
2781 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2782 DROP PREPARE prep_2;
2783 DROP VIEW view_retval_1;
2784
2785 Invoking prepared statement prep_1 invoking unsafe use of mysql.general_log.
2786 PREPARE prep_1 FROM "INSERT INTO t0 SELECT COUNT(*) FROM mysql.general_log";
2787 * binlog_format = STATEMENT: expect 1 warnings.
2788 EXECUTE prep_1;
2789 Warnings:
2790 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2791 include/assert.inc [There should be 1 warning(s)]
2792 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2793 include/assert.inc [There should be 0 warning(s)]
2794 include/assert.inc [Only two events should exist in the binary log]
2795 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2796 Warnings:
2797 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2798 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2799 Warnings:
2800 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2801 DROP PREPARE prep_1;
2802
2803 Invoking unsafe use of mysql.general_log.
2804 * binlog_format = STATEMENT: expect 1 warnings.
2805 INSERT INTO t0 SELECT COUNT(*) FROM mysql.general_log;
2806 Warnings:
2807 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2808 include/assert.inc [There should be 1 warning(s)]
2809 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2810 include/assert.inc [There should be 0 warning(s)]
2811 include/assert.inc [Only two events should exist in the binary log]
2812 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2813 Warnings:
2814 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2815 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on replicas.
2816 Warnings:
2817 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2818 * Invoke statement so that return value is discarded: expect no warning.
2819 SELECT COUNT(*) FROM mysql.general_log;
2820
2821 ==== Testing a statement that is unsafe several times ====
2822
2823 Invoking function func_sidef_1 invoking statement that is unsafe several times.
2824 CREATE FUNCTION func_sidef_1() RETURNS VARCHAR(100) BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO ta0 VALUES (multi_unsafe_func()); RETURN 0; END;
2825 * binlog_format = STATEMENT: expect 2 warnings.
2826 INSERT INTO t1 SELECT func_sidef_1();
2827 Warnings:
2828 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2829 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
2830 include/assert.inc [There should be 2 warning(s)]
2831 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2832 include/assert.inc [There should be 0 warning(s)]
2833 include/assert.inc [Only two events should exist in the binary log]
2834 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2835 Warnings:
2836 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2837 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2838 Warnings:
2839 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2840
2841 Invoking function func_sidef_2 invoking function func_sidef_1 invoking statement that is unsafe several times.
2842 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); RETURN 0; END;
2843 * binlog_format = STATEMENT: expect 2 warnings.
2844 INSERT INTO t2 SELECT func_sidef_2();
2845 Warnings:
2846 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2847 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
2848 include/assert.inc [There should be 2 warning(s)]
2849 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2850 include/assert.inc [There should be 0 warning(s)]
2851 include/assert.inc [Only two events should exist in the binary log]
2852 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2853 Warnings:
2854 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2855 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2856 Warnings:
2857 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2858 DROP FUNCTION func_sidef_2;
2859
2860 Invoking procedure proc_2 invoking function func_sidef_1 invoking statement that is unsafe several times.
2861 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 SELECT func_sidef_1(); INSERT INTO ta2 VALUES (47); END;
2862 * binlog_format = STATEMENT: expect 2 warnings.
2863 CALL proc_2();
2864 Warnings:
2865 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2866 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
2867 include/assert.inc [There should be 2 warning(s)]
2868 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2869 include/assert.inc [There should be 0 warning(s)]
2870 include/assert.inc [Only two events should exist in the binary log]
2871 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2872 Warnings:
2873 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2874 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2875 Warnings:
2876 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2877 DROP PROCEDURE proc_2;
2878
2879 Invoking trigger trig_2 invoking function func_sidef_1 invoking statement that is unsafe several times.
2880 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT func_sidef_1(); END;
2881 * binlog_format = STATEMENT: expect 2 warnings.
2882 INSERT INTO trigger_table_2 VALUES (1);
2883 Warnings:
2884 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2885 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
2886 include/assert.inc [There should be 2 warning(s)]
2887 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2888 include/assert.inc [There should be 0 warning(s)]
2889 include/assert.inc [Only two events should exist in the binary log]
2890 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2891 Warnings:
2892 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2893 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2894 Warnings:
2895 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2896 DROP TRIGGER trig_2;
2897
2898 Invoking view view_sidef_2 invoking function func_sidef_1 invoking statement that is unsafe several times.
2899 CREATE VIEW view_sidef_2 AS SELECT func_sidef_1();
2900 * binlog_format = STATEMENT: expect 2 warnings.
2901 INSERT INTO t2 SELECT * FROM view_sidef_2;
2902 Warnings:
2903 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2904 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
2905 include/assert.inc [There should be 2 warning(s)]
2906 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2907 include/assert.inc [There should be 0 warning(s)]
2908 include/assert.inc [Only two events should exist in the binary log]
2909 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2910 Warnings:
2911 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2912 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2913 Warnings:
2914 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2915 DROP VIEW view_sidef_2;
2916
2917 Invoking prepared statement prep_2 invoking function func_sidef_1 invoking statement that is unsafe several times.
2918 PREPARE prep_2 FROM "INSERT INTO t1 SELECT func_sidef_1()";
2919 * binlog_format = STATEMENT: expect 2 warnings.
2920 EXECUTE prep_2;
2921 Warnings:
2922 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2923 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
2924 include/assert.inc [There should be 2 warning(s)]
2925 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2926 include/assert.inc [There should be 0 warning(s)]
2927 include/assert.inc [Only two events should exist in the binary log]
2928 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2929 Warnings:
2930 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2931 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2932 Warnings:
2933 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2934 DROP PREPARE prep_2;
2935 DROP FUNCTION func_sidef_1;
2936
2937 Invoking procedure proc_1 invoking statement that is unsafe several times.
2938 CREATE PROCEDURE proc_1() BEGIN INSERT INTO ta0 VALUES (multi_unsafe_func()); INSERT INTO ta1 VALUES (47); END;
2939 * binlog_format = STATEMENT: expect 2 warnings.
2940 CALL proc_1();
2941 Warnings:
2942 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2943 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
2944 include/assert.inc [There should be 2 warning(s)]
2945 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2946 include/assert.inc [There should be 0 warning(s)]
2947 include/assert.inc [Only two events should exist in the binary log]
2948 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2949 Warnings:
2950 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2951 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2952 Warnings:
2953 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2954
2955 Invoking function func_sidef_2 invoking procedure proc_1 invoking statement that is unsafe several times.
2956 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); RETURN 0; END;
2957 * binlog_format = STATEMENT: expect 2 warnings.
2958 INSERT INTO t2 SELECT func_sidef_2();
2959 Warnings:
2960 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2961 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
2962 include/assert.inc [There should be 2 warning(s)]
2963 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2964 include/assert.inc [There should be 0 warning(s)]
2965 include/assert.inc [Only two events should exist in the binary log]
2966 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2967 Warnings:
2968 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2969 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2970 Warnings:
2971 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2972 DROP FUNCTION func_sidef_2;
2973
2974 Invoking procedure proc_2 invoking procedure proc_1 invoking statement that is unsafe several times.
2975 CREATE PROCEDURE proc_2() BEGIN CALL proc_1(); INSERT INTO ta2 VALUES (47); END;
2976 * binlog_format = STATEMENT: expect 2 warnings.
2977 CALL proc_2();
2978 Warnings:
2979 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2980 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
2981 include/assert.inc [There should be 2 warning(s)]
2982 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
2983 include/assert.inc [There should be 0 warning(s)]
2984 include/assert.inc [Only two events should exist in the binary log]
2985 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
2986 Warnings:
2987 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2988 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2989 Warnings:
2990 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
2991 DROP PROCEDURE proc_2;
2992
2993 Invoking trigger trig_2 invoking procedure proc_1 invoking statement that is unsafe several times.
2994 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); CALL proc_1(); END;
2995 * binlog_format = STATEMENT: expect 2 warnings.
2996 INSERT INTO trigger_table_2 VALUES (1);
2997 Warnings:
2998 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
2999 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3000 include/assert.inc [There should be 2 warning(s)]
3001 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3002 include/assert.inc [There should be 0 warning(s)]
3003 include/assert.inc [Only two events should exist in the binary log]
3004 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3005 Warnings:
3006 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3007 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3008 Warnings:
3009 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3010 DROP TRIGGER trig_2;
3011
3012 Invoking prepared statement prep_2 invoking procedure proc_1 invoking statement that is unsafe several times.
3013 PREPARE prep_2 FROM "CALL proc_1()";
3014 * binlog_format = STATEMENT: expect 2 warnings.
3015 EXECUTE prep_2;
3016 Warnings:
3017 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3018 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3019 include/assert.inc [There should be 2 warning(s)]
3020 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3021 include/assert.inc [There should be 0 warning(s)]
3022 include/assert.inc [Only two events should exist in the binary log]
3023 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3024 Warnings:
3025 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3026 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3027 Warnings:
3028 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3029 DROP PREPARE prep_2;
3030 DROP PROCEDURE proc_1;
3031
3032 Invoking trigger trig_1 invoking statement that is unsafe several times.
3033 CREATE TRIGGER trig_1 BEFORE INSERT ON trigger_table_1 FOR EACH ROW BEGIN INSERT INTO ta1 VALUES (47); INSERT INTO ta0 VALUES (multi_unsafe_func()); END;
3034 * binlog_format = STATEMENT: expect 2 warnings.
3035 INSERT INTO trigger_table_1 VALUES (1);
3036 Warnings:
3037 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3038 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3039 include/assert.inc [There should be 2 warning(s)]
3040 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3041 include/assert.inc [There should be 0 warning(s)]
3042 include/assert.inc [Only two events should exist in the binary log]
3043 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3044 Warnings:
3045 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3046 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3047 Warnings:
3048 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3049
3050 Invoking function func_sidef_2 invoking trigger trig_1 invoking statement that is unsafe several times.
3051 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); RETURN 0; END;
3052 * binlog_format = STATEMENT: expect 2 warnings.
3053 INSERT INTO t2 SELECT func_sidef_2();
3054 Warnings:
3055 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3056 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3057 include/assert.inc [There should be 2 warning(s)]
3058 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3059 include/assert.inc [There should be 0 warning(s)]
3060 include/assert.inc [Only two events should exist in the binary log]
3061 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3062 Warnings:
3063 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3064 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3065 Warnings:
3066 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3067 DROP FUNCTION func_sidef_2;
3068
3069 Invoking procedure proc_2 invoking trigger trig_1 invoking statement that is unsafe several times.
3070 CREATE PROCEDURE proc_2() BEGIN INSERT INTO trigger_table_1 VALUES (1); INSERT INTO ta2 VALUES (47); END;
3071 * binlog_format = STATEMENT: expect 2 warnings.
3072 CALL proc_2();
3073 Warnings:
3074 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3075 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3076 include/assert.inc [There should be 2 warning(s)]
3077 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3078 include/assert.inc [There should be 0 warning(s)]
3079 include/assert.inc [Only two events should exist in the binary log]
3080 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3081 Warnings:
3082 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3083 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3084 Warnings:
3085 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3086 DROP PROCEDURE proc_2;
3087
3088 Invoking trigger trig_2 invoking trigger trig_1 invoking statement that is unsafe several times.
3089 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO trigger_table_1 VALUES (1); END;
3090 * binlog_format = STATEMENT: expect 2 warnings.
3091 INSERT INTO trigger_table_2 VALUES (1);
3092 Warnings:
3093 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3094 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3095 include/assert.inc [There should be 2 warning(s)]
3096 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3097 include/assert.inc [There should be 0 warning(s)]
3098 include/assert.inc [Only two events should exist in the binary log]
3099 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3100 Warnings:
3101 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3102 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3103 Warnings:
3104 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3105 DROP TRIGGER trig_2;
3106
3107 Invoking prepared statement prep_2 invoking trigger trig_1 invoking statement that is unsafe several times.
3108 PREPARE prep_2 FROM "INSERT INTO trigger_table_1 VALUES (1)";
3109 * binlog_format = STATEMENT: expect 2 warnings.
3110 EXECUTE prep_2;
3111 Warnings:
3112 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3113 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3114 include/assert.inc [There should be 2 warning(s)]
3115 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3116 include/assert.inc [There should be 0 warning(s)]
3117 include/assert.inc [Only two events should exist in the binary log]
3118 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3119 Warnings:
3120 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3121 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3122 Warnings:
3123 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3124 DROP PREPARE prep_2;
3125 DROP TRIGGER trig_1;
3126
3127 Invoking view view_sidef_1 invoking statement that is unsafe several times.
3128 CREATE VIEW view_sidef_1 AS SELECT multi_unsafe_func();
3129 * binlog_format = STATEMENT: expect 2 warnings.
3130 INSERT INTO t1 SELECT * FROM view_sidef_1;
3131 Warnings:
3132 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3133 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3134 include/assert.inc [There should be 2 warning(s)]
3135 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3136 include/assert.inc [There should be 0 warning(s)]
3137 include/assert.inc [Only two events should exist in the binary log]
3138 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3139 Warnings:
3140 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3141 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3142 Warnings:
3143 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3144
3145 Invoking function func_sidef_2 invoking view view_sidef_1 invoking statement that is unsafe several times.
3146 CREATE FUNCTION func_sidef_2() RETURNS VARCHAR(100) BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT * FROM view_sidef_1; RETURN 0; END;
3147 * binlog_format = STATEMENT: expect 2 warnings.
3148 INSERT INTO t2 SELECT func_sidef_2();
3149 Warnings:
3150 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3151 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3152 include/assert.inc [There should be 2 warning(s)]
3153 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3154 include/assert.inc [There should be 0 warning(s)]
3155 include/assert.inc [Only two events should exist in the binary log]
3156 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3157 Warnings:
3158 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3159 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3160 Warnings:
3161 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3162 DROP FUNCTION func_sidef_2;
3163
3164 Invoking procedure proc_2 invoking view view_sidef_1 invoking statement that is unsafe several times.
3165 CREATE PROCEDURE proc_2() BEGIN INSERT INTO t1 SELECT * FROM view_sidef_1; INSERT INTO ta2 VALUES (47); END;
3166 * binlog_format = STATEMENT: expect 2 warnings.
3167 CALL proc_2();
3168 Warnings:
3169 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3170 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3171 include/assert.inc [There should be 2 warning(s)]
3172 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3173 include/assert.inc [There should be 0 warning(s)]
3174 include/assert.inc [Only two events should exist in the binary log]
3175 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3176 Warnings:
3177 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3178 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3179 Warnings:
3180 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3181 DROP PROCEDURE proc_2;
3182
3183 Invoking trigger trig_2 invoking view view_sidef_1 invoking statement that is unsafe several times.
3184 CREATE TRIGGER trig_2 BEFORE INSERT ON trigger_table_2 FOR EACH ROW BEGIN INSERT INTO ta2 VALUES (47); INSERT INTO t1 SELECT * FROM view_sidef_1; END;
3185 * binlog_format = STATEMENT: expect 2 warnings.
3186 INSERT INTO trigger_table_2 VALUES (1);
3187 Warnings:
3188 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3189 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3190 include/assert.inc [There should be 2 warning(s)]
3191 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3192 include/assert.inc [There should be 0 warning(s)]
3193 include/assert.inc [Only two events should exist in the binary log]
3194 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3195 Warnings:
3196 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3197 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3198 Warnings:
3199 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3200 DROP TRIGGER trig_2;
3201
3202 Invoking view view_sidef_2 invoking view view_sidef_1 invoking statement that is unsafe several times.
3203 CREATE VIEW view_sidef_2 AS SELECT * FROM view_sidef_1;
3204 * binlog_format = STATEMENT: expect 2 warnings.
3205 INSERT INTO t2 SELECT * FROM view_sidef_2;
3206 Warnings:
3207 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3208 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3209 include/assert.inc [There should be 2 warning(s)]
3210 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3211 include/assert.inc [There should be 0 warning(s)]
3212 include/assert.inc [Only two events should exist in the binary log]
3213 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3214 Warnings:
3215 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3216 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3217 Warnings:
3218 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3219 DROP VIEW view_sidef_2;
3220
3221 Invoking prepared statement prep_2 invoking view view_sidef_1 invoking statement that is unsafe several times.
3222 PREPARE prep_2 FROM "INSERT INTO t1 SELECT * FROM view_sidef_1";
3223 * binlog_format = STATEMENT: expect 2 warnings.
3224 EXECUTE prep_2;
3225 Warnings:
3226 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3227 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3228 include/assert.inc [There should be 2 warning(s)]
3229 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3230 include/assert.inc [There should be 0 warning(s)]
3231 include/assert.inc [Only two events should exist in the binary log]
3232 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3233 Warnings:
3234 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3235 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3236 Warnings:
3237 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3238 DROP PREPARE prep_2;
3239 DROP VIEW view_sidef_1;
3240
3241 Invoking prepared statement prep_1 invoking statement that is unsafe several times.
3242 PREPARE prep_1 FROM "INSERT INTO ta0 VALUES (multi_unsafe_func())";
3243 * binlog_format = STATEMENT: expect 2 warnings.
3244 EXECUTE prep_1;
3245 Warnings:
3246 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3247 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3248 include/assert.inc [There should be 2 warning(s)]
3249 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3250 include/assert.inc [There should be 0 warning(s)]
3251 include/assert.inc [Only two events should exist in the binary log]
3252 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3253 Warnings:
3254 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3255 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3256 Warnings:
3257 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3258 DROP PREPARE prep_1;
3259
3260 Invoking statement that is unsafe several times.
3261 * binlog_format = STATEMENT: expect 2 warnings.
3262 INSERT INTO ta0 VALUES (multi_unsafe_func());
3263 Warnings:
3264 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3265 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
3266 include/assert.inc [There should be 2 warning(s)]
3267 * SQL_LOG_BIN = 0: expect nothing logged and only deprecation warnings.
3268 include/assert.inc [There should be 0 warning(s)]
3269 include/assert.inc [Only two events should exist in the binary log]
3270 * binlog_format = MIXED: expect error since the engine is only statement capable and doesn't have row logging capability.
3271 Warnings:
3272 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3273 ERROR HY000: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3274 Warnings:
3275 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
3276 DROP TRIGGER double_autoinc_trig;
3277 DROP TABLE t0, t1, t2, ta0, ta1, ta2,
3278 autoinc_table, double_autoinc_table,
3279 data_table,
3280 trigger_table_1, trigger_table_2, trigger_table_3;
3281 DROP FUNCTION myfunc_int;
3282 DROP FUNCTION multi_unsafe_func;
3283 ==== Special system variables that should *not* be unsafe ====
3284 CREATE TABLE t1 (a VARCHAR(1000));
3285 CREATE TABLE autoinc_table (a INT PRIMARY KEY AUTO_INCREMENT);
3286 INSERT INTO t1 VALUES (@@session.auto_increment_increment);
3287 INSERT INTO t1 VALUES (@@session.auto_increment_offset);
3288 INSERT INTO t1 VALUES (@@session.character_set_client);
3289 INSERT INTO t1 VALUES (@@session.character_set_connection);
3290 INSERT INTO t1 VALUES (@@session.character_set_database);
3291 INSERT INTO t1 VALUES (@@session.character_set_server);
3292 INSERT INTO t1 VALUES (@@session.collation_connection);
3293 INSERT INTO t1 VALUES (@@session.collation_database);
3294 INSERT INTO t1 VALUES (@@session.collation_server);
3295 INSERT INTO t1 VALUES (@@session.foreign_key_checks);
3296 INSERT INTO t1 VALUES (@@session.identity);
3297 INSERT INTO t1 VALUES (@@session.last_insert_id);
3298 INSERT INTO t1 VALUES (@@session.lc_time_names);
3299 INSERT INTO t1 VALUES (@@session.pseudo_thread_id);
3300 INSERT INTO t1 VALUES (@@session.sql_auto_is_null);
3301 INSERT INTO t1 VALUES (@@session.timestamp);
3302 INSERT INTO t1 VALUES (@@session.time_zone);
3303 INSERT INTO t1 VALUES (@@session.unique_checks);
3304 SET @my_var= 4711;
3305 INSERT INTO t1 VALUES (@my_var);
3306 SET insert_id= 12;
3307 INSERT INTO autoinc_table VALUES (NULL);
3308 The following variables *should* give a warning, despite they are replicated.
3309 INSERT INTO t1 VALUES (@@session.sql_mode);
3310 Warnings:
3311 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3312 INSERT INTO t1 VALUES (@@session.insert_id);
3313 Warnings:
3314 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the replica.
3315 DROP TABLE t1, autoinc_table;
3316 SET GLOBAL debug= @old_debug;
3317 "End of tests"