Debian Codegraph @

mysql-test/suite/rpl/r/rpl_drop_view.result

raw
1 include/master-slave.inc
2 [connection master]
3 drop table if exists t1, t2;
4 drop view if exists v1, v2, v3, not_exist_view;
5 create table t1 (a int);
6 create table t2 (b int);
7 create table t3 (c int);
8 create view v1 as select * from t1;
9 create view v2 as select * from t2;
10 create view v3 as select * from t3;
11 drop view not_exist_view;
12 ERROR 42S02: Unknown VIEW: 'test.not_exist_view'
13 drop view v1, not_exist_view;
14 ERROR 42S02: Unknown VIEW: 'test.not_exist_view'
15 select * from v1;
16 ERROR 42S02: Table 'test.v1' doesn't exist
17 drop view v2, v3;
18 connection slave;
19 select * from v1;
20 ERROR 42S02: Table 'test.v1' doesn't exist
21 select * from v2;
22 ERROR 42S02: Table 'test.v2' doesn't exist
23 select * from v3;
24 ERROR 42S02: Table 'test.v3' doesn't exist
25 ==== clean up ====
26 connection master;
27 drop table t1, t2, t3;
28 connection slave;
29 include/rpl_end.inc