Paul,
What is the type of field for your ID field. You probably need to increase
the size/type of your first field. Your hitting a 32k limit for signed
integers on some systems.
Pat...
----- Original Message -----
From: Paul H. Bern <pbern@stripped>
To: <mysql@stripped>
Sent: Tuesday, February 15, 2000 11:00 AM
Subject: Phantom repeating ID
>
> Hi All,
>
> I have a really strange (to me anyhow) problem. I'm trying to load a
> tab-delimited file with 11 fields and 42,793 records. The first field is
> a non-unique ID and the source of my problem. The file appears to load
> correctly, except that starting with the 12,793rd record, the ID field
> repeats the same number (32767 - the ID has nothing to do with the record
> number) for the rest of the file. Interestingly enough, this ID does not
> actually appear in the data, and the last good record has an ID=32766. I
> cleaned out all "/", "\", "&" from the file and still had the same
> problem. I even tried sorting the input file on a different field before
> loading it and still got the repeating 32767 - on the same exact records
> as before rather than at the 12,793rd, as though I had simply sorted the
> previous table.
>
> Any ideas?
>
>
>
> Thanks!
>
> Paul
>
> *****************************************************************
> Paul H. Bern The only thing worse than
> Data and Statistical Services not getting what you wanted
> Princeton University is getting what you asked for
> (609) 258-6053
>
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread27837@stripped
>
> To unsubscribe, send a message to:
> <mysql-unsubscribe-patrick=coconet.com@stripped>
>
>
