Session1: lock tables t1 read;
Session2: delete from t1 where id=2;
Session3: lock tables t1 read;

Session1, 2, 3 according to time sequence, session3 read lock can you add?

CodePudding user response:

Session3 read lock can't add

CodePudding user response:

I in version 5.6 added, 5.7 I can't