CREATE TABLE ... AS SELECT is not supported

[Seppo Jaakola]

CREATE TABLE ... AS SELECT does not replicate under TO isolation. And it will cause a crash at later table population phase:

120909 15:30:42 [ERROR] WSREP: FSM: no such a transition REPLICATING -> REPLICATING

[Seppo Jaakola (seppo-jaakola)]

Fix pushed in: http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3793

[Seppo Jaakola (seppo-jaakola)]

This fix caused a problem with binlog files, the create table statement does not enter binlog files. Problem reported in MariaDB project with tracker: https://mariadb.atlassian.net/browse/MDEV-544

[Seppo Jaakola (seppo-jaakola)]

fix pushed to enable binlog writes for both CREATE TABLE and following inserts: http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3804

[Seppo Jaakola (seppo-jaakola)]

There is one more issue with CREATE...SELECT and concurrent DDL as described in: https://mariadb.atlassian.net/browse/MDEV-542

To reproduce, two concurrent DDL sessions should be run:
1. CREATE TABLE t1 AS SELECT SLEEP(30);
2. drop table t1;

[Seppo Jaakola (seppo-jaakola)]

Fix pushed for interrupted CREATE..SELECT cases: http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3805

[Seppo Jaakola (seppo-jaakola)]

Current implementation could cause inconsistency between binlog files, and the fix was refactored to replicate full CTAS as one write set. Last piece of this refactoring was committed in revision: http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3806