Statement-based replication of LIMIT clauses
in DELETE,
UPDATE, and
INSERT ...
SELECT statements is unsafe since the order of the
rows affected is not defined. (Such statements can be replicated
correctly with statement-based replication only if they also
contain an ORDER BY clause.) When such a
statement is encountered:
When using
STATEMENTmode, a warning that the statement is not safe for statement-based replication is now issued.Currently, when using
STATEMENTmode, warnings are issued for DML statements containingLIMITeven when they also have anORDER BYclause (and so are made deterministic). This is a known issue. (Bug#42851)When using
MIXEDmode, the statement is now automatically replicated using row-based mode.