Mastering Database Isolation Levels: ACID Properties Explained with Examples

Mastering Database Isolation Levels: ACID Properties Explained with Examples

There is one problem in READ COMMITTED

WHEN USING REPEATABLE READ, other users commits will not be reflected
it is using locally cached data

You are reading some row data. But that was modified by others.
You cannot overwrite on that row and committing update on the affected rows will not be allowed