1
SET GLOBAL innodb_file_format='Barracuda';
2
SET GLOBAL innodb_file_per_table=on;
3
CREATE TABLE bug52745 (
4
a2 int(10) unsigned DEFAULT NULL,
5
col37 time DEFAULT NULL,
6
col38 char(229) CHARACTER SET utf8 DEFAULT NULL,
8
col40 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
9
col41 int(10) unsigned DEFAULT NULL,
10
col42 varchar(248) CHARACTER SET utf8 DEFAULT NULL,
11
col43 smallint(5) unsigned zerofill DEFAULT NULL,
12
col44 varchar(150) CHARACTER SET utf8 DEFAULT NULL,
13
col45 float unsigned zerofill DEFAULT NULL,
14
col46 binary(1) DEFAULT NULL,
15
col47 tinyint(4) DEFAULT NULL,
16
col48 tinyint(1) DEFAULT NULL,
17
col49 timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
18
col50 binary(1) DEFAULT NULL,
19
col51 double unsigned zerofill DEFAULT NULL,
20
col52 int(10) unsigned DEFAULT NULL,
21
col53 time DEFAULT NULL,
22
col54 double unsigned DEFAULT NULL,
23
col55 time DEFAULT NULL,
24
col56 mediumtext CHARACTER SET latin2,
26
col58 decimal(52,16) unsigned zerofill NOT NULL DEFAULT '000000000000000000000000000000000000.0000000000000000',
27
col59 binary(1) DEFAULT NULL,
29
col61 time DEFAULT NULL,
30
col62 longtext CHARACTER SET utf8 COLLATE utf8_persian_ci,
31
col63 timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
32
col64 int(10) unsigned DEFAULT NULL,
33
col65 date DEFAULT NULL,
34
col66 timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
35
col67 binary(1) DEFAULT NULL,
37
col69 date DEFAULT NULL,
38
col70 tinyint(3) unsigned zerofill DEFAULT NULL,
39
col71 varchar(44) CHARACTER SET utf8 DEFAULT NULL,
40
col72 datetime DEFAULT NULL,
41
col73 smallint(5) unsigned zerofill DEFAULT NULL,
43
col75 bit(34) DEFAULT NULL,
44
col76 float unsigned zerofill DEFAULT NULL,
45
col77 year(2) DEFAULT NULL,
46
col78 tinyint(3) unsigned DEFAULT NULL,
47
col79 set('msfheowh','tbpxbgf','by','wahnrjw','myqfasxz','rsokyumrt') CHARACTER SET latin2 DEFAULT NULL,
48
col80 datetime DEFAULT NULL,
49
col81 smallint(6) DEFAULT NULL,
50
col82 enum('xtaurnqfqz','rifrse','kuzwpbvb','niisabk','zxavro','rbvasv','','uulrfaove','','') DEFAULT NULL,
51
col83 bigint(20) unsigned zerofill DEFAULT NULL,
52
col84 float unsigned zerofill DEFAULT NULL,
53
col85 double DEFAULT NULL,
54
col86 enum('ylannv','','vlkhycqc','snke','cxifustp','xiaxaswzp','oxl') CHARACTER SET latin1 COLLATE latin1_german2_ci DEFAULT NULL,
55
col87 varbinary(221) DEFAULT NULL,
56
col88 double unsigned DEFAULT NULL,
57
col89 float unsigned zerofill DEFAULT NULL,
59
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
61
Note 1291 Column 'col82' has duplicated value '' in ENUM
62
Note 1291 Column 'col82' has duplicated value '' in ENUM
63
INSERT INTO bug52745 SET
64
col40='0000-00-00 00:00:00',
69
col56='wakefulness\'',
70
col57=repeat('absorbefacient\'',106),
73
col60=repeat('Noelani\'',16),
76
col63='19950106155112',
79
col66='19600719080256',
80
col68=repeat('Sagittarius\'',54),
84
col74=repeat('zipp',11),
89
col80='20500609035724',
94
col87='HZdkf.4 s7t,5Rmq 8so fmr,ruGLUG25TrtI.yQ 2SuHq0ML7rw7.4 b2yf2E5TJxOtBBZImezDnzpj,uPYfznnEUDN1e9aQoO 2DsplB7TFWy oQJ br HLF :F,eQ p4i1oWsr lL3PG,hjCz6hYqN h1QTjLCjrv:QCdSzpYBibJAtZCxLOk3l6Blsh.W',
97
col90=repeat('gale',48);
99
Warning 1265 Data truncated for column 'col53' at row 1
100
Warning 1264 Out of range value for column 'col54' at row 1
101
Warning 1265 Data truncated for column 'col59' at row 1
102
Warning 1265 Data truncated for column 'col61' at row 1
103
Warning 1264 Out of range value for column 'col64' at row 1
104
Warning 1265 Data truncated for column 'col65' at row 1
105
Warning 1264 Out of range value for column 'col66' at row 1
106
Warning 1265 Data truncated for column 'col68' at row 1
107
Warning 1265 Data truncated for column 'col69' at row 1
108
Warning 1264 Out of range value for column 'col70' at row 1
109
Warning 1264 Out of range value for column 'col78' at row 1
110
Warning 1265 Data truncated for column 'col79' at row 1
111
Warning 1264 Out of range value for column 'col84' at row 1
114
Warning 1265 Data truncated for column 'col53' at row 1
115
Warning 1264 Out of range value for column 'col54' at row 1
116
Warning 1265 Data truncated for column 'col59' at row 1
117
Warning 1265 Data truncated for column 'col61' at row 1
118
Warning 1264 Out of range value for column 'col64' at row 1
119
Warning 1265 Data truncated for column 'col65' at row 1
120
Warning 1264 Out of range value for column 'col66' at row 1
121
Warning 1265 Data truncated for column 'col68' at row 1
122
Warning 1265 Data truncated for column 'col69' at row 1
123
Warning 1264 Out of range value for column 'col70' at row 1
124
Warning 1264 Out of range value for column 'col78' at row 1
125
Warning 1265 Data truncated for column 'col79' at row 1
126
Warning 1264 Out of range value for column 'col84' at row 1
128
SET GLOBAL innodb_file_format=Antelope;
129
SET GLOBAL innodb_file_per_table=0;