Performance issue when pattern comprehension expands TO input values #1989
Labels
bug
bug
Effort - Medium
Effort - Medium
Frequency - Monthly
Frequency - Monthly
Priority - Later
Priority - Later
Reach - VeryFew
Reach - VeryFew
Severity - S3
Severity - S3
Memgraph version
2.16.0
Describe the bug
A clear and concise description of what the bug is.
To Reproduce
Steps to reproduce the behavior:
EXPLAIN MATCH (n:Person) WITH n AS actor, [(m)-->(n) WHERE m.released < 3000 | m.released] AS years RETURN actor.name, years;
Workaround
Run
EXPLAIN MATCH (n:Person) WITH n AS actor, [(n)<--(m) WHERE m.released < 3000 | m.released] AS years RETURN actor.name, years;
Be sure that the input vertex for pattern comprehension is first in the expansion inside pattern comprehension.
Expected behavior
No ScanAll, pattern comprehension branch should expand from the input vertex.
Logs
Not optimized plan:
Optimized should be:
The text was updated successfully, but these errors were encountered: