1DROP TABLE IF EXISTS local_1_1;
2CREATE  TABLE IF NOT EXISTS local_1_1 ( f1 VARCHAR ( 32 ) NOT NULL  , f2 VARCHAR ( 128 ) NOT NULL DEFAULT 'cboepfaobilcchabvglgjdbynog' , f3 VARCHAR ( 32 ) NOT NULL  , f4 VARBINARY ( 32 ) NOT NULL  , f5 VARBINARY ( 1024 )  DEFAULT 'ycboepfao' , KEY ( f1 /* ( 2 ) */ , f2 /* ( 2 ) */ ) ) ENGINE=HEAP KEY_BLOCK_SIZE = 512;
3INSERT IGNORE INTO local_1_1 VALUES ( REPEAT( 'ervydbimvmbqmsowdbsa' , 1 ) , 'v' , NULL , NULL , REPEAT( 'mervydbimvmbqms' , 5 ) ) , ( 'p' , 6 , 'n' , REPEAT( 'imervydbimvmbqmsowdbs' , 4 ) , 'do' ) , ( NULL , NULL , REPEAT( 'himervydbimvmbqmsowdbsaybudvwaamvhempuublmia' , 6 ) , REPEAT('X', POW(2, 20) * 2) , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT('X', POW(2, 20) * 2) , REPEAT( 'Y' , 763 ) , NULL , REPEAT('X', POW(2, 20) * 2) , NULL ) , ( REPEAT('X', POW(2, 20) * 2) , 'time' , 'how' , 2 , REPEAT( 'Y' , 107 ) ) , ( REPEAT( 'hyshimervydbimvmbqmsowdbsaybud' , 5 ) , 2 , 8 , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( 'come' , NULL , 'i' , NULL , REPEAT('X', POW(2, 20) * 2) );
4Warnings:
5Warning	1048	Column 'f3' cannot be null
6Warning	1048	Column 'f4' cannot be null
7Warning	1265	Data truncated for column 'f4' at row 2
8Warning	1048	Column 'f1' cannot be null
9Warning	1048	Column 'f2' cannot be null
10Warning	1265	Data truncated for column 'f3' at row 3
11Warning	1265	Data truncated for column 'f4' at row 3
12Warning	1265	Data truncated for column 'f5' at row 3
13Warning	1265	Data truncated for column 'f1' at row 4
14Warning	1265	Data truncated for column 'f2' at row 4
15Warning	1265	Data truncated for column 'f4' at row 4
16Warning	1265	Data truncated for column 'f1' at row 5
17Warning	1265	Data truncated for column 'f1' at row 6
18Warning	1265	Data truncated for column 'f5' at row 6
19Warning	1265	Data truncated for column 'f5' at row 7
20INSERT IGNORE INTO local_1_1 VALUES ( 'ok' , NULL , REPEAT( 'Y' , 651 ) , 2 , 5 ) , ( REPEAT( 'zylcdzkfrqpihyshimervydbimvmbqmsowdbsaybu' , 3 ) , REPEAT( 'Y' , 282 ) , REPEAT( 'X' , 0 ) , REPEAT( 'Y' , 369 ) , 'g' ) , ( 'think' , REPEAT('X', POW(2, 20) * 2), NULL , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT( 'Y' , 468 ) , REPEAT( 'dfvbrzylcd' , 6 ) , REPEAT( 'Y' , 264 ) , NULL , 'c' ) , ( NULL , NULL , REPEAT( 'srdfvbrzylcdzkfrqpihyshimervydbimvmbqms' , 0 ) , REPEAT( 'Y' , 244 ) , 7 ) , ( REPEAT( 'Y' , 0 ) , 'how' , 'going' , 'q' , NULL );
21Warnings:
22Warning	1048	Column 'f2' cannot be null
23Warning	1265	Data truncated for column 'f3' at row 1
24Warning	1265	Data truncated for column 'f1' at row 2
25Warning	1265	Data truncated for column 'f2' at row 2
26Warning	1265	Data truncated for column 'f4' at row 2
27Warning	1265	Data truncated for column 'f2' at row 3
28Warning	1048	Column 'f3' cannot be null
29Warning	1048	Column 'f4' cannot be null
30Warning	1265	Data truncated for column 'f5' at row 3
31Warning	1265	Data truncated for column 'f1' at row 4
32Warning	1265	Data truncated for column 'f3' at row 4
33Warning	1048	Column 'f1' cannot be null
34Warning	1265	Data truncated for column 'f4' at row 5
35INSERT IGNORE INTO local_1_1 VALUES ( REPEAT('X', POW(2, 20) * 2) , NULL , NULL , NULL , REPEAT('X', POW(2, 20) * 2) ) , ( REPEAT('X', POW(2, 20) * 2) , NULL , REPEAT('X', POW(2, 20) * 2) , 'this' , 'e' ) , ( NULL , 'think' , NULL , 'were' , NULL ) , ( 9 , 'l' , 'c' , 3 , REPEAT( 'geysrdfvbrzylcdzkfrqpihyshimervydbi' , 5 ) ) , ( NULL , NULL , NULL , 'h' , 'w' );
36Warnings:
37Warning	1265	Data truncated for column 'f1' at row 1
38Warning	1048	Column 'f2' cannot be null
39Warning	1048	Column 'f3' cannot be null
40Warning	1048	Column 'f4' cannot be null
41Warning	1265	Data truncated for column 'f5' at row 1
42Warning	1265	Data truncated for column 'f1' at row 2
43Warning	1265	Data truncated for column 'f3' at row 2
44Warning	1048	Column 'f1' cannot be null
45INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1;
46INSERT IGNORE INTO local_1_1 SELECT * FROM local_1_1;
47UPDATE IGNORE local_1_1 SET f5 = REPEAT ('X', 215566);
48Warnings:
49Warning	1265	Data truncated for column 'f5' at row 1
50Warning	1265	Data truncated for column 'f5' at row 2
51Warning	1265	Data truncated for column 'f5' at row 3
52Warning	1265	Data truncated for column 'f5' at row 4
53Warning	1265	Data truncated for column 'f5' at row 5
54Warning	1265	Data truncated for column 'f5' at row 6
55Warning	1265	Data truncated for column 'f5' at row 7
56Warning	1265	Data truncated for column 'f5' at row 8
57Warning	1265	Data truncated for column 'f5' at row 9
58Warning	1265	Data truncated for column 'f5' at row 10
59Warning	1265	Data truncated for column 'f5' at row 11
60Warning	1265	Data truncated for column 'f5' at row 12
61Warning	1265	Data truncated for column 'f5' at row 13
62Warning	1265	Data truncated for column 'f5' at row 14
63Warning	1265	Data truncated for column 'f5' at row 15
64Warning	1265	Data truncated for column 'f5' at row 16
65Warning	1265	Data truncated for column 'f5' at row 17
66Warning	1265	Data truncated for column 'f5' at row 18
67Warning	1265	Data truncated for column 'f5' at row 19
68Warning	1265	Data truncated for column 'f5' at row 20
69Warning	1265	Data truncated for column 'f5' at row 21
70Warning	1265	Data truncated for column 'f5' at row 22
71Warning	1265	Data truncated for column 'f5' at row 23
72Warning	1265	Data truncated for column 'f5' at row 24
73Warning	1265	Data truncated for column 'f5' at row 25
74Warning	1265	Data truncated for column 'f5' at row 26
75Warning	1265	Data truncated for column 'f5' at row 27
76Warning	1265	Data truncated for column 'f5' at row 28
77Warning	1265	Data truncated for column 'f5' at row 29
78Warning	1265	Data truncated for column 'f5' at row 30
79Warning	1265	Data truncated for column 'f5' at row 31
80Warning	1265	Data truncated for column 'f5' at row 32
81Warning	1265	Data truncated for column 'f5' at row 33
82Warning	1265	Data truncated for column 'f5' at row 34
83Warning	1265	Data truncated for column 'f5' at row 35
84Warning	1265	Data truncated for column 'f5' at row 36
85Warning	1265	Data truncated for column 'f5' at row 37
86Warning	1265	Data truncated for column 'f5' at row 38
87Warning	1265	Data truncated for column 'f5' at row 39
88Warning	1265	Data truncated for column 'f5' at row 40
89Warning	1265	Data truncated for column 'f5' at row 41
90Warning	1265	Data truncated for column 'f5' at row 42
91Warning	1265	Data truncated for column 'f5' at row 43
92Warning	1265	Data truncated for column 'f5' at row 44
93Warning	1265	Data truncated for column 'f5' at row 45
94Warning	1265	Data truncated for column 'f5' at row 46
95Warning	1265	Data truncated for column 'f5' at row 47
96Warning	1265	Data truncated for column 'f5' at row 48
97Warning	1265	Data truncated for column 'f5' at row 49
98Warning	1265	Data truncated for column 'f5' at row 50
99Warning	1265	Data truncated for column 'f5' at row 51
100Warning	1265	Data truncated for column 'f5' at row 52
101Warning	1265	Data truncated for column 'f5' at row 53
102Warning	1265	Data truncated for column 'f5' at row 54
103Warning	1265	Data truncated for column 'f5' at row 55
104Warning	1265	Data truncated for column 'f5' at row 56
105Warning	1265	Data truncated for column 'f5' at row 57
106Warning	1265	Data truncated for column 'f5' at row 58
107Warning	1265	Data truncated for column 'f5' at row 59
108Warning	1265	Data truncated for column 'f5' at row 60
109Warning	1265	Data truncated for column 'f5' at row 61
110Warning	1265	Data truncated for column 'f5' at row 62
111Warning	1265	Data truncated for column 'f5' at row 63
112Warning	1265	Data truncated for column 'f5' at row 64
113DROP TABLE local_1_1;
114