JurjenBraam opened a new issue, #2167:
URL: https://github.com/apache/age/issues/2167
**Describe the bug**
Similar to a previous bug #1634 trying to dynamically unpack properties when
using the combination of UNWIND and SET leads to an error: `properties()
argument must resolve to a scalar value`
**How are you accessing AGE (Command line, driver, etc.)?**
- Both Command line and NodeJS driver
**What data setup do we need to do?**
- None
**What is the necessary configuration info needed?**
- None
**What is the command that caused the error?**
```pgsql
SELECT * FROM cypher('my_graph_name', $$
UNWIND [{id: 'stock_1', quantity: 100 }] as row
CREATE (s:Stock {id: row.id})
SET s = row
RETURN s
$$) as (a agtype)
```
```
ERROR: properties() argument must resolve to a scalar value
```
**Expected behavior**
Creation of Nodes where all input data are propagated as properties: (Stock
{id: 'stock_1', quantity: 100})
As it when explicitly stating the property key and value:
```pgsql
SELECT * FROM cypher('my_graph_name', $$
UNWIND [{id: 'stock_1', quantity: 100 }] as row
CREATE (s:Stock {id: row.id})
SET s.quantity = row.quantity
RETURN s
$$) as (s agtype)
```
**Environment (please complete the following information):**
- Version: 1.5.0 running in Docker and on an Azure Database for PostgreSQL
flexible server
**Additional context**
For Neo4j using the combination of UNWIND and SET does work as expected:
```pgsql
UNWIND [{id: 'stock_1', quantity: 100 }] AS row
MERGE (n:${nodeLabel} {id: row.id})
SET n = row
RETURN n
```
--
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
