You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE VERTEX TYPE Person IF NOT EXISTS;
CREATE PROPERTY Person.role IF NOT EXISTS STRING;
CREATE VERTEX TYPE House IF NOT EXISTS;
CREATE EDGE TYPE LivesIn IF NOT EXISTS;
DELETE FROM LivesIn;
DELETE FROM Person;
DELETE FROM House;
CREATE VERTEX House;
CREATE VERTEX Person SET role='mom';
CREATE VERTEX Person SET role='dad';
CREATE VERTEX Person SET role='child';
CREATE EDGE LivesIn FROM (SELECT FROM Person) TO (SELECT FROM House);
MATCH {TYPE: Person, AS: personVertex} -LivesIn-> {TYPE: House}
, NOT {AS: personVertex} -DummyEdge-> {TYPE: House}
RETURN personVertex;
The text was updated successfully, but these errors were encountered:
ArcadeDB Version:
24.6.1
OS and JDK Version:
Official Docker image
Expected behavior
Should return all three different Person vertices, as the NOT part does not match:
personVertex
{"@Rid":"#59:5","@type":"Person","@cat":"v","role":"child","@out":1,"@in":0}
{"@Rid":"#56:4","@type":"Person","@cat":"v","role":"dad","@out":1,"@in":0}
{"@Rid":"#53:3","@type":"Person","@cat":"v","role":"mom","@out":1,"@in":0}
Actual behavior
Returns only one (seemingly random) of the Person vertices but repeats the same three (equal to the total number of Person vertices) times:
personVertex
{"@Rid":"#65:4","@type":"Person","@cat":"v","role":"child","@out":1,"@in":0}
{"@Rid":"#65:4","@type":"Person","@cat":"v","role":"child","@out":1,"@in":0}
{"@Rid":"#65:4","@type":"Person","@cat":"v","role":"child","@out":1,"@in":0}
Steps to reproduce
CREATE VERTEX TYPE Person IF NOT EXISTS;
CREATE PROPERTY Person.role IF NOT EXISTS STRING;
CREATE VERTEX TYPE House IF NOT EXISTS;
CREATE EDGE TYPE LivesIn IF NOT EXISTS;
DELETE FROM
LivesIn
;DELETE FROM
Person
;DELETE FROM
House
;CREATE VERTEX House;
CREATE VERTEX Person SET role='mom';
CREATE VERTEX Person SET role='dad';
CREATE VERTEX Person SET role='child';
CREATE EDGE LivesIn FROM (SELECT FROM Person) TO (SELECT FROM House);
MATCH {TYPE: Person, AS: personVertex} -LivesIn-> {TYPE: House}
, NOT {AS: personVertex} -DummyEdge-> {TYPE: House}
RETURN personVertex;
The text was updated successfully, but these errors were encountered: