From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann <daniel.baumann@progress-linux.org> Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org> --- mysql-test/include/rpl_multi_engine2.inc | 87 ++++++++++++++++++++++++++++++++ 1 file changed, 87 insertions(+) create mode 100644 mysql-test/include/rpl_multi_engine2.inc (limited to 'mysql-test/include/rpl_multi_engine2.inc') diff --git a/mysql-test/include/rpl_multi_engine2.inc b/mysql-test/include/rpl_multi_engine2.inc new file mode 100644 index 00000000..24154220 --- /dev/null +++ b/mysql-test/include/rpl_multi_engine2.inc @@ -0,0 +1,87 @@ +############################################################# +# Author: Rafal +# Date: 2007-08-20 +# based on rpl_multi_engine3.inc +############################################################# + +connection slave; +STOP SLAVE; +RESET SLAVE; + +connection master; +RESET MASTER; + +connection slave; +START SLAVE; + +--echo --- Populate t1 with data --- +connection master; +--disable_query_log +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"); +--enable_query_log + +--echo --- Select from t1 on master --- +select * +from t1 +order by id; + +sync_slave_with_master; +--echo --- Select from t1 on slave --- +select * +from t1 +order by id; + +--echo --- Perform basic operation on master --- +--echo --- and ensure replicated correctly --- +connection master; + +--echo --- Update t1 on master -- +UPDATE t1 SET b1 = 0, bc='updated', t="2006-02-22" +WHERE id < 100 +ORDER BY id; + +--echo --- Check the update on master --- +SELECT * +FROM t1 +WHERE id < 100 +ORDER BY id; + +# Must give injector thread a little time to get update +# into the binlog other wise we will miss the update. + +sync_slave_with_master; +--echo --- Check Update on slave --- +SELECT * +FROM t1 +WHERE id < 100 +ORDER BY id; + +connection master; +--echo --- Remove a record from t1 on master --- +DELETE FROM t1 WHERE id = 412; + +--echo --- Show current count on master for t1 --- +SELECT COUNT(*) FROM t1; + +sync_slave_with_master; +--echo --- Show current count on slave for t1 --- +SELECT COUNT(*) FROM t1; + +connection master; +TRUNCATE TABLE t1; +sync_slave_with_master; +connection master; -- cgit v1.2.3