Debian Codegraph @

mysql-test/suite/maria/aria_pack_mdev14183.result

raw
1 CREATE TABLE `t` (
2 `col_1` varchar(255) NOT NULL DEFAULT '',
3 `col_2` varchar(255) NOT NULL,
4 `col_3` int(11) NOT NULL DEFAULT '0',
5 `col_4` int(11) NOT NULL DEFAULT '0'
6 ) ENGINE=Aria TRANSACTIONAL=0 PAGE_CHECKSUM=0;
7 insert into t values
8 ('foobar','qux',0,0),('abcdef','qux',0,0);
9 Compressing test/t.MAD: (2 records)
10 - Calculating statistics
11
12 normal: 0 empty-space: 0 empty-zero: 0 empty-fill: 0
13 pre-space: 0 end-space: 0 intervall-fields: 0 zero: 2
14 Original trees: 4 After join: 1
15 - Compressing file
16 Min record length: 5 Max length: 5 Mean total length: 35
17 99.57%
18 # restart
19 SELECT * FROM t;
20 col_1 col_2 col_3 col_4
21 foobar qux 0 0
22 abcdef qux 0 0
23 DROP TABLE t;