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 found in lsqb #1206

Closed
acquamarin opened this issue Jan 26, 2023 · 2 comments
Closed

Bugs found in lsqb #1206

acquamarin opened this issue Jan 26, 2023 · 2 comments
Assignees
Labels
bug Something isn't working

Comments

@acquamarin
Copy link
Collaborator

These queries are failing while running lsqb queries on ldbc dataset:
Q1:

MATCH (:Country)<-[:IS_PART_OF]-(:City)<-[:IS_LOCATED_IN]-(:Person)<-[:HAS_MEMBER]-(:Forum)-[:CONTAINER_OF]->(:Post)<-[:REPLY_OF]-(:Comment)-[:HAS_TAG]->(:Tag)-[:HAS_TYPE]->(:TagClass)
RETURN count(*) AS count

Bug: runs into an infinite loop

Q8:

MATCH (tag1:Tag)<-[:HAS_TAG]-(message:Message)<-[:REPLY_OF]-(comment:Comment)-[:HAS_TAG]->(tag2:Tag)
WHERE NOT (comment)-[:HAS_TAG]->(tag1)
  AND tag1 <> tag2
RETURN count(*) AS count

Bug: crashes with a C++ error ("RuntimeError: _Map_base::at)"
Q9:


MATCH (person1:Person)-[:KNOWS]-(person2:Person)-[:KNOWS]-(person3:Person)-[:HAS_INTEREST]->(tag:Tag)
WHERE NOT (person1)-[:KNOWS]-(person3)
  AND person1 <> person3
RETURN count(*) AS count

Bug: crashes with a segfault

Our loader also fails on a large dataset (> sf1)

@ray6080 ray6080 added the bug Something isn't working label Jan 26, 2023
@ray6080 ray6080 mentioned this issue Feb 2, 2023
25 tasks
@aziz-mu
Copy link
Contributor

aziz-mu commented May 23, 2023

Update:
Q1 - is working as intended now.
Q8 - Still gives an Error: _Map_base::at
Q9 - Now gives an Error: Cannot infer the size of a variable dataType instead of a segfault

@aziz-mu
Copy link
Contributor

aziz-mu commented May 24, 2023

Closing this issue - Q8 and Q9, as written, give Parser Exceptions (expected), and they can be translated to working queries using WHERE NOT EXISTS {} syntax, as in #1566

@aziz-mu aziz-mu closed this as completed May 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants