diff options
Diffstat (limited to 'mysql-test/r/binlog_innodb.result')
| -rw-r--r-- | mysql-test/r/binlog_innodb.result | 138 |
1 files changed, 0 insertions, 138 deletions
diff --git a/mysql-test/r/binlog_innodb.result b/mysql-test/r/binlog_innodb.result deleted file mode 100644 index 9dfb6544811..00000000000 --- a/mysql-test/r/binlog_innodb.result +++ /dev/null @@ -1,138 +0,0 @@ -SET BINLOG_FORMAT=MIXED; -RESET MASTER; -CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=INNODB; -INSERT INTO t1 VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6); -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ; -UPDATE t1 SET b = 2*a WHERE a > 1; -COMMIT; -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; -UPDATE t1 SET b = a * a WHERE a > 3; -COMMIT; -SET BINLOG_FORMAT=STATEMENT; -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; -UPDATE t1 SET b = 1*a WHERE a > 1; -ERROR HY000: Binary logging not possible. Message: Transaction level 'READ-UNCOMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' -COMMIT; -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; -UPDATE t1 SET b = 2*a WHERE a > 2; -ERROR HY000: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' -COMMIT; -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ; -UPDATE t1 SET b = 3*a WHERE a > 3; -COMMIT; -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE; -UPDATE t1 SET b = 4*a WHERE a > 4; -COMMIT; -SET BINLOG_FORMAT=MIXED; -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; -UPDATE t1 SET b = 1*a WHERE a > 1; -COMMIT; -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; -UPDATE t1 SET b = 2*a WHERE a > 2; -COMMIT; -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ; -UPDATE t1 SET b = 3*a WHERE a > 3; -COMMIT; -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE; -UPDATE t1 SET b = 4*a WHERE a > 4; -COMMIT; -SET BINLOG_FORMAT=ROW; -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; -UPDATE t1 SET b = 1*a WHERE a > 1; -COMMIT; -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; -UPDATE t1 SET b = 2*a WHERE a > 2; -COMMIT; -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ; -UPDATE t1 SET b = 3*a WHERE a > 3; -COMMIT; -BEGIN; -SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE; -UPDATE t1 SET b = 4*a WHERE a > 4; -COMMIT; -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 PRIMARY KEY, b INT) ENGINE=INNODB -master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6) -master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; BEGIN -master-bin.000001 # Query # # use `test`; UPDATE t1 SET b = 2*a WHERE a > 1 -master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; BEGIN -master-bin.000001 # Table_map # # table_id: # (test.t1) -master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; BEGIN -master-bin.000001 # Query # # use `test`; UPDATE t1 SET b = 3*a WHERE a > 3 -master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; BEGIN -master-bin.000001 # Query # # use `test`; UPDATE t1 SET b = 4*a WHERE a > 4 -master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; BEGIN -master-bin.000001 # Table_map # # table_id: # (test.t1) -master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; BEGIN -master-bin.000001 # Table_map # # table_id: # (test.t1) -master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; BEGIN -master-bin.000001 # Query # # use `test`; UPDATE t1 SET b = 3*a WHERE a > 3 -master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; BEGIN -master-bin.000001 # Query # # use `test`; UPDATE t1 SET b = 4*a WHERE a > 4 -master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; BEGIN -master-bin.000001 # Table_map # # table_id: # (test.t1) -master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; BEGIN -master-bin.000001 # Table_map # # table_id: # (test.t1) -master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; BEGIN -master-bin.000001 # Table_map # # table_id: # (test.t1) -master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; BEGIN -master-bin.000001 # Table_map # # table_id: # (test.t1) -master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Xid # # COMMIT /* XID */ -DROP TABLE t1; -show status like "binlog_cache_use"; -Variable_name Value -Binlog_cache_use 13 -show status like "binlog_cache_disk_use"; -Variable_name Value -Binlog_cache_disk_use 0 -create table t1 (a int) engine=innodb; -show status like "binlog_cache_use"; -Variable_name Value -Binlog_cache_use 14 -show status like "binlog_cache_disk_use"; -Variable_name Value -Binlog_cache_disk_use 1 -begin; -delete from t1; -commit; -show status like "binlog_cache_use"; -Variable_name Value -Binlog_cache_use 15 -show status like "binlog_cache_disk_use"; -Variable_name Value -Binlog_cache_disk_use 1 -drop table t1; -End of tests |