[infinispan-issues] [JBoss JIRA] (ISPN-11013) Selecting a single field in a query returns wrong "total_count"

[Jens Reimann (Jira)]

    [ https://issues.jboss.org/browse/ISPN-11013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13820176#comment-13820176 ] 

Jens Reimann commented on ISPN-11013:
-------------------------------------

Setting the properties as requests breaks the query process:

{code}

10:28:01.429 [HotRod-client-async-pool-1-1] WARN  org.infinispan.HOTROD - ISPN004005: Error received from the server: org.infinispan.objectfilter.ParsingException: ISPN028522: No relational queries can be applied to property 'tenantId' in type io.enmasse.iot.infinispan.device.DeviceInformation since the property is analyzed.
Exception in thread "main" org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for messageId=118 returned server error (status=0x85): org.infinispan.objectfilter.ParsingException: ISPN028522: No relational queries can be applied to property 'tenantId' in type io.enmasse.iot.infinispan.device.DeviceInformation since the property is analyzed.
{code}

Interestingly the default value for Analyzed should be YES. So it looks like the default does not get applied.

> Selecting a single field in a query returns wrong "total_count"
> ---------------------------------------------------------------
>
>                 Key: ISPN-11013
>                 URL: https://issues.jboss.org/browse/ISPN-11013
>             Project: Infinispan
>          Issue Type: Bug
>          Components: Remote Querying
>    Affects Versions: 10.0.1.Final
>            Reporter: Jens Reimann
>            Assignee: Gustavo Fernandes
>            Priority: Major
>         Attachments: deviceManagement.proto, infinispan.xml
>
>
> Adding a field selector to the query returns the wrong "total_count" in the result:
> {code:java}
> ➜  openshift oc -n enmasse-infra rsh infinispan-0 curl 'http://app:test12@infinispan-0:11222/rest/v2/caches/devices?action=search&query=from+io.enmasse.iot.registry.infinispan.data.DeviceInformation+d&max_results=1' 
> {
>   "total_results" : 38847,
>   "hits" : [ {
>     "hit" : {
>       "_type" : "io.enmasse.iot.registry.infinispan.data.DeviceInformation",
>       "tenantId" : "jbtest.iot/2019-11-29T08:52:39Z",
>       "deviceId" : "http-inserter-wh5xn103",
>       "version" : "992899e8-c557-4a2c-8bc0-db950a803898",
>       "registrationInformation" : "{}",
>       "credentials" : [ {
>         "authId" : "device-103",
>         "type" : "hashed-password",
>         "secrets" : [ "{\"hash-function\":\"bcrypt\",\"pwd-hash\":\"$2y$12$JELemetlJuc.6ZgQkCn5X..7UEPQm5iQV23lgno7/2sEKY2i.mPmS\"}" ]
>       } ]
>     }
>   } ]
> }
> {code}
> {code:java}
> ➜  openshift oc -n enmasse-infra rsh infinispan-0 curl 'http://app:test12@infinispan-0:11222/rest/v2/caches/devices?action=search&query=select+d.deviceId+from+io.enmasse.iot.registry.infinispan.data.DeviceInformation+d&max_results=1'
> {
>   "total_results" : 1,
>   "hits" : [ {
>     "hit" : {
>       "deviceId" : "http-inserter-wh5xn103"
>     }
>   } ]
> }
> {code}



--
This message was sent by Atlassian Jira
(v7.13.8#713008)