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

Logic inconsistency: unequal numbers of returned rows #5624

Open
polyominal opened this issue Jul 8, 2023 · 1 comment
Open

Logic inconsistency: unequal numbers of returned rows #5624

polyominal opened this issue Jul 8, 2023 · 1 comment
Labels
affects/none PR/issue: this bug affects none version. severity/none Severity of bug type/bug Type: something is unexpected

Comments

@polyominal
Copy link

polyominal commented Jul 8, 2023

(This one behaves somewhat differently from #5616, as both results are non-empty; hope it helps with bug detection.)

Bug Description

The following two logically equivalent (as one could verify) queries are returning inconsistent results of different number of rows.

Query 1:

MATCH (n1)-[]-(n2:L5:L2)<-[:T1]-(n3:L1), (n4:L4)-[]-(n2:L1:L5) RETURN *

Query 2:

MATCH (n4:L4), (n1), (n2:L5:L2:L1)-[]-(n1), (n4:L4)-[]-(n2:L5:L1), (n3:L1), (n2:L5:L1)<-[:T1]-(n3:L1) RETURN *

Environments

  • OS: Linux nn 5.19.0-41-generic #42~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue Apr 18 17:40:00 UTC 2 x86_64 x86_64 x86_64 GNU/Linux
  • CPU: 13th Gen Intel(R) Core(TM) i5-13400
  • Nebula Graph Version: v3.5.0

How To Reproduce

Steps to reproduce the behavior:

  1. Execute the statements in create.log to set up a fresh database.
  2. Run both of the aforementioned queries and check the results.

Expected behavior
The first query gives a result of 5118 rows; the second one yields 5225 rows.

@polyominal polyominal added the type/bug Type: something is unexpected label Jul 8, 2023
@github-actions github-actions bot added affects/none PR/issue: this bug affects none version. severity/none Severity of bug labels Jul 8, 2023
@polyominal polyominal changed the title Logic inconsistency: unequal numbers of returned rows from two equivalent queries Logic inconsistency: unequal numbers of returned rows Jul 8, 2023
@kikimo
Copy link
Contributor

kikimo commented Oct 10, 2023

thanks for reporting,we can reproduce

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. severity/none Severity of bug type/bug Type: something is unexpected
Projects
None yet
Development

No branches or pull requests

2 participants