summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/long_unique_bugs_replication.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/long_unique_bugs_replication.result')
-rw-r--r--mysql-test/main/long_unique_bugs_replication.result29
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/main/long_unique_bugs_replication.result b/mysql-test/main/long_unique_bugs_replication.result
new file mode 100644
index 00000000..39b0ebe2
--- /dev/null
+++ b/mysql-test/main/long_unique_bugs_replication.result
@@ -0,0 +1,29 @@
+#
+# MDEV-22722 Assertion "inited==NONE" failed in handler::ha_index_init on the slave during UPDATE
+#
+include/master-slave.inc
+[connection master]
+create table t1 (i1 int, a1 text, unique key i1 (a1)) engine=myisam;
+insert into t1 values (1,1);
+insert into t1 values (2,2);
+update t1 set a1 = 'd' limit 1;
+update t1 set a1 = 'd2' where i1= 2;
+connection slave;
+connection master;
+drop table t1;
+#
+# MDEV-32093 long uniques break old->new replication
+#
+connection slave;
+create table t1 (id int not null, b1 varchar(255) not null, b2 varchar(2550) not null, unique (id), unique key (b1,b2) using hash) default charset utf8mb3;
+set global slave_exec_mode=idempotent;
+binlog 'aRf2ZA8BAAAA/AAAAAABAAAAAAQAMTAuNS4xNS1NYXJpYURCLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABpF/ZkEzgNAAgAEgAEBAQEEgAA5AAEGggAAAAICAgCAAAACgoKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEwQADQgICAoKCgFRmTlk';
+binlog 'bBf2ZBMBAAAANAAAAJgHAAAAAHEAAAAAAAEABHRlc3QAAnQxAAQDDw8IBP0C4h0AeqMD4A==bBf2ZBcBAAAANAAAAMwHAAAAAHEAAAAAAAEABP/wj6QAAAEAYgEAZa6/VU0JAAAANteqUw==';
+binlog 'bBf2ZBMBAAAANAAAAJgHAAAAAHEAAAAAAAEABHRlc3QAAnQxAAQDDw8IBP0C4h0AeqMD4A==bBf2ZBcBAAAANAAAAMwHAAAAAHEAAAAAAAEABP/wj6QAAAEAYgEAZa6/VU0JAAAANteqUw==';
+binlog 'bBf2ZBMBAAAANAAAAHUkAAAAAHEAAAAAAAEABHRlc3QAAnQxAAQDDw8IBP0C4h0AaTGFIg==bBf2ZBgBAAAASAAAAL0kAAAAAHEAAAAAAAEABP//8I+kAAABAGIBAGWuv1VNCQAAAPBuWwAAAQBiAQBlrr9VTQkAAADxS9Lu';
+drop table t1;
+set global slave_exec_mode=default;
+#
+# End of 10.4 tests
+#
+include/rpl_end.inc