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

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13555318#comment-13555318 ] 

Ramesh Reddy commented on TEIID-5305:
-------------------------------------

I was using a SNAPSHOT version from 10.2, definitely not master.  I will check against the 10.2

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