Debian Codegraph @

mysql-test/suite/innodb/t/innodb_scrub.test

raw
1 -- source include/have_innodb.inc
2 -- source include/no_valgrind_without_big.inc
3
4 let $MYSQLD_DATADIR=`select @@datadir`;
5 CREATE TABLE t1(f1 int auto_increment primary key,
6 f2 varchar(256),
7 f3 text) engine = innodb stats_persistent=0;
8 let $numinserts = 500;
9 --disable_query_log
10 begin;
11 while ($numinserts)
12 {
13 dec $numinserts;
14 eval INSERT INTO t1(f2,f3) VALUES ('repairman', repeat('unicycle', 1000));
15 }
16 commit;
17 --enable_query_log
18 FLUSH TABLE t1 FOR EXPORT;
19 UNLOCK TABLES;
20
21 let SEARCH_PATTERN= unicycle|repairman;
22 let SEARCH_FILE= $MYSQLD_DATADIR/test/t1.ibd;
23 -- source include/search_pattern_in_file.inc
24 DELETE FROM t1;
25 -- source include/wait_all_purged.inc
26 FLUSH TABLE t1 FOR EXPORT;
27 UNLOCK TABLES;
28 -- source include/search_pattern_in_file.inc
29 DROP TABLE t1;
30
31 --echo #
32 --echo # MDEV-30527 Assertion !m_freed_pages in mtr_t::start()
33 --echo # on DROP TEMPORARY TABLE
34 --echo #
35 SET @scrub= @@GLOBAL.innodb_immediate_scrub_data_uncompressed;
36 SET GLOBAL innodb_immediate_scrub_data_uncompressed= 1;
37 SET @fpt=@@GLOBAL.innodb_file_per_table;
38 SET GLOBAL innodb_file_per_table=0;
39 CREATE TABLE t ENGINE=InnoDB AS SELECT 1;
40 DROP TABLE t;
41 SET GLOBAL innodb_file_per_table=@fpt;
42 CREATE TEMPORARY TABLE tmp ENGINE=InnoDB AS SELECT 1;
43 DROP TABLE tmp;
44 SET GLOBAL INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED= @scrub;
45 --echo # End of 10.6 tests