--source include/have_innodb.inc

--source include/have_debug.inc

create table t1(f1 int not null, f2 int not null,

                f3 int as (f2) virtual, index(f1),

                index(f2))engine=innodb;

insert into t1(f1, f2) values(1, 2);

set DEBUG_SYNC="innodb_inplace_alter_table_enter SIGNAL dml_start WAIT_FOR dml_finish";

send alter table t1 add index(f3), algorithm=inplace;

connect(con1,localhost,root,,,);

set DEBUG_SYNC="now WAIT_FOR dml_start";

BEGIN;

INSERT INTO t1(f1, f2) VALUES(3, 4);

UPDATE t1 SET f2= 5 WHERE f2= 4;

COMMIT;

set DEBUG_SYNC="now SIGNAL dml_finish";

disconnect con1;

connection default;

reap;

check table t1;

drop table t1;

select f3 from t1 use index(f3);

drop table t1;

set debug_sync=reset;

…

check table t1;

Table	Op	Msg_type	Msg_text

test.t1	check	Warning	InnoDB: Index 'f3' contains 3 entries, should be 2.

test.t1	check	error	Corrupt

drop table t1;

set debug_sync=reset;