Debian Codegraph @

mysql-test/suite/innodb_zip/r/innochecksum.result

raw
1 # Set the environmental variables
2 call mtr.add_suppression("Unable to read tablespace .* page no .* into the buffer pool after 100 attempts");
3 call mtr.add_suppression("Warning: database page corruption or a failed");
4 SET GLOBAL innodb_file_per_table=on;
5 CREATE TABLE tab1(c1 INT PRIMARY KEY,c2 VARCHAR(20)) ENGINE=InnoDB;
6 CREATE INDEX idx1 ON tab1(c2(10));
7 INSERT INTO tab1 VALUES(1, 'Innochecksum InnoDB1');
8 CREATE TABLE t1(id INT AUTO_INCREMENT PRIMARY KEY, msg VARCHAR(255)) ENGINE=INNODB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
9 insert into t1 values(1,"i");
10 insert into t1 values(2,"am");
11 insert into t1 values(3,"compressed table");
12 # Shutdown the Server
13 # Server Default checksum = innodb
14 [1a]: check the innochecksum when file doesn't exists
15 Pattern "Error: MYSQLD_DATADIR/test/aa.ibd cannot be found" found
16 [1b]: check the innochecksum without --strict-check
17 [2]: check the innochecksum with full form --strict-check=crc32
18 [3]: check the innochecksum with short form -C crc32
19 [4]: check the innochecksum with --no-check ignores algorithm check, warning is expected
20 Pattern "Error: --no-check must be associated with --write option." found
21 [5]: check the innochecksum with short form --no-check ignores algorithm check, warning is expected
22 Pattern "Error: --no-check must be associated with --write option." found
23 [6]: check the innochecksum with full form strict-check & no-check , an error is expected
24 Pattern "Error: --strict-check option cannot be used together with --no-check option." found
25 [7]: check the innochecksum with short form strict-check & no-check , an error is expected
26 Pattern "Error: --strict-check option cannot be used together with --no-check option." found
27 [8]: check the innochecksum with short & full form combination
28 # strict-check & no-check, an error is expected
29 Pattern "Error: --strict-check option cannot be used together with --no-check option." found
30 [9]: check the innochecksum with full form --strict-check=innodb
31 [10]: check the innochecksum with full form --strict-check=none
32 # when server Default checksum=crc32
33 [11]: check the innochecksum with short form -C innodb
34 # when server Default checksum=crc32
35 [12]: check the innochecksum with short form -C none
36 # when server Default checksum=crc32
37 [13]: check strict-check with invalid values
38 Pattern "Error while setting value \'strict_innodb\' to \'strict-check\'" found
39 Pattern "Error while setting value \'strict_innodb\' to \'strict-check\'" found
40 Pattern "Error while setting value \'strict_crc32\' to \'strict-check\'" found
41 Pattern "Error while setting value \'strict_crc32\' to \'strict-check\'" found
42 Pattern "Error while setting value \'strict_none\' to \'strict-check\'" found
43 Pattern "Error while setting value \'strict_none\' to \'strict-check\'" found
44 Pattern "Error while setting value \'InnoBD\' to \'strict-check\'" found
45 Pattern "Error while setting value \'InnoBD\' to \'strict-check\'" found
46 Pattern "Error while setting value \'crc\' to \'strict-check\'" found
47 Pattern "Error while setting value \'no\' to \'strict-check\'" found
48 [14a]: when server default checksum=crc32 rewrite new checksum=crc32 with innochecksum
49 # Also check the long form of write option.
50 [14b]: when server default checksum=crc32 rewrite new checksum=innodb with innochecksum
51 # Also check the long form of write option.
52 # start the server with innodb_checksum_algorithm=InnoDB
53 # restart: --innodb_checksum_algorithm=innodb
54 INSERT INTO tab1 VALUES(2, 'Innochecksum CRC32');
55 SELECT c1,c2 FROM tab1 order by c1,c2;
56 c1 c2
57 1 Innochecksum InnoDB1
58 2 Innochecksum CRC32
59 # Stop the server
60 [15]: when server default checksum=crc32 rewrite new checksum=none with innochecksum
61 # Also check the short form of write option.
62 # Start the server with checksum algorithm=none
63 # restart: --innodb_checksum_algorithm=none
64 INSERT INTO tab1 VALUES(3, 'Innochecksum None');
65 SELECT c1,c2 FROM tab1 order by c1,c2;
66 c1 c2
67 1 Innochecksum InnoDB1
68 2 Innochecksum CRC32
69 3 Innochecksum None
70 DROP TABLE t1;
71 # Stop the server
72 [16]: rewrite into new checksum=crc32 with innochecksum
73 # Restart the DB server with innodb_checksum_algorithm=crc32
74 # restart: --innodb_checksum_algorithm=crc32 --innodb_file_per_table=on
75 SELECT * FROM tab1;
76 c1 c2
77 1 Innochecksum InnoDB1
78 2 Innochecksum CRC32
79 3 Innochecksum None
80 DELETE FROM tab1 where c1=3;
81 SELECT c1,c2 FROM tab1 order by c1,c2;
82 c1 c2
83 1 Innochecksum InnoDB1
84 2 Innochecksum CRC32
85 # Stop server
86 [17]: rewrite into new checksum=InnoDB
87 # Restart the DB server with innodb_checksum_algorithm=InnoDB
88 # restart: --innodb_checksum_algorithm=innodb --innodb_file_per_table=on
89 DELETE FROM tab1 where c1=2;
90 SELECT * FROM tab1;
91 c1 c2
92 1 Innochecksum InnoDB1
93 # Stop server
94 [18]:check Innochecksum with invalid write options
95 Pattern "Error while setting value \'strict_crc32\' to \'write\'" found
96 Pattern "Error while setting value \'strict_innodb\' to \'write\'" found
97 Pattern "Error while setting value \'crc23\' to \'write\'" found
98 # Restart the server
99 # restart
100 DROP TABLE tab1;
101 SET GLOBAL innodb_file_per_table=default;