
复制Case1: HELLODBA.COM>settimeon 10:22:09 HELLODBA.COM>update t_test1 set SECONDARY=Awhere object_id = -1; 1 row updated. 10:22:22 HELLODBA.COM>commit; Commit complete. Session 1: 10:22:25 HELLODBA.COM>update t_test1 set SECONDARY=Bwhere object_id = -1 and SECONDARY=Band (selectcount(*) from t_test2 t1,浅述
t_test2 t2) > 0; 0 rows updated. 10:23:15 HELLODBA.COM> Session 2: 10:22:37 HELLODBA.COM>update t_test1 set SECONDARY=Bwhere object_id = -1; 1 row updated. 10:23:02 HELLODBA.COM>commit; Commit complete. 10:23:04 HELLODBA.COM> Case2: 10:25:38 HELLODBA.COM>update t_test1 set SECONDARY=Awhere object_id = -1; 1 row updated. 10:25:48 HELLODBA.COM>commit; Commit complete. Session 1: 10:26:05 HELLODBA.COM>update t_test1 set SECONDARY=Bwhere object_id = -1 and SECONDARY=Aand (selectcount(*) from t_test2 t1, t_test2 t2) > 0; 0 rows updated. 10:27:21 HELLODBA.COM> Session 2: 10:26:16 HELLODBA.COM>update t_test1 set SECONDARY=Bwhere object_id = -1; 1 row updated. 10:26:41 HELLODBA.COM>commit; Commit complete. 10:26:42 HELLODBA.COM> 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.