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#
15source include/have_log_bin.inc;
16source include/have_binlog_format_row.inc;
17
18RESET 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
31