|
0.67.760
by eve
Heap testing grammar with DML statements and persistent tables |
1 |
USE test; |
2 |
||
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; |
|
5 |
||
6 |
# Oversize primary key |
|
7 |
CREATE TABLE heap_oversize_pk ( f1 VARCHAR(1024) 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; |
|
8 |
||
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; |
|
11 |
||
12 |
# Very large KEY_BLOCK_SIZE |
|
13 |
CREATE TABLE heap_large_block ( f1 VARCHAR(1024) 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; |
|
14 |
||
15 |
# Complex indexes |
|
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; |
|
17 |
||
18 |
# No indexes at all, small records # Due to bug 784468 , we can not use VARCHAR(2) or similar |
|
19 |
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; |
|
20 |
||
21 |
# No indexes at all, large records |
|
22 |
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; |
|
23 |