However, one may encounter difficulties when replicating from an
older master to a newer slave if the master uses statements or
relies on behavior no longer supported in the version of MySQL
used on the slave. For example, in MySQL 5.5,
CREATE TABLE
... SELECT statements are permitted to change tables
other than the one being created, but are no longer allowed to do
so in MySQL 5.6 (see
Section 16.4.1.4, “Replication of
CREATE
TABLE ... SELECT Statements”).