vesoft-inc / nebula

A distributed, fast open-source graph database featuring horizontal scalability and high availability
https://nebula-graph.io
Apache License 2.0
10.68k stars 1.2k forks source link

Logic inconsistency: unequal numbers of returned rows #5624

Open polyominal opened 1 year ago

polyominal commented 1 year ago

(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

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.

kikimo commented 11 months ago

thanks for reporting,we can reproduce