FWIW:
It also appears to me that negative one (-1) plus one (1) is ZERO (0)
which may be why you are having trouble...?
in ignorance,
haiku
On Wednesday, April 18, 2001, at 01:09 AM, Milo Stefani wrote:
> As Far as I can remember it is explicitly said in the Manual that
> inserting
> a negative value in an autoincrement field is a Bad Thing
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, April 18, 2001 6:14 AM
> Subject: Possible bug in 3.23.32 or later
>
>
>>> Description:
>> When i insert into a negative integer into primary key (id int) field,
>> it
> works fine.
>> However, the next insert i do without specifing the id explicitly and
> relying on mysql to
>> generate the next number in the sequence (should be 1) will use the
>> upper
> bound (2^32 - 1)
>> Then every other insert after that will not insert since there are no
>> id's
> available.
>>
>>
>>> How-To-Repeat:
>>
>> CREATE TABLE category
>> (
>> id INT NOT NULL AUTO_INCRE17;6,
>> name VARCHAR(50) NOT NULL,
>> code VARCHAR(50) NOT NULL,
>> description TEXT,
>> picture VARCHAR(50),
>> parent INT NOT NULL DEFAULT 0,
>> active TINYINT,
>> members INT NOT NULL DEFAULT 0,
>> storeid INT,
>> feature1 INT NOT NULL DEFAULT 0,
>> feature2 INT NOT NULL DEFAULT 0,
>> priority INT,
>> KEY (code),
>> KEY (name),
>> PRIMARY KEY (id)
>> )\g
>>
>>
>> INSERT INTO category
> (id,name,code,description,picture,parent,active,members,storeid,feature1,
> fea
> ture2) VALUES (-10,'NEW','NEW','All new products','none',-1,0,0,1,0,0);
>>
>> Then try:
>> INSERT INTO category
> (name,code,description,picture,parent,active,members,storeid,feature1,featur
> e2) VALUES ('test','test','All test products','none',-1,0,0,1,0,0);
>>
>> That should make the id 2^32 -1 (or something aroudn there).
>>
>> That id should be 1!!!
>>
>>
>>> Fix:
>>
>>
>>
>>> Submitter-Id: <submitter ID>
>>> Originator: Duane Homick
>>> Organization:
>> Inline Internet Systems, Inc.
>>
>>> MySQL support: none
>>> Synopsis: bug in primary key insert with negative integers
>>> Severity: serious
>>> Priority: medium
>>> Category: mysql
>>> Class: sw-bug
>>> Release: mysql-3.23.32 (TCX binary)
>>
>>> Environment:
>>
>>
>> ---------------------------------------------------------------------
>> Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <mysql-unsubscribe-
> [EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php