Debian Codegraph @

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

raw
1 SET @save_algorithm = @@GLOBAL.innodb_compression_algorithm;
2 create table innodb_normal (c1 int not null auto_increment primary key, b char(200)) engine=innodb;
3 create table innodb_page_compressed1 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=1;
4 create table innodb_page_compressed2 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=2;
5 create table innodb_page_compressed3 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=3;
6 create table innodb_page_compressed4 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=4;
7 create table innodb_page_compressed5 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=5;
8 create table innodb_page_compressed6 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=6;
9 create table innodb_page_compressed7 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=7;
10 create table innodb_page_compressed8 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=8;
11 create table innodb_page_compressed9 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=9;
12 connect prevent_purge,localhost,root;
13 START TRANSACTION WITH CONSISTENT SNAPSHOT;
14 connection default;
15 begin;
16 insert into innodb_normal SET b=REPEAT('Aa',50);
17 insert into innodb_page_compressed1 SET b=REPEAT('Aa',50);
18 insert into innodb_page_compressed2 SET b=REPEAT('Aa',50);
19 insert into innodb_page_compressed3 SET b=REPEAT('Aa',50);
20 insert into innodb_page_compressed4 SET b=REPEAT('Aa',50);
21 insert into innodb_page_compressed5 SET b=REPEAT('Aa',50);
22 insert into innodb_page_compressed6 SET b=REPEAT('Aa',50);
23 insert into innodb_page_compressed7 SET b=REPEAT('Aa',50);
24 insert into innodb_page_compressed8 SET b=REPEAT('Aa',50);
25 insert into innodb_page_compressed9 SET b=REPEAT('Aa',50);
26 commit;
27 FLUSH TABLES innodb_normal,
28 innodb_page_compressed1, innodb_page_compressed2, innodb_page_compressed3,
29 innodb_page_compressed4, innodb_page_compressed5, innodb_page_compressed6,
30 innodb_page_compressed7, innodb_page_compressed8, innodb_page_compressed9
31 FOR EXPORT;
32 FOUND 12 /AaAaAaAa/ in innodb_normal.ibd
33 NOT FOUND /AaAaAaAa/ in innodb_page_compressed1.ibd
34 NOT FOUND /AaAaAaAa/ in innodb_page_compressed2.ibd
35 NOT FOUND /AaAaAaAa/ in innodb_page_compressed3.ibd
36 NOT FOUND /AaAaAaAa/ in innodb_page_compressed4.ibd
37 NOT FOUND /AaAaAaAa/ in innodb_page_compressed5.ibd
38 NOT FOUND /AaAaAaAa/ in innodb_page_compressed6.ibd
39 NOT FOUND /AaAaAaAa/ in innodb_page_compressed7.ibd
40 NOT FOUND /AaAaAaAa/ in innodb_page_compressed8.ibd
41 NOT FOUND /AaAaAaAa/ in innodb_page_compressed9.ibd
42 UNLOCK TABLES;
43 drop table innodb_normal;
44 drop table innodb_page_compressed1;
45 drop table innodb_page_compressed2;
46 drop table innodb_page_compressed3;
47 drop table innodb_page_compressed4;
48 drop table innodb_page_compressed5;
49 drop table innodb_page_compressed6;
50 drop table innodb_page_compressed7;
51 drop table innodb_page_compressed8;
52 drop table innodb_page_compressed9;
53 SET GLOBAL innodb_compression_algorithm=@save_algorithm;