Skip to content

AQL Bug: (Related to issue 218) AQL PATHS query fails when Edge has only one node #219

@frankmayer

Description

@frankmayer

This is related to issue #218

The AQL query fails when doing a PATHS and an edge has a missing node.

Error is: JavaScript exception in file 'client/client.js' at 214,7: [ArangoError 1202: document not found]

This console script demonstrates it:


db._create ('users');
db._create ('pets');
edges._create('relations');
user = db.users.save({"name": "Frank"});
pet = db.pets.save({"type": "cat",    "name": "Faustino"});
edge = edges.relations.save(user._id, pet._id,{label:"has", since:"2010"});
pet = db.pets.save({"type": "cat",    "name": "Ramses"});
edge = edges.relations.save(user._id, pet._id,{label:"has", since:"2004"});


edges.relations.outEdges(user._id);

 st = db._createStatement({ "query" : 'FOR p IN PATHS(users, relations, "outbound") FILTER p.source._id == "'+user._id+'" && LENGTH(p.edges) == 1 RETURN { relation: p.vertices}' });
queryres = st.execute();
print (queryres.elements());


db.pets.remove(pet._id);

edges.relations.outEdges(user._id);

queryres = st.execute();
print (queryres.elements());

edges.relations.remove(edge._id);

edges.relations.outEdges(user._id);

queryres = st.execute();
print (queryres.elements());


Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions