]
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}