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

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 8.7.1.6_2, 8.12
    • 8.7.1.6_2
    • Misc. Connectors
    • None

      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)

        1. server.log
          15 kB
          Filip Elias

              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: