[GitHub] [age] Zainab-Saad commented on issue #978: The count number does not match on UPDATE and DELETE.

["Zainab-Saad (via GitHub)" <gi...@apache.org>]

Zainab-Saad commented on issue #978:
URL: https://github.com/apache/age/issues/978#issuecomment-1584106238

   In AGE, only the rows returned from the cypher query will be displayed in the table (even if you made changes to graph entities in your cypher query) and hence you need to use the `RETURN` clause to see the changes made to the graph entities. For example, in both the UPDATE and DELETE examples, you need to RETURN the rows as :
   ```
   SELECT * FROM cypher ( 'tmp', $$                                        
   MATCH (a:Part) WHERE a.part_num=~'3+'
   SET a.part_num='333' RETURN a
   $$) AS (a agtype) ;
   ```
   
   and 
   
   ```
   SELECT * FROM cypher ( 'tmp', $$                                        
   MATCH (a:Part) WHERE a.part_num=~'3+' DELETE a RETURN a
   $$) AS (a agtype) ;
   ```
   


-- 
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-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org