diff options
Diffstat (limited to 'mysql-test/suite/innodb/t/temp_truncate_debug.test')
| -rw-r--r-- | mysql-test/suite/innodb/t/temp_truncate_debug.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/t/temp_truncate_debug.test b/mysql-test/suite/innodb/t/temp_truncate_debug.test new file mode 100644 index 00000000..b33ad713 --- /dev/null +++ b/mysql-test/suite/innodb/t/temp_truncate_debug.test @@ -0,0 +1,22 @@ +--source include/have_innodb.inc +--source include/have_sequence.inc +--source include/have_debug.inc + +call mtr.add_suppression("InnoDB: Cannot shrink the temporary tablespace"); +--source include/restart_mysqld.inc +SET GLOBAL INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG=2; +CREATE TEMPORARY TABLE t1(f1 INT NOT NULL, + f2 INT NOT NULL)ENGINE=InnoDB; +INSERT INTO t1 SELECT seq, seq FROM seq_1_to_65536; +DROP TABLE t1; +SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE= 4294967294; + +SET @saved_debug_dbug = @@SESSION.debug_dbug; +SET DEBUG_DBUG="+d,fail_temp_truncate"; +SET GLOBAL INNODB_TRUNCATE_TEMPORARY_TABLESPACE_NOW= 1; +SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE= 4294967294; +SET DEBUG_DBUG=@saved_debug_dbug; + +SET GLOBAL INNODB_TRUNCATE_TEMPORARY_TABLESPACE_NOW= 1; +SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE= 4294967294; +SET GLOBAL INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG=default; |