[VL] Results are mismatch with vanilla Spark, it maybe caused by cast(string as bigint)

[kecookier]

Backend

VL (Velox)

Bug description

The following SQL might lead to wrong results, but it's not yet certain if there are other factors involved.
I will try to reproduce later.

SELECT deal_id,
                       spu_id
                  FROM tableA a LATERAL VIEW explode(split(regexp_replace(spu_list, '\\[|\\]',''),",")) tmp_table AS spu_id
          )a
          LEFT JOIN (
                SELECT cast(spu_id AS bigint) AS spu_id
                  FROM tableB
               )b
            ON a.spu_id = b.spu_id

Spark version

None

Spark configurations

No response

System information

No response

Relevant logs

No response