--source include/have_innodb.inc --disable_abort_on_error SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' ; # Replay happens for all InnoDB ROW_FORMATs Redundant Compact Dynamic Compressed CREATE TABLE t4 ( col1 INT, col_varchar VARCHAR(500), col_text TEXT ) ENGINE = InnoDB; ALTER TABLE t4 ADD COLUMN col_text_g_copy TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)) AFTER col1 ; ALTER TABLE t4 CHANGE COLUMN col_text_g_copy col_text_G TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)) ; ALTER TABLE t4 MODIFY COLUMN col_text_g TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)) AFTER col1 ; ALTER TABLE t4 ADD COLUMN col_text_g_copy TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)) AFTER col_varchar ; ALTER TABLE t4 DROP COLUMN col_text_g ; DROP TABLE t4;