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

Multiple chained CALLs do not return result. #2518

Open
antejavor opened this issue Dec 4, 2024 · 0 comments
Open

Multiple chained CALLs do not return result. #2518

antejavor opened this issue Dec 4, 2024 · 0 comments
Labels
bug bug community community Effort - Unknown Effort - Unknown Frequency - EveryTime Frequency - EveryTime Reach - Some Reach - Some Severity - S2 Severity - S2

Comments

@antejavor
Copy link
Contributor

Memgraph version
Which version did you use?

Multiple "calls" in the same query doesn't seem to work, and I get no result, but when I use one call it works.
for example:

// Retrieve up to 10 distinct values of attribute 'a' that include 'ab'
CALL {
MATCH (n:my_label)
WHERE n.groupId CONTAINS 'a'
RETURN DISTINCT n.groupId AS value
LIMIT 10
}
WITH COLLECT(value) AS aValues

// Retrieve up to 10 distinct values of attribute 'b' that include 'ab'
CALL {
MATCH (n:my_label)
WHERE n.vpcId CONTAINS 'a'
RETURN DISTINCT n.vpcId AS value2
LIMIT 10
}
WITH aValues, COLLECT(value2) AS bValues

// Retrieve up to 10 distinct values of attribute 'c' that include 'ab'
CALL {
MATCH (n:my_label)
WHERE n.kind CONTAINS 'a'
RETURN DISTINCT n.kind AS value3
LIMIT 10
}
WITH aValues, bValues, COLLECT(value3) AS cValues

RETURN aValues, bValues, cValues;

Context: https://discord.com/channels/842007348272169002/1313606689659949078/1313852362619883580

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

No branches or pull requests

1 participant