From 06eaf7232e9a920468c0f8d74dcf2fe8b555501c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 14:24:36 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/suite/rpl/include/rpl_blackhole.test | 30 +++++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 mysql-test/suite/rpl/include/rpl_blackhole.test (limited to 'mysql-test/suite/rpl/include/rpl_blackhole.test') diff --git a/mysql-test/suite/rpl/include/rpl_blackhole.test b/mysql-test/suite/rpl/include/rpl_blackhole.test new file mode 100644 index 00000000..6e7102b4 --- /dev/null +++ b/mysql-test/suite/rpl/include/rpl_blackhole.test @@ -0,0 +1,30 @@ +# Check replication of one statement assuming that the engine on the +# slave is a blackhole engine. + +# Input: +# $statement Statement to evaluate, it is assumed to change t1 + +# 1. Evaluate statement on master, it is assumed to change t1 +# 2. Wait for statement to be processed on slave +# 3. SELECT from table t1 to see what was written +# 4. Compare position on slave before executing statement and after +# executing statement. If difference is >0, then something was +# written to the binary log on the slave. + +# On Connection Slave +let $before = query_get_value("SHOW MASTER STATUS", Position, 1); + +connection master; +eval $statement; + +sync_slave_with_master; +--echo # Expect 0 +SELECT COUNT(*) FROM t1; +let $after = query_get_value("SHOW MASTER STATUS", Position, 1); +let $something_written = `select $after - $before != 0`; +if ($something_written) { + --echo >>> Something was written to binary log <<< +} +if (!$something_written) { + --echo >>> Nothing was written to binary log <<< +} -- cgit v1.2.3