bitnine-oss / agensgraph

AgensGraph, a transactional graph database based on PostgreSQL
http://www.agensgraph.org
Other
1.34k stars 149 forks source link

ERROR: properties in vertex cannot be NULL #481

Open dodiego opened 5 years ago

dodiego commented 5 years ago

Hi there,

So, i have the following structure:

image

If I run the following query:

MATCH (v1) WITH v1
MATCH (v1)-[r2:rel2]->(v2) WITH v1, v2, r2 
MATCH (v2)-[r3:sub_rel]->(v3) WITH v2, v3, r3, v1, r2
RETURN *;

I get the following error: ERROR: properties in vertex cannot be NULL Also, the following query gives me the same error:

MATCH (v1)-[r2:rel2]->(v2) WITH v1, v2, r2 
MATCH (v2)-[r3:sub_rel]->(v3) WITH v2, v3, r3, v1, r2
RETURN *;

But if i remove the last WITH, it works just fine:

MATCH (v1)-[r2:rel2]->(v2) WITH v1, v2, r2 
MATCH (v2)-[r3:sub_rel]->(v3) RETURN *;

Why does this happen?

If it is of any help, you can check the framework that i'm working on and run the relationship of relationship of relationship test

dodiego commented 5 years ago

I managed to solve my test by using a slightly different query:

MATCH (v1) WITH v1
MATCH (v1)-[r0:rel2]->(v2) WITH v1, r0, v2
MATCH (v2)-[r1:sub_rel]->(v3) WITH v1, r0, v2, r1, v3
RETURN *

But I still don't know why the first version doesn't work.