Debian Codegraph @

mysql-test/suite/rpl/t/rpl_drop_view.test

raw
1 # test case for bug#30998
2 # Drop View breaks replication if view does not exist
3 #
4 --source include/not_group_replication_plugin.inc
5 source include/set_privilege_checks_user_as_system_user.inc;
6 source include/master-slave.inc;
7 --disable_warnings
8 drop table if exists t1, t2;
9 drop view if exists v1, v2, v3, not_exist_view;
10 --enable_warnings
11 create table t1 (a int);
12 create table t2 (b int);
13 create table t3 (c int);
14 create view v1 as select * from t1;
15 create view v2 as select * from t2;
16 create view v3 as select * from t3;
17 --error 1051
18 drop view not_exist_view;
19 --error 1051
20 drop view v1, not_exist_view;
21 drop view v1, v2, v3;
22 --source include/sync_slave_sql_with_master.inc
23 --error 1146
24 select * from v1;
25 --error 1146
26 select * from v2;
27 --error 1146
28 select * from v3;
29
30 --echo ==== clean up ====
31 connection master;
32 drop table t1, t2, t3;
33 --source include/sync_slave_sql_with_master.inc
34 --source include/rpl_end.inc