Debian Codegraph @

mysql-test/suite/funcs_1/r/is_columns_innodb.result

raw
1 DROP DATABASE IF EXISTS test1;
2 CREATE DATABASE test1 charset latin1;
3 USE test;
4 drop table if exists tb1 ;
5 create table tb1 (
6 f1 char(0),
7 f2 char(0) binary,
8 f3 char(0) ascii,
9 f4 tinytext,
10 f5 text,
11 f6 mediumtext,
12 f7 longtext,
13 f8 tinyblob,
14 f9 blob,
15 f10 mediumblob,
16 f11 longblob,
17 f12 binary,
18 f13 tinyint,
19 f14 tinyint unsigned,
20 f15 tinyint zerofill,
21 f16 tinyint unsigned zerofill,
22 f17 smallint,
23 f18 smallint unsigned,
24 f19 smallint zerofill,
25 f20 smallint unsigned zerofill,
26 f21 mediumint,
27 f22 mediumint unsigned,
28 f23 mediumint zerofill,
29 f24 mediumint unsigned zerofill,
30 f25 int,
31 f26 int unsigned,
32 f27 int zerofill,
33 f28 int unsigned zerofill,
34 f29 bigint,
35 f30 bigint unsigned,
36 f31 bigint zerofill,
37 f32 bigint unsigned zerofill,
38 f33 decimal,
39 f34 decimal unsigned,
40 f35 decimal zerofill,
41 f36 decimal unsigned zerofill not null DEFAULT 9.9,
42 f37 decimal (0) not null DEFAULT 9.9,
43 f38 decimal (64) not null DEFAULT 9.9,
44 f39 decimal (0) unsigned not null DEFAULT 9.9,
45 f40 decimal (64) unsigned not null DEFAULT 9.9,
46 f41 decimal (0) zerofill not null DEFAULT 9.9,
47 f42 decimal (64) zerofill not null DEFAULT 9.9,
48 f43 decimal (0) unsigned zerofill not null DEFAULT 9.9,
49 f44 decimal (64) unsigned zerofill not null DEFAULT 9.9,
50 f45 decimal (0,0) not null DEFAULT 9.9,
51 f46 decimal (63,30) not null DEFAULT 9.9,
52 f47 decimal (0,0) unsigned not null DEFAULT 9.9,
53 f48 decimal (63,30) unsigned not null DEFAULT 9.9,
54 f49 decimal (0,0) zerofill not null DEFAULT 9.9,
55 f50 decimal (63,30) zerofill not null DEFAULT 9.9,
56 f51 decimal (0,0) unsigned zerofill not null DEFAULT 9.9,
57 f52 decimal (63,30) unsigned zerofill not null DEFAULT 9.9,
58 f53 numeric not null DEFAULT 99,
59 f54 numeric unsigned not null DEFAULT 99,
60 f55 numeric zerofill not null DEFAULT 99,
61 f56 numeric unsigned zerofill not null DEFAULT 99,
62 f57 numeric (0) not null DEFAULT 99,
63 f58 numeric (64) not null DEFAULT 99
64 ) charset latin1 engine = innodb;
65 Warnings:
66 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
67 Warning 1287 'ASCII' is deprecated and will be removed in a future release. Please use CHARACTER SET charset_name instead
68 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
69 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
70 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
71 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
72 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
73 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
74 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
75 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
76 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
77 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
78 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
79 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
80 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
81 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
82 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
83 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
84 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
85 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
86 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
87 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
88 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
89 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
90 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
91 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
92 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
93 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
94 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
95 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
96 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
97 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
98 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
99 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
100 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
101 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
102 Note 1265 Data truncated for column 'f36' at row 1
103 Note 1265 Data truncated for column 'f37' at row 1
104 Note 1265 Data truncated for column 'f38' at row 1
105 Note 1265 Data truncated for column 'f39' at row 1
106 Note 1265 Data truncated for column 'f40' at row 1
107 Note 1265 Data truncated for column 'f41' at row 1
108 Note 1265 Data truncated for column 'f42' at row 1
109 Note 1265 Data truncated for column 'f43' at row 1
110 Note 1265 Data truncated for column 'f44' at row 1
111 Note 1265 Data truncated for column 'f45' at row 1
112 Note 1265 Data truncated for column 'f47' at row 1
113 Note 1265 Data truncated for column 'f49' at row 1
114 Note 1265 Data truncated for column 'f51' at row 1
115 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb1.txt'
116 into table tb1 CHARACTER SET latin1;
117 drop table if exists tb2 ;
118 create table tb2 (
119 f59 numeric (0) unsigned,
120 f60 numeric (64) unsigned,
121 f61 numeric (0) zerofill,
122 f62 numeric (64) zerofill,
123 f63 numeric (0) unsigned zerofill,
124 f64 numeric (64) unsigned zerofill,
125 f65 numeric (0,0),
126 f66 numeric (63,30),
127 f67 numeric (0,0) unsigned,
128 f68 numeric (63,30) unsigned,
129 f69 numeric (0,0) zerofill,
130 f70 numeric (63,30) zerofill,
131 f71 numeric (0,0) unsigned zerofill,
132 f72 numeric (63,30) unsigned zerofill,
133 f73 real,
134 f74 real unsigned,
135 f75 real zerofill,
136 f76 real unsigned zerofill,
137 f77 double default 7.7,
138 f78 double unsigned default 7.7,
139 f79 double zerofill default 7.7,
140 f80 double unsigned zerofill default 8.8,
141 f81 float not null default 8.8,
142 f82 float unsigned not null default 8.8,
143 f83 float zerofill not null default 8.8,
144 f84 float unsigned zerofill not null default 8.8,
145 f85 float(0) not null default 8.8,
146 f86 float(23) not null default 8.8,
147 f87 float(0) unsigned not null default 8.8,
148 f88 float(23) unsigned not null default 8.8,
149 f89 float(0) zerofill not null default 8.8,
150 f90 float(23) zerofill not null default 8.8,
151 f91 float(0) unsigned zerofill not null default 8.8,
152 f92 float(23) unsigned zerofill not null default 8.8,
153 f93 float(24) not null default 8.8,
154 f94 float(53) not null default 8.8,
155 f95 float(24) unsigned not null default 8.8,
156 f96 float(53) unsigned not null default 8.8,
157 f97 float(24) zerofill not null default 8.8,
158 f98 float(53) zerofill not null default 8.8,
159 f99 float(24) unsigned zerofill not null default 8.8,
160 f100 float(53) unsigned zerofill not null default 8.8,
161 f101 date not null default '2000-01-01',
162 f102 time not null default 20,
163 f103 datetime not null default '2/2/2',
164 f104 timestamp not null default 20001231235959,
165 f105 year not null default 2000,
166 f108 enum("1enum","2enum") not null default "1enum",
167 f109 set("1set","2set") not null default "1set"
168 ) charset latin1 engine = innodb;
169 Warnings:
170 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
171 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
172 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
173 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
174 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
175 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
176 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
177 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
178 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
179 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
180 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
181 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
182 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
183 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
184 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
185 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
186 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
187 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
188 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
189 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
190 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
191 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
192 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
193 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
194 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
195 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
196 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
197 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
198 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
199 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
200 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
201 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
202 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
203 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
204 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
205 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
206 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
207 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
208 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
209 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
210 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
211 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
212 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
213 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
214 Warning 4095 Delimiter '/' in position 1 in datetime value '2/2/2' at row 1 is deprecated. Prefer the standard '-'.
215 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb2.txt'
216 into table tb2 CHARACTER SET latin1 ;
217 drop table if exists tb3 ;
218 create table tb3 (
219 f118 char not null DEFAULT 'a',
220 f119 char binary not null DEFAULT b'101',
221 f120 char ascii not null DEFAULT b'101',
222 f121 tinytext,
223 f122 text,
224 f123 mediumtext,
225 f124 longtext,
226 f125 tinyblob,
227 f126 blob,
228 f127 mediumblob,
229 f128 longblob,
230 f129 binary not null DEFAULT b'101',
231 f130 tinyint not null DEFAULT 99,
232 f131 tinyint unsigned not null DEFAULT 99,
233 f132 tinyint zerofill not null DEFAULT 99,
234 f133 tinyint unsigned zerofill not null DEFAULT 99,
235 f134 smallint not null DEFAULT 999,
236 f135 smallint unsigned not null DEFAULT 999,
237 f136 smallint zerofill not null DEFAULT 999,
238 f137 smallint unsigned zerofill not null DEFAULT 999,
239 f138 mediumint not null DEFAULT 9999,
240 f139 mediumint unsigned not null DEFAULT 9999,
241 f140 mediumint zerofill not null DEFAULT 9999,
242 f141 mediumint unsigned zerofill not null DEFAULT 9999,
243 f142 int not null DEFAULT 99999,
244 f143 int unsigned not null DEFAULT 99999,
245 f144 int zerofill not null DEFAULT 99999,
246 f145 int unsigned zerofill not null DEFAULT 99999,
247 f146 bigint not null DEFAULT 999999,
248 f147 bigint unsigned not null DEFAULT 999999,
249 f148 bigint zerofill not null DEFAULT 999999,
250 f149 bigint unsigned zerofill not null DEFAULT 999999,
251 f150 decimal not null DEFAULT 999.999,
252 f151 decimal unsigned not null DEFAULT 999.17,
253 f152 decimal zerofill not null DEFAULT 999.999,
254 f153 decimal unsigned zerofill,
255 f154 decimal (0),
256 f155 decimal (64),
257 f156 decimal (0) unsigned,
258 f157 decimal (64) unsigned,
259 f158 decimal (0) zerofill,
260 f159 decimal (64) zerofill,
261 f160 decimal (0) unsigned zerofill,
262 f161 decimal (64) unsigned zerofill,
263 f162 decimal (0,0),
264 f163 decimal (63,30),
265 f164 decimal (0,0) unsigned,
266 f165 decimal (63,30) unsigned,
267 f166 decimal (0,0) zerofill,
268 f167 decimal (63,30) zerofill,
269 f168 decimal (0,0) unsigned zerofill,
270 f169 decimal (63,30) unsigned zerofill,
271 f170 numeric,
272 f171 numeric unsigned,
273 f172 numeric zerofill,
274 f173 numeric unsigned zerofill,
275 f174 numeric (0),
276 f175 numeric (64)
277 ) charset latin1 engine = innodb;
278 Warnings:
279 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
280 Warning 1287 'ASCII' is deprecated and will be removed in a future release. Please use CHARACTER SET charset_name instead
281 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
282 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
283 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
284 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
285 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
286 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
287 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
288 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
289 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
290 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
291 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
292 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
293 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
294 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
295 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
296 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
297 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
298 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
299 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
300 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
301 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
302 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
303 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
304 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
305 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
306 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
307 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
308 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
309 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
310 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
311 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
312 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
313 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
314 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
315 Note 1265 Data truncated for column 'f150' at row 1
316 Note 1265 Data truncated for column 'f151' at row 1
317 Note 1265 Data truncated for column 'f152' at row 1
318 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb3.txt'
319 into table tb3 CHARACTER SET latin1;
320 drop table if exists tb4;
321 create table tb4 (
322 f176 numeric (0) unsigned not null DEFAULT 9,
323 f177 numeric (64) unsigned not null DEFAULT 9,
324 f178 numeric (0) zerofill not null DEFAULT 9,
325 f179 numeric (64) zerofill not null DEFAULT 9,
326 f180 numeric (0) unsigned zerofill not null DEFAULT 9,
327 f181 numeric (64) unsigned zerofill not null DEFAULT 9,
328 f182 numeric (0,0) not null DEFAULT 9,
329 f183 numeric (63,30) not null DEFAULT 9,
330 f184 numeric (0,0) unsigned not null DEFAULT 9,
331 f185 numeric (63,30) unsigned not null DEFAULT 9,
332 f186 numeric (0,0) zerofill not null DEFAULT 9,
333 f187 numeric (63,30) zerofill not null DEFAULT 9,
334 f188 numeric (0,0) unsigned zerofill not null DEFAULT 9,
335 f189 numeric (63,30) unsigned zerofill not null DEFAULT 9,
336 f190 real not null DEFAULT 88.8,
337 f191 real unsigned not null DEFAULT 88.8,
338 f192 real zerofill not null DEFAULT 88.8,
339 f193 real unsigned zerofill not null DEFAULT 88.8,
340 f194 double not null DEFAULT 55.5,
341 f195 double unsigned not null DEFAULT 55.5,
342 f196 double zerofill not null DEFAULT 55.5,
343 f197 double unsigned zerofill not null DEFAULT 55.5,
344 f198 float,
345 f199 float unsigned,
346 f200 float zerofill,
347 f201 float unsigned zerofill,
348 f202 float(0),
349 f203 float(23),
350 f204 float(0) unsigned,
351 f205 float(23) unsigned,
352 f206 float(0) zerofill,
353 f207 float(23) zerofill,
354 f208 float(0) unsigned zerofill,
355 f209 float(23) unsigned zerofill,
356 f210 float(24),
357 f211 float(53),
358 f212 float(24) unsigned,
359 f213 float(53) unsigned,
360 f214 float(24) zerofill,
361 f215 float(53) zerofill,
362 f216 float(24) unsigned zerofill,
363 f217 float(53) unsigned zerofill,
364 f218 date,
365 f219 time,
366 f220 datetime,
367 f221 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
368 f222 year,
369 f225 enum("1enum","2enum"),
370 f226 set("1set","2set"),
371 f235 char(0),
372 f236 char(90),
373 f237 char(255) ascii,
374 f238 varchar(0),
375 f239 varchar(20000) binary,
376 f240 varchar(2000),
377 f241 char(100)
378 ) charset latin1 engine = innodb;
379 Warnings:
380 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
381 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
382 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
383 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
384 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
385 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
386 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
387 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
388 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
389 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
390 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
391 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
392 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
393 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
394 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
395 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
396 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
397 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
398 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
399 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
400 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
401 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
402 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
403 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
404 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
405 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
406 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
407 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
408 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
409 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
410 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
411 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
412 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
413 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
414 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
415 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
416 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
417 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
418 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
419 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
420 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
421 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
422 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
423 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
424 Warning 1287 'ASCII' is deprecated and will be removed in a future release. Please use CHARACTER SET charset_name instead
425 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
426 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb4.txt'
427 into table tb4 CHARACTER SET latin1;
428 USE test1;
429 drop table if exists tb2 ;
430 create table tb2 (
431 f59 numeric (0) unsigned,
432 f60 numeric (64) unsigned,
433 f61 numeric (0) zerofill,
434 f62 numeric (64) zerofill,
435 f63 numeric (0) unsigned zerofill,
436 f64 numeric (64) unsigned zerofill,
437 f65 numeric (0,0),
438 f66 numeric (63,30),
439 f67 numeric (0,0) unsigned,
440 f68 numeric (63,30) unsigned,
441 f69 numeric (0,0) zerofill,
442 f70 numeric (63,30) zerofill,
443 f71 numeric (0,0) unsigned zerofill,
444 f72 numeric (63,30) unsigned zerofill,
445 f73 real,
446 f74 real unsigned,
447 f75 real zerofill,
448 f76 real unsigned zerofill,
449 f77 double default 7.7,
450 f78 double unsigned default 7.7,
451 f79 double zerofill default 7.7,
452 f80 double unsigned zerofill default 8.8,
453 f81 float not null default 8.8,
454 f82 float unsigned not null default 8.8,
455 f83 float zerofill not null default 8.8,
456 f84 float unsigned zerofill not null default 8.8,
457 f85 float(0) not null default 8.8,
458 f86 float(23) not null default 8.8,
459 f87 float(0) unsigned not null default 8.8,
460 f88 float(23) unsigned not null default 8.8,
461 f89 float(0) zerofill not null default 8.8,
462 f90 float(23) zerofill not null default 8.8,
463 f91 float(0) unsigned zerofill not null default 8.8,
464 f92 float(23) unsigned zerofill not null default 8.8,
465 f93 float(24) not null default 8.8,
466 f94 float(53) not null default 8.8,
467 f95 float(24) unsigned not null default 8.8,
468 f96 float(53) unsigned not null default 8.8,
469 f97 float(24) zerofill not null default 8.8,
470 f98 float(53) zerofill not null default 8.8,
471 f99 float(24) unsigned zerofill not null default 8.8,
472 f100 float(53) unsigned zerofill not null default 8.8,
473 f101 date not null default '2000-01-01',
474 f102 time not null default 20,
475 f103 datetime not null default '2/2/2',
476 f104 timestamp not null default 20001231235959,
477 f105 year not null default 2000,
478 f108 enum("1enum","2enum") not null default "1enum",
479 f109 set("1set","2set") not null default "1set"
480 ) charset latin1 engine = innodb;
481 Warnings:
482 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
483 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
484 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
485 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
486 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
487 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
488 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
489 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
490 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
491 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
492 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
493 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
494 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
495 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
496 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
497 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
498 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
499 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
500 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
501 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
502 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
503 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
504 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
505 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
506 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
507 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
508 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
509 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
510 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
511 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
512 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
513 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
514 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
515 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
516 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
517 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
518 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
519 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
520 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
521 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
522 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
523 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
524 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
525 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
526 Warning 4095 Delimiter '/' in position 1 in datetime value '2/2/2' at row 1 is deprecated. Prefer the standard '-'.
527 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb2.txt'
528 into table tb2 CHARACTER SET latin1 ;
529 USE test;
530 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
531 USE test;
532 DROP TABLE IF EXISTS t1, t2, t4, t10, t11;
533 CREATE TABLE t1 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
534 charset latin1 ENGINE = InnoDB;
535 CREATE TABLE t2 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
536 charset latin1 ENGINE = InnoDB;
537 CREATE TABLE t4 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
538 charset latin1 ENGINE = InnoDB;
539 CREATE TABLE t10 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
540 charset latin1 ENGINE = InnoDB;
541 CREATE TABLE t11 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
542 charset latin1 ENGINE = InnoDB;
543 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t1
544 character set latin1;
545 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t2
546 character set latin1;
547 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t4
548 character set latin1;
549 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t10
550 character set latin1;
551 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t11
552 character set latin1;
553 drop TABLE if exists t3;
554 CREATE TABLE t3 (f1 char(20), f2 char(20), f3 integer) charset latin1 ENGINE = InnoDB;
555 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t3.txt' INTO TABLE t3
556 character set latin1;
557 drop database if exists test4;
558 CREATE database test4;
559 use test4;
560 CREATE TABLE t6 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int)
561 charset latin1 ENGINE = InnoDB;
562 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t6
563 character set latin1;
564 use test;
565 drop TABLE if exists t7, t8;
566 CREATE TABLE t7 (f1 char(20),f2 char(25),f3 date,f4 int) charset latin1 ENGINE = InnoDB;
567 CREATE TABLE t8 (f1 char(20),f2 char(25),f3 date,f4 int) charset latin1 ENGINE = InnoDB;
568 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' INTO TABLE t7
569 character set latin1;
570 Warnings:
571 Warning 1265 Data truncated for column 'f3' at row 1
572 Warning 1265 Data truncated for column 'f3' at row 2
573 Warning 1265 Data truncated for column 'f3' at row 3
574 Warning 1265 Data truncated for column 'f3' at row 4
575 Warning 1265 Data truncated for column 'f3' at row 5
576 Warning 1265 Data truncated for column 'f3' at row 6
577 Warning 1265 Data truncated for column 'f3' at row 7
578 Warning 1265 Data truncated for column 'f3' at row 8
579 Warning 1265 Data truncated for column 'f3' at row 9
580 Warning 1265 Data truncated for column 'f3' at row 10
581 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' INTO TABLE t8
582 character set latin1;
583 Warnings:
584 Warning 1265 Data truncated for column 'f3' at row 1
585 Warning 1265 Data truncated for column 'f3' at row 2
586 Warning 1265 Data truncated for column 'f3' at row 3
587 Warning 1265 Data truncated for column 'f3' at row 4
588 Warning 1265 Data truncated for column 'f3' at row 5
589 Warning 1265 Data truncated for column 'f3' at row 6
590 Warning 1265 Data truncated for column 'f3' at row 7
591 Warning 1265 Data truncated for column 'f3' at row 8
592 Warning 1265 Data truncated for column 'f3' at row 9
593 Warning 1265 Data truncated for column 'f3' at row 10
594 drop TABLE if exists t9;
595 CREATE TABLE t9 (f1 int, f2 char(25), f3 int) charset latin1 ENGINE = InnoDB;
596 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t9.txt' INTO TABLE t9
597 character set latin1;
598 SET sql_mode = default;
599 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
600 SELECT * FROM information_schema.columns
601 WHERE table_schema LIKE 'test%'
602 ORDER BY table_schema,
603 table_name COLLATE utf8_general_ci,
604 ordinal_position;
605 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT GENERATION_EXPRESSION SRS_ID
606 def test t1 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
607 def test t1 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
608 def test t1 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
609 def test t1 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
610 def test t1 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
611 def test t1 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
612 def test t10 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
613 def test t10 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
614 def test t10 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
615 def test t10 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
616 def test t10 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
617 def test t10 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
618 def test t11 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
619 def test t11 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
620 def test t11 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
621 def test t11 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
622 def test t11 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
623 def test t11 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
624 def test t2 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
625 def test t2 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
626 def test t2 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
627 def test t2 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
628 def test t2 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
629 def test t2 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
630 def test t3 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
631 def test t3 f2 2 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
632 def test t3 f3 3 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
633 def test t4 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
634 def test t4 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
635 def test t4 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
636 def test t4 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
637 def test t4 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
638 def test t4 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
639 def test t7 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
640 def test t7 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
641 def test t7 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
642 def test t7 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
643 def test t8 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
644 def test t8 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
645 def test t8 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
646 def test t8 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
647 def test t9 f1 1 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
648 def test t9 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
649 def test t9 f3 3 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
650 def test tb1 f1 1 NULL YES char 0 0 NULL NULL NULL latin1 latin1_swedish_ci char(0) select,insert,update,references NULL
651 def test tb1 f2 2 NULL YES char 0 0 NULL NULL NULL latin1 latin1_bin char(0) select,insert,update,references NULL
652 def test tb1 f3 3 NULL YES char 0 0 NULL NULL NULL latin1 latin1_swedish_ci char(0) select,insert,update,references NULL
653 def test tb1 f4 4 NULL YES tinytext 255 255 NULL NULL NULL latin1 latin1_swedish_ci tinytext select,insert,update,references NULL
654 def test tb1 f5 5 NULL YES text 65535 65535 NULL NULL NULL latin1 latin1_swedish_ci text select,insert,update,references NULL
655 def test tb1 f6 6 NULL YES mediumtext 16777215 16777215 NULL NULL NULL latin1 latin1_swedish_ci mediumtext select,insert,update,references NULL
656 def test tb1 f7 7 NULL YES longtext 4294967295 4294967295 NULL NULL NULL latin1 latin1_swedish_ci longtext select,insert,update,references NULL
657 def test tb1 f8 8 NULL YES tinyblob 255 255 NULL NULL NULL NULL NULL tinyblob select,insert,update,references NULL
658 def test tb1 f9 9 NULL YES blob 65535 65535 NULL NULL NULL NULL NULL blob select,insert,update,references NULL
659 def test tb1 f10 10 NULL YES mediumblob 16777215 16777215 NULL NULL NULL NULL NULL mediumblob select,insert,update,references NULL
660 def test tb1 f11 11 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL NULL longblob select,insert,update,references NULL
661 def test tb1 f12 12 NULL YES binary 1 1 NULL NULL NULL NULL NULL binary(1) select,insert,update,references NULL
662 def test tb1 f13 13 NULL YES tinyint NULL NULL 3 0 NULL NULL NULL tinyint select,insert,update,references NULL
663 def test tb1 f14 14 NULL YES tinyint NULL NULL 3 0 NULL NULL NULL tinyint unsigned select,insert,update,references NULL
664 def test tb1 f15 15 NULL YES tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned zerofill select,insert,update,references NULL
665 def test tb1 f16 16 NULL YES tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned zerofill select,insert,update,references NULL
666 def test tb1 f17 17 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint select,insert,update,references NULL
667 def test tb1 f18 18 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint unsigned select,insert,update,references NULL
668 def test tb1 f19 19 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned zerofill select,insert,update,references NULL
669 def test tb1 f20 20 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned zerofill select,insert,update,references NULL
670 def test tb1 f21 21 NULL YES mediumint NULL NULL 7 0 NULL NULL NULL mediumint select,insert,update,references NULL
671 def test tb1 f22 22 NULL YES mediumint NULL NULL 7 0 NULL NULL NULL mediumint unsigned select,insert,update,references NULL
672 def test tb1 f23 23 NULL YES mediumint NULL NULL 7 0 NULL NULL NULL mediumint(8) unsigned zerofill select,insert,update,references NULL
673 def test tb1 f24 24 NULL YES mediumint NULL NULL 7 0 NULL NULL NULL mediumint(8) unsigned zerofill select,insert,update,references NULL
674 def test tb1 f25 25 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
675 def test tb1 f26 26 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL
676 def test tb1 f27 27 NULL YES int NULL NULL 10 0 NULL NULL NULL int(10) unsigned zerofill select,insert,update,references NULL
677 def test tb1 f28 28 NULL YES int NULL NULL 10 0 NULL NULL NULL int(10) unsigned zerofill select,insert,update,references NULL
678 def test tb1 f29 29 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select,insert,update,references NULL
679 def test tb1 f30 30 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL
680 def test tb1 f31 31 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned zerofill select,insert,update,references NULL
681 def test tb1 f32 32 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned zerofill select,insert,update,references NULL
682 def test tb1 f33 33 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
683 def test tb1 f34 34 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
684 def test tb1 f35 35 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
685 def test tb1 f36 36 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
686 def test tb1 f37 37 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
687 def test tb1 f38 38 10 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) select,insert,update,references NULL
688 def test tb1 f39 39 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
689 def test tb1 f40 40 10 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL
690 def test tb1 f41 41 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
691 def test tb1 f42 42 0000000000000000000000000000000000000000000000000000000000000010 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
692 def test tb1 f43 43 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
693 def test tb1 f44 44 0000000000000000000000000000000000000000000000000000000000000010 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
694 def test tb1 f45 45 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
695 def test tb1 f46 46 9.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL
696 def test tb1 f47 47 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
697 def test tb1 f48 48 9.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL
698 def test tb1 f49 49 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
699 def test tb1 f50 50 000000000000000000000000000000009.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
700 def test tb1 f51 51 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
701 def test tb1 f52 52 000000000000000000000000000000009.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
702 def test tb1 f53 53 99 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
703 def test tb1 f54 54 99 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
704 def test tb1 f55 55 0000000099 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
705 def test tb1 f56 56 0000000099 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
706 def test tb1 f57 57 99 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
707 def test tb1 f58 58 99 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) select,insert,update,references NULL
708 def test tb2 f59 1 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
709 def test tb2 f60 2 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL
710 def test tb2 f61 3 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
711 def test tb2 f62 4 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
712 def test tb2 f63 5 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
713 def test tb2 f64 6 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
714 def test tb2 f65 7 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
715 def test tb2 f66 8 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL
716 def test tb2 f67 9 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
717 def test tb2 f68 10 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL
718 def test tb2 f69 11 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
719 def test tb2 f70 12 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
720 def test tb2 f71 13 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
721 def test tb2 f72 14 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
722 def test tb2 f73 15 NULL YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
723 def test tb2 f74 16 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
724 def test tb2 f75 17 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
725 def test tb2 f76 18 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
726 def test tb2 f77 19 7.7 YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
727 def test tb2 f78 20 7.7 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
728 def test tb2 f79 21 00000000000000000007.7 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
729 def test tb2 f80 22 00000000000000000008.8 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
730 def test tb2 f81 23 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
731 def test tb2 f82 24 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
732 def test tb2 f83 25 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
733 def test tb2 f84 26 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
734 def test tb2 f85 27 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
735 def test tb2 f86 28 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
736 def test tb2 f87 29 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
737 def test tb2 f88 30 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
738 def test tb2 f89 31 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
739 def test tb2 f90 32 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
740 def test tb2 f91 33 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
741 def test tb2 f92 34 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
742 def test tb2 f93 35 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
743 def test tb2 f94 36 8.8 NO double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
744 def test tb2 f95 37 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
745 def test tb2 f96 38 8.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
746 def test tb2 f97 39 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
747 def test tb2 f98 40 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
748 def test tb2 f99 41 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
749 def test tb2 f100 42 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
750 def test tb2 f101 43 2000-01-01 NO date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
751 def test tb2 f102 44 00:00:20 NO time NULL NULL NULL NULL 0 NULL NULL time select,insert,update,references NULL
752 def test tb2 f103 45 0002-02-02 00:00:00 NO datetime NULL NULL NULL NULL 0 NULL NULL datetime select,insert,update,references NULL
753 def test tb2 f104 46 2000-12-31 23:59:59 NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select,insert,update,references NULL
754 def test tb2 f105 47 2000 NO year NULL NULL NULL NULL NULL NULL NULL year select,insert,update,references NULL
755 def test tb2 f108 48 1enum NO enum 5 5 NULL NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references NULL
756 def test tb2 f109 49 1set NO set 9 9 NULL NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references NULL
757 def test tb3 f118 1 a NO char 1 1 NULL NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references NULL
758 def test tb3 f119 2  NO char 1 1 NULL NULL NULL latin1 latin1_bin char(1) select,insert,update,references NULL
759 def test tb3 f120 3  NO char 1 1 NULL NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references NULL
760 def test tb3 f121 4 NULL YES tinytext 255 255 NULL NULL NULL latin1 latin1_swedish_ci tinytext select,insert,update,references NULL
761 def test tb3 f122 5 NULL YES text 65535 65535 NULL NULL NULL latin1 latin1_swedish_ci text select,insert,update,references NULL
762 def test tb3 f123 6 NULL YES mediumtext 16777215 16777215 NULL NULL NULL latin1 latin1_swedish_ci mediumtext select,insert,update,references NULL
763 def test tb3 f124 7 NULL YES longtext 4294967295 4294967295 NULL NULL NULL latin1 latin1_swedish_ci longtext select,insert,update,references NULL
764 def test tb3 f125 8 NULL YES tinyblob 255 255 NULL NULL NULL NULL NULL tinyblob select,insert,update,references NULL
765 def test tb3 f126 9 NULL YES blob 65535 65535 NULL NULL NULL NULL NULL blob select,insert,update,references NULL
766 def test tb3 f127 10 NULL YES mediumblob 16777215 16777215 NULL NULL NULL NULL NULL mediumblob select,insert,update,references NULL
767 def test tb3 f128 11 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL NULL longblob select,insert,update,references NULL
768 def test tb3 f129 12 0x05 NO binary 1 1 NULL NULL NULL NULL NULL binary(1) select,insert,update,references NULL
769 def test tb3 f130 13 99 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint select,insert,update,references NULL
770 def test tb3 f131 14 99 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint unsigned select,insert,update,references NULL
771 def test tb3 f132 15 099 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned zerofill select,insert,update,references NULL
772 def test tb3 f133 16 099 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned zerofill select,insert,update,references NULL
773 def test tb3 f134 17 999 NO smallint NULL NULL 5 0 NULL NULL NULL smallint select,insert,update,references NULL
774 def test tb3 f135 18 999 NO smallint NULL NULL 5 0 NULL NULL NULL smallint unsigned select,insert,update,references NULL
775 def test tb3 f136 19 00999 NO smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned zerofill select,insert,update,references NULL
776 def test tb3 f137 20 00999 NO smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned zerofill select,insert,update,references NULL
777 def test tb3 f138 21 9999 NO mediumint NULL NULL 7 0 NULL NULL NULL mediumint select,insert,update,references NULL
778 def test tb3 f139 22 9999 NO mediumint NULL NULL 7 0 NULL NULL NULL mediumint unsigned select,insert,update,references NULL
779 def test tb3 f140 23 00009999 NO mediumint NULL NULL 7 0 NULL NULL NULL mediumint(8) unsigned zerofill select,insert,update,references NULL
780 def test tb3 f141 24 00009999 NO mediumint NULL NULL 7 0 NULL NULL NULL mediumint(8) unsigned zerofill select,insert,update,references NULL
781 def test tb3 f142 25 99999 NO int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
782 def test tb3 f143 26 99999 NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL
783 def test tb3 f144 27 0000099999 NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned zerofill select,insert,update,references NULL
784 def test tb3 f145 28 0000099999 NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned zerofill select,insert,update,references NULL
785 def test tb3 f146 29 999999 NO bigint NULL NULL 19 0 NULL NULL NULL bigint select,insert,update,references NULL
786 def test tb3 f147 30 999999 NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL
787 def test tb3 f148 31 00000000000000999999 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned zerofill select,insert,update,references NULL
788 def test tb3 f149 32 00000000000000999999 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned zerofill select,insert,update,references NULL
789 def test tb3 f150 33 1000 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
790 def test tb3 f151 34 999 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
791 def test tb3 f152 35 0000001000 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
792 def test tb3 f153 36 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
793 def test tb3 f154 37 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
794 def test tb3 f155 38 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) select,insert,update,references NULL
795 def test tb3 f156 39 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
796 def test tb3 f157 40 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL
797 def test tb3 f158 41 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
798 def test tb3 f159 42 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
799 def test tb3 f160 43 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
800 def test tb3 f161 44 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
801 def test tb3 f162 45 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
802 def test tb3 f163 46 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL
803 def test tb3 f164 47 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
804 def test tb3 f165 48 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL
805 def test tb3 f166 49 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
806 def test tb3 f167 50 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
807 def test tb3 f168 51 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
808 def test tb3 f169 52 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
809 def test tb3 f170 53 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
810 def test tb3 f171 54 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
811 def test tb3 f172 55 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
812 def test tb3 f173 56 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
813 def test tb3 f174 57 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
814 def test tb3 f175 58 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) select,insert,update,references NULL
815 def test tb4 f176 1 9 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
816 def test tb4 f177 2 9 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL
817 def test tb4 f178 3 0000000009 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
818 def test tb4 f179 4 0000000000000000000000000000000000000000000000000000000000000009 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
819 def test tb4 f180 5 0000000009 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
820 def test tb4 f181 6 0000000000000000000000000000000000000000000000000000000000000009 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
821 def test tb4 f182 7 9 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
822 def test tb4 f183 8 9.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL
823 def test tb4 f184 9 9 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
824 def test tb4 f185 10 9.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL
825 def test tb4 f186 11 0000000009 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
826 def test tb4 f187 12 000000000000000000000000000000009.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
827 def test tb4 f188 13 0000000009 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
828 def test tb4 f189 14 000000000000000000000000000000009.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
829 def test tb4 f190 15 88.8 NO double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
830 def test tb4 f191 16 88.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
831 def test tb4 f192 17 00000000000000000088.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
832 def test tb4 f193 18 00000000000000000088.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
833 def test tb4 f194 19 55.5 NO double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
834 def test tb4 f195 20 55.5 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
835 def test tb4 f196 21 00000000000000000055.5 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
836 def test tb4 f197 22 00000000000000000055.5 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
837 def test tb4 f198 23 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
838 def test tb4 f199 24 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
839 def test tb4 f200 25 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
840 def test tb4 f201 26 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
841 def test tb4 f202 27 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
842 def test tb4 f203 28 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
843 def test tb4 f204 29 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
844 def test tb4 f205 30 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
845 def test tb4 f206 31 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
846 def test tb4 f207 32 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
847 def test tb4 f208 33 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
848 def test tb4 f209 34 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
849 def test tb4 f210 35 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
850 def test tb4 f211 36 NULL YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
851 def test tb4 f212 37 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
852 def test tb4 f213 38 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
853 def test tb4 f214 39 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
854 def test tb4 f215 40 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
855 def test tb4 f216 41 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
856 def test tb4 f217 42 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
857 def test tb4 f218 43 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
858 def test tb4 f219 44 NULL YES time NULL NULL NULL NULL 0 NULL NULL time select,insert,update,references NULL
859 def test tb4 f220 45 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select,insert,update,references NULL
860 def test tb4 f221 46 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP select,insert,update,references NULL
861 def test tb4 f222 47 NULL YES year NULL NULL NULL NULL NULL NULL NULL year select,insert,update,references NULL
862 def test tb4 f225 48 NULL YES enum 5 5 NULL NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references NULL
863 def test tb4 f226 49 NULL YES set 9 9 NULL NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references NULL
864 def test tb4 f235 50 NULL YES char 0 0 NULL NULL NULL latin1 latin1_swedish_ci char(0) select,insert,update,references NULL
865 def test tb4 f236 51 NULL YES char 90 90 NULL NULL NULL latin1 latin1_swedish_ci char(90) select,insert,update,references NULL
866 def test tb4 f237 52 NULL YES char 255 255 NULL NULL NULL latin1 latin1_swedish_ci char(255) select,insert,update,references NULL
867 def test tb4 f238 53 NULL YES varchar 0 0 NULL NULL NULL latin1 latin1_swedish_ci varchar(0) select,insert,update,references NULL
868 def test tb4 f239 54 NULL YES varchar 20000 20000 NULL NULL NULL latin1 latin1_bin varchar(20000) select,insert,update,references NULL
869 def test tb4 f240 55 NULL YES varchar 2000 2000 NULL NULL NULL latin1 latin1_swedish_ci varchar(2000) select,insert,update,references NULL
870 def test tb4 f241 56 NULL YES char 100 100 NULL NULL NULL latin1 latin1_swedish_ci char(100) select,insert,update,references NULL
871 def test1 tb2 f59 1 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
872 def test1 tb2 f60 2 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL
873 def test1 tb2 f61 3 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
874 def test1 tb2 f62 4 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
875 def test1 tb2 f63 5 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
876 def test1 tb2 f64 6 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
877 def test1 tb2 f65 7 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
878 def test1 tb2 f66 8 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL
879 def test1 tb2 f67 9 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
880 def test1 tb2 f68 10 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL
881 def test1 tb2 f69 11 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
882 def test1 tb2 f70 12 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
883 def test1 tb2 f71 13 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
884 def test1 tb2 f72 14 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
885 def test1 tb2 f73 15 NULL YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
886 def test1 tb2 f74 16 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
887 def test1 tb2 f75 17 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
888 def test1 tb2 f76 18 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
889 def test1 tb2 f77 19 7.7 YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
890 def test1 tb2 f78 20 7.7 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
891 def test1 tb2 f79 21 00000000000000000007.7 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
892 def test1 tb2 f80 22 00000000000000000008.8 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
893 def test1 tb2 f81 23 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
894 def test1 tb2 f82 24 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
895 def test1 tb2 f83 25 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
896 def test1 tb2 f84 26 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
897 def test1 tb2 f85 27 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
898 def test1 tb2 f86 28 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
899 def test1 tb2 f87 29 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
900 def test1 tb2 f88 30 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
901 def test1 tb2 f89 31 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
902 def test1 tb2 f90 32 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
903 def test1 tb2 f91 33 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
904 def test1 tb2 f92 34 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
905 def test1 tb2 f93 35 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
906 def test1 tb2 f94 36 8.8 NO double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
907 def test1 tb2 f95 37 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
908 def test1 tb2 f96 38 8.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
909 def test1 tb2 f97 39 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
910 def test1 tb2 f98 40 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
911 def test1 tb2 f99 41 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
912 def test1 tb2 f100 42 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
913 def test1 tb2 f101 43 2000-01-01 NO date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
914 def test1 tb2 f102 44 00:00:20 NO time NULL NULL NULL NULL 0 NULL NULL time select,insert,update,references NULL
915 def test1 tb2 f103 45 0002-02-02 00:00:00 NO datetime NULL NULL NULL NULL 0 NULL NULL datetime select,insert,update,references NULL
916 def test1 tb2 f104 46 2000-12-31 23:59:59 NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select,insert,update,references NULL
917 def test1 tb2 f105 47 2000 NO year NULL NULL NULL NULL NULL NULL NULL year select,insert,update,references NULL
918 def test1 tb2 f108 48 1enum NO enum 5 5 NULL NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references NULL
919 def test1 tb2 f109 49 1set NO set 9 9 NULL NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references NULL
920 def test4 t6 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
921 def test4 t6 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
922 def test4 t6 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
923 def test4 t6 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
924 def test4 t6 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
925 def test4 t6 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
926 ##########################################################################
927 # Show the quotient of CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH
928 ##########################################################################
929 SELECT DISTINCT
930 CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
931 DATA_TYPE,
932 CHARACTER_SET_NAME,
933 COLLATION_NAME
934 FROM information_schema.columns
935 WHERE table_schema LIKE 'test%'
936 AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH = 1
937 ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE;
938 COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
939 1.0000 binary NULL NULL
940 1.0000 blob NULL NULL
941 1.0000 longblob NULL NULL
942 1.0000 mediumblob NULL NULL
943 1.0000 tinyblob NULL NULL
944 1.0000 char latin1 latin1_bin
945 1.0000 varchar latin1 latin1_bin
946 1.0000 char latin1 latin1_swedish_ci
947 1.0000 enum latin1 latin1_swedish_ci
948 1.0000 longtext latin1 latin1_swedish_ci
949 1.0000 mediumtext latin1 latin1_swedish_ci
950 1.0000 set latin1 latin1_swedish_ci
951 1.0000 text latin1 latin1_swedish_ci
952 1.0000 tinytext latin1 latin1_swedish_ci
953 1.0000 varchar latin1 latin1_swedish_ci
954 SELECT DISTINCT
955 CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
956 DATA_TYPE,
957 CHARACTER_SET_NAME,
958 COLLATION_NAME
959 FROM information_schema.columns
960 WHERE table_schema LIKE 'test%'
961 AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH <> 1
962 ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE;
963 COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
964 SELECT DISTINCT
965 CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
966 DATA_TYPE,
967 CHARACTER_SET_NAME,
968 COLLATION_NAME
969 FROM information_schema.columns
970 WHERE table_schema LIKE 'test%'
971 AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH IS NULL
972 ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE;
973 COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
974 NULL bigint NULL NULL
975 NULL date NULL NULL
976 NULL datetime NULL NULL
977 NULL decimal NULL NULL
978 NULL double NULL NULL
979 NULL float NULL NULL
980 NULL int NULL NULL
981 NULL mediumint NULL NULL
982 NULL smallint NULL NULL
983 NULL time NULL NULL
984 NULL timestamp NULL NULL
985 NULL tinyint NULL NULL
986 NULL year NULL NULL
987 NULL char latin1 latin1_bin
988 NULL char latin1 latin1_swedish_ci
989 NULL varchar latin1 latin1_swedish_ci
990 --> CHAR(0) is allowed (see manual), and here both CHARACHTER_* values
991 --> are 0, which is intended behavior, and the result of 0 / 0 IS NULL
992 SELECT CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
993 TABLE_SCHEMA,
994 TABLE_NAME,
995 COLUMN_NAME,
996 DATA_TYPE,
997 CHARACTER_MAXIMUM_LENGTH,
998 CHARACTER_OCTET_LENGTH,
999 CHARACTER_SET_NAME,
1000 COLLATION_NAME,
1001 COLUMN_TYPE
1002 FROM information_schema.columns
1003 WHERE table_schema LIKE 'test%'
1004 ORDER BY TABLE_SCHEMA, TABLE_NAME COLLATE utf8_general_ci, ORDINAL_POSITION;
1005 COL_CML TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE
1006 1.0000 test t1 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1007 1.0000 test t1 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1008 NULL test t1 f3 date NULL NULL NULL NULL date
1009 NULL test t1 f4 int NULL NULL NULL NULL int
1010 1.0000 test t1 f5 char 25 25 latin1 latin1_swedish_ci char(25)
1011 NULL test t1 f6 int NULL NULL NULL NULL int
1012 1.0000 test t10 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1013 1.0000 test t10 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1014 NULL test t10 f3 date NULL NULL NULL NULL date
1015 NULL test t10 f4 int NULL NULL NULL NULL int
1016 1.0000 test t10 f5 char 25 25 latin1 latin1_swedish_ci char(25)
1017 NULL test t10 f6 int NULL NULL NULL NULL int
1018 1.0000 test t11 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1019 1.0000 test t11 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1020 NULL test t11 f3 date NULL NULL NULL NULL date
1021 NULL test t11 f4 int NULL NULL NULL NULL int
1022 1.0000 test t11 f5 char 25 25 latin1 latin1_swedish_ci char(25)
1023 NULL test t11 f6 int NULL NULL NULL NULL int
1024 1.0000 test t2 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1025 1.0000 test t2 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1026 NULL test t2 f3 date NULL NULL NULL NULL date
1027 NULL test t2 f4 int NULL NULL NULL NULL int
1028 1.0000 test t2 f5 char 25 25 latin1 latin1_swedish_ci char(25)
1029 NULL test t2 f6 int NULL NULL NULL NULL int
1030 1.0000 test t3 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1031 1.0000 test t3 f2 char 20 20 latin1 latin1_swedish_ci char(20)
1032 NULL test t3 f3 int NULL NULL NULL NULL int
1033 1.0000 test t4 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1034 1.0000 test t4 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1035 NULL test t4 f3 date NULL NULL NULL NULL date
1036 NULL test t4 f4 int NULL NULL NULL NULL int
1037 1.0000 test t4 f5 char 25 25 latin1 latin1_swedish_ci char(25)
1038 NULL test t4 f6 int NULL NULL NULL NULL int
1039 1.0000 test t7 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1040 1.0000 test t7 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1041 NULL test t7 f3 date NULL NULL NULL NULL date
1042 NULL test t7 f4 int NULL NULL NULL NULL int
1043 1.0000 test t8 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1044 1.0000 test t8 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1045 NULL test t8 f3 date NULL NULL NULL NULL date
1046 NULL test t8 f4 int NULL NULL NULL NULL int
1047 NULL test t9 f1 int NULL NULL NULL NULL int
1048 1.0000 test t9 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1049 NULL test t9 f3 int NULL NULL NULL NULL int
1050 NULL test tb1 f1 char 0 0 latin1 latin1_swedish_ci char(0)
1051 NULL test tb1 f2 char 0 0 latin1 latin1_bin char(0)
1052 NULL test tb1 f3 char 0 0 latin1 latin1_swedish_ci char(0)
1053 1.0000 test tb1 f4 tinytext 255 255 latin1 latin1_swedish_ci tinytext
1054 1.0000 test tb1 f5 text 65535 65535 latin1 latin1_swedish_ci text
1055 1.0000 test tb1 f6 mediumtext 16777215 16777215 latin1 latin1_swedish_ci mediumtext
1056 1.0000 test tb1 f7 longtext 4294967295 4294967295 latin1 latin1_swedish_ci longtext
1057 1.0000 test tb1 f8 tinyblob 255 255 NULL NULL tinyblob
1058 1.0000 test tb1 f9 blob 65535 65535 NULL NULL blob
1059 1.0000 test tb1 f10 mediumblob 16777215 16777215 NULL NULL mediumblob
1060 1.0000 test tb1 f11 longblob 4294967295 4294967295 NULL NULL longblob
1061 1.0000 test tb1 f12 binary 1 1 NULL NULL binary(1)
1062 NULL test tb1 f13 tinyint NULL NULL NULL NULL tinyint
1063 NULL test tb1 f14 tinyint NULL NULL NULL NULL tinyint unsigned
1064 NULL test tb1 f15 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill
1065 NULL test tb1 f16 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill
1066 NULL test tb1 f17 smallint NULL NULL NULL NULL smallint
1067 NULL test tb1 f18 smallint NULL NULL NULL NULL smallint unsigned
1068 NULL test tb1 f19 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill
1069 NULL test tb1 f20 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill
1070 NULL test tb1 f21 mediumint NULL NULL NULL NULL mediumint
1071 NULL test tb1 f22 mediumint NULL NULL NULL NULL mediumint unsigned
1072 NULL test tb1 f23 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill
1073 NULL test tb1 f24 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill
1074 NULL test tb1 f25 int NULL NULL NULL NULL int
1075 NULL test tb1 f26 int NULL NULL NULL NULL int unsigned
1076 NULL test tb1 f27 int NULL NULL NULL NULL int(10) unsigned zerofill
1077 NULL test tb1 f28 int NULL NULL NULL NULL int(10) unsigned zerofill
1078 NULL test tb1 f29 bigint NULL NULL NULL NULL bigint
1079 NULL test tb1 f30 bigint NULL NULL NULL NULL bigint unsigned
1080 NULL test tb1 f31 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill
1081 NULL test tb1 f32 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill
1082 NULL test tb1 f33 decimal NULL NULL NULL NULL decimal(10,0)
1083 NULL test tb1 f34 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1084 NULL test tb1 f35 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1085 NULL test tb1 f36 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1086 NULL test tb1 f37 decimal NULL NULL NULL NULL decimal(10,0)
1087 NULL test tb1 f38 decimal NULL NULL NULL NULL decimal(64,0)
1088 NULL test tb1 f39 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1089 NULL test tb1 f40 decimal NULL NULL NULL NULL decimal(64,0) unsigned
1090 NULL test tb1 f41 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1091 NULL test tb1 f42 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1092 NULL test tb1 f43 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1093 NULL test tb1 f44 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1094 NULL test tb1 f45 decimal NULL NULL NULL NULL decimal(10,0)
1095 NULL test tb1 f46 decimal NULL NULL NULL NULL decimal(63,30)
1096 NULL test tb1 f47 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1097 NULL test tb1 f48 decimal NULL NULL NULL NULL decimal(63,30) unsigned
1098 NULL test tb1 f49 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1099 NULL test tb1 f50 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1100 NULL test tb1 f51 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1101 NULL test tb1 f52 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1102 NULL test tb1 f53 decimal NULL NULL NULL NULL decimal(10,0)
1103 NULL test tb1 f54 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1104 NULL test tb1 f55 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1105 NULL test tb1 f56 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1106 NULL test tb1 f57 decimal NULL NULL NULL NULL decimal(10,0)
1107 NULL test tb1 f58 decimal NULL NULL NULL NULL decimal(64,0)
1108 NULL test tb2 f59 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1109 NULL test tb2 f60 decimal NULL NULL NULL NULL decimal(64,0) unsigned
1110 NULL test tb2 f61 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1111 NULL test tb2 f62 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1112 NULL test tb2 f63 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1113 NULL test tb2 f64 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1114 NULL test tb2 f65 decimal NULL NULL NULL NULL decimal(10,0)
1115 NULL test tb2 f66 decimal NULL NULL NULL NULL decimal(63,30)
1116 NULL test tb2 f67 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1117 NULL test tb2 f68 decimal NULL NULL NULL NULL decimal(63,30) unsigned
1118 NULL test tb2 f69 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1119 NULL test tb2 f70 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1120 NULL test tb2 f71 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1121 NULL test tb2 f72 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1122 NULL test tb2 f73 double NULL NULL NULL NULL double
1123 NULL test tb2 f74 double NULL NULL NULL NULL double unsigned
1124 NULL test tb2 f75 double NULL NULL NULL NULL double unsigned zerofill
1125 NULL test tb2 f76 double NULL NULL NULL NULL double unsigned zerofill
1126 NULL test tb2 f77 double NULL NULL NULL NULL double
1127 NULL test tb2 f78 double NULL NULL NULL NULL double unsigned
1128 NULL test tb2 f79 double NULL NULL NULL NULL double unsigned zerofill
1129 NULL test tb2 f80 double NULL NULL NULL NULL double unsigned zerofill
1130 NULL test tb2 f81 float NULL NULL NULL NULL float
1131 NULL test tb2 f82 float NULL NULL NULL NULL float unsigned
1132 NULL test tb2 f83 float NULL NULL NULL NULL float unsigned zerofill
1133 NULL test tb2 f84 float NULL NULL NULL NULL float unsigned zerofill
1134 NULL test tb2 f85 float NULL NULL NULL NULL float
1135 NULL test tb2 f86 float NULL NULL NULL NULL float
1136 NULL test tb2 f87 float NULL NULL NULL NULL float unsigned
1137 NULL test tb2 f88 float NULL NULL NULL NULL float unsigned
1138 NULL test tb2 f89 float NULL NULL NULL NULL float unsigned zerofill
1139 NULL test tb2 f90 float NULL NULL NULL NULL float unsigned zerofill
1140 NULL test tb2 f91 float NULL NULL NULL NULL float unsigned zerofill
1141 NULL test tb2 f92 float NULL NULL NULL NULL float unsigned zerofill
1142 NULL test tb2 f93 float NULL NULL NULL NULL float
1143 NULL test tb2 f94 double NULL NULL NULL NULL double
1144 NULL test tb2 f95 float NULL NULL NULL NULL float unsigned
1145 NULL test tb2 f96 double NULL NULL NULL NULL double unsigned
1146 NULL test tb2 f97 float NULL NULL NULL NULL float unsigned zerofill
1147 NULL test tb2 f98 double NULL NULL NULL NULL double unsigned zerofill
1148 NULL test tb2 f99 float NULL NULL NULL NULL float unsigned zerofill
1149 NULL test tb2 f100 double NULL NULL NULL NULL double unsigned zerofill
1150 NULL test tb2 f101 date NULL NULL NULL NULL date
1151 NULL test tb2 f102 time NULL NULL NULL NULL time
1152 NULL test tb2 f103 datetime NULL NULL NULL NULL datetime
1153 NULL test tb2 f104 timestamp NULL NULL NULL NULL timestamp
1154 NULL test tb2 f105 year NULL NULL NULL NULL year
1155 1.0000 test tb2 f108 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum')
1156 1.0000 test tb2 f109 set 9 9 latin1 latin1_swedish_ci set('1set','2set')
1157 1.0000 test tb3 f118 char 1 1 latin1 latin1_swedish_ci char(1)
1158 1.0000 test tb3 f119 char 1 1 latin1 latin1_bin char(1)
1159 1.0000 test tb3 f120 char 1 1 latin1 latin1_swedish_ci char(1)
1160 1.0000 test tb3 f121 tinytext 255 255 latin1 latin1_swedish_ci tinytext
1161 1.0000 test tb3 f122 text 65535 65535 latin1 latin1_swedish_ci text
1162 1.0000 test tb3 f123 mediumtext 16777215 16777215 latin1 latin1_swedish_ci mediumtext
1163 1.0000 test tb3 f124 longtext 4294967295 4294967295 latin1 latin1_swedish_ci longtext
1164 1.0000 test tb3 f125 tinyblob 255 255 NULL NULL tinyblob
1165 1.0000 test tb3 f126 blob 65535 65535 NULL NULL blob
1166 1.0000 test tb3 f127 mediumblob 16777215 16777215 NULL NULL mediumblob
1167 1.0000 test tb3 f128 longblob 4294967295 4294967295 NULL NULL longblob
1168 1.0000 test tb3 f129 binary 1 1 NULL NULL binary(1)
1169 NULL test tb3 f130 tinyint NULL NULL NULL NULL tinyint
1170 NULL test tb3 f131 tinyint NULL NULL NULL NULL tinyint unsigned
1171 NULL test tb3 f132 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill
1172 NULL test tb3 f133 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill
1173 NULL test tb3 f134 smallint NULL NULL NULL NULL smallint
1174 NULL test tb3 f135 smallint NULL NULL NULL NULL smallint unsigned
1175 NULL test tb3 f136 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill
1176 NULL test tb3 f137 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill
1177 NULL test tb3 f138 mediumint NULL NULL NULL NULL mediumint
1178 NULL test tb3 f139 mediumint NULL NULL NULL NULL mediumint unsigned
1179 NULL test tb3 f140 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill
1180 NULL test tb3 f141 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill
1181 NULL test tb3 f142 int NULL NULL NULL NULL int
1182 NULL test tb3 f143 int NULL NULL NULL NULL int unsigned
1183 NULL test tb3 f144 int NULL NULL NULL NULL int(10) unsigned zerofill
1184 NULL test tb3 f145 int NULL NULL NULL NULL int(10) unsigned zerofill
1185 NULL test tb3 f146 bigint NULL NULL NULL NULL bigint
1186 NULL test tb3 f147 bigint NULL NULL NULL NULL bigint unsigned
1187 NULL test tb3 f148 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill
1188 NULL test tb3 f149 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill
1189 NULL test tb3 f150 decimal NULL NULL NULL NULL decimal(10,0)
1190 NULL test tb3 f151 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1191 NULL test tb3 f152 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1192 NULL test tb3 f153 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1193 NULL test tb3 f154 decimal NULL NULL NULL NULL decimal(10,0)
1194 NULL test tb3 f155 decimal NULL NULL NULL NULL decimal(64,0)
1195 NULL test tb3 f156 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1196 NULL test tb3 f157 decimal NULL NULL NULL NULL decimal(64,0) unsigned
1197 NULL test tb3 f158 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1198 NULL test tb3 f159 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1199 NULL test tb3 f160 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1200 NULL test tb3 f161 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1201 NULL test tb3 f162 decimal NULL NULL NULL NULL decimal(10,0)
1202 NULL test tb3 f163 decimal NULL NULL NULL NULL decimal(63,30)
1203 NULL test tb3 f164 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1204 NULL test tb3 f165 decimal NULL NULL NULL NULL decimal(63,30) unsigned
1205 NULL test tb3 f166 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1206 NULL test tb3 f167 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1207 NULL test tb3 f168 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1208 NULL test tb3 f169 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1209 NULL test tb3 f170 decimal NULL NULL NULL NULL decimal(10,0)
1210 NULL test tb3 f171 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1211 NULL test tb3 f172 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1212 NULL test tb3 f173 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1213 NULL test tb3 f174 decimal NULL NULL NULL NULL decimal(10,0)
1214 NULL test tb3 f175 decimal NULL NULL NULL NULL decimal(64,0)
1215 NULL test tb4 f176 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1216 NULL test tb4 f177 decimal NULL NULL NULL NULL decimal(64,0) unsigned
1217 NULL test tb4 f178 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1218 NULL test tb4 f179 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1219 NULL test tb4 f180 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1220 NULL test tb4 f181 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1221 NULL test tb4 f182 decimal NULL NULL NULL NULL decimal(10,0)
1222 NULL test tb4 f183 decimal NULL NULL NULL NULL decimal(63,30)
1223 NULL test tb4 f184 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1224 NULL test tb4 f185 decimal NULL NULL NULL NULL decimal(63,30) unsigned
1225 NULL test tb4 f186 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1226 NULL test tb4 f187 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1227 NULL test tb4 f188 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1228 NULL test tb4 f189 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1229 NULL test tb4 f190 double NULL NULL NULL NULL double
1230 NULL test tb4 f191 double NULL NULL NULL NULL double unsigned
1231 NULL test tb4 f192 double NULL NULL NULL NULL double unsigned zerofill
1232 NULL test tb4 f193 double NULL NULL NULL NULL double unsigned zerofill
1233 NULL test tb4 f194 double NULL NULL NULL NULL double
1234 NULL test tb4 f195 double NULL NULL NULL NULL double unsigned
1235 NULL test tb4 f196 double NULL NULL NULL NULL double unsigned zerofill
1236 NULL test tb4 f197 double NULL NULL NULL NULL double unsigned zerofill
1237 NULL test tb4 f198 float NULL NULL NULL NULL float
1238 NULL test tb4 f199 float NULL NULL NULL NULL float unsigned
1239 NULL test tb4 f200 float NULL NULL NULL NULL float unsigned zerofill
1240 NULL test tb4 f201 float NULL NULL NULL NULL float unsigned zerofill
1241 NULL test tb4 f202 float NULL NULL NULL NULL float
1242 NULL test tb4 f203 float NULL NULL NULL NULL float
1243 NULL test tb4 f204 float NULL NULL NULL NULL float unsigned
1244 NULL test tb4 f205 float NULL NULL NULL NULL float unsigned
1245 NULL test tb4 f206 float NULL NULL NULL NULL float unsigned zerofill
1246 NULL test tb4 f207 float NULL NULL NULL NULL float unsigned zerofill
1247 NULL test tb4 f208 float NULL NULL NULL NULL float unsigned zerofill
1248 NULL test tb4 f209 float NULL NULL NULL NULL float unsigned zerofill
1249 NULL test tb4 f210 float NULL NULL NULL NULL float
1250 NULL test tb4 f211 double NULL NULL NULL NULL double
1251 NULL test tb4 f212 float NULL NULL NULL NULL float unsigned
1252 NULL test tb4 f213 double NULL NULL NULL NULL double unsigned
1253 NULL test tb4 f214 float NULL NULL NULL NULL float unsigned zerofill
1254 NULL test tb4 f215 double NULL NULL NULL NULL double unsigned zerofill
1255 NULL test tb4 f216 float NULL NULL NULL NULL float unsigned zerofill
1256 NULL test tb4 f217 double NULL NULL NULL NULL double unsigned zerofill
1257 NULL test tb4 f218 date NULL NULL NULL NULL date
1258 NULL test tb4 f219 time NULL NULL NULL NULL time
1259 NULL test tb4 f220 datetime NULL NULL NULL NULL datetime
1260 NULL test tb4 f221 timestamp NULL NULL NULL NULL timestamp
1261 NULL test tb4 f222 year NULL NULL NULL NULL year
1262 1.0000 test tb4 f225 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum')
1263 1.0000 test tb4 f226 set 9 9 latin1 latin1_swedish_ci set('1set','2set')
1264 NULL test tb4 f235 char 0 0 latin1 latin1_swedish_ci char(0)
1265 1.0000 test tb4 f236 char 90 90 latin1 latin1_swedish_ci char(90)
1266 1.0000 test tb4 f237 char 255 255 latin1 latin1_swedish_ci char(255)
1267 NULL test tb4 f238 varchar 0 0 latin1 latin1_swedish_ci varchar(0)
1268 1.0000 test tb4 f239 varchar 20000 20000 latin1 latin1_bin varchar(20000)
1269 1.0000 test tb4 f240 varchar 2000 2000 latin1 latin1_swedish_ci varchar(2000)
1270 1.0000 test tb4 f241 char 100 100 latin1 latin1_swedish_ci char(100)
1271 NULL test1 tb2 f59 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1272 NULL test1 tb2 f60 decimal NULL NULL NULL NULL decimal(64,0) unsigned
1273 NULL test1 tb2 f61 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1274 NULL test1 tb2 f62 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1275 NULL test1 tb2 f63 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1276 NULL test1 tb2 f64 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1277 NULL test1 tb2 f65 decimal NULL NULL NULL NULL decimal(10,0)
1278 NULL test1 tb2 f66 decimal NULL NULL NULL NULL decimal(63,30)
1279 NULL test1 tb2 f67 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1280 NULL test1 tb2 f68 decimal NULL NULL NULL NULL decimal(63,30) unsigned
1281 NULL test1 tb2 f69 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1282 NULL test1 tb2 f70 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1283 NULL test1 tb2 f71 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1284 NULL test1 tb2 f72 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1285 NULL test1 tb2 f73 double NULL NULL NULL NULL double
1286 NULL test1 tb2 f74 double NULL NULL NULL NULL double unsigned
1287 NULL test1 tb2 f75 double NULL NULL NULL NULL double unsigned zerofill
1288 NULL test1 tb2 f76 double NULL NULL NULL NULL double unsigned zerofill
1289 NULL test1 tb2 f77 double NULL NULL NULL NULL double
1290 NULL test1 tb2 f78 double NULL NULL NULL NULL double unsigned
1291 NULL test1 tb2 f79 double NULL NULL NULL NULL double unsigned zerofill
1292 NULL test1 tb2 f80 double NULL NULL NULL NULL double unsigned zerofill
1293 NULL test1 tb2 f81 float NULL NULL NULL NULL float
1294 NULL test1 tb2 f82 float NULL NULL NULL NULL float unsigned
1295 NULL test1 tb2 f83 float NULL NULL NULL NULL float unsigned zerofill
1296 NULL test1 tb2 f84 float NULL NULL NULL NULL float unsigned zerofill
1297 NULL test1 tb2 f85 float NULL NULL NULL NULL float
1298 NULL test1 tb2 f86 float NULL NULL NULL NULL float
1299 NULL test1 tb2 f87 float NULL NULL NULL NULL float unsigned
1300 NULL test1 tb2 f88 float NULL NULL NULL NULL float unsigned
1301 NULL test1 tb2 f89 float NULL NULL NULL NULL float unsigned zerofill
1302 NULL test1 tb2 f90 float NULL NULL NULL NULL float unsigned zerofill
1303 NULL test1 tb2 f91 float NULL NULL NULL NULL float unsigned zerofill
1304 NULL test1 tb2 f92 float NULL NULL NULL NULL float unsigned zerofill
1305 NULL test1 tb2 f93 float NULL NULL NULL NULL float
1306 NULL test1 tb2 f94 double NULL NULL NULL NULL double
1307 NULL test1 tb2 f95 float NULL NULL NULL NULL float unsigned
1308 NULL test1 tb2 f96 double NULL NULL NULL NULL double unsigned
1309 NULL test1 tb2 f97 float NULL NULL NULL NULL float unsigned zerofill
1310 NULL test1 tb2 f98 double NULL NULL NULL NULL double unsigned zerofill
1311 NULL test1 tb2 f99 float NULL NULL NULL NULL float unsigned zerofill
1312 NULL test1 tb2 f100 double NULL NULL NULL NULL double unsigned zerofill
1313 NULL test1 tb2 f101 date NULL NULL NULL NULL date
1314 NULL test1 tb2 f102 time NULL NULL NULL NULL time
1315 NULL test1 tb2 f103 datetime NULL NULL NULL NULL datetime
1316 NULL test1 tb2 f104 timestamp NULL NULL NULL NULL timestamp
1317 NULL test1 tb2 f105 year NULL NULL NULL NULL year
1318 1.0000 test1 tb2 f108 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum')
1319 1.0000 test1 tb2 f109 set 9 9 latin1 latin1_swedish_ci set('1set','2set')
1320 1.0000 test4 t6 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1321 1.0000 test4 t6 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1322 NULL test4 t6 f3 date NULL NULL NULL NULL date
1323 NULL test4 t6 f4 int NULL NULL NULL NULL int
1324 1.0000 test4 t6 f5 char 25 25 latin1 latin1_swedish_ci char(25)
1325 NULL test4 t6 f6 int NULL NULL NULL NULL int
1326 SET sql_mode = default;
1327 DROP DATABASE test1;
1328 DROP DATABASE test4;
1329 DROP TABLE test.t1;
1330 DROP TABLE test.t2;
1331 DROP TABLE test.t3;
1332 DROP TABLE test.t4;
1333 DROP TABLE test.t7;
1334 DROP TABLE test.t8;
1335 DROP TABLE test.t9;
1336 DROP TABLE test.t10;
1337 DROP TABLE test.t11;
1338 DROP TABLE test.tb1;
1339 DROP TABLE test.tb2;
1340 DROP TABLE test.tb3;
1341 DROP TABLE test.tb4;