[GitHub] [age] Amr-Shams commented on issue #988: Unexpected output from MATCH RETURN query when nodes don't have a specific property

["Amr-Shams (via GitHub)" <gi...@apache.org>]

Amr-Shams commented on issue #988:
URL: https://github.com/apache/age/issues/988#issuecomment-1591060739

   Yes, the behavior of Cypher is expected, as it does not check for the existence of a property on a node by default and instead returns null for missing properties. This allows for flexible querying of graph data, as it is designed to handle graph nodes with different sets of properties. The flexibility of the query language allows for efficient querying and avoids the need for preprocessing the data, which can negatively impact performance.
   
   For example, if you have a graph with 12 nodes and you execute a query that attempts to retrieve nodes based on a particular property, Cypher will retrieve all nodes and check if that property exists in any of them. If the property is found, it will return the value of that property for the node, otherwise, it will return null. This approach allows for more efficient querying of graph data, as it avoids the need for preprocessing the data to ensure that all nodes have the same properties.
   
   Overall, the behavior of Cypher is designed to be flexible and efficient, allowing for querying of graph data with nodes that have different sets of properties, while also avoiding the need for preprocessing the data, which can negatively impact performance.


-- 
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