diangamichael commented on issue #1611:
URL: https://github.com/apache/age/issues/1611#issuecomment-2040762064
To apply a workaround to the query and avoid using list comprehensions in
the MERGE clause, you can modify the query to precompute the list before using
it in the MERGE clause. Here's how you can rewrite the query:
WITH input_list AS (
SELECT [1,2,3] AS list
)
SELECT * FROM cypher('graph_name', $$
MERGE ({list: u.list})
ON CREATE SET ...
ON MATCH SET ...
$$) AS (a agtype);
In this modified query:
We first create a Common Table Expression (CTE) named input_list to compute
the list [1,2,3].
Then, we reference this computed list u.list within the MERGE clause.
You need to replace ON CREATE SET ... and ON MATCH SET ... with the
appropriate actions you want to perform when the MERGE clause creates or
matches a node.
By precomputing the list outside the MERGE clause, we avoid using list
comprehensions directly within it, potentially bypassing the error you
encountered.
To apply a workaround to the query and avoid using list comprehensions in
the MERGE clause, you can modify the query to precompute the list before using
it in the MERGE clause. Here's how you can rewrite the query:
sql
Copy code
WITH input_list AS (
SELECT [1,2,3] AS list
)
SELECT * FROM cypher('graph_name', $$
MERGE ({list: u.list})
ON CREATE SET ...
ON MATCH SET ...
$$) AS (a agtype);
In this modified query:
We first create a Common Table Expression (CTE) named input_list to compute
the list [1,2,3].
Then, we reference this computed list u.list within the MERGE clause.
You need to replace ON CREATE SET ... and ON MATCH SET ... with the
appropriate actions you want to perform when the MERGE clause creates or
matches a node.
By precomputing the list outside the MERGE clause, we avoid using list
comprehensions directly within it, potentially bypassing the error you
encountered.
--
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]
