MySQL RR隔离级别下两个事务在未提交状态下不能修改同一行
Open
@cfzjywxk is already working on this.
Since Aug 4, 2021.
area/transaction
type/bugfix
- Dominant language
- Python
- Stars
- 1.8k
- Forks
- 1.2k
- Avg merge
- 1d 16h
- Merged PRs (30d)
- 31
Description
文件：transaction-isolation-levels
“MySQL 可重复读隔离级别在更新时并不检验当前版本是否可见，也就是说，即使该行在事务启动后被更新过，同样可以继续更新” 该语句有错误。MySQL中RR隔离级别下如果事务一更新了某一行后未提交，事务二是无法更新这一行的（产生锁冲突），事务一提交后事务二才可以更改；反之如果事务一启动后没有对某行数据做修改，而事务二后启动但先对该行数据进行修改，此时事务一也无法修改。这个表现和TiDB是一致的。
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.