diff options
| author | unknown <aelkin/elkin@dsl-hkigw8-feb9fb00-191.dhcp.inet.fi> | 2006-09-28 17:55:45 +0300 |
|---|---|---|
| committer | unknown <aelkin/elkin@dsl-hkigw8-feb9fb00-191.dhcp.inet.fi> | 2006-09-28 17:55:45 +0300 |
| commit | 277b80da67146c99f1a27a9f415454dcf244e3da (patch) | |
| tree | 2fe486a895c893e16b912ccfff6aa55727c3f8bd | |
| parent | fff0993e0bbf7ac9a3a49034c2ccdd445940bffd (diff) | |
| download | mariadb-git-277b80da67146c99f1a27a9f415454dcf244e3da.tar.gz | |
the results of binlog_statement_insert_delayed in STATEMENT - non-recommended mode i.e not checked
by make test - got changed due to show binlog events relocation to deterministic
position at extra/binlog_tests/binlog_insert_delayed.test.
mysql-test/r/binlog_statement_insert_delayed.result:
results changed due to moving a binlog check affront of indetermistic queries.
| -rw-r--r-- | mysql-test/r/binlog_statement_insert_delayed.result | 18 |
1 files changed, 7 insertions, 11 deletions
diff --git a/mysql-test/r/binlog_statement_insert_delayed.result b/mysql-test/r/binlog_statement_insert_delayed.result index af10aa8ed4e..7a1b9a7ec9b 100644 --- a/mysql-test/r/binlog_statement_insert_delayed.result +++ b/mysql-test/r/binlog_statement_insert_delayed.result @@ -3,6 +3,13 @@ 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 102; +Log_name Pos Event_type Server_id End_log_pos Info +master-bin.000001 # Query 1 # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam +master-bin.000001 # Query 1 # use `test`; insert delayed into t1 values (207) +master-bin.000001 # Intvar 1 # INSERT_ID=208 +master-bin.000001 # Query 1 # use `test`; insert delayed into t1 values (null) +master-bin.000001 # Query 1 # 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 @@ -19,15 +26,4 @@ a 306 400 401 -show binlog events from 102; -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query 1 # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam -master-bin.000001 # Query 1 # use `test`; insert delayed into t1 values (207) -master-bin.000001 # Intvar 1 # INSERT_ID=208 -master-bin.000001 # Query 1 # use `test`; insert delayed into t1 values (null) -master-bin.000001 # Query 1 # use `test`; insert delayed into t1 values (300) -master-bin.000001 # Intvar 1 # INSERT_ID=301 -master-bin.000001 # Query 1 # use `test`; insert delayed into t1 values (null),(null),(null),(null) -master-bin.000001 # Intvar 1 # INSERT_ID=305 -master-bin.000001 # Query 1 # use `test`; insert delayed into t1 values (null),(null),(400),(null) drop table t1; |