Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

16.4.1.17 Replication and LIMIT

Statement-based replication ofLIMIT clauses inDELETE,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 anORDER BY clause.) When such a statement is encountered:

  • When usingSTATEMENT mode, a warning that the statement is not safe for statement-based replication is now issued.

    When usingSTATEMENT 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 usingMIXED mode, the statement is now automatically replicated using row-based mode.