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

Reply via email to