[teiid-issues] [JBoss JIRA] Resolved: (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 resolved TEIID-1406.
-----------------------------------
Fix Version/s: 7.1.1
Resolution: Done
updated the timestamp formatting toe not include the Z character. milliseconds do seem to
be supported by salesforce though
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
Fix For: 7.1.1
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