Bug #9247 load data infile
Submitted: 17 Mar 2005 12:49 Modified: 17 Mar 2005 19:15
Reporter: Cedric Copy Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:Mysql 4.1.8 / Mysql querybrowser 1.1.5 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[17 Mar 2005 12:49] Cedric Copy
Description:
When I try to load data from a text file into Mysql using Mysql QUery browser and the LOAD DATA INFILE command, I end up with only the exact half of the source data set.

How to repeat:
-put a txt file at the appropriate path.
-go to query browser and type :"load data infile 'c:/corpdb3.TXT' into table mydb.inptab fields terminated by ',' optionally enclosed by '$' lines terminated by '\n'"
- execute "select * from mydb.inptab" : only half of the data present in the txt file is loaded.
[17 Mar 2005 19:15] MySQL Verification Team
I wasn't able to repeat the behavior reported.
[25 Sep 2007 17:47] Billy Vital
I have the same problem as Cedric. 

Anyone knows why?