This section discusses the rules that are applied when a
TABLE ... SELECT statement is replicated.
TABLE ... SELECT always performs an implicit commit
(Section 13.3.3, “Statements That Cause an Implicit Commit”).
CREATE TABLE ...
SELECT is itself replicated.
TABLE ... SELECT replicates as follows:
Statement does not use IF NOT EXISTS. The statement has no effect. However, the implicit commit caused by the statement is logged. This is true regardless of the storage engine used and the reason for which the statement failed.
Statement uses IF NOT EXISTS. The
CREATE TABLE IF NOT EXISTS ... SELECTis logged with an error.