12:45 p.m.
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
2:18 p.m.
New subject: [JBoss JIRA] Assigned: (TEIID-1362) salesforce push down queries won't get resolved correctly
[
https://jira.jboss.org/browse/TEIID-1362?page=com.atlassian.jira.plugin.s...
]
John Doyle reassigned TEIID-1362:
---------------------------------
Assignee: John Doyle (was: Steven Hawkins)
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: John Doyle
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
2:20 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1362) salesforce push down queries won't get resolved correctly
[
https://jira.jboss.org/browse/TEIID-1362?page=com.atlassian.jira.plugin.s...
]
John Doyle commented on TEIID-1362:
-----------------------------------
I've debugged through some similar queries (I don't have the objects in the
original SQL) and found that results are coming back null. Not sure what the issue is
yet, but it doesn't appear to be an issue with our handling of the result.
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: John Doyle
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
10:10 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1362) salesforce push down queries won't get resolved correctly
[
https://jira.jboss.org/browse/TEIID-1362?page=com.atlassian.jira.plugin.s...
]
John Doyle commented on TEIID-1362:
-----------------------------------
Digging deeper I found that the data is in the result from SF.
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: John Doyle
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
3:36 p.m.
New subject: [JBoss JIRA] Work started: (TEIID-1362) salesforce push down queries won't get resolved correctly
[
https://jira.jboss.org/browse/TEIID-1362?page=com.atlassian.jira.plugin.s...
]
Work on TEIID-1362 started by John Doyle.
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: John Doyle
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
2:59 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1362) salesforce push down queries won't get resolved correctly
[
https://jira.jboss.org/browse/TEIID-1362?page=com.atlassian.jira.plugin.s...
]
John Doyle resolved TEIID-1362.
-------------------------------
Fix Version/s: 7.1.1
7.3
Resolution: Done
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: John Doyle
Fix For: 7.1.1, 7.3
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
3:01 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-1362) salesforce push down queries won't get resolved correctly
[
https://jira.jboss.org/browse/TEIID-1362?page=com.atlassian.jira.plugin.s...
]
John Doyle updated TEIID-1362:
------------------------------
Affects Version/s: 7.1
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.1, 7.2
Environment: Teiid 7.2 final on JBoss EAP 5.1 with sun java 1.6.0_20
Reporter: Wanja Pernath
Assignee: John Doyle
Fix For: 7.1.1, 7.3
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
11:38 p.m.
New subject: [JBoss JIRA] Closed: (TEIID-1362) salesforce push down queries won't get resolved correctly
[
https://issues.jboss.org/browse/TEIID-1362?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1362.
---------------------------------
salesforce push down queries won't get resolved correctly
---------------------------------------------------------
Key: TEIID-1362
URL: https://issues.jboss.org/browse/TEIID-1362
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1, 7.2
Environment: Teiid 7.2 final on JBoss EAP 5.1 with sun java 1.6.0_20
Reporter: Wanja Pernath
Assignee: John Doyle
Fix For: 7.1.1, 7.3
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
4852
days inactive
4979
days old
7 comments
3 participants
participants (3)
-
John Doyle (JIRA) -
Steven Hawkins (JIRA)
-
Wanja Pernath (JIRA)