Bug 781157 (SOA-3658)

Summary: Misc. Salesforce Translator Issues (for SOA-P)
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: jolee
Component: unspecifiedAssignee: jolee
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.2.0 GACC: jolee
Target Milestone: ---   
Target Release: One Off Releases   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-3658
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-12-15 15:04:17 UTC Type: Support Patch
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On: 781152    
Bug Blocks: 781155    

Description jolee 2011-12-09 16:50:49 UTC 
Support Case Reference: http://doesntexist.com
project_key: SOA

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
Comment 1 jolee 2011-12-09 16:50:49 UTC 
Link: Added: This issue Cloned from SOA-3651
Comment 2 jolee 2011-12-09 16:50:49 UTC 
Link: Added: This issue is a dependency of SOA-3656
Comment 3 jolee 2011-12-09 16:55:19 UTC 
Workflow: Removed: jira Added: JEMS Support Case Workflow v8
Support Case Reference: Added: http://doesntexist.com
Steps to Reproduce: Removed: 1 - deploy the attached VDB, SFTestVDB.vdb
2 - execute query "SELECT Name,CreatedDate,MondayStartTime FROM SFTest.salesforce.BusinessHours"
Comment 4 jolee 2011-12-09 16:55:40 UTC 
Link: Added: This issue depends SOA-3651
Comment 5 jolee 2011-12-09 16:55:48 UTC 
Link: Removed: This issue Cloned from SOA-3651
Comment 6 jolee 2011-12-13 17:10:50 UTC 
Fix committed:  r3735 - https://svn.jboss.org/repos/teiid/branches/7.4.x/?p=3735