[teiid-issues] [JBoss JIRA] (TEIID-3532) Infinispan-dsl-cache translator: Exception is thrown when order by clause is used

[Filip Elias (JIRA)]

Filip Elias created TEIID-3532:
----------------------------------

             Summary: Infinispan-dsl-cache translator: Exception is thrown when order by clause is used
                 Key: TEIID-3532
                 URL: https://issues.jboss.org/browse/TEIID-3532
             Project: Teiid
          Issue Type: Bug
          Components: Misc. Connectors
    Affects Versions: 8.7.1.6_2
            Reporter: Filip Elias
            Assignee: Steven Hawkins
         Attachments: server.log

Infinispan-dsl-cache translator will fail if order by clause is pushed down.

Sample query:
{code}
select intKey from smalla where intkey > 1 order by intKey
{code}

Exception:
{code}
Connector worker process failed for atomic-request=iLuNd1gO/2N0.4.0.7: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[38] returned server error (status=0x85): org.hibernate.hql.ParsingException: HQLPARSER000002: The query FROM org.jboss.qe.jdg_remote.protobuf.SmallA _gen0 WHERE _gen0.intKey > 1 ORDER BY _gen0.null ASC is not valid; Parser error messages: [[statement, statementElement, selectStatement, orderByClause, sortSpecification, sortKey, concatenation, additiveExpression, multiplyExpression, unaryExpression, atom, identPrimary]: line 1:89 mismatched token: [@32,89:92='null',<124>,1:89]; expecting type IDENTIFIER].
	at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:298)
	at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:88)
	at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:74)
{code}

Full log is in the attachment.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)