MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
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 STATEMENT mode, a warning that
the statement is not safe for statement-based replication is
now issued.
When using STATEMENT mode, warnings are
issued for DML statements containing
LIMIT even when they also have an
ORDER BY clause (and so are made
deterministic). This is a known issue. (Bug #42851)
When using MIXED mode, the statement is
now automatically replicated using row-based mode.