SNAPSHOT and CURRENT browser query returns different results when query limit is enabled.
book
Article ID: KB0094200
calendar_today
Updated On:
Products
Versions
TIBCO ActiveSpaces
-
Not Applicable
-
Description
Resolution: SNAPSHOT and CURRENT Browser query returns a different number of tuples when query limit is enabled and filter matches more tuples as specified in the query limit.
as-admin commands: show space "List" entries filter "id1='10K'" query_limit 10000 timescope "CURRENT" -> returns 10000 show space "List" entries filter "id1='10K'" query_limit 10000 timescope "SNAPSHOT" -> returns 9979
The query_limit only works for CURRENT timescope and it is not an accurate value, which means if you want to return 10K it might return a number around 10K. Also, if there are only 10k matching entries in the cluster, then it is possible that the number of tuples returned would be less than 10k due to the distribution of the tuples in the cluster. With a query limit of 10k, each seeder is sent the query limit of 10k of seeders. There would be a deviation in the number of entries per seeder.
Issue/Introduction
SNAPSHOT and CURRENT browser query returns different results when query limit is enabled.
Environment
Product: TIBCO ActiveSpaces
Version: All versions
OS: All Supported Operating Systems
--------------------