mysql隔离等级和预期结果不一样
我mysql的isolation level设置的是REPEATABLE-READ,我开两个session,session1执行如下语句:
use HRSystem;
start transaction;
select * from Persons where name="hello";
然后session2执行如下语句:
use HRSystem;
start transaction;
update Persons set city="Hangzhou" where name="hello";
居然session2不会block,然后在session1再次执行select,居然能看到最新的更改结果,怎么回事?