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 is incompatible with mysql #35065

Closed
zyguan opened this issue May 31, 2022 · 1 comment
Closed

Release savepoint is incompatible with mysql #35065

zyguan opened this issue May 31, 2022 · 1 comment
Labels
severity/minor type/bug The issue is confirmed as a bug.

Comments

@zyguan
Copy link
Contributor

zyguan commented May 31, 2022

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 */ release savepoint p1;
/* test */ rollback to p2; -- tidb: OK; mysql: SAVEPOINT p2 does not exist
/* test */ rollback;

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

The result of rollback to p2 should be consistent with mysql

3. What did you see instead (Required)

tidb returned ok, however mysql reported an error.

4. What is your TiDB version? (Required)

master

@zyguan zyguan added the type/bug The issue is confirmed as a bug. label May 31, 2022
@zyguan
Copy link
Contributor Author

zyguan commented May 31, 2022

duplicated with #35063

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/minor type/bug The issue is confirmed as a bug.
Projects
None yet
Development

No branches or pull requests

2 participants