[Bug]: BVT `fulltext/fulltext_async.sql` failed

[gouhongshen]

Is there an existing issue for the same bug?

• [x] I have checked the existing issues.

Branch Name

main

Commit ID

latest

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

https://github.com/matrixorigin/matrixone/actions/runs/19451623887/job/55657334667?pr=22845

2025-11-18 02:28:46 INFO  Executor:291 - The script file[/home/runner/work/matrixone/matrixone/test/distributed/cases/fulltext/fulltext2.sql] has been executed, and cost: 1.348s, total:222, success:219, failed:0, ignored:3, abnoraml:0
2025-11-18 02:28:46 INFO  Executor:37 - Start to execute the script file[/home/runner/work/matrixone/matrixone/test/distributed/cases/fulltext/fulltext_async.sql] now, and it will take a few moment,pleas wait......
2025-11-18 02:29:06 ERROR RSSet:164 - The row count does not equal with each other, one is 2, the other is 0
2025-11-18 02:29:06 ERROR Executor:199 - [/home/runner/work/matrixone/matrixone/test/distributed/cases/fulltext/fulltext_async.sql][row:28][select * from src where match(body, title) against('red');] was executed failed, con[id=0, user=dump, ***
2025-11-18 02:29:06 ERROR Executor:201 - [EXPECT RESULT]:
id    body    title
0    color is red    t1
3    blue is not red    colorful
2025-11-18 02:29:06 ERROR Executor:202 - [ACTUAL RESULT]:
id    body    title
2025-11-18 02:29:06 ERROR RSSet:164 - The row count does not equal with each other, one is 2, the other is 0
2025-11-18 02:29:06 ERROR Executor:199 - [/home/runner/work/matrixone/matrixone/test/distributed/cases/fulltext/fulltext_async.sql][row:33][select * from src2 where match(body, title) against('red');] was executed failed, con[id=0, user=dump, ***
2025-11-18 02:29:06 ERROR Executor:201 - [EXPECT RESULT]:
id1    id2    body    title
id0    0    red    t1
id3    3    blue red    t4
2025-11-18 02:29:06 ERROR Executor:202 - [ACTUAL RESULT]:
id1    id2    body    title
2025-11-18 02:29:06 INFO  Executor:291 - The script file[/home/runner/work/matrixone/matrixone/test/distributed/cases/fulltext/fulltext_async.sql] has been executed, and cost: 20.088s, total:14, success:12, failed:2, ignored:0, abnoraml:0
2025-11-18 02:29:06 INFO  Executor:37 - Start to execute the script file[/home/runner/work/matrixone/matrixone/test/distributed/cases/fulltext/fulltext_bm25.sql] now, and it will take a few moment,pleas wait......
2025-11-18 02:29:32 INFO  Executor:291 - The script file[/home/runner/work/matrixone/matrixone/test/distributed/cases/fulltext/fulltext_bm25.sql] has been executed, and cost: 26.151s, total:197, success:197, failed:0, ignored:0, abnoraml:0
2025-11-18 02:29:32 INFO  Executor:37 - Start to execute the script file[/home/runner/work/matrixone/matrixone/test/distributed/cases/fulltext/jsonvalue.sql] now, and it will take a few moment,pleas wait......

Expected Behavior

No response

Steps to Reproduce

run ci

Additional information

No response

[LeftHandCold]

https://github.com/matrixorigin/matrixone/actions/runs/19884471941/job/56988867015?pr=23204