# mysqlbinlog_trans.test # # Show that mysqlbinlog work correctly with transactions. # --let $engine_type= InnoDB --source include/have_binlog_format_row.inc # # The test case records the output of mysqlbinlog, thence if compression # is enabled, then it fails as the compression event is output. # --source include/not_binlog_transaction_compression_on.inc --source include/have_log_bin.inc --echo # --echo # Preparatory cleanup. --echo # --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings --echo # --echo # We need a fixed timestamp to avoid varying results. --echo # SET timestamp=1000000000; --echo # --echo # Delete all existing binary logs. --echo # RESET MASTER; --echo # --echo # Bug#22350047: IF CLIENT KILLED AFTER ROLLBACK TO SAVEPOINT PREVIOUS --echo # STMTS COMMITTED --echo # connect(connection1, localhost, root,,); --let $connection_id=`SELECT CONNECTION_ID()` --eval CREATE TABLE t1(a INT) ENGINE=$engine_type BEGIN; INSERT INTO t1 VALUES(1); SAVEPOINT tx_0; ROLLBACK TO SAVEPOINT tx_0; connection default; --replace_result $connection_id CONN_ID --eval KILL CONNECTION $connection_id --echo # Without the patch, field 'a' contained the value 1 SELECT * FROM t1; DROP TABLE t1;