Debian Codegraph @

mysql-test/suite/innodb/r/lob-format.result

raw
1 #
2 # WL#9263 Independent compress/decompress of BLOB pages
3 #
4 set global innodb_compression_level = 0;
5 create table t1 (f1 int primary key, f2 longblob)
6 row_format=compressed, engine=innodb;
7 insert into t1 values (1, repeat('+', 40000));
8 set debug = '+d,lob_insert_single_zstream';
9 insert into t1 values (2, repeat('~', 40000));
10 set debug = '-d,lob_insert_single_zstream';
11 select f1, right(f2, 40) from t1;
12 f1 right(f2, 40)
13 1 ++++++++++++++++++++++++++++++++++++++++
14 2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
15 # Kill and restart
16 select f1, right(f2, 40) from t1;
17 f1 right(f2, 40)
18 1 ++++++++++++++++++++++++++++++++++++++++
19 2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
20 drop table t1;
21 set global innodb_compression_level = default;