>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,feature2)
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,feature2) 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