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.

Sign up for GitHub

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

Jump to bottom

Index scan returning incorrect results for queries #1915

Closed
anuchak opened this issue Aug 10, 2023 · 4 comments
Closed

Index scan returning incorrect results for queries #1915

anuchak opened this issue Aug 10, 2023 · 4 comments
Assignees
@ray6080 @andyfengHKU
Labels
bug Something isn't working

Comments

@anuchak
Copy link
Collaborator

anuchak commented Aug 10, 2023

Screenshot from 2023-08-09 20-46-49

Screenshot from 2023-08-09 20-52-32

This is from LDBC-100 dataset, when I give exact equality condition on PK the IndexScan operator is used.
Incorrect properties and everything gets returned.
@anuchak
Copy link
Collaborator Author

anuchak commented Aug 10, 2023

The 2nd screenshot shows for the same tuple, the correct answer when filter is given.

@anuchak
Copy link
Collaborator Author

anuchak commented Aug 10, 2023

Update on this, pulled the latest master changes again. Index scan seems to be the problem:

Screenshot from 2023-08-09 21-47-42

@ray6080 ray6080 self-assigned this Aug 14, 2023
@ray6080 ray6080 added the bug Something isn't working label Aug 14, 2023
@ray6080
Copy link
Contributor

ray6080 commented Sep 7, 2023 •
edited

@anuchak , can you give a try on the latest master again? I can't reproduce it locally.

@ray6080
Copy link
Contributor

ray6080 commented Sep 7, 2023

Actually, i've reproduced it. This PR should fix it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ray6080 ray6080

@andyfengHKU andyfengHKU

Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@ray6080 @anuchak @andyfengHKU @acquamarin