好吧,这个话题在维基百科中有这样的词,链接是here
. Serializable This is the highest isolation level. With a lock-based concurrency control DBMS implementation, serializability requires read and write locks (acquired on selected data) to be released at the end of the transaction. Also 100 must be acquired when a SELECT query uses a ranged WHERE clause, especially to avoid the phantom reads phenomenon (see below). When using non-lock based concurrency control, no locks are acquired; however, if the system detects a write collision among several concurrent transactions, only one of them is allowed to commit. See snapshot isolation for more details on this topic.
但整个话题并没有解释"范围锁定",谷歌也没有准确的描述.
什么是"范围锁",与"读锁"和"写锁"有什么不同?
谢谢!