[JBoss JIRA] Created: (TEIID-1362) salesforce push down queries won't get resolved correctly
by Wanja Pernath (JIRA)
salesforce push down queries won't get resolved correctly
---------------------------------------------------------
Key: TEIID-1362
URL: https://jira.jboss.org/browse/TEIID-1362
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.2
Environment: Teiid 7.2 final on JBoss EAP 5.1 with sun java 1.6.0_20
Reporter: Wanja Pernath
Assignee: Steven Hawkins
GIVEN:
select a.name, b.sumary
from Opp a OUTER JOIN OLI b ON a.id = b.foreignId
JoinQueryVisitor of SFDC translator correctly creates:
select a.name, (select b.summary from OLI b) from Opp a
As of SFDC docs:
http://www.salesforce.com/us/developer/docs/api/index_Left.htm#StartTopic...
you get a result set of for example:
"opp #1", [b] QueryResult for row #1
"opp #2", [b] QueryResult for row #2
Which must be transformed into something like this (EXPECTED)
"opp #1", 100
"opp #1", 150
"opp #1", 43000
"opp #2", 10000
"opp #2", 100
etc.
Right now, it gets transformed into something like (CURRENT)
"opp #1", null
"opp #2", null
"opp #3", null
etc.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 9 months
[JBoss JIRA] Updated: (TEIID-114) Execs of xml procedures cannot be used as correlated scalar subqueries
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-114?page=com.atlassian.jira.plugin.... ]
Steven Hawkins updated TEIID-114:
---------------------------------
Fix Version/s: (was: 8.0)
Affects Version/s: 6.0.0
(was: 9.x)
> 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: 6.0.0
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Optional
>
> 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
13 years, 9 months