[New cypher engine] Failing query #3128
Description
Hello,
When trying with the new cypher engine i have an error with this query com.arcadedb.exception.CommandExecutionException :
(also having a more descriptive error would help)
UNWIND $batch as row
MATCH (a) WHERE ID(a) = row.source_id
MATCH (b) WHERE ID(b) = row.target_id
MERGE (a)-[r:in]->(b) RETURN a, b, rAlso gave a try with :
UNWIND $batch as row
MATCH (a),(b) WHERE ID(a) = row.source_id and ID(b) = row.target_id
MERGE (a)-[r:in]->(b)
RETURN a, b, rparams for the batch :
{"batch": [{"source_id": "#1:0", "target_id": "#4:0", "features": {}, "relation_type": "in"}, {"source_id": "#1:0", "target_id": "#4:0", "features": {}, "relation_type": "in"}, {"source_id": "#1:0", "target_id": "#4:0", "features": {}, "relation_type": "in"}, {"source_id": "#1:0", "target_id": "#4:0", "features": {}, "relation_type": "in"}, {"source_id": "#1:0", "target_id": "#4:0", "features": {}, "relation_type": "in"}, {"source_id": "#1:0", "target_id": "#4:0", "features": {}, "relation_type": "in"}, {"source_id": "#1:0", "target_id": "#4:0", "features": {}, "relation_type": "in"}, {"source_id": "#1:0", "target_id": "#4:0", "features": {}, "relation_type": "in"}, {"source_id": "#1:0", "target_id": "#4:0", "features": {}, "relation_type": "in"}]}Database dump right before the error :