[CALCITE-5588] ArrayIndexOutOfBoundsException on "on not exists" or "on exists"

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.33.0
• Assignee: Unassigned
• Reporter: Magnus Mogren
• Created: 16/Mar/23 08:50
• Updated: 04/Apr/23 05:53

Description

Execute this SQL

select Header.Name from ( VALUES (1, 'A'), (2, 'B')) as Header(Id, Name) join (values (11, 1), (12, 1), (21, 2)) as Version(Id, Parent) on not exists (select 1 from (values (11, 1), (12, 1), (21, 2)) as Version2(Id, Parent) where Version2.Parent = Header.Id and Version2.Id > Version.Id) 

 

Expected result

A ResultSet containing this

NAME

A

A

B

 

Actual result

ArrayIndexOutOfBoundsException: Index 2 out of bounds for length 2

Issue Links

• is related to: CALCITE-1045 Decorrelate sub-queries in Project and Join