[
https://issues.apache.org/jira/browse/CALCITE-5588?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhen Chen resolved CALCITE-5588.
--------------------------------
Fix Version/s: 1.42.0
Resolution: Duplicate
Fixed via
[{{ea7fb17}}|https://github.com/apache/calcite/commit/ea7fb170532de95d02486922b2601e09b855631c]
This Jira is same as CALCITE-7318
> ArrayIndexOutOfBoundsException on "on not exists" or "on exists"
> ----------------------------------------------------------------
>
> Key: CALCITE-5588
> URL: https://issues.apache.org/jira/browse/CALCITE-5588
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.33.0
> Reporter: Magnus Mogren
> Priority: Major
> Fix For: 1.42.0
>
>
> Execute this SQL
> {code:java}
> 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) {code}
>
> *Expected result*
> A ResultSet containing this
> |*NAME*|
> |A|
> |A|
> |B|
>
> *Actual result*
> {color:#FF0000}ArrayIndexOutOfBoundsException: Index 2 out of bounds for
> length 2{color}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
