Skip to content

TiDB should use separated Allocators for the auto_increment column value and the row ID #982

@zimulala

Description

@zimulala

execute SQL statements as follows:

create table t (c int auto_increment, key(c));
insert into t values();
insert into t values();
select * from t;

tidb result:

+---+
| c |
+---+
| 1 |
| 3 |
+---+

mysql result:

+---+
| c |
+---+
| 1 |
| 2 |
+---+

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions