[MDEV-29198] non-deterministic functions in virtual columns unsafe for replication Created: 2022-07-28  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Replication, Virtual Columns
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s: 10.11

Type: Bug Priority: Major
Reporter: Sergei Golubchik Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-29185 RANDOM_BYTES as a virtual column func... Closed

 Description   

some functions are allowed in virtual columns and that make tables unsafe in replication. For example,

--source include/have_binlog_format_mixed.inc
--source include/master-slave.inc
reset master; 
create table t (a int, b varbinary(200) as (uuid(a)));
insert into t (a) values (1),(2);
create table t2 as select * from t;
select a, b from t2;
--sync_slave_with_master
select a, b from t2;
--connection master
show binlog events;
drop table t, t2;
--source include/rpl_end.inc


Generated at Thu Feb 08 10:06:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.