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