Bug 780326 (SOA-2734) - Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
Summary: Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismat...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-2734
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.1.0.ER5
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.1.0.CR1
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-01-04 14:30 UTC by Paul Nittel
Modified: 2011-02-08 14:58 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-02-08 14:58:08 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-2734 0 None None None Never

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.
Note You need to log in before you can comment on or make changes to this bug.