AbdulSamad4068 commented on issue #876: URL: https://github.com/apache/age/issues/876#issuecomment-1534278721
The error message "column reference '_age_default_alias_0' is ambiguous" indicates that the column reference used in the query is not unique and could refer to more than one column. In this particular case, it seems that the issue may be related to the use of the alias "n0" and "n1" for nodes in the MATCH clause. The alias could be conflicting with a default alias generated by the system, causing the ambiguity error. To solve this issue, you could try using a different alias for the nodes in the MATCH clause, or using a different alias for the "0" value in the RETURN clause. For example, you could rewrite the query as follows: `MATCH (n:Node)-[]->() MATCH (n1:Node)-[]->() RETURN 0 AS result ` Where "Node" is the label of the nodes you want to match. By using different aliases and specifying the label of the nodes, you can avoid conflicts with the default aliases generated by the system and resolve the ambiguity error. If this does not solve the issue, you could try checking the database schema and ensuring that there are no naming conflicts or other issues that could cause ambiguity errors. -- 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]
