3
# Standard HEAP table with 2 indexes
4
CREATE TABLE heap_standard ( f1 VARCHAR(32) NOT NULL, f2 VARCHAR(64) , f3 VARCHAR(1024), f4 VARCHAR(1024) NOT NULL, PRIMARY KEY (f1) , KEY (f2) ) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=99;
7
CREATE TABLE heap_oversize_pk ( f1 VARCHAR(1000) NOT NULL, f2 VARCHAR(64), f3 VARCHAR(1024), f4 VARCHAR(1024) NOT NULL, PRIMARY KEY (f1) ) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=1027;
9
# Very small KEY_BLOCK_SIZE
10
CREATE TABLE heap_small_block ( f1 VARCHAR(1) NOT NULL, f2 VARCHAR(1024), f3 VARCHAR(1024), f4 VARCHAR(1024) NOT NULL, PRIMARY KEY (f1) ) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=5;
12
# Very large KEY_BLOCK_SIZE
13
CREATE TABLE heap_large_block ( f1 VARCHAR(1000) NOT NULL, f2 VARCHAR(1024), f3 VARCHAR(1024), f4 VARCHAR(1024) NOT NULL, PRIMARY KEY (f1) ) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=65535;
16
CREATE TABLE heap_complex_indexes ( f1 VARCHAR(32) NOT NULL, f2 VARCHAR(32) NOT NULL, f3 VARCHAR(32), f4 VARCHAR(32), PRIMARY KEY (f1, f2), KEY (f2, f3) , UNIQUE (f3, f4)) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=134;
18
# Complex hash indexes
19
CREATE TABLE heap_complex_indexes_hash ( f1 VARCHAR(32) NOT NULL, f2 VARCHAR(32) NOT NULL, f3 VARCHAR(32), f4 VARCHAR(32), PRIMARY KEY (f1, f2) USING HASH , KEY (f2, f3) USING HASH , UNIQUE (f3, f4) USING HASH ) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=134;
21
# No indexes at all, small records # Due to bug 784468 , we can not use VARCHAR(2) or similar
22
CREATE TABLE heap_noindexes_small ( f1 VARCHAR(31), f2 VARCHAR(31), f3 VARCHAR(31), f4 VARCHAR(31) NOT NULL) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=1024;
24
# No indexes at all, large records
25
CREATE TABLE heap_noindexes_large ( f1 VARCHAR(1024), f2 VARCHAR(1024), f3 VARCHAR(1024), f4 VARCHAR(1024) NOT NULL) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=128;
28
CREATE TABLE heap_blobs ( f1 VARCHAR(32) NOT NULL, f2 VARCHAR(64), f3 BLOB, f4 TEXT NOT NULL, PRIMARY KEY (f1) , KEY (f2) ) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=99;
30
# Standard HEAP table with CHAR() and 2 indexes
31
CREATE TABLE heap_char ( f1 CHAR(32) NOT NULL, f2 CHAR(64) , f3 CHAR(255), f4 CHAR(255) NOT NULL, PRIMARY KEY (f1) , KEY (f2) ) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=99;
33
# Misc other field types
34
CREATE TABLE heap_other_types ( f1 INTEGER NOT NULL AUTO_INCREMENT, f2 DATETIME, f3 DOUBLE, f4 DECIMAL (20,10) , PRIMARY KEY (f1) , KEY (f2) ) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=99;
36
# Standard HEAP table with 2 indexes and ROW_FORMAT=FIXED
37
CREATE TABLE heap_fixed ( f1 VARCHAR(32) NOT NULL, f2 VARCHAR(64) , f3 VARCHAR(1024), f4 VARCHAR(1024) NOT NULL, PRIMARY KEY (f1) , KEY (f2) ) ENGINE=HEAP ROW_FORMAT=FIXED KEY_BLOCK_SIZE=99;