阅读背景:

保持SELECT不检索事务开始后引用的行

来源:互联网 

Given this scenario:

鉴于这种场景:

TIME  TRANSACTION 1             TRANSACTION 2
1sec  BEGIN
2sec  INSERT RECORDS INTO T1   
3sec  (doing other things)      BEGIN
4sec  (doing other things)      (doing other things)   
5sec  COMMIT                    (doing other things)   
6sec                            SELECT * FROM T1    <<- GETS ROWS INSERTED BY T1
TIME  TRANSACT



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: