Strange error using WITH DISTINCT in Version 3.5.0


(Clooney24) #1

We are facing a strange behaviour in our 3.5.0 test database. The following cypher returns as expected one existing Uuid:

MATCH (industry:IndustryCM)
WHERE industry.Uuid = "72eb68e8-2418-4039-896e-799f497bb7ab" 
WITH industry
RETURN industry.Uuid

Almost the same cypher just including DISTINCT in the WITH clause:

MATCH (industry:IndustryCM)
WHERE industry.Uuid = "72eb68e8-2418-4039-896e-799f497bb7ab" 
WITH DISTINCT industry
RETURN industry.Uuid

returns the following error:
#### Neo.DatabaseError.General.UnknownError Neo.DatabaseError.General.UnknownError: key not found: CachedNodeProperty(industry,PropertyKeyName(Uuid))

This happens on our test db (3.5.0) running a backup from the live db (3.4.7) - so same data.

Executing the same cypher on our live db (3.4.7) on the same data works fine.

Just tested using DISTINCT in combination with RETURN instead of WITH - this works fine on 3.5.0:

MATCH (industry:IndustryCM)
WHERE industry.Uuid = "72eb68e8-2418-4039-896e-799f497bb7ab" 
RETURN DISTINCT industry.Uuid

We need the WITH DISTINCT statement as the cypher in our scenario is a few lines longer.

I appreciate your help.


(Andrew Bowman) #2

Sounds like a bug. Can you copy this over as a github issue for us to investigate?


(David Fauth) #3

This bug has been reported internally and hopefully we will get it fixed in a patch release.

Dave


(Clooney24) #4

Thanks for your replies.
I just created Issue #12105 for this.