[MDEV-29772] CREATE OR REPLACE not atomic for sequences (a.k.a tables with SEQUENCE=1) - Jira

XML

Word

Printable

This may be an expected limitation, in this case specify it for further documentation and feel free to close as not-a-bug or wont-fix.

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;

bb-10.11-midenok 8e82c973eeb
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

Note: While reproducing/modifying the test case, be careful not to hit ~~MDEV-29771~~.

is caused by

MDEV-25292 Atomic CREATE OR REPLACE TABLE

relates to

MDEV-29798 Document atomic CREATE OR REPLACE