List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 15 2002 11:38pm
Subject:Re: Fwd: Re: Bug in auto_increment
View as plain text  
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.

>Dennis Schwerdel
>>Date: Sun, 15 Dec 2002 20:51:14 +0100
>>From: bugs@stripped
>>To: Dennis Schwerdel <mail@stripped>
>>Subject: Re:  Bug in auto_increment
>>Sender: lists@stripped
>>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
>>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:
>   (the manual)
>           (the list archive)
>To request this thread, e-mail <mysql-thread127523@stripped>
>To unsubscribe, e-mail <>
>Trouble unsubscribing? Try:

Fwd: Re: Bug in auto_incrementDennis Schwerdel15 Dec
  • Re: Fwd: Re: Bug in auto_incrementPaul DuBois16 Dec
    • Re: Fwd: Re: Bug in auto_incrementMichael T. Babcock16 Dec
    • Re: Fwd: Re: Bug in auto_incrementSteve Yates16 Dec