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

Storage crash in query #4262

Closed
Shylock-Hg opened this issue May 17, 2022 · 2 comments · Fixed by #4268
Closed

Storage crash in query #4262

Shylock-Hg opened this issue May 17, 2022 · 2 comments · Fixed by #4268
Assignees
Labels
type/bug Type: something is unexpected
Milestone

Comments

@Shylock-Hg
Copy link
Contributor

Please check the FAQ documentation before raising an issue

Describe the bug (required)
Storage crash in query:

MATCH (n:Person)-[:KNOWS]-(friend:Person)<-[:POST_HAS_CREATOR|COMMENT_HAS_CREATOR]-(message)
  WHERE id(n) == 'p-19791209300143' and (message.`Comment`.creationDate <= datetime('2012-11-28T00:00:00.000') or message.`Post`.creationDate <= datetime('2012-11-28T00:00:00.000'))
  RETURN
    id(friend) AS personId,
    friend.Person.firstName AS personFirstName,
    friend.Person.lastName AS personLastName,
    id(message) AS messageId,
    CASE exists(message.`Comment`.content)
      WHEN true THEN coalesce(message.`Comment`.imageFile,message.`Comment`.content)
      ELSE coalesce(message.Post.imageFile,message.Post.content)
    END AS messageContent,
    CASE exists(message.`Comment`.content)
      WHEN true THEN message.`Comment`.creationDate
      ELSE message.Post.creationDate
    END AS messageCreationDate
    ORDER BY messageCreationDate DESC, messageId ASC
    LIMIT 20

Your Environments (required)

  • OS: uname -a
  • Compiler: g++ --version or clang++ --version
  • CPU: lscpu
  • Commit id (e.g. a3ffc7d8)

How To Reproduce(required)

Steps to reproduce the behavior:

  1. Step 1
  2. Step 2
  3. Step 3

Expected behavior

Additional context

@Shylock-Hg Shylock-Hg added the type/bug Type: something is unexpected label May 17, 2022
@Sophie-Xie Sophie-Xie added this to the v3.2.0 milestone May 17, 2022
@Sophie-Xie
Copy link
Contributor

@Shylock-Hg pls add more info, such as core......

@Shylock-Hg
Copy link
Contributor Author

@critical27 Same with #4184 , but in GetProps

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Type: something is unexpected
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants