| 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; |