Debian Codegraph @

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

raw
1 CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB STATS_PERSISTENT=0;
2 SET GLOBAL innodb_log_checkpoint_now=ON;
3 FLUSH TABLE t1 FOR EXPORT;
4 UNLOCK TABLES;
5 INSERT INTO t1 SET a=1;
6 FLUSH TABLE t1 FOR EXPORT;
7 UNLOCK TABLES;
8 # Skip InnoDB Doublewrite Buffer
9 Should not exist when summary excludes dblwr pages
10 Should exist when summary includes dblwr pages
11 # restart
12 CREATE TABLE ibd_1(f1 INT PRIMARY KEY)ENGINE=InnoDB;
13 INSERT INTO ibd_1 VALUES(1), (2), (3), (4);
14 SET GLOBAL innodb_file_per_table=0;
15 CREATE TABLE ibd_2(f1 INT PRIMARY KEY)ENGINE=InnoDB;
16 INSERT INTO ibd_2 SELECT seq FROM seq_1_to_8451;
17 # Pass wrong tablespace flag for ibdata2
18 FOUND 1 /Error: Page 0 checksum mismatch/ in result.log
19 # Pass wrong tablespace flag for ibdata1
20 FOUND 1 /Error: Mismatch between provided tablespace flags/ in result.log
21 # Pass invalid tablespace flag for ibdata1
22 FOUND 1 /Error: Provided --tablespace-flags is not valid/ in result.log
23 # innochecksum should be succesfull
24 NOT FOUND /Fail/ in result.log
25 # Create a tablespace with page number > 2^31
26 # Test innochecksum with the modified ibdata3
27 FOUND 1 /Error: First page of the tablespace file should be 0, but encountered page number 2147483649/ in result.log
28 # Test innochecksum with the modified ibdata3 with tablespace flags
29 FOUND 1 /Exceeded the maximum allowed checksum mismatch/ in result.log
30 # restart
31 DROP TABLE t1, ibd_1, ibd_2;