EVOLUTION-MANAGER

Edit File: alter_table_disable_keys_updating.result

DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( c1 int NOT NULL, c2 text NOT NULL, c3 int NOT NULL, c4 int NOT NULL, PRIMARY KEY(c1), KEY idx1(c3,c4), FULLTEXT KEY ft1(c2) ) COMMENT='ENGINE "MyISAM"' DEFAULT CHARSET=utf8; INSERT INTO t1 VALUES(1, 'test1', 1, 1); INSERT INTO t1 VALUES(2, 'test2', 2, 2); INSERT INTO t1 VALUES(3, 'test3', 1, 3); ALTER TABLE t1 DISABLE KEYS; DELETE FROM t1 WHERE c1 = 2; UPDATE t1 SET c4 = 4 WHERE c1 = 1; INSERT INTO t1 VALUES(4, 'test4', 2, 4); TRUNCATE t1; DROP TABLE t1;