MySQL :: MySQL 8.4 Reference Manual :: 19.5.1.18 Replication and LIMIT (original) (raw)

The world's most popular open source database

19.5.1.18 Replication and LIMIT

Statement-based replication of LIMIT clauses in DELETE,UPDATE, andINSERT ... 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 containingLIMIT even when they also have anORDER 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.