Nested CALL Subqueries with CREATE in Optional Match Cause Unexpected Behavior #3072
Description
Memgraph version
memgraph 3.3.0
Describe the bug
When executing a Cypher query with nested CALL subqueries containing OPTIONAL MATCH followed by CREATE, Memgraph Logs:
org.neo4j.driver.internal.logging.JULogger warn
warn: [0xb2f82549][localhost:7683][bolt-1] Fatal error occurred in the pipeline
org.neo4j.driver.internal.shaded.io.netty.handler.codec.DecoderException: Failed to read inbound message:
Query:
MATCH p0 = (:l3:l7:l1:l8:l5:l9:l6:l2:l11), (n0)
CALL{OPTIONAL MATCH p1 = () <-[:rt11]- (n1) <-[r0:rt4 {k6: "Kb7Vm"}]- (:l7 {id: 119}), (:l10:l6:l4 {id: 21}), p2 = (:l2:l4:l6:l10:l9:l7:l0:l3 {k0: "Hu6"}) <-[r1 {k5: true}]- ()
CALL{ OPTIONAL MATCH (n2{id:13})
CALL{OPTIONAL MATCH (n4 {k9: "hb5EvbK"})
WITH n4.k1 AS alias1, n4 CREATE (:l2:l9:l10:l11:l5:l7:l8 {k0: "X", k1: [], k2: 2051699589, k4: -1370770409, k5: false, k11: "F", id: 128, k6: "1", k10: 849621271, k7: "X", k9: "H4i8Udq"}) -[r3:rt2 {k0: "0zt", k1: [-344172793, 1026708731], k2: 609173837, k3: true, k4: -1358495095, k5: true, k11: "W", k6: "j", k10: 1143558141, k7: "Tt", k8: true, k9: "UR78", id: 26}]-> (n5:l6:l3:l0:l7:l1:l4:l5:l9:l2:l11:l10 {k1: [-731828202], k2: -619318814, k4: -55801862, k11: "zDUfP", id: 129, k6: "II", k7: "X"})
WITH alias1, r3.k7 AS alias4, n5 AS alias7, r3 AS alias8
RETURN alias7 AS n6, alias1 AS alias9}
RETURN alias9 AS alias19 }
WITH DISTINCT * RETURN DISTINCT r0 AS r4}
RETURN *
To Reproduce
1.Load the same dataset into Memgraph
2.Execute the above query
3.Observe result