Skip to content

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

Closed
@jievince

Description

@jievince

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

Metadata

Metadata

Assignees

Labels

affects/nonePR/issue: this bug affects none version.process/doneProcess of bugseverity/majorSeverity of bugtype/bugType: something is unexpected

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions