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

[Van Halbert (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13252983#comment-13252983 ] 

Van Halbert commented on TEIID-3771:
------------------------------------

Teiid still throws NPE. But this one is from different class in Teiid:

12:41:44,024 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue183) TEIID30019 Unexpected exception for request 4xUbUdDkdulW.0: java.lang.NullPointerException
	at org.teiid.query.optimizer.relational.rules.RuleMergeVirtual.doMerge(RuleMergeVirtual.java:218) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
	at 

> 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: 8.12.1, 8.13
>
>
> 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)