[teiid-issues] [JBoss JIRA] (TEIID-5305) NPE when executing a query

[Ramesh Reddy (JIRA)]

Ramesh Reddy created TEIID-5305:
-----------------------------------

             Summary: NPE when executing a query
                 Key: TEIID-5305
                 URL: https://issues.jboss.org/browse/TEIID-5305
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
            Reporter: Ramesh Reddy
            Assignee: Steven Hawkins


while executing a query like 

{code}
SELECT MyOrclTbl.wellname, MyOrclTbl.surveyname, MyOrclTbl.npts, depthTable.depth, azimuthTable.azimuth,inclinationTable.inclination  
FROM   
(select 'Well-01' as wellname,   
   'survey_01' as surveyname,   
   6 as npts,   
   '10,20,30,40,50,60' depth,   
   '0,8.05,8.05,10.73,5.80,10.46' azimuth,   
   '0.00,0.96,1.10,1.20,1.47,1.56' as inclination  
) as MyOrclTbl,   
TEXTTABLE (MyOrclTbl.depth COLUMNS depth integer, id for ordinality ROW DELIMITER ',' DELIMITER '-') as depthTable  
LEFT JOIN TEXTTABLE (MyOrclTbl.azimuth COLUMNS azimuth double, id for ordinality ROW DELIMITER ',' DELIMITER '-') as azimuthTable ON depthTable.id = azimuthTable.id  
LEFT JOIN TEXTTABLE (MyOrclTbl.inclination COLUMNS inclination double, id for ordinality ROW DELIMITER ',' DELIMITER '-') as inclinationTable ON depthTable.id = inclinationTable.id  
{code}

I see an error in log 

{code}
00 ERROR [org.teiid.PROCESSOR] (Worker14_QueryProcessorQueue121) qdLiyou1hVfE TEIID30019 Unexpected exception for request qdLiyou1hVfE.40: java.lang.NullPointerException
	at org.teiid.query.optimizer.relational.rules.RulePlanOuterJoins.checkLeftOrdering(RulePlanOuterJoins.java:338)
	at org.teiid.query.optimizer.relational.rules.RulePlanOuterJoins.planLeftOuterJoinAssociativityBeforePlanning(RulePlanOuterJoins.java:251)
	at org.teiid.query.optimizer.relational.rules.RulePlanOuterJoins.execute(RulePlanOuterJoins.java:62)
	at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:995)
	at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:228)
	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:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)

{code}




--
This message was sent by Atlassian JIRA
(v7.5.0#75005)