At 22:42 +0100 12/15/02, Dennis Schwerdel wrote:
>I think you did not properly process this request.
The phenomenon you describe below is not a bug in MySQL. The problem
is that you are trying to use an AUTO_INCREMENT column in an unsupported
manner. AUTO_INCREMENT columns are for use only with *positive* integers,
and any attempt to use them otherwise will eventually cause you grief.
(As you've already discovered.) Putting 0 in an AUTO_INCREMENT column
is a bad idea. Don't do it.
>>Date: Sun, 15 Dec 2002 20:51:14 +0100
>>To: Dennis Schwerdel <mail@stripped>
>>Subject: Re: Bug in auto_increment
>>Your message cannot be posted to bugs@stripped because it did not
>>follow the format expected by our spam/off-topic filter. To this list we
>>accept only repeatable bugs reports, meaning that you can describe a
>>set of steps we can follow to repeat the bug on our systems.
>>If you are having problems with MySQL but are unable to provide the required
>>description, and have not purchased a support contract from MySQL AB,
>>you should send your message to mysql@stripped and possibly one of our
>>knowledgable users or developers will help you. However, we do not guarantee
>>that every message on mysql@stripped will be answered. We can afford
>>to provide free code, but unfortunately, we cannot afford to provide
>>guaranteed free support on top of that. We do, nevertheless, fix our bugs
>>regardless of who reports them and whose systems they affect, and will
>>investigate your problem if you can prove to us with a test case that the
>>error is in our code and not yours.
>>If you have purchased a support contract from MySQL AB, you should follow
>>the standard support request procedure to report this problem. Support
>>contracts are available at https://order.mysql.com/.
>>If you are able to describe how we can repeat the problem, include the string
>>"How-To-Repeat:" in the body of your message, followed by the detailed
>>description of what we need to do to make it happen, and our filter will
>>accept your message. If you use mysqlbug script, which comes with the MySQL
>>distribution, to post the message, it will be automatically accepted.
>>You have written the following:
>>---start of your message----
>>I think I've found a bug in the auto_increment feature.
>>I got the following table :
>>CREATE TABLE gebaeude_daten (
>> id int(10) unsigned NOT NULL auto_increment,
>> name varchar(64) NOT NULL default '',
>> kosten int(10) unsigned NOT NULL default '0',
>> produktion mediumint(10) unsigned NOT NULL default '0',
>> max_anzahl smallint(10) unsigned NOT NULL default '0',
>> ticks tinyint(10) unsigned NOT NULL default '0',
>> PRIMARY KEY (id),
>> KEY kosten (kosten),
>> KEY produktion (produktion),
>> KEY max_anzahl (max_anzahl),
>> KEY ticks (ticks)
>>INSERT INTO gebaeude_daten VALUES (0, 'Bank Stufe 1', 1000, 30, 900, 1);
>>The 0 in the id field is bugy.
>>Every time I change the table definition with ALTER, the 0 becomes the next
>>For example the last id was 70.
>>Then I added keys with ALTER and 'Bank Stufe 1' was id 71.
>>I am now doing the command "UPDATE gebaeude_daten SET id = 0 WHERE name =
>>'Bank Stufe 1' ;" every 30 min. automatically but that couldn't be the
>>I hope you will fix it or just help me to fix my table.
>>MfG Dennis Schwerdel
>>---end of your message-------
>>MySQL Development Team
>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 <mysql-thread127523@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php