Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Paging predicate causes full scans on small result sets #13159

Closed
taburet opened this issue May 21, 2018 · 1 comment
Closed

Paging predicate causes full scans on small result sets #13159

taburet opened this issue May 21, 2018 · 1 comment

Comments

@taburet
Copy link
Contributor

@taburet taburet commented May 21, 2018

If the inner predicate of the paging predicate returns an empty result set, the paging predicate returns null as the indexed query result, this interpreted as an absence of the indexed result by the query engine and the execution falls back to the full scan.

For OS edition this causes the full scan reevaluation of the indexed query returned an empty result. For HD this causes the full scan reevaluation on every partition returned an empty result.

@taburet taburet added this to the 3.10.2 milestone May 21, 2018
@taburet taburet self-assigned this May 21, 2018
@sertugkaya
Copy link

@sertugkaya sertugkaya commented May 21, 2018

Related to ZD3902.

taburet added a commit to taburet/hazelcast that referenced this issue May 22, 2018
If the inner predicate of the paging predicate returns an empty result
set, the paging predicate returns null as the indexed query result, this
interpreted as an absence of the indexed result by the query engine and
the execution falls back to the full scan. This change fixes this
misbehavior.

Fixes: hazelcast#13159
taburet added a commit that referenced this issue May 22, 2018
If the inner predicate of the paging predicate returns an empty result
set, the paging predicate returns null as the indexed query result, this
interpreted as an absence of the indexed result by the query engine and
the execution falls back to the full scan. This change fixes this
misbehavior.

Fixes: #13159
taburet added a commit to taburet/hazelcast that referenced this issue May 22, 2018
If the inner predicate of the paging predicate returns an empty result
set, the paging predicate returns null as the indexed query result, this
interpreted as an absence of the indexed result by the query engine and
the execution falls back to the full scan. This change fixes this
misbehavior.

(cherry-picked from b24588a)

Fixes: hazelcast#13159
taburet added a commit that referenced this issue May 22, 2018
If the inner predicate of the paging predicate returns an empty result
set, the paging predicate returns null as the indexed query result, this
interpreted as an absence of the indexed result by the query engine and
the execution falls back to the full scan. This change fixes this
misbehavior.

(cherry-picked from b24588a)

Fixes: #13159
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

3 participants
You can’t perform that action at this time.