Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bugs with the unwind, collect keyword #645

Open
w158937299 opened this issue Jan 19, 2024 · 0 comments
Open

Bugs with the unwind, collect keyword #645

w158937299 opened this issue Jan 19, 2024 · 0 comments

Comments

@w158937299
Copy link

Agensgraph version: 2.13.0
Operating system: (Windows 11)
API/Driver: (psycopg2 2.9.7)
Steps to reproduce
3
4

As shown in the first picture, query 1 unfolds the "p6" property values of nodes with outgoing relationships into separate rows. It can be observed that neo4j returns the correct results, while Agensgraph returns an empty set. Query 2 returns the "p6" property values of nodes with outgoing relationships, checking if the data retrieval is functioning properly. The results from neo4j and Agensgraph are consistent. Query 3 replaces the "unwind" keyword with "with" to check if other operators are causing the issue, and the results from neo4j and Agensgraph are also consistent. Therefore, we suspect that there may be a bug in Agensgraph when using the "unwind" keyword to unfold property values.
As shown in the second picture, query 1 first retrieves nodes with the label "nt3" and the property "p5" value 'Ce', then obtains nodes reached along the "et3" relationship from these nodes, and finally aggregates them into a list. Neo4j returns the correct results, while Agensgraph fails to retrieve the node's key-value pairs. Query 2, after removing the "collect" keyword, yields consistent results in both neo4j and Agensgraph. This bug is similar to the one in listing 8, so we suspect that Agensgraph may have a bug when using the "collect" keyword to gather nodes into a list.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant