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

[Mark Drilling (Created) (JIRA)]

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