tvaeyens opened a new issue, #1907:
URL: https://github.com/apache/age/issues/1907
**Describe the bug**
When using a MERGE for a relation between two nodes that is not present in
the database, the properties are not stored inside the database.
**How are you accessing AGE (Command line, driver, etc.)?**
- Age viewer
- Python Driver
**What data setup do we need to do?**
```pgsql
SELECT * FROM ag_catalog.create_graph('test_graph');
SELECT * from cypher('test_graph', $$
CREATE (n:Testnode {name: 'Test Node A'})
RETURN n
$$) as (n agtype);
SELECT * from cypher('test_graph', $$
CREATE (n:Testnode {name: 'Test Node B'})
RETURN n
$$) as (n agtype);
```
**What is the necessary configuration info needed?**
N/A
**What is the command that caused the error?**
```pgsql
SELECT * FROM cypher('test_graph', $$
MATCH (a)
WHERE a.name= 'Test Node A'
MATCH (b)
WHERE b.name= 'Test Node B'
MERGE (a)-[r:RELATED_TO]->(b)
SET r = {property1: 'something', property2: 'else'}
RETURN r
$$) AS (r agtype);
```
This gives the following output which is correct:
```json
{"id":1125899906842625,"label":"RELATED_TO","end_id":844424930131970,"start_id":844424930131969,"properties":{"property1":"something","property2":"else"}}
```
When executing the next query:
```pgsql
SELECT * FROM cypher('test_graph', $$
MATCH (a)-[r]->(b)
return a, r, b
$$) AS (a agtype, r agtype, b agtype);
```
This following output is received:
```json
{"id":844424930131969,"label":"Testnode","properties":{"name":"Test Node
A"}}
,{"id":1125899906842625,"label":"RELATED_TO","end_id":844424930131970,"start_id":844424930131969,"properties":{}}
,{"id":844424930131970,"label":"Testnode","properties":{"name":"Test Node B"}}
```
As you can see, the edge properties are not here anymore. Is this expected
behavior? Or does this type of queries need to be formed in another way?
**Expected behavior**
I thought the edge properties would still be present when executing the last
query.
**Environment (please complete the following information):**
- Running from the apache/age:latest Docker image
**Additional context**
N/A
--
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: dev-unsubscr...@age.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
