List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 20 1999 3:41pm
Subject:Re: Bug report
View as plain text  
At 3:27 PM -0400 8/20/99, Paradox wrote:
>Please fix ASAP, my database is now broke because of it.

Isn't that statement a little extreme?  Is there some reason you
can't just use SMALLINT rather than TINYINT in the meantime?


>
>----- Original Message -----
>From: Paul DuBois <paul@stripped>
>To: Paradox <paradox2@stripped>; <mysql@stripped>
>Cc: <monty@stripped>
>Sent: Friday, August 20, 1999 11:21 AM
>Subject: Re: Am I a drunk?
>
>
>> At 3:00 PM -0400 8/20/99, Paradox wrote:
>> >I just upgraded to 3.23.2-alpha, completely deleting my old database
>files
>> >and starting over, and now I seem to be unable to insert into one of my
>> >tables with an auto_increment primary key because on the second insert it
>> >says:
>> >
>> >ERROR 1062 at line 7: Duplicate entry '1' for key 1
>> >
>> >Heres a way to reproduce it:
>> >
>> >CREATE TABLE TEST (
>> >COMPID TINYINT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
>> >BAH CHAR(10) NOT NULL);
>> >
>> >
>> >INSERT INTO TEST VALUES (NULL, 'hello');
>> >INSERT INTO TEST VALUES (NULL, 'test');
>>
>> I can reproduce this on 3.23.2 under Solaris 2.51.
>> The problem goes away if I remove the UNSIGNED or change TINYINT
>> to another integer type.
>>
>> Looks like a bug to me.
>>
>> --
>> Paul DuBois, paul@stripped
>>
>>
>>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread10823@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@stripped instead.


-- 
Paul DuBois, paul@stripped
Thread
Bug reportParadox20 Aug
  • Re: Bug reportPaul DuBois20 Aug
    • Re: Bug reportNem W Schlecht20 Aug
      • Re: Bug reportMichael Widenius27 Aug
    • Re: Bug reportBill Gerrard20 Aug
      • Re: Bug reportThimble Smith20 Aug
        • RE: Bug reportBill Gerrard21 Aug
  • Bug reportMichael Widenius27 Aug