18.104.22.168 Replication and LIMIT
Statement-based replication of
LIMIT clauses in
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:
STATEMENTmode, a warning that the statement is not safe for statement-based replication is now issued.
STATEMENTmode, warnings are issued for DML statements containing
LIMITeven when they also have an
ORDER BYclause (and so are made deterministic). This is a known issue. (Bug #42851)
MIXEDmode, the statement is now automatically replicated using row-based mode.