Replication of LIMIT clauses in
DELETE,
UPDATE, and
INSERT ...
SELECT statements is not guaranteed, since the order
of the rows affected is not defined. Such statements can be
replicated correctly only if they also contain an ORDER
BY clause.

User Comments
Add your own comment.