Gecko [ 122.154.134.11 ]

Name	Size	Permission
binlog_base64_flag.result	3.74 KB	-rw-r--r--
binlog_bug23533.result	486 B	-rw-r--r--
binlog_bug36391.result	129 B	-rw-r--r--
binlog_database.result	5.28 KB	-rw-r--r--
binlog_delete_and_flush_index....	1.75 KB	-rw-r--r--
binlog_drop_if_exists.result	5.26 KB	-rw-r--r--
binlog_grant.result	1.18 KB	-rw-r--r--
binlog_incident.result	181 B	-rw-r--r--
binlog_index.result	5.2 KB	-rw-r--r--
binlog_innodb.result	6.05 KB	-rw-r--r--
binlog_innodb_row.result	2.47 KB	-rw-r--r--
binlog_killed.result	3.43 KB	-rw-r--r--
binlog_killed_simulate.result	1.25 KB	-rw-r--r--
binlog_mix_innodb_stat.result	610 B	-rw-r--r--
binlog_mixed_failure_mixing_en...	16.79 KB	-rw-r--r--
binlog_mixed_load_data.result	429 B	-rw-r--r--
binlog_multi_engine.result	4.59 KB	-rw-r--r--
binlog_mysqlbinlog-cp932.resul...	344 B	-rw-r--r--
binlog_mysqlbinlog2.result	36.63 KB	-rw-r--r--
binlog_mysqlbinlog_base64.resu...	1.69 KB	-rw-r--r--
binlog_mysqlbinlog_row.result	150.85 KB	-rw-r--r--
binlog_mysqlbinlog_row_innodb....	239.94 KB	-rw-r--r--
binlog_mysqlbinlog_row_myisam....	241.25 KB	-rw-r--r--
binlog_mysqlbinlog_row_trans.r...	16.1 KB	-rw-r--r--
binlog_old_versions.result	1.3 KB	-rw-r--r--
binlog_query_filter_rules.resu...	173 B	-rw-r--r--
binlog_reset_master.result	14 B	-rw-r--r--
binlog_row_binlog.result	76.4 KB	-rw-r--r--
binlog_row_ctype_cp932.result	87.42 KB	-rw-r--r--
binlog_row_ctype_ucs.result	1.27 KB	-rw-r--r--
binlog_row_drop_tmp_tbl.result	1.17 KB	-rw-r--r--
binlog_row_failure_mixing_engi...	18.09 KB	-rw-r--r--
binlog_row_innodb_stat.result	610 B	-rw-r--r--
binlog_row_insert_select.resul...	829 B	-rw-r--r--
binlog_row_mix_innodb_myisam.r...	32.72 KB	-rw-r--r--
binlog_row_mysqlbinlog_db_filt...	1.5 KB	-rw-r--r--
binlog_row_mysqlbinlog_verbose...	2.68 KB	-rw-r--r--
binlog_server_id.result	1.2 KB	-rw-r--r--
binlog_sf.result	1.67 KB	-rw-r--r--
binlog_sql_mode.result	3.51 KB	-rw-r--r--
binlog_start_comment.result	357 B	-rw-r--r--
binlog_statement_insert_delaye...	949 B	-rw-r--r--
binlog_stm_binlog.result	51.51 KB	-rw-r--r--
binlog_stm_blackhole.result	7.29 KB	-rw-r--r--
binlog_stm_ctype_cp932.result	87.42 KB	-rw-r--r--
binlog_stm_ctype_ucs.result	1.29 KB	-rw-r--r--
binlog_stm_do_db.result	2.08 KB	-rw-r--r--
binlog_stm_drop_tmp_tbl.result	2.3 KB	-rw-r--r--
binlog_stm_innodb_stat.result	610 B	-rw-r--r--
binlog_stm_insert_select.resul...	707 B	-rw-r--r--
binlog_stm_mix_innodb_myisam.r...	30.23 KB	-rw-r--r--
binlog_stm_ps.result	811 B	-rw-r--r--
binlog_stm_row.result	2.48 KB	-rw-r--r--
binlog_stm_unsafe_warning.resu...	1.71 KB	-rw-r--r--
binlog_tmp_table.result	877 B	-rw-r--r--
binlog_truncate_innodb.result	2.45 KB	-rw-r--r--
binlog_truncate_myisam.result	439 B	-rw-r--r--
binlog_unsafe.result	13.81 KB	-rw-r--r--
binlog_write_error.result	3.58 KB	-rw-r--r--

Code Editor : binlog_multi_engine.result

