when i exec sql like this，IndexOutOfBoundsException will be raised. we don`t know why.
with b as (
select store_no,order_unit_no,item_no,max(item_name) as item_naa
from retail_gms_ods.inventory
group by store_no,order_unit_no,item_no
order by store_no,order_unit_no,item_no
limit 100
)
SELECT
a.store_no,
a.order_unit_no,
a.item_code,
a.item_name,
a.item_no,
a.color_no,
a.sku_no,
a.size_kind,
a.balance_qty
FROM
retail_gms_ods.inventory a
INNER JOIN
b
ON a.store_no = b.store_no
AND a.order_unit_no = b.order_unit_no
AND a.item_no = b.item_no
but we can explain it success.
Sql exec can be more robust.
Search before asking
Version
1.1.3
What's Wrong?
when i exec sql like this，IndexOutOfBoundsException will be raised. we don`t know why.
but we can explain it success.
What You Expected?
Sql exec can be more robust.
How to Reproduce?
No response
Anything Else?
No response
Are you willing to submit PR?
Code of Conduct