flaky test: e2e single-node binary test: lookup join result mismatch

[yezizp2012]

Describe the bug

| | e2e_test/visibility_mode/../batch/./basic/lookup_join.slt.part .. [FAILED]
failed to run `e2e_test/visibility_mode/checkpoint.slt`
Caused by:
    query result mismatch:
    [SQL] select * from t1 left join t3 on t1.v1 = t3.v1 order by t1.v1, t1.v2;
    [Diff] (-expected|+actual)
    -   1 1 1 2
    -   1 4 1 2
    -   3 3 NULL NULL
    -   5 5 NULL NULL
    at e2e_test/visibility_mode/../batch/./basic/lookup_join.slt.part:19
    at e2e_test/visibility_mode/../batch/distribution_mode.slt:7
    at e2e_test/visibility_mode/checkpoint.slt:5

https://buildkite.com/risingwavelabs/main-cron/builds/2476#018f7b8d-91db-4b4b-9b91-68117dd8a4dd

Error message/log

No response

To Reproduce

No response

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

No response