Using Neo4j Enterprise 4.4.2, I get wrong results from a cypher query using a simple WHERE condition in a bigger query. The same condition works in a small cypher. Here is the small cypher that correctly outputs a message count of 4:
The bigger production cypher results in the same application and position on line 85 and follows the same condition as above, but results in a wrong message count of 0
I marked the "or false" part as when removing this, which logically should have no effect, the cypher outputs the correct message count of 4. (just to explain, this "or false" results from a more complex application logic)
For more details, here the relevant part of the profile of the first small working cypher:
And the NOT working bigger cypher inlcuding "or false"
And the working bigger cypher without "or false"
Do I miss something or is this a bug in the cypher processing?
Best,
Reiner