List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 24 2002 8:41pm
Subject:RE: Warnings after LOAD DATA statement
View as plain text  
At 10:50 -0800 3/24/02, Nick Arnett wrote:
>  > -----Original Message-----
>>  From: Maribel Piloto [mailto:pilotom@stripped]
>>  Sent: Sunday, March 24, 2002 10:24 AM
>>  The data is loading fine and the NULL values are in fact
>>  correctly entered
>>  as NULLs but I'm getting this warning after the LOAD statement:
>>  Records: 3  Deleted: 0  Skipped: 0  Warnings: 3
>>  I don't understand why I'm getting the warnings or what they're about.
>When you load data from a file, there's no way to know exactly what the
>warnings are.  However, they are the same ones you'd get from a single
>insert statement, or from too many or two few columns in your insert file
>(extra columns are ignored).
>A suggestion here recently was to do a SELECT ... INTO FILE after your
>insert, selecting the records you just inserted (easier if you just do this
>into an empty table), then compare the output file with your input file.
>Having done that myself, I'm still mystified by where the warnings are
>coming from on my inserts.  I need a better file comparison tool...

Check the "early release" distribution for the utility.

>Of course, the alternative way to figure out what's going on is to do
>individual INSERT statements and look at the actual warnings.

Warnings after LOAD DATA statementMaribel Piloto24 Mar
  • RE: Warnings after LOAD DATA statementNick Arnett24 Mar
    • RE: Warnings after LOAD DATA statementPaul DuBois24 Mar
  • Re: Warnings after LOAD DATA statementPaul DuBois24 Mar