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_multi_update.test | 33 ++++++++++++++++++++++ 1 file changed, 33 insertions(+) create mode 100644 mysql-test/suite/rpl/include/rpl_multi_update.test (limited to 'mysql-test/suite/rpl/include/rpl_multi_update.test') diff --git a/mysql-test/suite/rpl/include/rpl_multi_update.test b/mysql-test/suite/rpl/include/rpl_multi_update.test new file mode 100644 index 00000000..cdbdbc19 --- /dev/null +++ b/mysql-test/suite/rpl/include/rpl_multi_update.test @@ -0,0 +1,33 @@ +source include/master-slave.inc; + +call mtr.add_suppression('Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.'); + +eval CREATE TABLE t1 ( + a int unsigned not null auto_increment primary key, + b int unsigned +) ENGINE=$engine_type; + +eval CREATE TABLE t2 ( + a int unsigned not null auto_increment primary key, + b int unsigned +) ENGINE=$engine_type; + +INSERT INTO t1 VALUES (NULL, 0); +--disable_warnings ONCE +INSERT INTO t1 SELECT NULL, 0 FROM t1; + +INSERT INTO t2 VALUES (NULL, 0), (NULL,1); + +SELECT * FROM t1 ORDER BY a; +SELECT * FROM t2 ORDER BY a; + +--disable_warnings ONCE +UPDATE t1, t2 SET t1.b = t2.b WHERE t1.a = t2.a; +sync_slave_with_master; + +# End of 4.1 tests + +connection master; +drop table t1, t2; + +--source include/rpl_end.inc -- cgit v1.2.3