bug: cross join with enforced spill failed for 1104=>index out of bounds: the len is 9 but the index is 9

[Xuanwo]

Search before asking

• I had searched in the issues and found no similar issues.

Version

Databend Query v1.2.645-nightly-01bc7ed672(rust-1.81.0-nightly-2024-10-13T22:10:34.588789615Z)

What's Wrong?

Running SQL on tpch_sf100:

set join_spilling_memory_ratio = 10;
set join_spilling_bytes_threshold_per_proc = 4657589;
set disable_join_reorder = 1;
set max_vacuum_temp_files_after_query=0;

select
    o_comment, c_custkey
from
    customer
    cross join
    orders
where o_comment not like '%pending%deposits%' and c_custkey > 100 and c_custkey < 120
order by o_comment
    limit 20;

will hit the following error:

1104=>index out of bounds: the len is 12 but the index is 12

---

Databend Cloud Query ID: f9943142-2855-43c4-b558-92e4b49bc69c

How to Reproduce?

Running given SQL in databend cloud.

Are you willing to submit PR?

• Yes I am willing to submit a PR!