Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
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 id
9 5
10 8
11 10
12 20
13 30
14 SELECT * FROM v1;
15 id
16 20
17 30
18 # Syncing slave with master
19 connection slave;
20 SELECT * FROM t1;
21 id
22 5
23 8
24 10
25 20
26 30
27 SELECT * FROM v1;
28 id
29 20
30 30
31 connection master;
32 CREATE VIEW v1 AS SELECT * FROM t1 WHERE id>10;
33 ERROR 42S01: Table 'v1' already exists
34 CREATE VIEW IF NOT EXISTS v1 AS SELECT * FROM t1 WHERE id>10;
35 Warnings:
36 Note 1050 Table 'v1' already exists
37 CREATE OR REPLACE VIEW IF NOT EXISTS v1 AS SELECT * FROM t1 WHERE id>10;
38 ERROR HY000: Incorrect usage of OR REPLACE and IF NOT EXISTS
39 # Syncing slave with master
40 connection slave;
41 SELECT * FROM t1;
42 id
43 5
44 8
45 10
46 20
47 30
48 SELECT * FROM v1;
49 id
50 20
51 30
52 connection master;
53 CREATE OR REPLACE VIEW v1 AS SELECT * FROM t1 WHERE id>10;
54 INSERT INTO t1 VALUES (50), (80), (3), (2), (40);
55 SELECT * FROM t1;
56 id
57 5
58 8
59 10
60 20
61 30
62 50
63 80
64 3
65 2
66 40
67 SELECT * FROM v1;
68 id
69 20
70 30
71 50
72 80
73 40
74 # Syncing slave with master
75 connection slave;
76 SELECT * FROM t1;
77 id
78 5
79 8
80 10
81 20
82 30
83 50
84 80
85 3
86 2
87 40
88 SELECT * FROM v1;
89 id
90 20
91 30
92 50
93 80
94 40
95 connection master;
96 RENAME TABLE v1 TO v2;
97 DROP VIEW v2;
98 DROP TABLE t1;
99 DROP VIEW v1;
100 ERROR 42S02: Unknown VIEW: 'test.v1'
101 DROP VIEW IF EXISTS v2;
102 Warnings:
103 Note 4092 Unknown VIEW: 'test.v2'
104 # Syncing slave with master
105 connection slave;
106 SELECT * FROM v1;
107 ERROR 42S02: Table 'test.v1' doesn't exist
108 include/rpl_end.inc