7:38 a.m.
[
https://issues.jboss.org/browse/TEIID-5186?page=com.atlassian.jira.plugin...
]
dalex dalex updated TEIID-5186:
-------------------------------
Steps to Reproduce:
1. create the following view and proc:
{code:xml}
<model visible = "true" type = "VIRTUAL" name =
"views">
<metadata type = "DDL"><![CDATA[
create view v as select 1 as a1
]]>
</metadata>
</model>
<model visible = "true" type = "VIRTUAL" name =
"procs">
<metadata type = "DDL"><![CDATA[
create virtual procedure pr0() returns (res integer) as
begin
select a.a1 from (SELECT * FROM views.v p) a where a.a1 in (select a1 from
a);
end
]]>
</metadata>
</model>
{code}
2. run the query:
{code:sql}
select * from (call procs.pr0()) a
{code}
but changing pr0 procedure on (changing sub-query in "in" clause):
{code:xml}
<model visible = "true" type = "VIRTUAL" name =
"procs">
<metadata type = "DDL"><![CDATA[
create virtual procedure pr0() returns (res integer) as
begin
select a.a1 from (SELECT * FROM views.v p) a where a.a1 in (1);
end
]]>
</metadata>
</model>
{code}
solves the NPE.
was:
1. create the following view and procs:
{code:xml}
<model visible = "true" type = "VIRTUAL" name =
"views">
<metadata type = "DDL"><![CDATA[
create view v as select 1 as a1
]]>
</metadata>
</model>
<model visible = "true" type = "VIRTUAL" name =
"procs">
<metadata type = "DDL"><![CDATA[
create virtual procedure pr0() returns (res integer) as
begin
select a.a1 from (SELECT * FROM views.v p) a where a.a1 in (select a1 from
a);
end
]]>
</metadata>
</model>
{code}
2. run the query:
{code:sql}
select * from (call procs.pr0()) a
{code}
but changing pr0 procedure on (changing sub-query in "in" clause):
{code:xml}
<model visible = "true" type = "VIRTUAL" name =
"procs">
<metadata type = "DDL"><![CDATA[
create virtual procedure pr0() returns (res integer) as
begin
select a.a1 from (SELECT * FROM views.v p) a where a.a1 in (1);
end
]]>
</metadata>
</model>
{code}
solves the NPE.
NPE in QueryResolver when calling virtual procedure
---------------------------------------------------
Key: TEIID-5186
URL: https://issues.jboss.org/browse/TEIID-5186
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 10.0.1
Environment: teiid-10.0.1 on WildFly Full 11.0.0.Final (WildFly Core
3.0.8.Final)
Reporter: dalex dalex
Assignee: Steven Hawkins
Priority: Blocker
When running query:
{code:sql}
select * from (call procs.pr0()) a
{code}
teiid throwing out the following stacktrace:
{code:noformat}
2017-12-20 14:28:12,939 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue6)
hVe+gXzCsZCA TEIID30019 Unexpected exception for request hVe+gXzCsZCA.1:
java.lang.NullPointerExcep
tion
at org.teiid.query.resolver.QueryResolver.resolveView(QueryResolver.java:387)
at
org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:2080)
at
org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:1462)
at
org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1349)
at
org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1300)
at
org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:1027)
at
org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:203)
at
org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
at
org.teiid.query.optimizer.relational.RelationalPlanner.planSubqueries(RelationalPlanner.java:737)
at
org.teiid.query.optimizer.relational.RelationalPlanner.connectSubqueryContainers(RelationalPlanner.java:696)
at
org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:220)
at
org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
at org.teiid.query.optimizer.ProcedurePlanner.optimize(ProcedurePlanner.java:86)
at
org.teiid.query.optimizer.QueryOptimizer.planProcedure(QueryOptimizer.java:206)
at
org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:146)
at
org.teiid.query.optimizer.relational.RelationalPlanner.addNestedCommand(RelationalPlanner.java:1719)
at
org.teiid.query.optimizer.relational.RelationalPlanner.addNestedProcedure(RelationalPlanner.java:1181)
at
org.teiid.query.optimizer.relational.RelationalPlanner.createStoredProcedurePlan(RelationalPlanner.java:1271)
at
org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:1037)
at
org.teiid.query.optimizer.relational.RelationalPlanner.addNestedCommand(RelationalPlanner.java:1709)
at
org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:1532)
at
org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1349)
at
org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:1300)
at
org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:1027)
at
org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:203)
at
org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:458)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:486)
at
org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:660)
at
org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
{code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
2352
days inactive
2352
days old
0 comments
1 participants
participants (1)
-
dalex dalex (JIRA)