1
CREATE TABLE t1 (a int) ENGINE=INNODB ROW_FORMAT=COMPRESSED;
2
CREATE TABLE t2 (a int) ENGINE=INNODB ROW_FORMAT=COMPACT;
3
CREATE TABLE t3 (a int) ENGINE=INNODB ROW_FORMAT=DYNAMIC;
4
CREATE TABLE t4 (a int) ENGINE=INNODB ROW_FORMAT=REDUNDANT;
5
CREATE TABLE t5 (a int) ENGINE=INNODB;
6
SELECT haildb_datadict_dump();
8
HailDB Data Dictionary Contents
9
-------------------------------
10
SYS_FOREIGN Format: REDUNDANT Page size: 0 Columns: 7 Indexes: 3
24
SYS_FOREIGN_COLS Format: REDUNDANT Page size: 0 Columns: 7 Indexes: 1
35
data_dictionary/haildb_table_definitions Format: COMPACT Page size: 0 Columns: 5 Indexes: 1
43
test/t1 Format: COMPRESSED Page size: 8192 Columns: 5 Indexes: 1
45
COL: hidden_primary_key_col
50
IDXCOL: hidden_primary_key_col
51
test/t2 Format: COMPACT Page size: 0 Columns: 5 Indexes: 1
53
COL: hidden_primary_key_col
58
IDXCOL: hidden_primary_key_col
59
test/t3 Format: DYNAMIC Page size: 0 Columns: 5 Indexes: 1
61
COL: hidden_primary_key_col
66
IDXCOL: hidden_primary_key_col
67
test/t4 Format: REDUNDANT Page size: 0 Columns: 5 Indexes: 1
69
COL: hidden_primary_key_col
74
IDXCOL: hidden_primary_key_col
75
test/t5 Format: COMPACT Page size: 0 Columns: 5 Indexes: 1
77
COL: hidden_primary_key_col
82
IDXCOL: hidden_primary_key_col
84
DROP TABLE t1, t2, t3, t4, t5;