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

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: Van Halbert 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.