Debian Codegraph @

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

raw
1 reset master;
2 create table t1 (a int not null auto_increment, primary key (a)) engine=myisam;
3 insert /* before delayed */ delayed /* after delayed */ into t1 values (207);
4 insert /*! delayed */ into t1 values (null);
5 insert delayed into t1 values (300);
6 FLUSH TABLES;
7 include/show_binlog_events.inc
8 Log_name Pos Event_type Server_id End_log_pos Info
9 master-bin.000001 # Gtid # # GTID #-#-#
10 master-bin.000001 # Query # # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
11 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
12 master-bin.000001 # Query # # use `test`; insert /* before delayed */ /* after delayed */ into t1 values (207)
13 master-bin.000001 # Query # # COMMIT
14 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
15 master-bin.000001 # Intvar # # INSERT_ID=208
16 master-bin.000001 # Query # # use `test`; insert /*! */ into t1 values (null)
17 master-bin.000001 # Query # # COMMIT
18 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
19 master-bin.000001 # Query # # use `test`; insert into t1 values (300)
20 master-bin.000001 # Query # # COMMIT
21 master-bin.000001 # Gtid # # GTID #-#-#
22 master-bin.000001 # Query # # use `test`; FLUSH TABLES
23 RESET MASTER;
24 insert /* before delayed */ delayed /* after delayed */ into t1 values (null),(null),(null),(null);
25 insert /*! delayed */ into t1 values (null),(null),(400),(null);
26 FLUSH TABLES;
27 include/show_binlog_events.inc
28 Log_name Pos Event_type Server_id End_log_pos Info
29 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
30 master-bin.000001 # Intvar # # INSERT_ID=301
31 master-bin.000001 # Query # # use `test`; insert /* before delayed */ /* after delayed */ into t1 values (null),(null),(null),(null)
32 master-bin.000001 # Query # # COMMIT
33 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
34 master-bin.000001 # Intvar # # INSERT_ID=305
35 master-bin.000001 # Query # # use `test`; insert /*! */ into t1 values (null),(null),(400),(null)
36 master-bin.000001 # Query # # COMMIT
37 master-bin.000001 # Gtid # # GTID #-#-#
38 master-bin.000001 # Query # # use `test`; FLUSH TABLES
39 select * from t1;
40 a
41 207
42 208
43 300
44 301
45 302
46 303
47 304
48 305
49 306
50 400
51 401
52 drop table t1;
53 reset master;