rafsun42 opened a new issue, #1219:
URL: https://github.com/apache/age/issues/1219
_Note: This task is ONLY assigned to people in the 'refactor create\merge'
project._
**Describe the bug**
If properties in the MERGE clause is set from a previous variable (i.e. `..
MERGE ( {key: some_variable} ) ..`), that particular key-value pair is not
persisted.
**How are you accessing AGE (Command line, driver, etc.)?**
Command line
**What data setup do we need to do?**
```pgsql
...
SELECT * FROM cypher('xyz',
$$
CREATE (x:Label1{arr:[1,2,3,4]})
RETURN x
$$) as (a agtype);
...
```
**What is the necessary configuration info needed?**
N/A
**What is the command that caused the error?**
```pgsql
SELECT * FROM cypher('xyz',
$$
MATCH (x:Label1{arr:[1,2,3,4]})
MERGE (y:Label2{key1:2, key2:x.arr, key3:3})
RETURN y
$$) as (a agtype);
```
**Behavior**
The `key2: x.arr` pair is not persisted in the output.
Output:
```
a
-------------------------------------------------------------------------------------------
{"id": 1688849860263937, "label": "Label2", "properties": {"key1": 2,
"key3": 3}}::vertex
(1 row)
```
**Expected behavior**
Expected output:
```
a
-------------------------------------------------------------------------------------------
{"id": 1688849860263937, "label": "Label2", "properties": {"key1": 2,
"key2": [1, 2, 3, 4], "key3": 3}}::vertex
(1 row)
```
**Environment (please complete the following information):**
PG15.4
Master branch
Ubuntu 22.04
**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
