[teiid-issues] [JBoss JIRA] (TEIID-3771) Teiid throws an NPE while executing query with nested subquery IN predicate
Steven Hawkins (JIRA)
issues at jboss.org
Wed Jun 15 11:55:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-3771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13253028#comment-13253028 ]
Steven Hawkins commented on TEIID-3771:
---------------------------------------
This occurs when the second level BQT1.SmallA is a view:
SELECT intkey FROM BQT1.SmallA AS A WHERE INTKEY IN (SELECT CONVERT(STRINGKEY, INTEGER) FROM BQT1.SMALLA AS A
The original fix was done assuming SmallA was a source table. So this could go either way in terms of being considered a new or existing issue.
> 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)
More information about the teiid-issues
mailing list