[JBoss JIRA] (ISPN-11013) Selecting a single field in a query returns wrong "total_count"
by Gustavo Fernandes (Jira)
[ https://issues.jboss.org/browse/ISPN-11013?page=com.atlassian.jira.plugin... ]
Gustavo Fernandes updated ISPN-11013:
-------------------------------------
Workaround Description: Make sure the field in the "SELECT" clause is indexed, non-analysed, and has Store.YES
Workaround: Workaround Exists
> 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...'
> {
> "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...'
> {
> "total_results" : 1,
> "hits" : [ {
> "hit" : {
> "deviceId" : "http-inserter-wh5xn103"
> }
> } ]
> }
> {code}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 10 months
[JBoss JIRA] (ISPN-11013) Selecting a single field in a query returns wrong "total_count" for non-indexed fields and fields with Store.NO
by Gustavo Fernandes (Jira)
[ https://issues.jboss.org/browse/ISPN-11013?page=com.atlassian.jira.plugin... ]
Gustavo Fernandes updated ISPN-11013:
-------------------------------------
Summary: Selecting a single field in a query returns wrong "total_count" for non-indexed fields and fields with Store.NO (was: Selecting a single field in a query returns wrong "total_count")
> Selecting a single field in a query returns wrong "total_count" for non-indexed fields and fields with Store.NO
> ---------------------------------------------------------------------------------------------------------------
>
> 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...'
> {
> "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...'
> {
> "total_results" : 1,
> "hits" : [ {
> "hit" : {
> "deviceId" : "http-inserter-wh5xn103"
> }
> } ]
> }
> {code}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 10 months
[JBoss JIRA] (ISPN-11013) Selecting a single field in a query returns wrong "total_count"
by Gustavo Fernandes (Jira)
[ https://issues.jboss.org/browse/ISPN-11013?page=com.atlassian.jira.plugin... ]
Gustavo Fernandes commented on ISPN-11013:
------------------------------------------
We'll investigate those count discrepancies. For now, I will add the Stored.YES as a workaround and change the JIRA title a bit
> 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...'
> {
> "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...'
> {
> "total_results" : 1,
> "hits" : [ {
> "hit" : {
> "deviceId" : "http-inserter-wh5xn103"
> }
> } ]
> }
> {code}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 10 months