[Bug]: UT TestUpdateWithRemotePartition failed

[xzxiong]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Branch Name

main

Commit ID

17e27ac2f

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

    partition_based_test.go:502: 
            Error Trace:    /home/runner/work/matrixone/matrixone/pkg/tests/shard/partition_based_test.go:502
                                        /home/runner/work/matrixone/matrixone/pkg/tests/shard/partition_based_test.go:269
                                        /home/runner/work/matrixone/matrixone/pkg/tests/shard/shard_test.go:108
                                        /home/runner/work/matrixone/matrixone/pkg/tests/shard/shard_test.go:40
                                        /home/runner/work/matrixone/matrixone/pkg/tests/shard/partition_based_test.go:240
            Error:          Not equal: 
                            expected: 100
                            actual  : 1
            Test:           TestUpdateWithRemotePartition

Expected Behavior

No response

Steps to Reproduce

https://github.com/matrixorigin/matrixone/actions/runs/11248199367/job/31272952009?pr=19168#step:9:1

Additional information

No response

[xzxiong]

@zhangxu19830126 ptal

[zhangxu19830126]

连续执行3个语句：

1. insert into (1,1)
2. update set value = 100 where id = 1
3. select where id = 1

1,2，3个语句都执行成功，但是查询出来的结果是1.

[daviszhen]

https://github.com/matrixorigin/matrixone/actions/runs/11271076832/job/31343184841?pr=19209#step:5:28740

[daviszhen]

https://github.com/matrixorigin/matrixone/actions/runs/11288756824/job/31397195941?pr=19174

[triump2020]

Pls ref to #19202