Zeesh-an commented on issue #978:
URL: https://github.com/apache/age/issues/978#issuecomment-1588063850
It appears there may be some confusion. Only the rows returned from a Cypher
query are displayed in the table. To accurately observe the changes made to
graph entities, RETURN clause in your queries can be used as mentioned by
@AbdulSamad4068 . Here's an alternative explanation along with modified
examples to demonstrate how you can adjust your UPDATE and DELETE queries to
view the affected rows:
```
SELECT * FROM cypher ('tmp', $$
MATCH (a:Part)
WHERE a.part_num =~ '3+'
SET a.part_num = '333'
RETURN a
$$) AS (a agtype);
```
In this query, the 'part_num' property of nodes labeled as 'Part' is
modified, specifically updating it to '333'. By including the RETURN clause and
specifying 'a', the modified rows will be returned and displayed as part of the
query result.
--
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]
