--echo #
--echo # BUG#19316315 CRASH RECOVERY FAILS AFTER ONLINE ADD INDEX
--echo #

--source include/have_debug_sync.inc

CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT) ENGINE=InnoDB;

INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,4), (5,5);

connect (con1,localhost,root,,);

SET DEBUG_SYNC = 'RESET';
SET DEBUG_SYNC = 'row_log_apply_after SIGNAL apply_after WAIT_FOR insert_after';
--send
ALTER TABLE t1 ADD UNIQUE INDEX(c2);

connection default;

SET DEBUG_SYNC = 'now WAIT_FOR apply_after';
INSERT INTO t1 VALUES(6, 6);

disconnect con1;

--source include/kill_and_restart_mysqld.inc

SELECT * FROM t1;

DROP TABLE t1;

# Clean up temporary tables left by crash.
# TODO: Revisit this after WL#9536
--disable_query_log
SET SESSION debug= "+d,skip_dd_table_access_check";
DELETE FROM mysql.index_column_usage WHERE column_id IN (
  SELECT c.id FROM mysql.columns c, mysql.tables t WHERE
  c.table_id = t.id AND t.name LIKE '#sql%');
DELETE FROM mysql.columns WHERE table_id IN (
  SELECT id FROM mysql.tables WHERE name LIKE '#sql%');
DELETE FROM mysql.indexes WHERE table_id IN (
  SELECT id FROM mysql.tables WHERE name LIKE '#sql%');
DELETE FROM mysql.tables WHERE name LIKE '#sql%';
SET SESSION debug= "-d,skip_dd_table_access_check";
--enable_query_log