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
>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