check_constraints_myisam.test

--source include/force_myisam_default.inc
--source include/have_myisam.inc

--echo #-----------------------------------------------------------------------
--echo # Test case to verify alter operations on non-transactional SE table
--echo # with check constraints.
--echo #-----------------------------------------------------------------------
CREATE TABLE t1(f1 INT CHECK (f1 < 10)) ENGINE = myisam;
SHOW CREATE TABLE t1;
ALTER TABLE t1 ADD f2 INT, ALGORITHM=copy;
SHOW CREATE TABLE t1;
ALTER TABLE t1 ALTER f1 SET DEFAULT 10, ALGORITHM=INPLACE;
SHOW CREATE TABLE t1;
DROP TABLE t1;