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))