List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:August 2 2010 7:39pm
Subject:RE: There is something wrong with bugs.mysql.com email server I think (another one)
View as plain text  
And now I just got yet another email for a different bug from 2008!! What's
going on here? 

BTW, this bug is super annoying! How sad that in FOUR YEARS AND FOURTEEN
DAYS it is yet to be fixed. Seriously? This can't be that hard to fix, in
fact, it seems that Innodb would have to go out of it's way to be different
than the standard SQL logic.

> -----Original Message-----
> From: Daevid Vincent [mailto:daevid@stripped] 
> Sent: Monday, August 02, 2010 12:35 PM
> To: 'MySQL List'
> Subject: There is something wrong with bugs.mysql.com email 
> server I think.
> 
> I don't know if anyone from mysql is monitoring this list, but I think
> there is something goofy going on with your email servers. I 
> just now got
> this email below. Uhm. I wrote that bug over a year and a 
> half ago, and the
> reply by Susanne was the day after. WTF?
> 
> ...better late than never I suppose, but maybe you should 
> look into your
> mail server Q and see if there are more "stuck" emails?! 

 

-----Original Message-----
From: Bug Database [mailto:do-not-reply@stripped] 
Sent: Sunday, August 01, 2010 4:04 AM
To: daevid@stripped
Subject: #21641 [Ver]: nonpreserving of InnoDB auto_increment values can
lead to unintended inheritance

Unsubscribe from updates to this bug at: http://bugs.mysql.com/21641

 Updated by:           Shane Bester
 Reported by:          Stephen Dewey
 Category:             Server: InnoDB
 Severity:             S4 (Feature request)
 Status:               Verified
-Version:              4.1.20
+Version:              4.1, 5.1, 5.5
-OS:                   Linux
+OS:                   Any
-OS Details:           Linux (Red Hat)
+OS Details:           
 Tags:                 auto_increment, innodb
 Defect Class:         D5 (Feature request)

[20 Oct 2008 23:40] Mattias Jonsson

Closed bug#34077 as a duplicate of this.

------------------------------------------------------------------------

[13 Feb 2008 23:29] Dave Latham

The current functionality is definitely not intuitive.  A persistent
auto-increment would be much appreciated!

------------------------------------------------------------------------

[19 Dec 2007 22:59] Mike Schumacher

I agree that this is a critical problem that needs to be addressed. We
are having all kinds of issues related to it. What is the status of
this bug?

------------------------------------------------------------------------

[4 Jun 2007 22:06] Dimitriy Alekseyev

What's the status of this feature request?

------------------------------------------------------------------------

[8 May 2007 3:20] Daevid Vincent

This bug is critical and is causing us all kinds of grief with database
integrity. Please escalate it.

mysqladmin create INNODB_IS_BROKEN

locutus ~ # mysql INNODB_IS_BROKEN
mysql> CREATE TABLE `foo` (                
    ->   `id` int(10) unsigned NOT NULL auto_increment, 
    ->   `name` varchar(20),  
    ->   PRIMARY KEY  (`id`)                    
    -> ) ENGINE=INNODB;
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO foo values (null, 'a');
mysql> INSERT INTO foo values (null, 'b');
mysql> INSERT INTO foo values (null, 'c');

mysql> SELECT * FROM foo;
+----+------+
| id | name |
+----+------+
|  1 | a    | 
|  2 | b    | 
|  3 | c    | 
+----+------+
3 rows in set (0.00 sec)

mysql> DELETE FROM foo;
Query OK, 3 rows affected (0.00 sec)

mysql> QUIT;

locutus ~ # /etc/init.d/mysql restart
 * Stopping mysql ...
 * Starting mysql (/etc/mysql/my.cnf) 
 
locutus ~ # mysql INNODB_IS_BROKEN
mysql> INSERT INTO foo values (null, 'd');
Query OK, 1 row affected (0.01 sec)

mysql> SELECT * FROM foo;
+----+------+
| id | name |
+----+------+
|  1 | d    | 
+----+------+
1 row in set (0.00 sec)

------------------------------------------------------------------------

[28 Aug 2006 13:08] Valeriy Kravchuk

Thank you for a reasonable feature request.

------------------------------------------------------------------------

Earlier comments can be viewed at http://bugs.mysql.com/21641


-- 
http://bugs.mysql.com/21641

Thread
There is something wrong with bugs.mysql.com email server I think.Daevid Vincent2 Aug
  • RE: There is something wrong with bugs.mysql.com email server I think (another one)Daevid Vincent2 Aug
    • Re: There is something wrong with bugs.mysql.com email server I think(another one)MySQL)2 Aug
      • Re: There is something wrong with bugs.mysql.com email server I think (another one)Baron Schwartz7 Aug
        • Re: There is something wrong with bugs.mysql.com email server I think (another one)Rob Wultsch8 Aug