[teiid-issues] [JBoss JIRA] (TEIID-3771) Teiid throws an NPE while executing query with nested subquery IN predicate

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-3771.
-----------------------------------
    Fix Version/s: 9.0.1
                   9.0
                       (was: 8.12.1)
                       (was: 8.13)
       Resolution: Done


Needed to better account for redefining a group (which is related to this issue, but not directly seen with it) and to redefine the correlated references so that invalid output elements aren't detected.

> Teiid throws an NPE while executing query with nested subquery IN predicate
> ---------------------------------------------------------------------------
>
>                 Key: TEIID-3771
>                 URL: https://issues.jboss.org/browse/TEIID-3771
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.7.1.6_2
>            Reporter: Juraj Duráni
>            Assignee: Steven Hawkins
>             Fix For: 9.0.1, 9.0
>
>
> Teiid throws an NPE while executing query with double IN predicate. Example query:
> SELECT intkey FROM BQT1.SmallA AS A WHERE INTKEY IN (SELECT CONVERT(STRINGKEY, INTEGER) FROM BQT1.SMALLA AS A WHERE STRINGKEY IN (SELECT CONVERT(INTKEY, STRING) FROM BQT1.SMALLA AS B WHERE A.INTNUM = B.INTNUM))



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)