mingfang commented on issue #1691:
URL: https://github.com/apache/age/issues/1691#issuecomment-2004732935
Also this is only a problem when multiple MERGE are called in the same query.
e.g. this works as expected, only one vertex is created
```
SELECT * FROM cypher('playground', $$
unwind ["foo"] as each
merge (v:TEST {name: each})
return v
$$) AS (v agtype)
SELECT * FROM cypher('playground', $$
unwind ["foo"] as each
merge (v:TEST {name: each})
return v
$$) AS (v agtype)
```
I'm guessing if multiple MERGE in the same query somehow is not seeing each
statement's "state" since the transaction is not committed yet. Totally a wild
guess.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]