Debian Codegraph @

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

raw
1 #
2 # Bug#27014083 - 8.0 CRASH RECOVERY FAILS FOR UPGRADED 5.7 COMPRESSED TABLES WITH SIZE < 96K
3 #
4 # Set different paths for --datadir
5 # Check that the file exists in the working folder.
6 # Extract 5.7 datadir
7 # These files are added to test error scenario, delete from for upgrade testing.
8 # Remove myisam partitioned tables. There are used for negative testing.
9 # start mysqld on the 5.7 datadir
10 # restart: --loose-skip-log-bin --skip-log-replica-updates --skip-replica-preserve-commit-order --datadir=MYSQLD_DATADIR1 --log-error=MYSQLD_LOG --innodb_page_size=16k
11 SELECT * FROM test.t_compressed;
12 c1 c2
13 SHOW CREATE TABLE test.t_compressed;
14 Table Create Table
15 t_compressed CREATE TABLE `t_compressed` (
16 `c1` int NOT NULL,
17 `c2` varchar(20) DEFAULT NULL,
18 PRIMARY KEY (`c1`)
19 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED
20 # Disable background threads that disturb.
21 SET GLOBAL innodb_log_checkpoint_now=ON;
22 SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
23 SET GLOBAL innodb_dict_stats_disabled_debug = 1;
24 SET GLOBAL innodb_master_thread_disabled_debug = 1;
25 INSERT INTO test.t_compressed VALUES (1, 'hello'), (2, 'hi');
26 INSERT INTO test.t_compressed VALUES (3, 'satya'), (4, 'bodapati');
27 INSERT INTO test.t_blob VALUES ('hello', 'hi', 'satya', 'bodapati');
28 INSERT INTO test.t_blob VALUES ('hi', 'hello', 'satya', 'bodapati');
29 # Kill and restart: --loose-skip-log-bin --skip-log-replica-updates --skip-replica-preserve-commit-order --datadir=MYSQLD_DATADIR1 --log-error=MYSQLD_LOG --innodb_page_size=16k
30 SELECT * FROM test.t_compressed;
31 c1 c2
32 1 hello
33 2 hi
34 3 satya
35 4 bodapati
36 SELECT * FROM test.t_blob;
37 a b c d
38 hello hi satya bodapati
39 hi hello satya bodapati
40 # Restart the server with default options.
41 # restart