Statement-based replication of
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
ORDER BY clause.) Beginning with
MySQL 5.1.24, 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.