diff options
| author | unknown <jmiller@mysql.com> | 2006-02-27 15:09:03 +0100 |
|---|---|---|
| committer | unknown <jmiller@mysql.com> | 2006-02-27 15:09:03 +0100 |
| commit | f8bc9b3cfd4c78286003af41ca369644e844d047 (patch) | |
| tree | ea151b511abb6bc3cfe8579c6df56f75277b405c /mysql-test/include/rpl_multi_engine3.inc | |
| parent | e2393aa24a02505688aabc73fa4ebf79aeff17d9 (diff) | |
| download | mariadb-git-f8bc9b3cfd4c78286003af41ca369644e844d047.tar.gz | |
New test case fro replication between ndb and other storage engines.
mysql-test/t/rpl_ndb_2innodb.test:
New rpl ndb test case for replicating to other storage engines
mysql-test/t/rpl_ndb_2myisam.test:
New rpl ndb test case for replicating to other storage engines
mysql-test/t/rpl_ndb_2innodb-slave.opt:
New rpl ndb test supporting option files
mysql-test/t/rpl_ndb_2innodb-master.opt:
New rpl ndb test supporting option files
mysql-test/t/rpl_ndb_2myisam-master.opt:
New rpl ndb test supporting option files
mysql-test/t/rpl_ndb_2myisam-slave.opt:
New rpl ndb test supporting option files
mysql-test/t/rpl_ndb_innodb2ndb.test:
New rpl ndb test case for replicating from other storage engines to ndb
mysql-test/t/rpl_ndb_myisam2ndb.test:
New rpl ndb test case for replicating from other storage engines to ndb
mysql-test/t/rpl_ndb_innodb2ndb-master.opt:
New rpl ndb test supporting option files
mysql-test/t/rpl_ndb_innodb2ndb-slave.opt:
New rpl ndb test supporting option files
mysql-test/t/rpl_ndb_myisam2ndb-master.opt:
New rpl ndb test supporting option files
mysql-test/t/rpl_ndb_myisam2ndb-slave.opt:
New rpl ndb test supporting option files
mysql-test/extra/rpl_tests/rpl_ndb_2multi_eng.test:
New test code that drives the rpl of ndb -> innodb/myisam or innodb/myisam -> ndb
mysql-test/include/rpl_multi_engine3.inc:
New include that cover repeating code of the rpl of ndb -> innodb/myisam or innodb/myisam -> ndb
mysql-test/t/disabled.def:
Updated to include new test cases that have outstanding bug reports.
Diffstat (limited to 'mysql-test/include/rpl_multi_engine3.inc')
| -rw-r--r-- | mysql-test/include/rpl_multi_engine3.inc | 54 |
1 files changed, 54 insertions, 0 deletions
diff --git a/mysql-test/include/rpl_multi_engine3.inc b/mysql-test/include/rpl_multi_engine3.inc new file mode 100644 index 00000000000..579d1f40830 --- /dev/null +++ b/mysql-test/include/rpl_multi_engine3.inc @@ -0,0 +1,54 @@ +############################################################# +# Author: JBM +# Date: 2006-02-23 +# Purpose: To reuse through out test and make maint easier +############################################################# +connection master; +--disable_query_log +select "--- Insert into t1 --" as ""; +INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"1905-11-14"); +INSERT INTO t1 VALUES(2,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"1965-11-14"); +INSERT INTO t1 VALUES(4,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"1985-11-14"); +INSERT INTO t1 VALUES(142,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"1995-11-14"); +INSERT INTO t1 VALUES(412,1,'Testing MySQL databases is a cool ', 'Must make it bug free for the customer',654321.4321,15.21,0,1965,"2005-11-14"); +select "--- Select from t1 on master --" as ""; +--enable_query_log +select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; +sync_slave_with_master; +--disable_query_log +select "--- Select from t1 on slave --" as ""; +--enable_query_log +select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id; +connection master; +--disable_query_log +select "--- Update t1 on master --" as ""; +--enable_query_log +UPDATE t1 SET b1 = 0, t="2006-02-22" WHERE id = 412; +--disable_query_log +select "--- Check the update on master --" as ""; +--enable_query_log +SELECT id,hex(b1),vc,bc,d,f,total,y,t FROM t1 WHERE id = 412; +# Must give injector thread a little time to get update +# into the binlog other wise we will miss the update. +sleep 3; +sync_slave_with_master; +--disable_query_log +select "--- Check Update on slave --" as ""; +--enable_query_log +SELECT id,hex(b1),vc,bc,d,f,total,y,t FROM t1 WHERE id = 412; +connection master; +--disable_query_log +select "--- Remove a record from t1 on master --" as ""; +--enable_query_log +DELETE FROM t1 WHERE id = 42; +--disable_query_log +select "--- Show current count on master for t1 --" as ""; +--enable_query_log +SELECT COUNT(*) FROM t1; +sync_slave_with_master; +--disable_query_log +select "--- Show current count on slave for t1 --" as ""; +--enable_query_log +SELECT COUNT(*) FROM t1; +connection master; +DELETE FROM t1; |