summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl_view.test
diff options
context:
space:
mode:
authorlars@mysql.com <>2005-12-22 06:39:02 +0100
committerlars@mysql.com <>2005-12-22 06:39:02 +0100
commitad126d90e019f223470e73e1b2b528f9007c4532 (patch)
tree192a6c65973c50f6a436a8c6e6bb19efa2ed2419 /mysql-test/t/rpl_view.test
parent0f8f444b8be51db1265a3c30a576c9e404b86071 (diff)
downloadmariadb-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.test47
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;