github.com/vescale/zgraph@v0.0.0-20230410094002-959c02d50f95/tests/testdata/logic_test/simple (about) 1 statement ok 2 CREATE GRAPH student_network 3 4 statement ok 5 USE student_network 6 7 statement ok 8 CREATE LABEL Person 9 10 statement ok 11 CREATE LABEL University 12 13 statement ok 14 CREATE LABEL knows 15 16 statement ok 17 CREATE LABEL studentOf 18 19 statement ok 20 INSERT VERTEX x LABELS (Person) PROPERTIES (x.name = 'Kathrine', x.dob = DATE '1994-01-15') 21 22 statement ok 23 INSERT VERTEX x LABELS (Person) PROPERTIES (x.name = 'Riya', x.dob = DATE '1995-03-20') 24 25 statement ok 26 INSERT VERTEX x LABELS (Person) PROPERTIES (x.name = 'Lee', x.dob = DATE '1996-01-20') 27 28 statement ok 29 INSERT VERTEX x LABELS (University) PROPERTIES (x.name = 'UC Berkeley') 30 31 statement ok 32 INSERT EDGE e BETWEEN x AND y LABELS ( knows ) FROM MATCH (x), MATCH (y) WHERE x.name = 'Kathrine' AND y.name = 'Lee' 33 34 statement ok 35 INSERT EDGE e BETWEEN x AND y LABELS ( knows ) FROM MATCH (x), MATCH (y) WHERE x.name = 'Kathrine' AND y.name = 'Riya' 36 37 statement ok 38 INSERT EDGE e BETWEEN x AND y LABELS ( knows ) FROM MATCH (x), MATCH (y) WHERE x.name = 'Lee' AND y.name = 'Kathrine' 39 40 statement ok 41 INSERT EDGE e BETWEEN x AND y LABELS ( studentOf ) FROM MATCH (x), MATCH (y) WHERE x.name = 'Kathrine' AND y.name = 'UC Berkeley' 42 43 statement ok 44 INSERT EDGE e BETWEEN x AND y LABELS ( studentOf ) FROM MATCH (x), MATCH (y) WHERE x.name = 'Riya' AND y.name = 'UC Berkeley' 45 46 statement ok 47 INSERT EDGE e BETWEEN x AND y LABELS ( studentOf ) FROM MATCH (x), MATCH (y) WHERE x.name = 'Lee' AND y.name = 'UC Berkeley' 48 49 query TT rowsort 50 SELECT a.name AS a, b.name AS b FROM MATCH (a:Person) -[e:knows]-> (b:Person) 51 ---- 52 Kathrine Lee 53 Kathrine Riya 54 Lee Kathrine 55 56 query TT rowsort label1 57 SELECT p2.name AS friend, u.name AS university 58 FROM MATCH (u:University) <-[anon1:studentOf]- (p1:Person) -[anon2:knows]-> (p2:Person) -[anon3:studentOf]-> (u) 59 WHERE p1.name = 'Lee' 60 ---- 61 Kathrine UC Berkeley 62 63 query TTT rowsort 64 SELECT p1.name AS p1, p2.name AS p2, p3.name AS p3 65 FROM MATCH (p1:Person) -[anon1:knows]-> (p2:Person) -[anon2:knows]-> (p3:Person) 66 WHERE p1.name = 'Lee'; 67 ---- 68 Lee Kathrine Lee 69 Lee Kathrine Riya 70 71 query TT rowsort label1 72 SELECT p2.name AS friend, u.name AS university 73 FROM MATCH (u:University) <-[anon1:studentOf]- (p1:Person) -[anon2:knows]-> (p2:Person) -[anon3:studentOf]-> (u) 74 WHERE p1.name = 'Lee'