source include/have_log_bin.inc; source include/not_embedded.inc; # Checking that the drop of a database does not replicate anything in # addition to the drop of the database reset master; create database testing_1; use testing_1; create table t1 (a int); create function sf1 (a int) returns int return a+1; create trigger tr1 before insert on t1 for each row insert into t2 values (2*new.a); create procedure sp1 (a int) insert into t1 values(a); drop database testing_1; source include/show_binlog_events.inc; # BUG#38773: DROP DATABASE cause switch to stmt-mode when there are # temporary tables open use test; reset master; create temporary table tt1 (a int); create table t1 (a int); insert into t1 values (1); disable_warnings; drop database if exists mysqltest1; enable_warnings; insert into t1 values (1); drop table tt1, t1; source include/show_binlog_events.inc; FLUSH STATUS;