CREATE TABLE t1m (m INT, n INT) ENGINE=MYISAM;
CREATE TABLE t1b (b INT, c INT) ENGINE=BLACKHOLE;
CREATE TABLE t1n (e INT, f INT) ENGINE=NDB;
RESET MASTER;
SET SESSION BINLOG_FORMAT=STATEMENT;
INSERT INTO t1b VALUES (1,1), (1,2), (2,1), (2,2);
INSERT INTO t1m VALUES (1,1), (1,2), (2,1), (2,2);
UPDATE t1m, t1b SET m = 2, b = 3 WHERE n = c;
*** Please look in binlog_multi_engine.test if you have a diff here ****
START TRANSACTION;
INSERT INTO t1n VALUES (1,1), (1,2), (2,1), (2,2);
UPDATE t1m, t1n SET m = 2, e = 3 WHERE n = f;
UPDATE t1n, t1b SET e = 2, b = 3 WHERE f = c;
COMMIT;
TRUNCATE t1m;
TRUNCATE t1b;
TRUNCATE t1n;
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
mysqld-bin.000001	#	Query	#	#	BEGIN
mysqld-bin.000001	#	Query	#	#	use `test`; INSERT INTO t1b VALUES (1,1), (1,2), (2,1), (2,2)
mysqld-bin.000001	#	Query	#	#	COMMIT
mysqld-bin.000001	#	Query	#	#	use `test`; INSERT INTO t1m VALUES (1,1), (1,2), (2,1), (2,2)
mysqld-bin.000001	#	Query	#	#	use `test`; UPDATE t1m, t1b SET m = 2, b = 3 WHERE n = c
mysqld-bin.000001	#	Query	#	#	BEGIN
mysqld-bin.000001	#	Query	#	#	use `test`; INSERT INTO t1n VALUES (1,1), (1,2), (2,1), (2,2)
mysqld-bin.000001	#	Query	#	#	use `test`; UPDATE t1m, t1n SET m = 2, e = 3 WHERE n = f
mysqld-bin.000001	#	Query	#	#	use `test`; UPDATE t1n, t1b SET e = 2, b = 3 WHERE f = c
mysqld-bin.000001	#	Query	#	#	COMMIT
mysqld-bin.000001	#	Query	#	#	BEGIN
mysqld-bin.000001	#	Table_map	#	#	table_id: # (test.t1n)
mysqld-bin.000001	#	Table_map	#	#	table_id: # (mysql.ndb_apply_status)
mysqld-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
mysqld-bin.000001	#	Query	#	#	COMMIT
mysqld-bin.000001	#	Query	#	#	use `test`; TRUNCATE t1m
mysqld-bin.000001	#	Query	#	#	use `test`; TRUNCATE t1b
mysqld-bin.000001	#	Query	#	#	use `test`; TRUNCATE t1n
RESET MASTER;
SET SESSION BINLOG_FORMAT=MIXED;
INSERT INTO t1b VALUES (1,1), (1,2), (2,1), (2,2);
INSERT INTO t1m VALUES (1,1), (1,2), (2,1), (2,2);
INSERT INTO t1n VALUES (1,1), (1,2), (2,1), (2,2);
UPDATE t1m, t1b SET m = 2, b = 3 WHERE n = c;
UPDATE t1m, t1n SET m = 2, e = 3 WHERE n = f;
ERROR HY000: Binary logging not possible. Message: Statement cannot be written atomically since more than one engine involved and at least one engine is self-logging
TRUNCATE t1m;
TRUNCATE t1b;
TRUNCATE t1n;
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
mysqld-bin.000001	#	Query	#	#	BEGIN
mysqld-bin.000001	#	Query	#	#	use `test`; INSERT INTO t1b VALUES (1,1), (1,2), (2,1), (2,2)
mysqld-bin.000001	#	Query	#	#	COMMIT
mysqld-bin.000001	#	Query	#	#	use `test`; INSERT INTO t1m VALUES (1,1), (1,2), (2,1), (2,2)
mysqld-bin.000001	#	Query	#	#	BEGIN
mysqld-bin.000001	#	Table_map	#	#	table_id: # (test.t1n)
mysqld-bin.000001	#	Table_map	#	#	table_id: # (mysql.ndb_apply_status)
mysqld-bin.000001	#	Write_rows	#	#	table_id: #
mysqld-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
mysqld-bin.000001	#	Query	#	#	COMMIT
mysqld-bin.000001	#	Query	#	#	use `test`; UPDATE t1m, t1b SET m = 2, b = 3 WHERE n = c
mysqld-bin.000001	#	Query	#	#	use `test`; TRUNCATE t1m
mysqld-bin.000001	#	Query	#	#	use `test`; TRUNCATE t1b
mysqld-bin.000001	#	Query	#	#	use `test`; TRUNCATE t1n
RESET MASTER;
SET SESSION BINLOG_FORMAT=ROW;
INSERT INTO t1m VALUES (1,1), (1,2), (2,1), (2,2);
INSERT INTO t1b VALUES (1,1), (1,2), (2,1), (2,2);
INSERT INTO t1n VALUES (1,1), (1,2), (2,1), (2,2);
UPDATE t1m, t1n SET m = 2, e = 3 WHERE n = f;
ERROR HY000: Binary logging not possible. Message: Statement cannot be written atomically since more than one engine involved and at least one engine is self-logging
UPDATE t1n, t1b SET e = 2, b = 3 WHERE f = c;
ERROR HY000: Binary logging not possible. Message: Statement cannot be written atomically since more than one engine involved and at least one engine is self-logging
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
mysqld-bin.000001	#	Query	#	#	BEGIN
mysqld-bin.000001	#	Table_map	#	#	table_id: # (test.t1m)
mysqld-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
mysqld-bin.000001	#	Query	#	#	COMMIT
mysqld-bin.000001	#	Query	#	#	BEGIN
mysqld-bin.000001	#	Table_map	#	#	table_id: # (test.t1b)
mysqld-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
mysqld-bin.000001	#	Query	#	#	COMMIT
mysqld-bin.000001	#	Query	#	#	BEGIN
mysqld-bin.000001	#	Table_map	#	#	table_id: # (test.t1n)
mysqld-bin.000001	#	Table_map	#	#	table_id: # (mysql.ndb_apply_status)
mysqld-bin.000001	#	Write_rows	#	#	table_id: #
mysqld-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
mysqld-bin.000001	#	Query	#	#	COMMIT
RESET MASTER;
DROP TABLE t1m, t1b, t1n;

${this.title}

Code Editor : binlog_multi_engine.result