16.4.1.3 Replication of CREATE TABLE ... SELECT Statements

This section discusses the rules that are applied when a CREATE TABLE ... SELECT statement is replicated.

Note

CREATE TABLE ... SELECT always performs an implicit commit (Section 13.3.3, “Statements That Cause an Implicit Commit”).

Statement succeeds.  A successful CREATE TABLE ... SELECT is itself replicated.

Statement fails.  A failed CREATE TABLE ... SELECT replicates as follows: