[teiid-issues] [JBoss JIRA] (TEIID-1852) Misc. Salesforce Translator Issues

[RH Bugzilla Integration (JIRA)]

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

RH Bugzilla Integration updated TEIID-1852:
-------------------------------------------

    Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=781152

    
> Misc. Salesforce Translator Issues
> ----------------------------------
>
>                 Key: TEIID-1852
>                 URL: https://issues.jboss.org/browse/TEIID-1852
>             Project: Teiid
>          Issue Type: Bug
>          Components: Salesforce Connector
>    Affects Versions: 6.0.0
>            Reporter: Mark Drilling
>            Assignee: Steven Hawkins
>             Fix For: 7.7
>
>         Attachments: SFTestVDB.vdb
>
>
> Query the BusinessHours table imported from Salesforce, which contains columns with 'time' datatype.
> For example, the query:
> SELECT Name,CreatedDate,MondayStartTime FROM SFTest.salesforce.BusinessHours
> Results in:
> Error Code:ERR.003.029.0025 Message:Failed to transform String to Time.  Expected format = hh:mm:ss for 08:00:00.000Z
> It looks like the code in QueryExecutionImpl.getCellDatum needs to handle translation of the salesforce time format
> Other issues:
> - nil string values will be returned as empty instead of null.
> - non-join criteria of the form column1 = column2 is rendered inappropriately (however it is not supported by SF we should look at restricting criteria support to literals)
> - IN predicate time/date/timestamp values are not formatted correctly
> - timezones are ignored on returned time/timestamp values.  So unless the server is in the same timezone as the values (typically Z/GMT) the local value will be incorrect.
> - a timezone is not included on literal times, which has the same issue as above.
> - IS NULL support should be added using col = NULL

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira