[teiid-issues] [JBoss JIRA] Commented: (TEIID-1406) Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
[
https://issues.jboss.org/browse/TEIID-1406?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1406:
---------------------------------------
The formats on
http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_...
don't show support for milliseconds - although they are supported by ISO. I can see
that change in your patch, but our timestamps also shouldn't include Z unless it is
indicating UTC - in which case the timezone offset should not be appended.
Salesforce connector does not parse {ts'2003-03-11
11:42:10.5'} - gets mismatched character ' ' expecting ':'
-------------------------------------------------------------------------------------------------------------
Key: TEIID-1406
URL: https://issues.jboss.org/browse/TEIID-1406
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: John Doyle
Attachments: sfQueryError.txt, TEIID-1406.patch.txt
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.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira