Multiple chained CALLs do not return result. #2518
Labels
bug
bug
community
community
Effort - Unknown
Effort - Unknown
Frequency - EveryTime
Frequency - EveryTime
Reach - Some
Reach - Some
Severity - S2
Severity - S2
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
The text was updated successfully, but these errors were encountered: