Escaped literal date format gives a parsing error using EDS ODBC connection

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In