summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorunknown <aelkin@dl145j.mysql.com>2007-10-30 14:08:37 +0100
committerunknown <aelkin@dl145j.mysql.com>2007-10-30 14:08:37 +0100
commitfcff3b5a8d5db3ff0c8f9b3cbfc5645c81ca4c48 (patch)
tree713e32d3e1e791c28aaf08fcb201d4637548b87e /mysql-test/r
parent356bdcb7c47e9fc848281687f725b1783194594a (diff)
downloadmariadb-git-fcff3b5a8d5db3ff0c8f9b3cbfc5645c81ca4c48.tar.gz
manual merge
BitKeeper/deleted/.del-rpl_slave_skip-slave.opt: Delete: mysql-test/t/rpl_slave_skip-slave.opt BitKeeper/deleted/.del-rpl_slave_skip.test: Delete: mysql-test/t/rpl_slave_skip.test BitKeeper/deleted/.del-rpl_slave_skip.result: Delete: mysql-test/r/rpl_slave_skip.result
Diffstat (limited to 'mysql-test/r')
-rw-r--r--mysql-test/r/rpl_slave_skip.result144
1 files changed, 0 insertions, 144 deletions
diff --git a/mysql-test/r/rpl_slave_skip.result b/mysql-test/r/rpl_slave_skip.result
deleted file mode 100644
index a59ac3eb884..00000000000
--- a/mysql-test/r/rpl_slave_skip.result
+++ /dev/null
@@ -1,144 +0,0 @@
-stop slave;
-drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
-reset master;
-reset slave;
-drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
-start slave;
-**** On Master ****
-CREATE TABLE t1 (a INT, b SET('master','slave')) ENGINE=INNODB;
-CREATE TABLE t2 (a INT, b SET('master','slave')) ENGINE=MYISAM;
-==== Skipping normal transactions ====
-**** On Slave ****
-STOP SLAVE;
-**** On Master ****
-BEGIN;
-INSERT INTO t1 VALUES (1, 'master');
-INSERT INTO t1 VALUES (2, 'master');
-INSERT INTO t1 VALUES (3, 'master');
-COMMIT;
-BEGIN;
-INSERT INTO t1 VALUES (4, 'master,slave');
-INSERT INTO t1 VALUES (5, 'master,slave');
-INSERT INTO t1 VALUES (6, 'master,slave');
-COMMIT;
-SELECT * FROM t1 ORDER BY a;
-a b
-1 master
-2 master
-3 master
-4 master,slave
-5 master,slave
-6 master,slave
-**** On Slave ****
-SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;
-START SLAVE;
-SELECT * FROM t1 ORDER BY a;
-a b
-4 master,slave
-5 master,slave
-6 master,slave
-**** On Master ****
-DELETE FROM t1;
-==== Skipping two normal transactions ====
-**** On Slave ****
-STOP SLAVE;
-**** On Master ****
-BEGIN;
-INSERT INTO t1 VALUES (1, 'master');
-INSERT INTO t1 VALUES (2, 'master');
-INSERT INTO t1 VALUES (3, 'master');
-COMMIT;
-BEGIN;
-INSERT INTO t1 VALUES (4, 'master');
-INSERT INTO t1 VALUES (5, 'master');
-INSERT INTO t1 VALUES (6, 'master');
-COMMIT;
-BEGIN;
-INSERT INTO t1 VALUES (7, 'master,slave');
-INSERT INTO t1 VALUES (8, 'master,slave');
-INSERT INTO t1 VALUES (9, 'master,slave');
-COMMIT;
-SELECT * FROM t1 ORDER BY a;
-a b
-1 master
-2 master
-3 master
-4 master
-5 master
-6 master
-7 master,slave
-8 master,slave
-9 master,slave
-**** On Slave ****
-SET GLOBAL SQL_SLAVE_SKIP_COUNTER=8;
-START SLAVE;
-SELECT * FROM t1 ORDER BY a;
-a b
-7 master,slave
-8 master,slave
-9 master,slave
-**** On Master ****
-DELETE FROM t1;
-==== Skipping without autocommit ====
-**** On Slave ****
-STOP SLAVE;
-**** On Master ****
-SET AUTOCOMMIT=0;
-INSERT INTO t1 VALUES (1, 'master');
-INSERT INTO t1 VALUES (2, 'master');
-INSERT INTO t1 VALUES (3, 'master');
-COMMIT;
-INSERT INTO t1 VALUES (4, 'master,slave');
-INSERT INTO t1 VALUES (5, 'master,slave');
-INSERT INTO t1 VALUES (6, 'master,slave');
-COMMIT;
-SELECT * FROM t1 ORDER BY a;
-a b
-1 master
-2 master
-3 master
-4 master,slave
-5 master,slave
-6 master,slave
-**** On Slave ****
-SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;
-START SLAVE;
-SELECT * FROM t1 ORDER BY a;
-a b
-4 master,slave
-5 master,slave
-6 master,slave
-==== Rollback of transaction with non-transactional change ====
-**** On Master ****
-DELETE FROM t1;
-SET AUTOCOMMIT=1;
-**** On Slave ****
-STOP SLAVE;
-**** On Master ****
-BEGIN;
-INSERT INTO t1 VALUES (1, '');
-INSERT INTO t2 VALUES (2, 'master');
-INSERT INTO t1 VALUES (3, '');
-ROLLBACK;
-BEGIN;
-INSERT INTO t1 VALUES (4, '');
-INSERT INTO t2 VALUES (5, 'master,slave');
-INSERT INTO t1 VALUES (6, '');
-ROLLBACK;
-SELECT * FROM t1 ORDER BY a;
-a b
-SELECT * FROM t2 ORDER BY a;
-a b
-2 master
-5 master,slave
-**** On Slave ****
-SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;
-START SLAVE;
-SELECT * FROM t1 ORDER BY a;
-a b
-SELECT * FROM t2 ORDER BY a;
-a b
-5 master,slave
-==== Cleanup ====
-**** On Master ****
-DROP TABLE t1, t2;