Escaped literal date format gives a parsing error using EDS ODBC connection
Issue
The below query with escaped literal date format runs fine using JDBC driver but ODBC driver throws a parsing error in EDS.
select {d '2011-01-01'}
2013-04-30 16:39:06,097 DEBUG [org.teiid.PROCESSOR] (Worker994_QueryProcessorQueue3000136) Request Thread 7S03Z43JDOcE.52 - error occurred
org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered ":" at line 1, column 20.
Was expecting one of:
<EOF>
"and" ...
"as" ...
"between" ...
"fetch" ...
"from" ...
"in" ...
"intersect" ...
"into" ...
"is" ...
...
Environment
- JBoss Enterprise Data Services (EDS) 5.3.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.