Debian Codegraph @

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

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