Oracle 租户使用 rowid 做为条件进行重复更新数据，第二次没有更新到数据的原因和解决方法

-- 表结构
CREATE TABLE "NEW_BIZ"."T22" (
  "NUM1" NUMBER(12) DEFAULT NULL NOT NULL ENABLE,
  "NUM2" NUMBER(12) DEFAULT NULL,
  CONSTRAINT "PK_num1
" PRIMARY KEY ("NUM1")
) COMPRESS FOR ARCHIVE REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0;

-- 当前只有一条数据，ROWID 为 *AAEPAQAAwAMAAAA=
obclient [NEW_BIZ]> select rowid,num1,num2 from t22;
+-------------------+------+------+
| ROWID             | NUM1 | NUM2 |
+-------------------+------+------+
| *AAEPAQAAwAMAAAA= |    3 |    3 |
+-------------------+------+------+
1 row in set (0.104 sec)

-- 第一次更新，影响一条数据
obclient [NEW_BIZ]> update t22 set num1=4,num2=4 where rowid='*AAEPAQAAwAMAAAA=';
Query OK, 1 row affected (0.100 sec)
Rows matched: 1  Changed: 1  Warnings: 0

-- 第二次更新，影响 0 行
obclient [NEW_BIZ]> update t22 set num1=5,num2=5 where rowid='*AAEPAQAAwAMAAAA=';
Query OK, 0 rows affected (0.096 sec)
Rows matched: 0  Changed: 0  Warnings: 0

-- 检查当前 rowid，第一次更新了主键，导致 rowid 发生了改变，所以第二次不会更新数据
obclient [NEW_BIZ]> select rowid,num1,num2 from t22;
+-------------------+------+------+
| ROWID             | NUM1 | NUM2 |
+-------------------+------+------+
| *AAEPAQAAwAQAAAA= |    4 |    4 |
+-------------------+------+------+