matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.76k stars 273 forks source link

[Bug]: The last inserted value of auto_increment column is incorrect. #10836

Open Ariznawlll opened 1 year ago

Ariznawlll commented 1 year ago

Is there an existing issue for the same bug?

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):a57df9af7694ff86d1c57b0c35e653c6e28fb029
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

image

Expected Behavior

image

Steps to Reproduce

Drop table if exists auto_increment02;
Create table auto_increment02(col1 int auto_increment unique key)auto_increment = 10;
Insert into auto_increment02 values();
Select * from auto_increment02;
Insert into auto_increment02 values(10);
insert into auto_increment02 values(100);
select last_insert_id();
Select * from auto_increment02;
Drop table auto_increment02;

Additional information

No response

YANGGMM commented 2 months ago

还在看

YANGGMM commented 1 month ago

还在看

YANGGMM commented 1 month ago

还在看

YANGGMM commented 1 month ago

还在看

YANGGMM commented 1 month ago

还在看

YANGGMM commented 1 month ago

还在看

YANGGMM commented 1 month ago

还在看

YANGGMM commented 1 month ago

还在看

YANGGMM commented 3 weeks ago

还在看

YANGGMM commented 2 weeks ago

还在看

YANGGMM commented 2 weeks ago

还在看

YANGGMM commented 1 week ago

还在看