[teiid-issues] [JBoss JIRA] (TEIID-3670) Salesforce query issue

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-3670.
-----------------------------------
    Resolution: Deferred


Marking as deferred. The exception doesn't quite match the expectation of the runtime type modeling of string, but since it is perfectly valid for salesforce to throw an exception when there is a datatype mismatch - similar to issuing something like int_col = 'x' in most databases - this doesn't seem to warrant addressing in our code at this time.

> Salesforce query issue
> ----------------------
>
>                 Key: TEIID-3670
>                 URL: https://issues.jboss.org/browse/TEIID-3670
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Salesforce Connector
>    Affects Versions: 8.7.3
>            Reporter: Mark Drilling
>            Assignee: Steven Hawkins
>            Priority: Minor
>             Fix For: 8.12
>
>         Attachments: SFException.txt
>
>
> Linking to JIRA that was logged under Teiid Designer.  I was able to reproduce the reported problem with both types of VDB - it is not really a designer issue.
> For this query:
> select Opportunity.CloseDate from SalesForceSource.Campaign, SalesForceSource.Opportunity WHERE Campaign.Id = Opportunity.CampaignId
> I was able to reproduce with earlier 8.7 version of teiid, but it appears to have been addressed in a later 8.7.x version (DV62).
> However I then tried this query:
> select Opportunity.CloseDate from SalesForceSource.Campaign, SalesForceSource.Opportunity WHERE Campaign.Id = 'xx'
> which results in a "Invalid QName in mapping: sf:INVALID_QUERY_FILTER_OPERATOR" exception (see attachment).  This occurs in the DV62/teiid8.7.1 version.
> I realize there has been some work recently in the salesforce connector area, so not sure if it is still an issue with recent versions.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)