Bug #4730 Auto_increment incremented with SHOW TABLE STATUS \G

• Submitted: 23 Jul 2004 20:17
• Modified: 12 Aug 2004 10:58
• Reporter: Johan Andersson
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: mysql 4.1 src bk
• Assigned to: Martin Skold
• CPU Architecture: Any

[23 Jul 2004 20:17] Johan Andersson

Description:
Great work with the auto_increment stuff.

However, it seems like show table status \G increments the auto_increment counter.

How to repeat:
create table t1( a integer auto_increment primary key, b integer not null) type=ndb;
create table t2( a integer auto_increment primary key, b integer not null) type=myisam;

insert into t1(b) values(1);
insert into t2(b) values(1);

show table status \G

auto_increment counter for ndb table has been incremented.

[12 Aug 2004 10:58] Martin Skold

Fixed and pushed.

[12 Aug 2004 10:58] Martin Skold

Fixed and pushed