Debian Codegraph @

mysql-test/suite/rpl/t/rpl_row_record_find_myisam.test

raw
1 --source include/not_group_replication_plugin.inc
2 source include/have_binlog_format_row.inc;
3 source include/master-slave.inc;
4
5 #
6 # BUG#40045: Replication failure on RBR + no PK + UPDATE + integer key + char
7 # with no key
8 #
9 connection master;
10 CREATE TABLE t1 ( i1 int, c1 char(1), key ( i1 ));
11 INSERT IGNORE INTO t1 VALUES (1, 'a');
12 UPDATE t1 SET c1 = 'b' WHERE i1 = 1;
13 DROP TABLE t1;
14 --source include/sync_slave_sql_with_master.inc
15
16 #
17 # BUG#40007: Replication failure with RBR + no PK + 2 indexed fields
18 #
19 connection master;
20 CREATE TABLE table1_myisam ( `bit_key` bit, `int_key` int, key (`bit_key` ), key (`int_key` ));
21 disable_warnings;
22 INSERT IGNORE INTO table1_myisam VALUES ('1', '-2146992385');
23 enable_warnings;
24 UPDATE `table1_myisam` SET `bit_key` = 0 WHERE `bit_key` = 1;
25 DROP TABLE table1_myisam;
26
27 --source include/rpl_end.inc