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

OPTIONAL MATCH causing ScanAll on related label #1958

Open
matea16 opened this issue Apr 22, 2024 · 1 comment
Open

OPTIONAL MATCH causing ScanAll on related label #1958

matea16 opened this issue Apr 22, 2024 · 1 comment
Labels
community community Effort - Unknown Effort - Unknown Frequency - Daily Frequency - Daily Reach - Some Reach - Some Severity - S3 Severity - S3

Comments

@matea16
Copy link

matea16 commented Apr 22, 2024

Description
A user on Discord reported using an OPTIONAL MATCH clause on a related label causes a ScanAll operation instead of leveraging existing relationships.

Environment
User tested it on version2.13.0-memgraph2.13.0-lab2.10.0-mage1.13, but it behaves the same on the latest version, 2.16.

Issue
Is this an expected behavior? If not, the fix is needed, if yes, it should be explained and documented

Query plan
snip

@matea16 matea16 added Effort - Unknown Effort - Unknown Severity - S3 Severity - S3 Frequency - Daily Frequency - Daily Reach - Some Reach - Some community community labels Apr 22, 2024
@Kevin-Mc-Callister
Copy link

Kevin-Mc-Callister commented Apr 23, 2024

Happy to hop on a call to describe the issue better if required :)

I believe what happens is:
On a query, after an optional match, the planner doesn't leverage relationships.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
community community Effort - Unknown Effort - Unknown Frequency - Daily Frequency - Daily Reach - Some Reach - Some Severity - S3 Severity - S3
Projects
Development

No branches or pull requests

2 participants