summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/t/innodb_bulk_create_index_flush.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/innodb/t/innodb_bulk_create_index_flush.test')
-rw-r--r--mysql-test/suite/innodb/t/innodb_bulk_create_index_flush.test75
1 files changed, 0 insertions, 75 deletions
diff --git a/mysql-test/suite/innodb/t/innodb_bulk_create_index_flush.test b/mysql-test/suite/innodb/t/innodb_bulk_create_index_flush.test
deleted file mode 100644
index cffca0cc773..00000000000
--- a/mysql-test/suite/innodb/t/innodb_bulk_create_index_flush.test
+++ /dev/null
@@ -1,75 +0,0 @@
-#
-# 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;