Non-repeatable reads: The reopened cursor in A1 retrieves updates of A2 on qualifying rows.
An unrepeatable read and phantom read can occur.
In fact, the only row-level locking that remains during INSERT is the next-key locks that are required to protect an INSERT from adding keys to repeatable read scanners.
Let's first consider repeatable read.