[teiid-issues] [JBoss JIRA] (TEIID-3771) Teiid throws an NPE while executing query with nested subquery IN predicate
Van Halbert (JIRA)
issues at jboss.org
Wed Jun 15 11:40:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-3771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13253019#comment-13253019 ]
Van Halbert commented on TEIID-3771:
------------------------------------
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 org.teiid.query.optimizer.relational.rules.RuleMergeVirtual.execute(RuleMergeVirtual.java:84) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:859) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:226) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:159) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.query.optimizer.relational.rules.RuleMergeCriteria.planMergeJoin(RuleMergeCriteria.java:301) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.query.optimizer.relational.rules.RuleMergeCriteria.findCriteriaChains(RuleMergeCriteria.java:172) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.query.optimizer.relational.rules.RuleMergeCriteria.findCriteriaChains(RuleMergeCriteria.java:191) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.query.optimizer.relational.rules.RuleMergeCriteria.execute(RuleMergeCriteria.java:145) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:859) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:226) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:159) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:442) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:470) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:642) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:337) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal]
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal]
> 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