Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL)
-
None
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 |
Attachments
Issue Links
- relates to
-
MDEV-29185 RANDOM_BYTES as a virtual column function makes binlog non-deterministic
- Closed