List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 19 1999 3:15pm
Subject:Re: bug: create table auto_increment=0
View as plain text  
At 2:33 PM +0100 11/19/99, Ondrej Koala Vacha wrote:
>  >Description:
>           auto_increment=0 works as auto_increment=1
>>How-To-Repeat:
>drop table if exists auto;
>create table auto (
>	id		smallint(5) unsigned NOT NULL AUTO_INCREMENT 
>PRIMARY KEY,
>	user		char(10) NOT NULL,
>	host		char(10) NOT NULL
>)
>
>AUTO_INCREMENT = 0
>;
>
>insert into auto (user,host)  values ('A','B');
>insert into auto (user,host)  values ('A','B');


What do you expect AUTO_INCREMENT = 0 to do exactly?

You can't have a 0 in an AUTO_INCREMENT column.  Inserting
0 is currently like inserting NULL, so when the initial
0 is inserted, an AUTO_INCREMENT value is inserted an you
get 1.

-- 
Paul DuBois, paul@stripped
Thread
bug: create table auto_increment=0Ondrej Koala Vacha19 Nov
  • Re: bug: create table auto_increment=0Paul DuBois19 Nov