summaryrefslogtreecommitdiff
path: root/mysql-test/main/check_constraint_innodb.result
blob: 4b412491204af985f874ccae328906fedfb8239a (plain)
1
2
3
4
5
6
7
8
9
create table t1 (a int, b smallint) engine=innodb;
connect con1,localhost,root,,test;
alter table t1 add constraint check (b < 8);
alter table t1 modify column b int, algorithm=inplace;
ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
connection default;
alter table t1 add primary key (a);
drop table t1;
disconnect con1;