MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
It is possible for the data on the source and replica to become
different if a statement is written in such a way that the data
modification is nondeterministic; that is, left up the query
optimizer. (In general, this is not a good practice, even
outside of replication.) Examples of nondeterministic statements
include DELETE
or
UPDATE
statements that use
LIMIT
with no ORDER BY
clause; see Section 19.5.1.18, “Replication and LIMIT”, for a
detailed discussion of these.