Bug #28308 Auto-increment settings do not work in "embedded" on OS X

• Submitted: 8 May 2007 15:53
• Modified: 7 Jun 2007 6:41
• Reporter: Joerg Bruehe
• Status: Duplicate
• Category: MySQL Server: Embedded Library ( libmysqld )
• Severity: S2 (Serious)
• Version: 5.1.18
• OS: MacOS
• Assigned to: Assigned Account
• CPU Architecture: Any

[8 May 2007 15:53] Joerg Bruehe

Description:
Effect is new in 5.1.18, was not observed before.

Test fails only in "embedded", only on OS X:
-------------------------------------------------------
*** r/alter_table.result
--- r/alter_table.reject
***************
*** 836,850
  id
  1
  2
! 50
  alter table t1 engine = heap;
  insert into t1 values (null);
  select * from t1;
  id
  1
  2
! 50
! 51
  drop table t1;
  create table t1 (v varchar(32));
  insert into t1 values ('def'),('abc'),('hij'),('3r4f');
--- 836,850
  id
  1
  2
! 3
  alter table t1 engine = heap;
  insert into t1 values (null);
  select * from t1;
  id
  1
  2
! 3
! 4
  drop table t1;
  create table t1 (v varchar(32));
  insert into t1 values ('def'),('abc'),('hij'),('3r4f');
-------------------------------------------------------

Just before this point, the test has these SQL statements:
   alter table t1 auto_increment = 50;
   alter table t1 engine = myisam;
   insert into t1 values (null);
   select * from t1;
So the setting of "auto_increment" does not take effect for "embedded" on OS X.

I suppose that this is also the error in test "heap_auto_increment",
but unluckily I cannot report that in detail because "diff" treats the result/reject file(s) as binary and does not produce output.

How to repeat:
Run the test suite.