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

[Gustavo Fernandes (Jira)]

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

Gustavo Fernandes edited comment on ISPN-11013 at 12/3/19 5:08 AM:
-------------------------------------------------------------------

The important bit is the {{Store.YES}} in the fields you have in the select clause, in order to get the correct count. If you change that in your proto, you need to either start with empty caches or re-index current data 



was (Author: gustavonalle):
The important bit is the {{Store.YES}} in the fields you have in the select clause, in order to get the correct count.


> 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)