Bug 780326 (SOA-2734)

Summary: Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Paul Nittel <pnittel>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0.ER5   
Target Milestone: ---   
Target Release: 5.1.0.CR1   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2734
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-02-08 14:58:08 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Paul Nittel 2011-01-04 14:30:25 UTC
project_key: SOA

As part of testing the SalesForce connector, I executed the following query:
Select Subject, ClosedDate from Case_ where ClosedDate > {ts'2003-03-11 11:42:10.5'}

and got back:
Error: Remote org.teiid.core.TeiidProcessingException: MALFORMED_QUERY: 
> 2003-03-11T11:42:10.500Z-05:00 LIMIT 100
                               ^
ERROR at Row:1:Column:101
line 1:101 mismatched character ' ' expecting ':'

A more complete stack trace is attached.

Comment 1 Van Halbert 2011-01-04 14:30:25 UTC
Link: Added: This issue Cloned from TEIID-1406


Comment 2 Van Halbert 2011-01-04 14:33:27 UTC
Security: Added: Public


Comment 3 Van Halbert 2011-01-04 14:34:03 UTC
Teiid has applied the fix to the 7.1.x branch.

Comment 4 Paul Nittel 2011-02-08 14:58:08 UTC
Tested with ER9 and closed.