CREATE OR REPLACE not atomic for sequences (a.k.a tables with SEQUENCE=1)

create table t (a int);

create sequence s;

--error ER_SEQUENCE_INVALID_TABLE_STRUCTURE

create or replace table s sequence=1 as select * from t;

show create table s;

# Cleanup

drop table if exists t, s;

create or replace table s sequence=1 as select * from t;

ERROR HY000: Sequence 'test.t' table structure is invalid (Wrong number of columns)

show create table s;

mysqltest: At line 6: query 'show create table s' failed: ER_NO_SUCH_TABLE (1146): Table 'test.s' doesn't exist