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

Wrong Results for Triangle Query #262

Open
ErvinXie opened this issue Jul 19, 2023 · 1 comment
Open

Wrong Results for Triangle Query #262

ErvinXie opened this issue Jul 19, 2023 · 1 comment
Labels
bug Something isn't working cypher the cypher query language

Comments

@ErvinXie
Copy link

Wrong Results for Triangle Query
TuGraph 3.5.0 provided wrong results on Finding Triangles in a graph when executing cypher on web interface.

To Reproduce
I used tugraph/tugraph-runtime-centos7 with tag "latest", image ID 1152289e2d3e.
And started this image by
sudo docker run -d -p 7070:7070 -p 9090:9090 --name -v /mypath:/home/root/ tugraph_demo tugraph/tugraph-runtime-centos7 lgraph_server -c /mypath/lgraph.json

My dataset is a randomly tag social network based on SNAP graph LastFM.
The graph files are
Person.csv
knows.csv
import.config.txt
Then i imported the graph by
lgraph_import --online false -c import.config.txt -d /mypath-to-data -g LastFM -u admin -p 73@TuGraph
Then I log in localhost:7070, and executed a cypher query:
match (p1:Person{community:0})-[:knows]-(p2:Person{community:1})-[:knows]-(p3:Person{community:2}), (p1)-[:knows]-(p3) RETURN DISTINCT p1.id,p2.id,p3.id ORDER BY p1.id,p2.id,p3.id;
Tugraph generated a results, and said there are 21759 triangles:
image

However, there are only 3433 triangles, which is verified by at least 2 other graph database.
For example, (13,1937,252) is a result tuple provided by tugraph. But there is no edge connecting Person 13 and Person 252.

@spasserby
Copy link
Collaborator

tugraph generated an incorrect execution plan, and I will make modifications soon.

@qishipengqsp qishipengqsp added bug Something isn't working cypher the cypher query language labels Jan 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working cypher the cypher query language
Projects
None yet
Development

No branches or pull requests

3 participants