Debian Codegraph @

mysql-test/suite/binlog_nogtid/t/binlog_nogtid_create_drop_temporary_table.test

raw
1 # ==== Purpose ====
2 #
3 # Verify that CREATE/DROP TEMPORARY TABLE is not written
4 # into binlog when @@session.binlog_format=ROW/MIXED and
5 # @@global.gtid_mode=OFF.
6 #
7 # ==== Implementation ====
8 #
9 # 1. SET @@session.binlog_format=ROW/MIXED;
10 # 2. Verify that CREATE/DROP TEMPORARY TABLE is not written
11 # into binlog when @@global.gtid_mode=OFF.
12 #
13 # ==== References ====
14 #
15 # WL#8872: Allow CREATE TEMPORARY/DROP TEMPORARY in transaction when GTID_MODE=ON in RBR
16 # Please see ./internal/mysql-test/suite/i_rpl/t/rpl_row_create_drop_temporary_in_transaction.test
17 # and mysql-test/suite/rpl/t/rpl_mixed_create_drop_temporary_in_transaction.test.
18
19 --source include/have_log_bin.inc
20 --source include/have_binlog_format_mixed_or_row.inc
21 --source include/force_myisam_default.inc
22 --source include/have_myisam.inc
23 --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1)
24 BEGIN;
25 CREATE TEMPORARY TABLE tmp1 (a INT) ENGINE=InnoDB;
26 DROP TEMPORARY TABLE tmp1;
27 CREATE TEMPORARY TABLE tmp2 (a INT) ENGINE=MyISAM;
28 DROP TEMPORARY TABLE tmp2;
29 COMMIT;
30 --let $assert_text= CREATE/DROP TEMPORARY TABLE is not written into binlog when @@session.binlog_format=ROW/MIXED and @@global.gtid_mode=OFF.
31 --let $assert_cond= [SHOW MASTER STATUS, Position, 1] = $saved_master_pos
32 --source include/assert.inc