[Bug]: `explain` case failed occasionally during bvt test

[sukki37]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Branch Name

1.2-dev

Commit ID

1822d80

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

https://github.com/matrixorigin/matrixone/actions/runs/9927033617/job/27421693502

2024-07-14 10:11:01 ERROR RSRow:83 - The value of [row:7,column:0] does not equal with each other,one is [              Join Cond: (t1.c1 = t2.c1) shuffle: range(t1.c1)],but the other is [              Join Cond: (t1.c1 = t2.c1) shuffle: hash(t1.c1)]
2024-07-14 10:11:01 ERROR Executor:199 - [/home/runner/_work/matrixone/matrixone/matrixone/test/distributed/cases/optimizer/top.test][row:28][explain select * from t1,t2 where t1.c1=t2.c1 and t2.c2 between 33333 and 555555 order by t1.c1 desc limit 10 offset 10;] was executed failed, con[id=0, user=dump, ***
2024-07-14 10:11:01 ERROR Executor:201 - [EXPECT RESULT]:
QUERY PLAN
Project
  ->  Sort
        Sort Key: t1.c1 DESC
        Limit: 10, Offset: 10
        Send Message: [tag 1 , type MsgTopValue]
        ->  Join
              Join Type: INNER   hashOnPK
              Join Cond: (t1.c1 = t2.c1) shuffle: range(t1.c1)
              ->  Table Scan on d1.t1
                    Sort Key: c1 DESC
                    Recv Message: [tag 1 , type MsgTopValue]
              ->  Table Scan on d1.t2
                    Filter Cond: t2.c2 BETWEEN 33333 AND 555555
                    Block Filter Cond: t2.c2 BETWEEN 33333 AND 555555
2024-07-14 10:11:01 ERROR Executor:202 - [ACTUAL RESULT]:
QUERY PLAN
Project
  ->  Sort
        Sort Key: t1.c1 DESC
        Limit: 10, Offset: 10
        Send Message: [tag 1 , type MsgTopValue]
        ->  Join
              Join Type: INNER   hashOnPK
              Join Cond: (t1.c1 = t2.c1) shuffle: hash(t1.c1)
              ->  Table Scan on d1.t1
                    Sort Key: c1 DESC
                    Recv Message: [tag 1 , type MsgTopValue]
              ->  Table Scan on d1.t2
                    Filter Cond: t2.c2 BETWEEN 33333 AND 555555
                    Block Filter Cond: t2.c2 BETWEEN 33333 AND 555555

Expected Behavior

No response

Steps to Reproduce

run bvt

Additional information

No response

[volgariver6]

fixed