1include/master-slave.inc 2[connection master] 3connection master; 4CREATE TABLE t1(id INT); 5CREATE VIEW v1 AS SELECT * FROM t1 WHERE id>10; 6INSERT INTO t1 VALUES (5), (8), (10), (20), (30); 7SELECT * FROM t1; 8id 95 108 1110 1220 1330 14SELECT * FROM v1; 15id 1620 1730 18# Syncing slave with master 19connection slave; 20SELECT * FROM t1; 21id 225 238 2410 2520 2630 27SELECT * FROM v1; 28id 2920 3030 31connection master; 32CREATE VIEW v1 AS SELECT * FROM t1 WHERE id>10; 33ERROR 42S01: Table 'v1' already exists 34CREATE VIEW IF NOT EXISTS v1 AS SELECT * FROM t1 WHERE id>10; 35Warnings: 36Note 1050 Table 'v1' already exists 37CREATE OR REPLACE VIEW IF NOT EXISTS v1 AS SELECT * FROM t1 WHERE id>10; 38ERROR HY000: Incorrect usage of OR REPLACE and IF NOT EXISTS 39# Syncing slave with master 40connection slave; 41SELECT * FROM t1; 42id 435 448 4510 4620 4730 48SELECT * FROM v1; 49id 5020 5130 52connection master; 53CREATE OR REPLACE VIEW v1 AS SELECT * FROM t1 WHERE id>10; 54INSERT INTO t1 VALUES (50), (80), (3), (2), (40); 55SELECT * FROM t1; 56id 575 588 5910 6020 6130 6250 6380 643 652 6640 67SELECT * FROM v1; 68id 6920 7030 7150 7280 7340 74# Syncing slave with master 75connection slave; 76SELECT * FROM t1; 77id 785 798 8010 8120 8230 8350 8480 853 862 8740 88SELECT * FROM v1; 89id 9020 9130 9250 9380 9440 95connection master; 96DROP VIEW v1; 97DROP TABLE t1; 98DROP VIEW v1; 99ERROR 42S02: Unknown VIEW: 'test.v1' 100DROP VIEW IF EXISTS v2; 101Warnings: 102Note 4092 Unknown VIEW: 'test.v2' 103# Syncing slave with master 104connection slave; 105SELECT * FROM v1; 106ERROR 42S02: Table 'test.v1' doesn't exist 107include/rpl_end.inc 108