summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/funcs/t/rpl_alter.test
diff options
context:
space:
mode:
authorOmer BarNir <omer@mysql.com>2010-03-17 23:42:07 -0700
committerOmer BarNir <omer@mysql.com>2010-03-17 23:42:07 -0700
commitc92b9b7315c01e87b1099e7df182213a1d8ffa6f (patch)
tree096cc41e4d541dd16c84cb829e630fef3d5baba7 /mysql-test/suite/engines/funcs/t/rpl_alter.test
parent96d4a0384629e5cddc93ee215e7af484e4b95bde (diff)
downloadmariadb-git-c92b9b7315c01e87b1099e7df182213a1d8ffa6f.tar.gz
Test suites for engine testing, moved from test-extra so will be available
for general use. mysql-test/Makefile.am: Adding directories of additional test suites mysql-test/mysql-stress-test.pl: Adding check for additional errors checking during test run
Diffstat (limited to 'mysql-test/suite/engines/funcs/t/rpl_alter.test')
-rw-r--r--mysql-test/suite/engines/funcs/t/rpl_alter.test24
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/suite/engines/funcs/t/rpl_alter.test b/mysql-test/suite/engines/funcs/t/rpl_alter.test
new file mode 100644
index 00000000000..576376a0264
--- /dev/null
+++ b/mysql-test/suite/engines/funcs/t/rpl_alter.test
@@ -0,0 +1,24 @@
+source include/master-slave.inc;
+--disable_warnings
+drop database if exists mysqltest;
+--enable_warnings
+create database mysqltest;
+
+create table mysqltest.t1 ( n int);
+alter table mysqltest.t1 add m int;
+insert into mysqltest.t1 values (1,2);
+create table mysqltest.t2 (n int);
+insert into mysqltest.t2 values (45);
+rename table mysqltest.t2 to mysqltest.t3, mysqltest.t1 to mysqltest.t2;
+save_master_pos;
+connection slave;
+sync_with_master;
+select * from mysqltest.t2;
+select * from mysqltest.t3;
+connection master;
+drop database mysqltest;
+save_master_pos;
+connection slave;
+sync_with_master;
+
+# End of 4.1 tests