1include/master-slave.inc 2[connection master] 3drop table if exists t1,v1; 4drop view if exists t1,v1; 5connection slave; 6reset master; 7connection master; 8create table t1 (a int); 9insert into t1 values (1); 10create view v1 as select a from t1; 11insert into v1 values (2); 12select * from v1 order by a; 13a 141 152 16connection slave; 17select * from v1 order by a; 18a 191 202 21connection master; 22update v1 set a=3 where a=1; 23select * from v1 order by a; 24a 252 263 27connection slave; 28select * from v1 order by a; 29a 302 313 32connection master; 33delete from v1 where a=2; 34select * from v1 order by a; 35a 363 37connection slave; 38select * from v1 order by a; 39a 403 41connection master; 42alter view v1 as select a as b from t1; 43connection slave; 44select * from v1 order by 1; 45b 463 47connection master; 48drop view v1; 49connection slave; 50select * from v1 order by a; 51ERROR 42S02: Table 'test.v1' doesn't exist 52connection master; 53drop table t1; 54connection slave; 55 56---> Test for BUG#20438 57 58---> Preparing environment... 59connection master; 60DROP TABLE IF EXISTS t1; 61DROP VIEW IF EXISTS v1; 62 63---> Synchronizing slave with master... 64connection slave; 65 66connection master; 67 68---> Creating objects... 69CREATE TABLE t1(c INT); 70/*!50003 CREATE VIEW v1 AS SELECT * FROM t1 */; 71 72---> Inserting value... 73INSERT INTO t1 VALUES(1); 74 75---> Checking on master... 76SELECT * FROM t1; 77c 781 79 80---> Synchronizing slave with master... 81connection slave; 82SELECT * FROM t1; 83c 841 85connection master; 86 87---> Cleaning up... 88DROP VIEW v1; 89DROP TABLE t1; 90connection slave; 91connection master; 92connection master; 93create table t1(a int, b int); 94insert into t1 values (1, 1), (1, 2), (1, 3); 95create view v1(a, b) as select a, sum(b) from t1 group by a; 96connection slave; 97explain v1; 98Field Type Null Key Default Extra 99a int(11) YES NULL 100b decimal(32,0) YES NULL 101show create table v1; 102View Create View character_set_client collation_connection 103v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,sum(`t1`.`b`) AS `b` from `t1` group by `t1`.`a` latin1 latin1_swedish_ci 104select * from v1; 105a b 1061 6 107connection master; 108drop table t1; 109drop view v1; 110connection slave; 111connection master; 112CREATE TABLE t1(a INT); 113CREATE VIEW v1 AS SELECT * FROM t1; 114CREATE VIEW v1 AS SELECT * FROM t1; 115ERROR 42S01: Table 'v1' already exists 116DROP VIEW v1; 117DROP TABLE t1; 118connection slave; 119connection master; 120CREATE TABLE t1 (a INT); 121# create view as output from mysqldump 10.11 (5.0.62) 122/*!50001 CREATE ALGORITHM=UNDEFINED */ 123/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ 124/*!50001 VIEW `v1` AS select `t1`.`a` AS `a` from `t1` where (`t1`.`a` < 3) */ 125/*!50002 WITH CASCADED CHECK OPTION */; 126SHOW CREATE VIEW v1; 127View Create View character_set_client collation_connection 128v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a` from `t1` where `t1`.`a` < 3 WITH CASCADED CHECK OPTION latin1 latin1_swedish_ci 129connection slave; 130SHOW CREATE VIEW v1; 131View Create View character_set_client collation_connection 132v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a` from `t1` where `t1`.`a` < 3 WITH CASCADED CHECK OPTION latin1 latin1_swedish_ci 133connection master; 134DROP VIEW v1; 135DROP TABLE t1; 136connection slave; 137End of 5.0 tests 138include/rpl_end.inc 139