Marcin Sokołowski
1 min readApr 24, 2020

--

I think that the definition of repeatable reads is slightly wrong:

Repeatable reads: Uncommitted reads in the current transaction are visible to the current transaction but changes made by other transactions (such as newly inserted rows) won’t be visible.

Repetable reads mode puts read/write lock on selected data, so you can still get phantom reads — newly inserted rows by other transactions will be visible. And btw, I guess you meant ‘uncomitted writes’ in the first sentence ;)

--

--