Neo4j中使用WITH/UNWIND子句时无法访问外部变量问题

问题原因 #

Cypher查询按阶段执行，WITH子句是不同查询阶段的分界线——只有在WITH子句中明确列出的变量，才会被传递到下一个查询阶段。你当前的WITH仅声明了participants变量，之前的owner和coaching未被包含在WITH的输出列表里，导致后续的UNWIND、MATCH、CREATE及RETURN阶段都无法访问这两个变量，因此抛出owner未定义的错误。

修复后的查询代码 #

MATCH (owner:User { id: 'b6bba33e-646a-46c2-80a2-4b6a6b5cece9' })
// Create one coaching that has two participants (WITH clause)
CREATE (coaching:Coaching {
  id: randomUUID(),
  subject: 'Testing coaching 1' ,
  notes: 'testing this new feature',
  createdAt: DateTime()
})<-[:COACHES]-(owner)
              

WITH owner, coaching, ['e1d8aaef-8db6-4dc1-8f3e-1bce06463d04', '6c20b918-284c-42a9-bc6f-ab4f99a09f2f'] AS participants
UNWIND participants AS p
MATCH (participant:User { id: p })
// Create relationship participant PARTICIPATES in coaching
CREATE (coaching)<-[:PARTICIPATES]-(participant)

RETURN owner, coaching, p

修复说明 #

在WITH子句开头添加owner, coaching，将这两个需要后续使用的变量明确传递到下一个查询阶段，这样后续操作就能正常访问它们，不会再出现变量未定义的错误。

内容的提问来源于stack exchange，提问作者Maarten Coppens