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

Infinispan-dsl-cache translator: Can't use IS [NOT] NULL operator for non-string columns

    XMLWordPrintable

Details

    Description

      If I use IS NULL or IS NOT NULL operator for non-string column, the server will throw the following exception:

      10:42:34,100 ERROR [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue151) Connector worker process failed for atomic-request=1LH0VEAxBj0U.40.0.30: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[176] returned server error (status=0x85): org.hibernate.search.SearchException: Cannot create numeric range query for field byteNum, since from and to values are null
      	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)
      	at org.infinispan.client.hotrod.impl.operations.HotRodOperation.readHeaderAndValidate(HotRodOperation.java:56)
      	at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:57)
      	at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:24)
      	at org.infinispan.client.hotrod.impl.operations.RetryOnFailureOperation.execute(RetryOnFailureOperation.java:50)
      	at org.infinispan.client.hotrod.impl.query.RemoteQuery.executeQuery(RemoteQuery.java:72)
      	at org.infinispan.client.hotrod.impl.query.RemoteQuery.list(RemoteQuery.java:62)
      	at org.teiid.translator.infinispan.dsl.DSLSearch.performSearch(DSLSearch.java:112)
      

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: