15 lines
586 B
Text
15 lines
586 B
Text
--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;
|
|
|