Error: Tried overwriting already taken variable name 'geo' as LongSlot(2,false,Node) (was: RefSlot(0,true,Any))

[tarendran_vivek]

Hi all,

When I try the query below I receive this error: Tried overwriting already taken variable name 'geo' as LongSlot(2,false,Node) (was: RefSlot(0,true,Any))

CALL db.index.fulltext.queryNodes('geo', '**')
YIELD node AS geo
CALL {
WITH geo
OPTIONAL MATCH (u:User)<-[:GROUPS]-(g:Groups)<-[:Sends]-(geo)
WITH g, collect(u) AS u1
RETURN collect(g{.*, users: u1}) AS data
UNION
WITH geo
OPTIONAL MATCH (a:Admin)<-[:Sends]-(geo)
RETURN collect(a) AS data
} RETURN geo{.*, data} AS results

When I ran it the first time I did not get any issues. However, when I ran it again I received this error.

Thanks in advance.

[alexabidri]

Hi community,

Having the same issue on my side also when combining subquery and Post-UNION processing with complex query and data sets. I am importing one external variables to the subquery and chaining multiple union with the same variable (like with geo in the previous example).
Any updates from neo4j?

Thanks,