Which types of SQL in TiDB use MVCC reads, and which types of SQL use current (latest data) reads?

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TiDB中哪些类型的SQL走MVCC读，哪些类型的SQL走当前（最新数据）读？

| username: alfred

【TiDB Usage Environment】Production\Test Environment\POC
【TiDB Version】
【Encountered Problem】
【Reproduction Path】What operations were performed to encounter the problem
【Problem Phenomenon and Impact】

2
| username: 突破边界 | Original post link

The term “current read” typically means reading the latest data while also locking this data to prevent other transactions from modifying it. Essentially, it is a pessimistic locking mechanism.

3
| username: ddhe9527 | Original post link

Refer to the official documentation: