Debian Codegraph @

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

raw
1 --source include/master-slave.inc
2
3 connection master;
4 CREATE TABLE t1(id INT);
5 CREATE VIEW v1 AS SELECT * FROM t1 WHERE id>10;
6 INSERT INTO t1 VALUES (5), (8), (10), (20), (30);
7 SELECT * FROM t1;
8 SELECT * FROM v1;
9
10 --echo # Syncing slave with master
11 sync_slave_with_master;
12 SELECT * FROM t1;
13 SELECT * FROM v1;
14
15 connection master;
16 --error ER_TABLE_EXISTS_ERROR
17 CREATE VIEW v1 AS SELECT * FROM t1 WHERE id>10;
18
19 CREATE VIEW IF NOT EXISTS v1 AS SELECT * FROM t1 WHERE id>10;
20
21 --error ER_WRONG_USAGE
22 CREATE OR REPLACE VIEW IF NOT EXISTS v1 AS SELECT * FROM t1 WHERE id>10;
23
24 --echo # Syncing slave with master
25 sync_slave_with_master;
26 SELECT * FROM t1;
27 SELECT * FROM v1;
28
29 connection master;
30 CREATE OR REPLACE VIEW v1 AS SELECT * FROM t1 WHERE id>10;
31 INSERT INTO t1 VALUES (50), (80), (3), (2), (40);
32 SELECT * FROM t1;
33 SELECT * FROM v1;
34
35 --echo # Syncing slave with master
36 sync_slave_with_master;
37 SELECT * FROM t1;
38 SELECT * FROM v1;
39
40 connection master;
41 RENAME TABLE v1 TO v2;
42 DROP VIEW v2;
43 DROP TABLE t1;
44
45 --error ER_UNKNOWN_VIEW
46 DROP VIEW v1;
47
48 DROP VIEW IF EXISTS v2;
49
50 --echo # Syncing slave with master
51 sync_slave_with_master;
52
53 --error ER_NO_SUCH_TABLE
54 SELECT * FROM v1;
55
56 --source include/rpl_end.inc