1CREATE TABLE IF NOT EXISTS local_1_1 (f1 VARCHAR (32) NOT NULL,
2f2 VARCHAR (128) NOT NULL,
3f3 BLOB NOT NULL,
4f4 TEXT,
5f5 BLOB (1024),
6PRIMARY KEY (f1),
7KEY (f1 , f2)
8) ENGINE=HEAP ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE = 2048;
9INSERT IGNORE INTO local_1_1 VALUES
10(REPEAT('egqeqfxwaejpqixuvvtentruyqadxiybjdfqjspfbyjdjczrrwjnagkzsoagatqookhsgtrvvbxacppljfzaseidqggxvuirm' , 5), NULL, NULL, NULL, REPEAT('hegqeqfxwaejpqixuvvtentruyqadxiy', 1)),
11('you', NULL, 0, REPEAT("X", 2048) , 0);
12Warnings:
13Warning	1265	Data truncated for column 'f1' at row 1
14Warning	1048	Column 'f2' cannot be null
15Warning	1048	Column 'f3' cannot be null
16Warning	1048	Column 'f2' cannot be null
17INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1;
18DROP TABLE local_1_1;
19