如何在Memgraph中让可选匹配结果不满足条件时不返回数据？

需求说明 #

• 执行OPTIONAL MATCH操作，检索数据库中可能存在或不存在的节点和关系
• 即使匹配到OPTIONAL MATCH的数据，必须满足特定条件才纳入最终结果；不满足条件时，查询需表现得如同未找到数据，不返回对应结果

初始尝试代码 #

MATCH (originServer:Server{ip:'192.168.0.1'})-[link]->(trafficLimit:BandwidthCap) 
MATCH (trafficLimit)-[endLink:Dest]->(destinationServer:Server{ip:'192.168.0.2'})
OPTIONAL MATCH (trafficLimit:BandwidthCap)-[viaPath:Via]->(intermediateRouter:Router)
WHERE (intermediateRouter IS NULL) OR any(i in ['Cisco'] where i = intermediateRouter.brand)
RETURN originServer, link, trafficLimit, endLink, destinationServer, viaPath, intermediateRouter;

调整后的问题代码 #

MATCH (originServer:Server{ip:'192.168.0.1'})-[link]->(trafficLimit:BandwidthCap) 
MATCH (trafficLimit)-[endLink:Dest]->(destinationServer:Server{ip:'192.168.0.2'})
OPTIONAL MATCH (trafficLimit:BandwidthCap)-[viaPath:Via]->(intermediateRouter:Router)
OPTIONAL MATCH (trafficLimit:BandwidthCap)-[exceptPath:Via]->(exceptionRouter:Router)
RETURN
CASE trafficLimit
WHEN intermediateRouter IS NULL AND exceptionRouter IS NULL THEN trafficLimit.cap
WHEN intermediateRouter = "Cisco" THEN trafficLimit.cap
ELSE NULL
END

问题分析与解决方案 #

你的需求完全可以实现，核心是修正OPTIONAL MATCH的逻辑，避免语法和逻辑错误：

初始代码的问题 #

WHERE子句放在OPTIONAL MATCH后逻辑矛盾：OPTIONAL MATCH已匹配到intermediateRouter节点时，intermediateRouter IS NULL永远不成立，导致只会保留品牌为Cisco的路由器，无法保留“没有匹配到路由器”的情况。

调整后代码的问题 #

1. CASE语法错误：CASE trafficLimit是将节点对象与布尔条件做比较，两者永远不相等，直接触发ELSE返回NULL
2. 多余的OPTIONAL MATCH：第二个OPTIONAL MATCH会匹配所有Via关系的路由器，导致exceptionRouter几乎不可能为NULL，让第一个WHEN条件完全失效

正确实现方式 #

方式1：在OPTIONAL MATCH中直接加条件

把筛选条件整合到匹配模式里，只匹配符合条件的路由器，无匹配时变量为NULL：

MATCH (originServer:Server{ip:'192.168.0.1'})-[link]->(trafficLimit:BandwidthCap) 
MATCH (trafficLimit)-[endLink:Dest]->(destinationServer:Server{ip:'192.168.0.2'})
// 仅匹配品牌为Cisco的路由器，无匹配则intermediateRouter和viaPath为NULL
OPTIONAL MATCH (trafficLimit)-[viaPath:Via]->(intermediateRouter:Router{brand: 'Cisco'})
RETURN originServer, link, trafficLimit, endLink, destinationServer, viaPath, intermediateRouter;

方式2：用WHERE过滤OPTIONAL MATCH结果

适合复杂条件场景，明确逻辑：要么无匹配，要么匹配的路由器符合要求：

MATCH (originServer:Server{ip:'192.168.0.1'})-[link]->(trafficLimit:BandwidthCap) 
MATCH (trafficLimit)-[endLink:Dest]->(destinationServer:Server{ip:'192.168.0.2'})
OPTIONAL MATCH (trafficLimit)-[viaPath:Via]->(intermediateRouter:Router)
// 保留无匹配，或匹配到Cisco路由器的情况
WHERE intermediateRouter IS NULL OR intermediateRouter.brand = 'Cisco'
RETURN originServer, link, trafficLimit, endLink, destinationServer, viaPath, intermediateRouter;

方式3：完全排除存在不符合条件数据的结果

如果需求是“只要存在非Cisco的路由器，就不返回这条主匹配结果”，可以用NOT EXISTS过滤：

MATCH (originServer:Server{ip:'192.168.0.1'})-[link]->(trafficLimit:BandwidthCap) 
MATCH (trafficLimit)-[endLink:Dest]->(destinationServer:Server{ip:'192.168.0.2'})
// 确保不存在非Cisco的路由器
WHERE NOT EXISTS((trafficLimit)-[:Via]->(:Router) WHERE NOT Router.brand = 'Cisco')
OPTIONAL MATCH (trafficLimit)-[viaPath:Via]->(intermediateRouter:Router{brand: 'Cisco'})
RETURN originServer, link, trafficLimit, endLink, destinationServer, viaPath, intermediateRouter;

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