[teiid-issues] [JBoss JIRA] (TEIID-1852) Salesforce Translator doesnt handle Time types

[Mark Drilling (Updated) (JIRA)]

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

Mark Drilling updated TEIID-1852:
---------------------------------

    Attachment: SFTestVDB.vdb


attaching example VDB
                
> Salesforce Translator doesnt handle Time types
> ----------------------------------------------
>
>                 Key: TEIID-1852
>                 URL: https://issues.jboss.org/browse/TEIID-1852
>             Project: Teiid
>          Issue Type: Bug
>          Components: Salesforce Connector
>    Affects Versions: 7.6
>            Reporter: Mark Drilling
>            Assignee: Steven Hawkins
>         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

--
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