Debian Codegraph @

mysql-test/suite/binlog/t/binlog_tmp_table_row.test

raw
1 # ==== Purpose ====
2 #
3 # Test if statements used temporary tables are not binlogged in the case of
4 # binlog_format=row
5 #
6 # ==== Method ====
7 #
8 # We will see if binlog file size is increased or not, It should be constant for the
9 # entire period of test.
10 #
11 # ==== Related bugs ====
12 #
13 # Mdev-9266
14 #
15 source include/have_log_bin.inc;
16 source include/have_binlog_format_row.inc;
17
18 RESET MASTER;
19
20 --echo #Create table test
21 --let $sql_query= create temporary table t1(a int, b int)
22 --source suite/binlog/include/check_binlog_size.inc
23
24 --echo #Add index test
25 --let $sql_query= create index index_a on t1(a)
26 --source suite/binlog/include/check_binlog_size.inc
27
28 --echo #drop index test
29 --let $sql_query= drop index index_a on t1
30 --source suite/binlog/include/check_binlog_size.inc