--source include/have_innodb.inc SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' ; # No SEGV with Compressed # CREATE TABLE t1 ( col1 INT PRIMARY KEY, col_text TEXT, col1_g INTEGER GENERATED ALWAYS AS (col1) ) ENGINE = InnoDB ROW_FORMAT = Compressed ; # but with Redundant , Dynamic and Compact. CREATE TABLE t1 ( col1 INT PRIMARY KEY, col_text TEXT, col1_g INTEGER GENERATED ALWAYS AS (col1) ) ENGINE = InnoDB ROW_FORMAT = Dynamic ; ALTER TABLE t1 MODIFY COLUMN col_text TEXT FIRST ; INSERT INTO t1 (col1, col_text ) VALUES ( 1475, 'AAA' ); ALTER TABLE t1 ADD UNIQUE INDEX ( col1_g ) ; DROP TABLE t1;