Reputation: 1
I know that both write and read are long-term locks. But even if it's all long-term, if transaction A reads the data with a read lock, and then transaction B changes and commits the data with a write lock, wouldn't fuzzy read occur when A reads the data again?
I really don't know how to solve the problem of fuzzy read at the read committed isolation level.
Upvotes: 0
Views: 14