The session variable SQL_MODE when set to include ALLOW_INVALID_DATES does not apply statements correctly on the slave.
Last Updated: 2013-07-17
Condition or Error
Replication fails due to an incorrect SQL mode,
applied for a specific transaction.
In affected versions, these statements can be bypassed by
explicitly ignoring that value in the event by editing
to include the following property line: