I think the explanation in lecture 8 about repeatable read isolation-level in the transaction concurrency section is a bit unclear. In the lecture, T1 has repeatable read isolation. Mosh does an UPDATE in T2 and commits it. But he does not try to execute the SELECT statement in the T1 again, and he mentions that even if he executes it, it will have the same result. In my mind that is the correct behaviour. Because that means the phantom read did not happen there. Any idea?
T1
Sorry! I cannot add an screenshot of T2 (limitation of being a new user in forums)