--source include/have_innodb.inc

CREATE TABLE IF NOT EXISTS t4 ( col1 INT, col2 INT, col_int INTEGER, col_string INTEGER, col_varchar VARCHAR(500), col_text TEXT ) ENGINE = InnoDB ROW_FORMAT = REDUNDANT;

ALTER TABLE t4 ADD PRIMARY KEY ( col_text(9), col_int );

ALTER TABLE t4 ADD COLUMN col_int_copy INTEGER;

ALTER TABLE t4 DROP PRIMARY KEY;

ALTER TABLE t4 ADD COLUMN col_text_copy TEXT;

ALTER TABLE t4 ADD PRIMARY KEY ( col_text(9), col_int );

ALTER TABLE t4 ADD COLUMN col_inTcol_int INTEGER;

ALTER TABLE t4 DROP PRIMARY KEY;

ALTER TABLE t4 ADD COLUMN col_texTcol_text TEXT;

ALTER TABLE t4 ADD PRIMARY KEY ( col_text(9), col_int );

ALTER TABLE t4 DROP PRIMARY KEY;

ALTER TABLE t4 MODIFY COLUMN col_text TEXT;

set DEBUG_SYNC="innodb_inplace_alter_table_enter SIGNAL alter_phase WAIT_FOR alter_finish";

--send ALTER TABLE t4 ADD PRIMARY KEY ( col_text(9), col_int )

connect(con1,localhost,root,,);

set DEBUG_SYNC="now WAIT_FOR alter_phase";

begin;

INSERT INTO t4 (col1,col2, col_int, col_string, col_text) VALUES ( 1, 1, 0, REPEAT(SUBSTR(CAST( 1 AS CHAR),1,1), 10), REPEAT(SUBSTR(CAST( 1 AS CHAR),1,1), 10000) );

rollback;

set DEBUG_SYNC="now SIGNAL alter_finish";

connection default;

reap;

disconnect con1;

select * from t4;

drop table t4;

set debug_sync=reset;