Debian Codegraph @

mysql-test/suite/rpl/r/rbr_lsu_off.result

raw
1 include/master-slave.inc
2 [connection master]
3 #
4 # MDEV-33957 UPDATE fails on replica replicating blob virtual column in
5 # NOBLOB mode when replica logging is off
6 #
7 connection slave;
8 select @@log_slave_updates;
9 @@log_slave_updates
10 0
11 connection master;
12 set binlog_row_image= 'NOBLOB';
13 create table t (
14 c int primary key, d int,
15 i blob generated always as (c), key k(i)) engine=innodb;
16 Warnings:
17 Note 1071 Specified key was too long; max key length is 3072 bytes
18 insert into t (c) values (1);
19 update t set d= 0;
20 connection slave;
21 connection master;
22 drop table t;
23 create table t (
24 c int primary key, d int,
25 i blob generated always as (c), key k(i)) engine=innodb
26 partition by key (c) partitions 2;
27 Warnings:
28 Note 1071 Specified key was too long; max key length is 3072 bytes
29 insert into t (c) values (1);
30 update t set d= 0;
31 connection slave;
32 connection master;
33 drop table t;
34 include/rpl_end.inc