Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

release savepoint behavior is inconsistent with mysql #35063

Closed
crazycs520 opened this issue May 31, 2022 · 0 comments · Fixed by #35064
Closed

release savepoint behavior is inconsistent with mysql #35063

crazycs520 opened this issue May 31, 2022 · 0 comments · Fixed by #35064
Labels
compatibility-mysql80 This is a compatibility issue with MySQL 8.0(but NOT 5.7) severity/minor type/bug The issue is confirmed as a bug.

Comments

@crazycs520
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

/* test */ select version();
/* test */ drop table if exists t;
/* test */ create table t (k int primary key, v varchar(20));
/* test */ begin;
/* test */ insert into t values (1, 'a');
/* test */ savepoint p1;
/* test */ insert into t values (2, 'b');
/* test */ savepoint p2;
/* test */ select * from t;
/* test */ release savepoint p1;
/* test */ select * from t;
/* test */ rollback to p2; -- tidb: OK; mysql: SAVEPOINT p2 does not exist;
/* test */ select * from t;
/* test */ rollback;

2. What did you expect to see? (Required)

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

master: 2c3f717

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
compatibility-mysql80 This is a compatibility issue with MySQL 8.0(but NOT 5.7) severity/minor type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant