[teiid-issues] [JBoss JIRA] (TEIID-4280) NPE in RuleMergeVirtual when running a query with nested CTEs

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-4280:
----------------------------------
      Component/s: Query Engine
    Fix Version/s: 9.1
                   9.0.1


> NPE in RuleMergeVirtual when running a query with nested CTEs
> -------------------------------------------------------------
>
>                 Key: TEIID-4280
>                 URL: https://issues.jboss.org/browse/TEIID-4280
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Salvatore R
>            Assignee: Steven Hawkins
>             Fix For: 9.1, 9.0.1
>
>
> I defined the following view, based on a table in PostgreSQL (pg.test_a):
> {code:sql}
> create view tv1 as
> WITH 
> 	alias as (SELECT a from pg.test_a),
> 	alias2 as (select t2.a as a1, t1.a from alias t1 join (SELECT a from pg.test_a) t2 on t1.a=t2.a),
> 	alias3 as (select t2.a as a1, t1.a from alias t1 join alias2 t2 on t1.a=t2.a)
> SELECT alias3.a1 FROM alias2 join alias3 on alias3.a=alias2.a;
> {code}
> When I run this query:
> {code:sql}
> with
> CTE1 as (
> 	select a1 from ( 
> 		with CTE11 as (select a1 from views.tv1) 
> 			select a1 from CTE11
> 	) as  SUBQ1),
> CTE2 as (
> 	select a1 from ( 
> 		with CTE21 as (select a1 from views.tv1) 
> 			select a1 from CTE21
> 	) as  SUBQ2)  
> select * from CTE1 as T1 join CTE2 as T2 on T1.a1=T2.a1
> {code}
> this exception is thrown:
> {code:sql}
> 16:36:34,749 ERROR [org.teiid.PROCESSOR] (Worker17_QueryProcessorQueue112) cMD3wCUrebvy TEIID30019 Unexpected exception for request cMD3wCUrebvy.34: java.lang.NullPointerException
>         at org.teiid.query.optimizer.relational.rules.RuleMergeVirtual.doMerge(RuleMergeVirtual.java:218)
>         at org.teiid.query.optimizer.relational.rules.RuleMergeVirtual.execute(RuleMergeVirtual.java:84)
>         at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:870)
>         at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:226)
>         at org.teiid.query.optimizer.relational.RelationalPlanner.planWith(RelationalPlanner.java:361)
>         at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:206)
>         at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:159)
>         at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:445)
>         at org.teiid.dqp.internal.process.Request.processRequest(Request.java:473)
>         at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:655)
>         at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:337)
>         at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
>         at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274)
>         at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
>         at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
>         at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>         at java.lang.Thread.run(Thread.java:745)
> {code}
> The same error occurs using inline views too.



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