aggregation § on subquery page

[v2belleville]

hi,

On the subqueries page, the example given for § aggregation https://neo4j.com/docs/cypher-manual/current/subqueries/call-subquery/
#call-aggregation

returns the same with or without a subquery

Which seem contradictory with the first sentence "Returning subqueries change the number of results of the query."

as a result, I can not figure what this § is about ...

[JPryce-Aklundh]

Thank you for raising this, @v2belleville - we will look into it.

[dmoree]

@v2belleville
Your second query seems invalid as c is not defined.

The statement:

Returning subqueries change the number of results of the query.

is correct, although it is slightly confusing because there doesn't seem to be enough context; particularly about what query is changed and from what.

The query that is being referred to is actually:

MATCH (p:Person)
RETURN p.name

This query returns 4 rows. This is the query that is being referred to as the enclosing query.

After adding the subquery the number of rows is changed because some do not result in a match.

This is due to Charlie and Dora having no friends unfortunately. So the result isn't friend as say null; but rather that Charlie and Dora disappear.

Ultimately, this section also seems out of place under the heading "Aggregations" since no aggregating functions are being used. It seems like it would function better under a separate section like "Cardinality".

[v2belleville]

hi, thanks for the feed back.

In my second screenshot, I've apparently pasted the wrong query. What I meant is this one :

that returns the same result than with no sub-query

which makes it difficult to see the point in using a sub-query in this case

I now see a query with an aggregation, but it also returns the same result as with no sub-query, so, it's still difficult to see why we should use a sub-query in those cases, and conversely, what are the contexts in which it make sense to use such sub-queries