AUTO_INCREMENT columns are for positive integers. You're trying to use
the column for an unintended use, so it's not surprising that there are
unintended consequences.
At 6:43 PM +0100 2/3/01, [EMAIL PROTECTED] wrote:
>Description:
> If I use a table containing AUTO_INCREMENT field, and I
Description:
If I use a table containing AUTO_INCREMENT field, and I have there
a 0 value, OPTIMIZE TABLE will fail.
How-To-Repeat:
CREATE TABLE test(
ID DECIMAL(5,0) NOT NULL AUTO_INCREMENT,
text CHAR(20) NOT NULL,
PRIMARY KEY(ID)); // o