I think you did not properly process this request. Dennis Schwerdel
Date: Sun, 15 Dec 2002 20:51:14 +0100 From: [EMAIL PROTECTED] To: Dennis Schwerdel <[EMAIL PROTECTED]> Subject: Re: Bug in auto_increment X-WEBDE-TAG: S Sender: [EMAIL PROTECTED] Your message cannot be posted to [EMAIL PROTECTED] 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 [EMAIL PROTECTED] and possibly one of our knowledgable users or developers will help you. However, we do not guarantee that every message on [EMAIL PROTECTED] 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---- Hello, 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) ) TYPE=MyISAM; 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 auto-index. 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 solution. 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php