summaryrefslogtreecommitdiff
path: root/mysql-test/suite/binlog/r/binlog_statement_insert_delayed.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/binlog/r/binlog_statement_insert_delayed.result')
-rw-r--r--mysql-test/suite/binlog/r/binlog_statement_insert_delayed.result29
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/suite/binlog/r/binlog_statement_insert_delayed.result b/mysql-test/suite/binlog/r/binlog_statement_insert_delayed.result
new file mode 100644
index 00000000000..3a2dc441632
--- /dev/null
+++ b/mysql-test/suite/binlog/r/binlog_statement_insert_delayed.result
@@ -0,0 +1,29 @@
+create table t1 (a int not null auto_increment, primary key (a)) engine=myisam;
+set @@session.auto_increment_increment=1, @@session.auto_increment_offset=1;
+insert delayed into t1 values (207);
+insert delayed into t1 values (null);
+insert delayed into t1 values (300);
+show binlog events from <binlog_start>;
+Log_name Pos Event_type Server_id End_log_pos Info
+master-bin.000001 # Query # # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
+master-bin.000001 # Query # # use `test`; insert delayed into t1 values (207)
+master-bin.000001 # Intvar # # INSERT_ID=208
+master-bin.000001 # Query # # use `test`; insert delayed into t1 values (null)
+master-bin.000001 # Query # # use `test`; insert delayed into t1 values (300)
+insert delayed into t1 values (null),(null),(null),(null);
+insert delayed into t1 values (null),(null),(400),(null);
+11 == 11
+select * from t1;
+a
+207
+208
+300
+301
+302
+303
+304
+305
+306
+400
+401
+drop table t1;