80
80
Note 1265 Data truncated for column 'f47' at row 1
81
81
Note 1265 Data truncated for column 'f49' at row 1
82
82
Note 1265 Data truncated for column 'f51' at row 1
83
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/myisam_tb1.txt' into table tb1 ;
83
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/myisam_tb1.txt'
84
85
drop table if exists tb2 ;
86
f59 numeric (0) unsigned,
87
f60 numeric (64) unsigned,
88
f61 numeric (0) zerofill,
89
f62 numeric (64) zerofill,
90
f63 numeric (0) unsigned zerofill,
91
f64 numeric (64) unsigned zerofill,
94
f67 numeric (0,0) unsigned,
95
f68 numeric (63,30) unsigned,
96
f69 numeric (0,0) zerofill,
97
f70 numeric (63,30) zerofill,
98
f71 numeric (0,0) unsigned zerofill,
99
f72 numeric (63,30) unsigned zerofill,
103
f76 real unsigned zerofill,
104
f77 double default 7.7,
105
f78 double unsigned default 7.7,
106
f79 double zerofill default 7.7,
107
f80 double unsigned zerofill default 8.8,
108
f81 float not null default 8.8,
109
f82 float unsigned not null default 8.8,
110
f83 float zerofill not null default 8.8,
111
f84 float unsigned zerofill not null default 8.8,
112
f85 float(0) not null default 8.8,
113
f86 float(23) not null default 8.8,
114
f87 float(0) unsigned not null default 8.8,
115
f88 float(23) unsigned not null default 8.8,
116
f89 float(0) zerofill not null default 8.8,
117
f90 float(23) zerofill not null default 8.8,
118
f91 float(0) unsigned zerofill not null default 8.8,
119
f92 float(23) unsigned zerofill not null default 8.8,
120
f93 float(24) not null default 8.8,
121
f94 float(53) not null default 8.8,
122
f95 float(24) unsigned not null default 8.8,
123
f96 float(53) unsigned not null default 8.8,
124
f97 float(24) zerofill not null default 8.8,
125
f98 float(53) zerofill not null default 8.8,
126
f99 float(24) unsigned zerofill not null default 8.8,
127
f100 float(53) unsigned zerofill not null default 8.8,
128
f101 date not null default '2000-01-01',
129
f102 time not null default 20,
130
f103 datetime not null default '2/2/2',
131
f104 timestamp not null default 20001231235959,
132
f105 year not null default 2000,
133
f106 year(3) not null default 2000,
134
f107 year(4) not null default 2000,
135
f108 enum("1enum","2enum") not null default "1enum",
87
f59 numeric (0) unsigned,
88
f60 numeric (64) unsigned,
89
f61 numeric (0) zerofill,
90
f62 numeric (64) zerofill,
91
f63 numeric (0) unsigned zerofill,
92
f64 numeric (64) unsigned zerofill,
95
f67 numeric (0,0) unsigned,
96
f68 numeric (63,30) unsigned,
97
f69 numeric (0,0) zerofill,
98
f70 numeric (63,30) zerofill,
99
f71 numeric (0,0) unsigned zerofill,
100
f72 numeric (63,30) unsigned zerofill,
104
f76 real unsigned zerofill,
105
f77 double default 7.7,
106
f78 double unsigned default 7.7,
107
f79 double zerofill default 7.7,
108
f80 double unsigned zerofill default 8.8,
109
f81 float not null default 8.8,
110
f82 float unsigned not null default 8.8,
111
f83 float zerofill not null default 8.8,
112
f84 float unsigned zerofill not null default 8.8,
113
f85 float(0) not null default 8.8,
114
f86 float(23) not null default 8.8,
115
f87 float(0) unsigned not null default 8.8,
116
f88 float(23) unsigned not null default 8.8,
117
f89 float(0) zerofill not null default 8.8,
118
f90 float(23) zerofill not null default 8.8,
119
f91 float(0) unsigned zerofill not null default 8.8,
120
f92 float(23) unsigned zerofill not null default 8.8,
121
f93 float(24) not null default 8.8,
122
f94 float(53) not null default 8.8,
123
f95 float(24) unsigned not null default 8.8,
124
f96 float(53) unsigned not null default 8.8,
125
f97 float(24) zerofill not null default 8.8,
126
f98 float(53) zerofill not null default 8.8,
127
f99 float(24) unsigned zerofill not null default 8.8,
128
f100 float(53) unsigned zerofill not null default 8.8,
129
f101 date not null default '2000-01-01',
130
f102 time not null default 20,
131
f103 datetime not null default '2/2/2',
132
f104 timestamp not null default 20001231235959,
133
f105 year not null default 2000,
134
f106 year(3) not null default 2000,
135
f107 year(4) not null default 2000,
136
f108 enum("1enum","2enum") not null default "1enum",
136
137
f109 set("1set","2set") not null default "1set",
137
f110 VARBINARY(64) null,
138
f111 VARBINARY(27) null ,
139
f112 VARBINARY(64) null ,
140
f113 VARBINARY(192) null ,
141
f114 VARBINARY(192) ,
142
f115 VARBINARY(27) null ,
143
f116 VARBINARY(64) null,
144
f117 VARBINARY(192) null
138
f110 VARBINARY(64) null,
139
f111 VARBINARY(27) null ,
140
f112 VARBINARY(64) null ,
141
f113 VARBINARY(192) null ,
142
f114 VARBINARY(192) ,
143
f115 VARBINARY(27) null ,
144
f116 VARBINARY(64) null,
145
f117 VARBINARY(192) null
145
146
) engine = myisam;
146
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/myisam_tb2.txt' into table tb2 ;
147
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/myisam_tb2.txt'
147
149
drop table if exists tb3 ;
148
150
create table tb3 (
149
f118 char not null DEFAULT 'a',
150
f119 char binary not null DEFAULT b'101',
151
f120 char ascii not null DEFAULT b'101',
155
f124 longtext unicode,
160
f129 binary not null DEFAULT b'101',
161
f130 tinyint not null DEFAULT 99,
162
f131 tinyint unsigned not null DEFAULT 99,
163
f132 tinyint zerofill not null DEFAULT 99,
164
f133 tinyint unsigned zerofill not null DEFAULT 99,
165
f134 smallint not null DEFAULT 999,
166
f135 smallint unsigned not null DEFAULT 999,
167
f136 smallint zerofill not null DEFAULT 999,
168
f137 smallint unsigned zerofill not null DEFAULT 999,
169
f138 mediumint not null DEFAULT 9999,
170
f139 mediumint unsigned not null DEFAULT 9999,
171
f140 mediumint zerofill not null DEFAULT 9999,
172
f141 mediumint unsigned zerofill not null DEFAULT 9999,
173
f142 int not null DEFAULT 99999,
174
f143 int unsigned not null DEFAULT 99999,
175
f144 int zerofill not null DEFAULT 99999,
176
f145 int unsigned zerofill not null DEFAULT 99999,
177
f146 bigint not null DEFAULT 999999,
178
f147 bigint unsigned not null DEFAULT 999999,
179
f148 bigint zerofill not null DEFAULT 999999,
180
f149 bigint unsigned zerofill not null DEFAULT 999999,
181
f150 decimal not null DEFAULT 999.999,
182
f151 decimal unsigned not null DEFAULT 999.17,
183
f152 decimal zerofill not null DEFAULT 999.999,
184
f153 decimal unsigned zerofill,
187
f156 decimal (0) unsigned,
188
f157 decimal (64) unsigned,
189
f158 decimal (0) zerofill,
190
f159 decimal (64) zerofill,
191
f160 decimal (0) unsigned zerofill,
192
f161 decimal (64) unsigned zerofill,
194
f163 decimal (63,30),
195
f164 decimal (0,0) unsigned,
196
f165 decimal (63,30) unsigned,
197
f166 decimal (0,0) zerofill,
198
f167 decimal (63,30) zerofill,
199
f168 decimal (0,0) unsigned zerofill,
200
f169 decimal (63,30) unsigned zerofill,
202
f171 numeric unsigned,
203
f172 numeric zerofill,
204
f173 numeric unsigned zerofill,
151
f118 char not null DEFAULT 'a',
152
f119 char binary not null DEFAULT b'101',
153
f120 char ascii not null DEFAULT b'101',
162
f129 binary not null DEFAULT b'101',
163
f130 tinyint not null DEFAULT 99,
164
f131 tinyint unsigned not null DEFAULT 99,
165
f132 tinyint zerofill not null DEFAULT 99,
166
f133 tinyint unsigned zerofill not null DEFAULT 99,
167
f134 smallint not null DEFAULT 999,
168
f135 smallint unsigned not null DEFAULT 999,
169
f136 smallint zerofill not null DEFAULT 999,
170
f137 smallint unsigned zerofill not null DEFAULT 999,
171
f138 mediumint not null DEFAULT 9999,
172
f139 mediumint unsigned not null DEFAULT 9999,
173
f140 mediumint zerofill not null DEFAULT 9999,
174
f141 mediumint unsigned zerofill not null DEFAULT 9999,
175
f142 int not null DEFAULT 99999,
176
f143 int unsigned not null DEFAULT 99999,
177
f144 int zerofill not null DEFAULT 99999,
178
f145 int unsigned zerofill not null DEFAULT 99999,
179
f146 bigint not null DEFAULT 999999,
180
f147 bigint unsigned not null DEFAULT 999999,
181
f148 bigint zerofill not null DEFAULT 999999,
182
f149 bigint unsigned zerofill not null DEFAULT 999999,
183
f150 decimal not null DEFAULT 999.999,
184
f151 decimal unsigned not null DEFAULT 999.17,
185
f152 decimal zerofill not null DEFAULT 999.999,
186
f153 decimal unsigned zerofill,
189
f156 decimal (0) unsigned,
190
f157 decimal (64) unsigned,
191
f158 decimal (0) zerofill,
192
f159 decimal (64) zerofill,
193
f160 decimal (0) unsigned zerofill,
194
f161 decimal (64) unsigned zerofill,
196
f163 decimal (63,30),
197
f164 decimal (0,0) unsigned,
198
f165 decimal (63,30) unsigned,
199
f166 decimal (0,0) zerofill,
200
f167 decimal (63,30) zerofill,
201
f168 decimal (0,0) unsigned zerofill,
202
f169 decimal (63,30) unsigned zerofill,
204
f171 numeric unsigned,
205
f172 numeric zerofill,
206
f173 numeric unsigned zerofill,
207
209
) Engine = myisam;
209
211
Note 1265 Data truncated for column 'f150' at row 1
210
212
Note 1265 Data truncated for column 'f151' at row 1
211
213
Note 1265 Data truncated for column 'f152' at row 1
212
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/myisam_tb3.txt' into table tb3 ;
214
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/myisam_tb3.txt'
213
216
drop table if exists tb4 ;
214
217
create table tb4 (
215
f176 numeric (0) unsigned not null DEFAULT 9,
216
f177 numeric (64) unsigned not null DEFAULT 9,
217
f178 numeric (0) zerofill not null DEFAULT 9,
218
f179 numeric (64) zerofill not null DEFAULT 9,
219
f180 numeric (0) unsigned zerofill not null DEFAULT 9,
220
f181 numeric (64) unsigned zerofill not null DEFAULT 9,
221
f182 numeric (0,0) not null DEFAULT 9,
222
f183 numeric (63,30) not null DEFAULT 9,
223
f184 numeric (0,0) unsigned not null DEFAULT 9,
224
f185 numeric (63,30) unsigned not null DEFAULT 9,
225
f186 numeric (0,0) zerofill not null DEFAULT 9,
226
f187 numeric (63,30) zerofill not null DEFAULT 9,
227
f188 numeric (0,0) unsigned zerofill not null DEFAULT 9,
228
f189 numeric (63,30) unsigned zerofill not null DEFAULT 9,
229
f190 real not null DEFAULT 88.8,
230
f191 real unsigned not null DEFAULT 88.8,
231
f192 real zerofill not null DEFAULT 88.8,
232
f193 real unsigned zerofill not null DEFAULT 88.8,
233
f194 double not null DEFAULT 55.5,
234
f195 double unsigned not null DEFAULT 55.5,
235
f196 double zerofill not null DEFAULT 55.5,
236
f197 double unsigned zerofill not null DEFAULT 55.5,
240
f201 float unsigned zerofill,
243
f204 float(0) unsigned,
244
f205 float(23) unsigned,
245
f206 float(0) zerofill,
246
f207 float(23) zerofill,
247
f208 float(0) unsigned zerofill,
248
f209 float(23) unsigned zerofill,
251
f212 float(24) unsigned,
252
f213 float(53) unsigned,
253
f214 float(24) zerofill,
254
f215 float(53) zerofill,
255
f216 float(24) unsigned zerofill,
256
f217 float(53) unsigned zerofill,
264
f225 enum("1enum","2enum"),
265
f226 set("1set","2set"),
218
f176 numeric (0) unsigned not null DEFAULT 9,
219
f177 numeric (64) unsigned not null DEFAULT 9,
220
f178 numeric (0) zerofill not null DEFAULT 9,
221
f179 numeric (64) zerofill not null DEFAULT 9,
222
f180 numeric (0) unsigned zerofill not null DEFAULT 9,
223
f181 numeric (64) unsigned zerofill not null DEFAULT 9,
224
f182 numeric (0,0) not null DEFAULT 9,
225
f183 numeric (63,30) not null DEFAULT 9,
226
f184 numeric (0,0) unsigned not null DEFAULT 9,
227
f185 numeric (63,30) unsigned not null DEFAULT 9,
228
f186 numeric (0,0) zerofill not null DEFAULT 9,
229
f187 numeric (63,30) zerofill not null DEFAULT 9,
230
f188 numeric (0,0) unsigned zerofill not null DEFAULT 9,
231
f189 numeric (63,30) unsigned zerofill not null DEFAULT 9,
232
f190 real not null DEFAULT 88.8,
233
f191 real unsigned not null DEFAULT 88.8,
234
f192 real zerofill not null DEFAULT 88.8,
235
f193 real unsigned zerofill not null DEFAULT 88.8,
236
f194 double not null DEFAULT 55.5,
237
f195 double unsigned not null DEFAULT 55.5,
238
f196 double zerofill not null DEFAULT 55.5,
239
f197 double unsigned zerofill not null DEFAULT 55.5,
243
f201 float unsigned zerofill,
246
f204 float(0) unsigned,
247
f205 float(23) unsigned,
248
f206 float(0) zerofill,
249
f207 float(23) zerofill,
250
f208 float(0) unsigned zerofill,
251
f209 float(23) unsigned zerofill,
254
f212 float(24) unsigned,
255
f213 float(53) unsigned,
256
f214 float(24) zerofill,
257
f215 float(53) zerofill,
258
f216 float(24) unsigned zerofill,
259
f217 float(53) unsigned zerofill,
267
f225 enum("1enum","2enum"),
268
f226 set("1set","2set"),
273
276
f234 VARBINARY(192),
274
f235 char(255) unicode,
275
278
f236 char(60) ascii,
276
279
f237 char(255) binary,
277
280
f238 varchar(0) binary,
278
281
f239 varbinary(1000),
279
f240 varchar(120) unicode,
280
f241 char(100) unicode,
282
285
) engine = myisam;
283
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/myisam_tb4.txt' into table tb4 ;
286
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/myisam_tb4.txt'
285
289
drop table if exists tb2 ;
286
290
create table tb2 (
287
f59 numeric (0) unsigned,
288
f60 numeric (64) unsigned,
289
f61 numeric (0) zerofill,
290
f62 numeric (64) zerofill,
291
f63 numeric (0) unsigned zerofill,
292
f64 numeric (64) unsigned zerofill,
295
f67 numeric (0,0) unsigned,
296
f68 numeric (63,30) unsigned,
297
f69 numeric (0,0) zerofill,
298
f70 numeric (63,30) zerofill,
299
f71 numeric (0,0) unsigned zerofill,
300
f72 numeric (63,30) unsigned zerofill,
304
f76 real unsigned zerofill,
305
f77 double default 7.7,
306
f78 double unsigned default 7.7,
307
f79 double zerofill default 7.7,
308
f80 double unsigned zerofill default 8.8,
309
f81 float not null default 8.8,
310
f82 float unsigned not null default 8.8,
311
f83 float zerofill not null default 8.8,
312
f84 float unsigned zerofill not null default 8.8,
313
f85 float(0) not null default 8.8,
314
f86 float(23) not null default 8.8,
315
f87 float(0) unsigned not null default 8.8,
316
f88 float(23) unsigned not null default 8.8,
317
f89 float(0) zerofill not null default 8.8,
318
f90 float(23) zerofill not null default 8.8,
319
f91 float(0) unsigned zerofill not null default 8.8,
320
f92 float(23) unsigned zerofill not null default 8.8,
321
f93 float(24) not null default 8.8,
322
f94 float(53) not null default 8.8,
323
f95 float(24) unsigned not null default 8.8,
324
f96 float(53) unsigned not null default 8.8,
325
f97 float(24) zerofill not null default 8.8,
326
f98 float(53) zerofill not null default 8.8,
327
f99 float(24) unsigned zerofill not null default 8.8,
328
f100 float(53) unsigned zerofill not null default 8.8,
329
f101 date not null default '2000-01-01',
330
f102 time not null default 20,
331
f103 datetime not null default '2/2/2',
332
f104 timestamp not null default 20001231235959,
333
f105 year not null default 2000,
334
f106 year(3) not null default 2000,
335
f107 year(4) not null default 2000,
336
f108 enum("1enum","2enum") not null default "1enum",
291
f59 numeric (0) unsigned,
292
f60 numeric (64) unsigned,
293
f61 numeric (0) zerofill,
294
f62 numeric (64) zerofill,
295
f63 numeric (0) unsigned zerofill,
296
f64 numeric (64) unsigned zerofill,
299
f67 numeric (0,0) unsigned,
300
f68 numeric (63,30) unsigned,
301
f69 numeric (0,0) zerofill,
302
f70 numeric (63,30) zerofill,
303
f71 numeric (0,0) unsigned zerofill,
304
f72 numeric (63,30) unsigned zerofill,
308
f76 real unsigned zerofill,
309
f77 double default 7.7,
310
f78 double unsigned default 7.7,
311
f79 double zerofill default 7.7,
312
f80 double unsigned zerofill default 8.8,
313
f81 float not null default 8.8,
314
f82 float unsigned not null default 8.8,
315
f83 float zerofill not null default 8.8,
316
f84 float unsigned zerofill not null default 8.8,
317
f85 float(0) not null default 8.8,
318
f86 float(23) not null default 8.8,
319
f87 float(0) unsigned not null default 8.8,
320
f88 float(23) unsigned not null default 8.8,
321
f89 float(0) zerofill not null default 8.8,
322
f90 float(23) zerofill not null default 8.8,
323
f91 float(0) unsigned zerofill not null default 8.8,
324
f92 float(23) unsigned zerofill not null default 8.8,
325
f93 float(24) not null default 8.8,
326
f94 float(53) not null default 8.8,
327
f95 float(24) unsigned not null default 8.8,
328
f96 float(53) unsigned not null default 8.8,
329
f97 float(24) zerofill not null default 8.8,
330
f98 float(53) zerofill not null default 8.8,
331
f99 float(24) unsigned zerofill not null default 8.8,
332
f100 float(53) unsigned zerofill not null default 8.8,
333
f101 date not null default '2000-01-01',
334
f102 time not null default 20,
335
f103 datetime not null default '2/2/2',
336
f104 timestamp not null default 20001231235959,
337
f105 year not null default 2000,
338
f106 year(3) not null default 2000,
339
f107 year(4) not null default 2000,
340
f108 enum("1enum","2enum") not null default "1enum",
337
341
f109 set("1set","2set") not null default "1set",
338
f110 VARBINARY(64) null,
339
f111 VARBINARY(27) null ,
340
f112 VARBINARY(64) null ,
341
f113 VARBINARY(192) null ,
342
f114 VARBINARY(192) ,
343
f115 VARBINARY(27) null ,
344
f116 VARBINARY(64) null,
345
f117 VARBINARY(192) null
342
f110 VARBINARY(64) null,
343
f111 VARBINARY(27) null ,
344
f112 VARBINARY(64) null ,
345
f113 VARBINARY(192) null ,
346
f114 VARBINARY(192) ,
347
f115 VARBINARY(27) null ,
348
f116 VARBINARY(64) null,
349
f117 VARBINARY(192) null
346
350
) engine = myisam;
347
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/myisam_tb2.txt' into table tb2 ;
351
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/myisam_tb2.txt'
350
355
DROP TABLE IF EXISTS t1, t2, t4, t10, t11;
351
CREATE TABLE t1 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = MyISAM;
352
CREATE TABLE t2 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = MyISAM;
353
CREATE TABLE t4 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = MyISAM;
354
CREATE TABLE t10 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = MyISAM;
355
CREATE TABLE t11 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = MyISAM;
356
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t1;
357
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t2;
358
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t4;
359
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t10;
360
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t11;
356
CREATE TABLE t1 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
358
CREATE TABLE t2 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
360
CREATE TABLE t4 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
362
CREATE TABLE t10 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
364
CREATE TABLE t11 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
366
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' INTO TABLE t1;
367
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' INTO TABLE t2;
368
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' INTO TABLE t4;
369
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' INTO TABLE t10;
370
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' INTO TABLE t11;
361
371
drop TABLE if exists t3;
362
372
CREATE TABLE t3 (f1 char(20), f2 char(20), f3 integer) ENGINE = MyISAM;
363
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t3.txt' INTO TABLE t3;
373
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t3.txt' INTO TABLE t3;
364
374
drop database if exists test4;
365
375
CREATE database test4;
367
CREATE TABLE t6 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = MyISAM;
368
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t6;
377
CREATE TABLE t6 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int)
379
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' INTO TABLE t6;
370
381
drop TABLE if exists t7, t8;
371
CREATE TABLE t7 (f1 char(20), f2 char(25), f3 date, f4 int) ENGINE = MyISAM;
372
CREATE TABLE t8 (f1 char(20), f2 char(25), f3 date, f4 int) ENGINE = MyISAM;
373
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t7.txt' INTO TABLE t7;
382
CREATE TABLE t7 (f1 char(20),f2 char(25),f3 date,f4 int) ENGINE = MyISAM;
383
CREATE TABLE t8 (f1 char(20),f2 char(25),f3 date,f4 int) ENGINE = MyISAM;
384
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t7.txt' INTO TABLE t7;
375
386
Warning 1265 Data truncated for column 'f3' at row 1
376
387
Warning 1265 Data truncated for column 'f3' at row 2