You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Thank you for this interesting corner case. As this is such a narrow use case I feel that our performance efforts are better spent on other things, also given that it is easy to hand optimize a query from one form to the other if it is a bottleneck for some use case.
If you are interested in the subtle nuances of patterns, I encourage you to participate in the ongoing OpenCypher work around path patterns opencypher/openCypher#187, which is essentially about extending Cypher patterns with regex-like functionality.
Environment
Background
Description
Consider:
The plan will include two
VarLengthExpand(All)
operators:Which is rather bonkers.
Also note the result:
This is correct, but why would anyone like to do this?
This query can be rewritten as:
Which is more efficient, and it only produces distinct paths:
I'm sure you'll also be able to work out the arithmetic for queries like this:
Anyhow, given the results are different, perhaps this is more of a case of semantics rather than optimisation.
The text was updated successfully, but these errors were encountered: