Cypher : new engine fails to match results #3271
Description
Hello :
Simplified query
MATCH (n {subtype:"DATE"})
MATCH (n)-[r]-(m:NER)
MATCH (n)--(chunk:CHUNK)--(document:DOCUMENT)
RETURN n.name AS nameReturns nothing on new engine, but returns something on old engine (correct behavior)
Database dump :
ORANO_IMAGE-backup-20260128-130458487.zip
Bonus :
MATCH (n)
MATCH (n)-[r]-(m:NER)
MATCH (n)--(chunk:CHUNK)--(document:DOCUMENT)
RETURN n.name AS name
Takes 14 seconds and returns zero result on NEW engine
Takes 11 seconds and returns multiple results on OLD engine