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

Experssion any/single/none/all in list has bugs #5114

Closed
jievince opened this issue Dec 26, 2022 · 0 comments · Fixed by #5061
Closed

Experssion any/single/none/all in list has bugs #5114

jievince opened this issue Dec 26, 2022 · 0 comments · Fixed by #5061
Assignees
Labels
affects/none PR/issue: this bug affects none version. process/done Process of bug severity/major Severity of bug type/bug Type: something is unexpected
Milestone

Comments

@jievince
Copy link
Contributor

jievince commented Dec 26, 2022

Please check the FAQ documentation before raising an issue

Describe the bug (required)
query1:

RETURN Any(a IN [2, 3, NULL] WHERE a > 3) AS r

It returns false but should return null

query2:

RETURN Single(a IN [2, 3, NULL] WHERE a == 3) AS r

It returns true but should return null

query3:

RETURN None(a IN [2, 3, NULL] WHERE a > 3) AS r

It returns true but should return null

query4:

RETURN All(a IN [2, 3, NULL] WHERE a > 0) AS r

It returns false but should return null

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

@jievince jievince added the type/bug Type: something is unexpected label Dec 26, 2022
@jievince jievince self-assigned this Dec 26, 2022
@jievince jievince added this to the v3.4.0 milestone Dec 26, 2022
@github-actions github-actions bot added affects/none PR/issue: this bug affects none version. severity/none Severity of bug labels Dec 26, 2022
@jievince jievince changed the title Experssion any in list has a bug Experssion any/single in list has bugs Dec 26, 2022
@jievince jievince changed the title Experssion any/single in list has bugs Experssion any/single/none in list has bugs Dec 26, 2022
@jievince jievince changed the title Experssion any/single/none in list has bugs Experssion any/single/none/all in list has bugs Dec 26, 2022
@Sophie-Xie Sophie-Xie added severity/major Severity of bug and removed severity/none Severity of bug labels Dec 27, 2022
@github-actions github-actions bot added the process/fixed Process of bug label Dec 28, 2022
@Hester-Gu Hester-Gu added the process/done Process of bug label Jan 13, 2023
@github-actions github-actions bot removed the process/fixed Process of bug label Jan 13, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects/none PR/issue: this bug affects none version. process/done Process of bug severity/major Severity of bug type/bug Type: something is unexpected
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants