Documentation Home
MySQL 9.3 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 261.1Kb
Man Pages (Zip) - 368.3Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


19.5.1.19 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.