为何Neo4J插入字段时不允许空格？问题排查求助

问题详情 #

执行这条MERGE语句：

MERGE (Limited_Edition_Independence_Day_TShirt:Conversation { name: "Limited_Edition_Independence_Day_TShirt", is_snippet: "false", title: "Limited Edition Independence Day T-Shirt", summary: "", status: "", date: "2024-06-02 12:48:51"})

触发错误：

Invalid input '?': expected "(", "ALL", "ANY" or "SHORTEST" (line 1, column 8 (offset: 7))
"MERGE (Limited_Edition_Independence_Day_TShirt:Conversation { name: "Limited_Edition_Independence_Day_TShirt", is_snippet: "false", title: "Limited Edition Independence Day T-Shirt ", summary: "", status: "", date: "2024-06-02 12:48:51"})"
        ^

把title的双引号改成反引号后，错误依旧：

Invalid input '?': expected "(", "ALL", "ANY" or "SHORTEST" (line 1, column 8 (offset: 7))
"MERGE (Limited_Edition_Independence_Day_TShirt:Conversation { name: "Limited_Edition_Independence_Day_TShirt", is_snippet: "false", title: `Limited Edition Independence Day T-Shirt`, summary: "", status: "", date: "2024-06-02 12:48:51"})"
        ^

相同格式的语句有时能正常执行，有时失败，还会弹出「Variable not defined」错误，所有问题均指向title字段。

另外这条带问号的语句，无论用双引号还是反引号包裹title内容，都执行失败：

MERGE (Megyn_Kelly_Trump_Convicted__Now_What_With_Aidala_Eiglarsh_Dershowitz_Geragos_Aronberg_Davis_Holloway_and_2_more_videos:Conversation { name: "Megyn_Kelly_Trump_Convicted__Now_What_With_Aidala_Eiglarsh_Dershowitz_Geragos_Aronberg_Davis_Holloway_and_2_more_videos", is_snippet: "false", title: `Megyn Kelly: `Trump Convicted - Now What? With Aidala, Eiglarsh, Dershowitz, Geragos, Aronberg, Davis, Holloway and 2 more videos`, summary: "", status: "", date: "2024-06-01 19:39:19"})

问题原因及解决办法 #

1. 字符串包裹方式误用 #

Cypher中字符串值必须用单引号或双引号包裹，反引号是用来处理特殊标识符（比如带空格的节点变量名、标签名）的，不能用来包裹字符串值。你之前用反引号包裹title的字符串内容，属于语法错误。

2. 简化节点变量名 #

你给节点定义的变量名（比如Limited_Edition_Independence_Day_TShirt）过长，虽然语法允许，但容易触发解析异常，且完全没必要——变量名只是查询中的临时标识，不影响节点本身的属性，建议改成短变量名（比如conv）：

MERGE (conv:Conversation { 
  name: "Limited_Edition_Independence_Day_TShirt", 
  is_snippet: "false", 
  title: "Limited Edition Independence Day T-Shirt", 
  summary: "", 
  status: "", 
  date: "2024-06-02 12:48:51"
})

3. 带问号语句的修复 #

最后那条语句中，你在反引号内嵌套了反引号，导致字符串提前闭合，后续内容被当成Cypher语法解析从而报错。改成双引号包裹字符串，内部的单引号直接保留即可：

MERGE (conv:Conversation { 
  name: "Megyn_Kelly_Trump_Convicted__Now_What_With_Aidala_Eiglarsh_Dershowitz_Geragos_Aronberg_Davis_Holloway_and_2_more_videos", 
  is_snippet: "false", 
  title: "Megyn Kelly: 'Trump Convicted - Now What? With Aidala, Eiglarsh, Dershowitz, Geragos, Aronberg, Davis, Holloway and 2 more videos'", 
  summary: "", 
  status: "", 
  date: "2024-06-01 19:39:19"
})

4. 排查隐藏特殊字符 #

如果上述修改后仍报错，检查语句中是否存在全角空格、不可见字符等隐藏问题，可以将语句复制到纯文本编辑器（如Notepad++）中查看，或手动重新输入核心内容。

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