mariadb/storage/tokudb/mysql-test/tokudb_mariadb/t/alter.test
2013-09-09 13:59:38 +02:00

16 lines
379 B
Text

create table t1 (i int) engine=TokuDB;
insert t1 values (1);
alter table t1 add column j int default '0';
select * from t1;
show create table t1;
alter table t1 modify i int default '1';
select * from t1;
show create table t1;
alter table t1 modify j int default '2', rename t2;
--error ER_NO_SUCH_TABLE
select * from t1;
select * from t2;
show create table t2;
drop table t2;