Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3 --source include/have_debug.inc
4
5 SET @save_debug=@@GLOBAL.INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG;
6 SET @save_scrub=@@GLOBAL.INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED;
7
8 SET GLOBAL INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED=1;
9 SET GLOBAL INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG=2;
10 let $MYSQLD_DATADIR=`select @@datadir`;
11 CREATE TABLE t1(f1 INT AUTO_INCREMENT PRIMARY KEY,
12 f2 VARCHAR(256) GENERATED ALWAYS as('repairman'),
13 INDEX idx(f2))ENGINE= InnoDB STATS_PERSISTENT=0;
14 INSERT INTO t1(f1) SELECT seq FROM seq_1_to_50;
15 FLUSH TABLE t1 FOR EXPORT;
16 let SEARCH_PATTERN= repairman;
17 let SEARCH_FILE= $MYSQLD_DATADIR/test/t1.ibd;
18 -- source include/search_pattern_in_file.inc
19 UNLOCK TABLES;
20
21 ALTER TABLE t1 DROP INDEX idx;
22 -- source include/wait_all_purged.inc
23 FLUSH TABLE t1 FOR EXPORT;
24 -- source include/search_pattern_in_file.inc
25 UNLOCK TABLES;
26 DROP TABLE t1;
27
28 --echo #
29 --echo # MDEV-37183 innodb_immediate_scrub_data_uncompressed=ON may break
30 --echo # crash recovery
31 --echo #
32 SET GLOBAL innodb_limit_optimistic_insert_debug=0;
33 # Note: MariaDB 10.6 fails to reproduce the crash; it maps DESC to ASC.
34 CREATE TABLE t(a VARCHAR(1) PRIMARY KEY,INDEX(a DESC)) ENGINE=InnoDB;
35 INSERT INTO t VALUES('2'),('1'),(''),('6'),('4'),('3');
36 SET GLOBAL innodb_limit_optimistic_insert_debug=3;
37 INSERT INTO t VALUES('8');
38 CHECK TABLE t;
39 SELECT COUNT(*) FROM t;
40 DROP TABLE t;
41
42 SET GLOBAL INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG=@save_debug;
43 SET GLOBAL INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED=@save_scrub;