List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 20 1999 3:21pm
Subject:Re: Am I a drunk?
View as plain text  
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
Thread
Am I a drunk?Paradox20 Aug
  • Re: Am I a drunk?Paul DuBois20 Aug
    • Re: Am I a drunk?Jani Tolonen20 Aug
Re: Am I a drunk?Paradox20 Aug