Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3532

Infinispan-dsl-cache translator: Exception is thrown when order by clause is used

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Major Major
    • None
    • 8.7.1.6_2
    • Misc. Connectors
    • None

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

      Sample query:

      select intKey from smalla where intkey > 1 order by intKey
      

      Exception:

      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)
      

      Full log is in the attachment.

            van.halbert Van Halbert (Inactive)
            felias_jira Filip Elias (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: