diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/sys_truncate_large.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/sys_truncate_large.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/sys_truncate_large.result b/mysql-test/suite/innodb/r/sys_truncate_large.result new file mode 100644 index 00000000..3b085ec4 --- /dev/null +++ b/mysql-test/suite/innodb/r/sys_truncate_large.result @@ -0,0 +1,22 @@ +set global innodb_file_per_table=0; +Warnings: +Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release +set global innodb_limit_optimistic_insert_debug=2; +set unique_checks=0, foreign_key_checks=0; +create table t1(f1 int not null)engine=innodb; +begin; +insert into t1 select * from seq_1_to_8192; +insert into t1 select * from seq_1_to_8192; +insert into t1 select * from seq_1_to_65536; +commit; +create table t2(f1 int not null)engine=innodb; +insert into t2 select * from seq_1_to_65536; +create table t3(f1 int not null)engine=innodb; +insert into t3 select * from seq_1_to_65536; +CREATE TABLE t4(f1 int not null)engine=innodb; +insert into t4 select * from seq_1_to_65536; +drop table t2; +drop table t4; +InnoDB 0 transactions not purged +# restart +drop table t3, t1; |