diff options
author | lars@mysql.com <> | 2005-12-22 06:39:02 +0100 |
---|---|---|
committer | lars@mysql.com <> | 2005-12-22 06:39:02 +0100 |
commit | ad126d90e019f223470e73e1b2b528f9007c4532 (patch) | |
tree | 192a6c65973c50f6a436a8c6e6bb19efa2ed2419 /mysql-test/t/rpl_view.test | |
parent | 0f8f444b8be51db1265a3c30a576c9e404b86071 (diff) | |
download | mariadb-git-ad126d90e019f223470e73e1b2b528f9007c4532.tar.gz |
WL#1012: All changes as one single changeset.
This includes both code and test cases.
Diffstat (limited to 'mysql-test/t/rpl_view.test')
-rw-r--r-- | mysql-test/t/rpl_view.test | 47 |
1 files changed, 0 insertions, 47 deletions
diff --git a/mysql-test/t/rpl_view.test b/mysql-test/t/rpl_view.test deleted file mode 100644 index 0a0c6a6dddb..00000000000 --- a/mysql-test/t/rpl_view.test +++ /dev/null @@ -1,47 +0,0 @@ -source include/master-slave.inc; ---disable_warnings -drop table if exists t1,v1; -drop view if exists t1,v1; -sync_slave_with_master; -reset master; ---enable_warnings - -# -# Check that createion drop of view is replicated, also check replication of -# updating of view -# -connection master; -create table t1 (a int); -insert into t1 values (1); -create view v1 as select a from t1; -insert into v1 values (2); -select * from v1 order by a; -sync_slave_with_master; -# view already have to be on slave -select * from v1 order by a; -connection master; -update v1 set a=3 where a=1; -select * from v1 order by a; -sync_slave_with_master; -select * from v1 order by a; -connection master; -delete from v1 where a=2; -select * from v1 order by a; -sync_slave_with_master; -select * from v1 order by a; -connection master; -# 'alter view' internally maped to creation, but still check that it works -alter view v1 as select a as b from t1; -sync_slave_with_master; -select * from v1 order by 1; -connection master; -drop view v1; -sync_slave_with_master; -#error, because view have to be removed from slave --- error 1146 -select * from v1 order by a; -connection master; -drop table t1; -sync_slave_with_master; ---replace_column 2 # 5 # -show binlog events limit 1,100; |