Debian Codegraph @

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

raw
1 drop table if exists t1;
2 reset master;
3 create table t1 (a int);
4 prepare s from "insert into t1 values (@a),(?)";
5 set @a=98;
6 execute s using @a;
7 prepare s from "insert into t1 values (?)";
8 set @a=99;
9 execute s using @a;
10 prepare s from "insert into t1 select 100 limit ?";
11 set @a=100;
12 execute s using @a;
13 Warnings:
14 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.
15 include/show_binlog_events.inc
16 Log_name Pos Event_type Server_id End_log_pos Info
17 binlog.000001 # Query # # use `test`; create table t1 (a int)
18 binlog.000001 # Query # # BEGIN
19 binlog.000001 # User var # # @`a`=98
20 binlog.000001 # Query # # use `test`; insert into t1 values (@a),(98)
21 binlog.000001 # Query # # COMMIT
22 binlog.000001 # Query # # BEGIN
23 binlog.000001 # Query # # use `test`; insert into t1 values (99)
24 binlog.000001 # Query # # COMMIT
25 binlog.000001 # Query # # BEGIN
26 binlog.000001 # Query # # use `test`; insert into t1 select 100 limit 100
27 binlog.000001 # Query # # COMMIT
28 drop table t1;