[ https://issues.jboss.org/browse/TEIID-1852?page=com.atlassian.jira.plugin... ] Mark Drilling updated TEIID-1852: --------------------------------- Attachment: SFTestVDB.vdb attaching example VDB -- 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

[ https://issues.jboss.org/browse/TEIID-1852?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-1852: ---------------------------------- Summary: Misc. Salesforce Translator Issues (was: Salesforce Translator doesnt handle Time types) Description: 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 was: 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

[ https://issues.jboss.org/browse/TEIID-1852?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-1852: ------------------------------------------- Bugzilla Update: Perform -- 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

[ https://issues.jboss.org/browse/TEIID-1852?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1852. --------------------------------- -- 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