MOON
Server: Apache/2.2.31 (Unix) mod_ssl/2.2.31 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4
System: Linux csr818.wilogic.com 2.6.18-419.el5xen #1 SMP Fri Feb 24 22:50:37 UTC 2017 x86_64
User: digitals (531)
PHP: 5.4.45
Disabled: NONE
Upload Files
File: //usr/share/mysql-test/suite/rpl/r/rpl_trunc_temp.result
include/master-slave.inc
[connection master]
create temporary table t1 (n int);
insert into t1 values(1);
show status like 'Slave_open_temp_tables';
Variable_name	Value
Slave_open_temp_tables	1
delete from t1;
show status like 'Slave_open_temp_tables';
Variable_name	Value
Slave_open_temp_tables	1
truncate t1;
show status like 'Slave_open_temp_tables';
Variable_name	Value
Slave_open_temp_tables	1
show status like 'Slave_open_temp_tables';
Variable_name	Value
Slave_open_temp_tables	0
include/rpl_end.inc