EVOLUTION-MANAGER

Edit File: innodb_bulk_create_index_flush.test

#
# Test flush on error in bulk load to make sure we do a proper cleanup.
# Note: We flush all dirty pages before applying any online log in bulk load.
#

-- source include/have_innodb.inc
-- source include/have_debug.inc

# Create Insert Procedure
DELIMITER |;
CREATE PROCEDURE populate_t1()
BEGIN
	DECLARE i int DEFAULT 1;

START TRANSACTION;
	WHILE (i <= 10000) DO
		INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
		SET i = i + 1;
	END WHILE;
	COMMIT;
END|
DELIMITER ;|

CREATE TABLE t1(
	class	INT,
	id	INT,
	title	VARCHAR(100)
) ENGINE=InnoDB;

-- disable_query_log
CALL populate_t1();
-- enable_query_log

SELECT COUNT(*) FROM t1;

SET @saved_dbug= @@SESSION.debug_dbug;
SET debug_dbug='+d,ib_index_build_fail_before_flush';

-- error ER_QUERY_INTERRUPTED
CREATE INDEX idx_id ON t1(id);

CHECK TABLE t1;

-- error ER_QUERY_INTERRUPTED
CREATE INDEX idx_title ON t1(title);

CHECK TABLE t1;

-- error ER_QUERY_INTERRUPTED
CREATE FULLTEXT INDEX fidx_title ON t1(title);

CHECK TABLE t1;

-- error ER_QUERY_INTERRUPTED
ALTER TABLE t1 ADD COLUMN content TEXT, FORCE;

CHECK TABLE t1;

SET debug_dbug= @saved_dbug;

INSERT INTO t1 VALUES(10001, 10001, 'a10000');

-- error ER_DUP_ENTRY
ALTER TABLE t1 ADD UNIQUE INDEX idx_title(title);

CHECK TABLE t1;

-- error ER_DUP_ENTRY
ALTER TABLE t1 ADD UNIQUE INDEX idx_id(id), ADD UNIQUE INDEX idx_title(title);

CHECK TABLE t1;

DROP TABLE t1;

DROP PROCEDURE populate_t1;