--source include/have_innodb.inc --disable_abort_on_error SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' ; CREATE TABLE t4 ( col1 INT PRIMARY KEY, col2 INT, col_int2 INTEGER, col_varchar VARCHAR(500), col_text TEXT ) ENGINE = InnoDB ROW_FORMAT = Redundant ; # No replay with the other ROW_FORMATs # CREATE TABLE t4 ( col1 INT PRIMARY KEY, col2 INT, col_int2 INTEGER, col_varchar VARCHAR(500), col_text TEXT ) ENGINE = InnoDB ROW_FORMAT = Compact ; # CREATE TABLE t4 ( col1 INT PRIMARY KEY, col2 INT, col_int2 INTEGER, col_varchar VARCHAR(500), col_text TEXT ) ENGINE = InnoDB ROW_FORMAT = Compressed ; # CREATE TABLE t4 ( col1 INT PRIMARY KEY, col2 INT, col_int2 INTEGER, col_varchar VARCHAR(500), col_text TEXT ) ENGINE = InnoDB ROW_FORMAT = Dynamic ; SET @fill_amount = (@@innodb_page_size / 2 ) + 1 ; INSERT INTO t4 (col1,col2, col_int2, col_text ) VALUES ( 20, 19, 2, REPEAT(2, @fill_amount) ) ; ALTER TABLE t4 ADD COLUMN col_text_copy TEXT ; UPDATE t4 SET col_text_copy = col_text ; ALTER TABLE t4 ADD KEY ( col_text(9) ) ; UPDATE t4 SET col1 = 52 ORDER BY col1 DESC LIMIT 2 ; # Playing around with the table t1 is only for enforcing to make the DB server # "aware" of the bad state. CREATE TABLE t1 (col1 INT) ENGINE = InnoDB; DROP TABLE t1; DROP TABLE t4;