Debian Codegraph @

mysql-test/suite/innodb/r/innodb_scrub.result

raw
1 CREATE TABLE t1(f1 int auto_increment primary key,
2 f2 varchar(256),
3 f3 text) engine = innodb stats_persistent=0;
4 FLUSH TABLE t1 FOR EXPORT;
5 UNLOCK TABLES;
6 FOUND 500500 /unicycle|repairman/ in t1.ibd
7 DELETE FROM t1;
8 InnoDB 0 transactions not purged
9 FLUSH TABLE t1 FOR EXPORT;
10 UNLOCK TABLES;
11 NOT FOUND /unicycle|repairman/ in t1.ibd
12 DROP TABLE t1;
13 #
14 # MDEV-30527 Assertion !m_freed_pages in mtr_t::start()
15 # on DROP TEMPORARY TABLE
16 #
17 SET @scrub= @@GLOBAL.innodb_immediate_scrub_data_uncompressed;
18 SET GLOBAL innodb_immediate_scrub_data_uncompressed= 1;
19 SET @fpt=@@GLOBAL.innodb_file_per_table;
20 SET GLOBAL innodb_file_per_table=0;
21 Warnings:
22 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
23 CREATE TABLE t ENGINE=InnoDB AS SELECT 1;
24 DROP TABLE t;
25 SET GLOBAL innodb_file_per_table=@fpt;
26 Warnings:
27 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
28 CREATE TEMPORARY TABLE tmp ENGINE=InnoDB AS SELECT 1;
29 DROP TABLE tmp;
30 SET GLOBAL INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED= @scrub;
31 # End of 10.6 tests