[teiid-issues] [JBoss JIRA] Reopened: (TEIID-114) Execs of xml procedures cannot be used as correlated scalar subqueries

[Steven Hawkins (JIRA)]

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

Steven Hawkins reopened TEIID-114:
----------------------------------

      Assignee: Steven Hawkins


reopening to make as properly resolved

> Execs of xml procedures cannot be used as correlated scalar subqueries
> ----------------------------------------------------------------------
>
>                 Key: TEIID-114
>                 URL: https://issues.jboss.org/browse/TEIID-114
>             Project: Teiid
>          Issue Type: Bug
>          Components: XML Planner/Processor
>    Affects Versions: 9.x
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Optional
>             Fix For: 8.0
>
>
> Defect Tracker #24364: attempted to run select (exec BooksInfo.getXMLBooksByEdition(edition)) result from booksinfo.booksinfo from the e2e audiobooks and received the following error:
> java.lang.NullPointerException
>  at com.metamatrix.query.processor.xml.RelationalPlanExecutor.<init>(RelationalPlanExecutor.java:67)
>  at com.metamatrix.query.processor.xml.XMLProcessorEnvironment.createResultExecutor(XMLProcessorEnvironment.java:213)
>  at com.metamatrix.query.processor.xml.ExecSqlInstruction.process(ExecSqlInstruction.java:35)
>  at com.metamatrix.query.processor.xml.XMLPlan.getNextXMLChunk(XMLPlan.java:320)
>  at com.metamatrix.query.processor.xml.XMLPlan.processXML(XMLPlan.java:256)
>  at com.metamatrix.query.processor.xml.XMLPlan.nextBatch(XMLPlan.java:187)
>  at com.metamatrix.query.processor.relational.SubqueryProcessorUtility.process(SubqueryProcessorUtility.java:231)
>  at com.metamatrix.query.processor.relational.DependentProjectNode.prepareToProcessTuple(DependentProjectNode.java:96)
>  at com.metamatrix.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:200)
>  at com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:244)
>  at com.metamatrix.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:143)
>  at com.metamatrix.query.processor.QueryProcessor.process(QueryProcessor.java:194)
>  at com.metamatrix.dqp.internal.process.ProcessWorker.processDirect(ProcessWorker.java:159)
>  at com.metamatrix.dqp.internal.process.ProcessWorker.process(ProcessWorker.java:89)
>  at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:64)

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira