Cucumber Reports (no 1.0.1) - Feature: OptionalMatch

Project	Number	Date
cypher-for-gremlin	1.0.1	31 May 2019, 13:18

	Steps	Scenarios	Features
OptionalMatch	15	0	0	0	0	15	3	0	3	0.000	Passed

Feature OptionalMatch

0.000

Scenario Satisfies the open world assumption, relationships between same nodes

Steps

Given an empty graph 0.000

Output 1

13:17:53.132 [Test worker] DEBUG o.a.t.g.driver.Client - g.V().drop()}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}

And having executed: 0.000

Doc string

CREATE (a:Player), (b:Team)
CREATE (a)-[:PLAYS_FOR]->(b),
       (a)-[:SUPPORTS]->(b)

Output 1

13:17:53.133 [Test worker] DEBUG o.a.t.g.driver.Client - CREATE (a:Player), (b:Team)
CREATE (a)-[:PLAYS_FOR]->(b),
       (a)-[:SUPPORTS]->(b)}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.133 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: CREATE (a:Player), (b:Team) CREATE (a)-[:PLAYS_FOR]->(b),        (a)-[:SUPPORTS]->(b)
13:17:53.136 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.addV('Player').as('a').addV('Team').as('b').addE('PLAYS_FOR').from('a').to('b').addE('SUPPORTS').from('a').to('b').barrier().limit(0)

When executing query: 0.000

Doc string

MATCH (p:Player)-[:PLAYS_FOR]->(team:Team)
OPTIONAL MATCH (p)-[s:SUPPORTS]->(team)
RETURN count(*) AS matches, s IS NULL AS optMatch

Output 1

13:17:53.159 [Test worker] DEBUG o.a.t.g.driver.Client - MATCH (p:Player)-[:PLAYS_FOR]->(team:Team)
OPTIONAL MATCH (p)-[s:SUPPORTS]->(team)
RETURN count(*) AS matches, s IS NULL AS optMatch}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.159 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: MATCH (p:Player)-[:PLAYS_FOR]->(team:Team) OPTIONAL MATCH (p)-[s:SUPPORTS]->(team) RETURN count(*) AS matches, s IS NULL AS optMatch
13:17:53.164 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.V().as('p').hasLabel('Player').outE('PLAYS_FOR').inV().as('team').hasLabel('Team').choose(__.select('p').outE('SUPPORTS').as('s').inV().as('  GENERATED6').where(__.select('  GENERATED6').where(eq('team'))), __.select('p').outE('SUPPORTS').as('s').inV().as('  GENERATED6').where(__.select('  GENERATED6').where(eq('team'))), __.constant('  cypher.null').as('s')).select('s').group().by(__.choose(__.is(eq('  cypher.null')), __.constant(true), __.constant(false))).by(__.fold().project('matches', 'optMatch').by(__.unfold().count()).by(__.unfold().choose(__.is(eq('  cypher.null')), __.constant(true), __.constant(false)))).unfold().select(values)

Then the result should be: 0.000

matches	optMatch
1	false

And no side effects 0.000

Output 1

13:17:53.166 [Test worker] DEBUG o.a.t.g.driver.Client - MATCH (n) RETURN id(n)}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.166 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: MATCH (n) RETURN id(n)
13:17:53.168 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.V().project('id(n)').by(__.id())
13:17:53.168 [Test worker] DEBUG o.a.t.g.driver.Client - MATCH ()-[r]->() RETURN id(r)}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.169 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: MATCH ()-[r]->() RETURN id(r)
13:17:53.171 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.E().project('id(r)').by(__.id())
13:17:53.171 [Test worker] DEBUG o.a.t.g.driver.Client - MATCH (n)
UNWIND labels(n) AS label
RETURN DISTINCT label}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.171 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: MATCH (n) UNWIND labels(n) AS label RETURN DISTINCT label
13:17:53.175 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.V().map(__.label().is(neq('vertex')).fold()).unfold().project('label').by(__.identity()).dedup()
13:17:53.176 [Test worker] DEBUG o.a.t.g.driver.Client - g.V().as('V').properties().project('nodeId', 'key', 'value').by(__.select('V').id()).by(__.key()).by(__.value())}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.182 [Test worker] DEBUG o.a.t.g.driver.Client - g.V().outE().as('E').properties().project('relId', 'key', 'value').by(__.select('E').id()).by(__.key()).by(__.value())}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
-labels:        0
+labels:        0
+nodes:         0
-nodes:         0
-properties:    0
+properties:    0
-relationships: 0
+relationships: 0

0.000

Scenario Satisfies the open world assumption, single relationship

Steps

Given an empty graph 0.000

Output 1

13:17:53.188 [Test worker] DEBUG o.a.t.g.driver.Client - g.V().drop()}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}

And having executed: 0.000

Doc string

CREATE (a:Player), (b:Team)
CREATE (a)-[:PLAYS_FOR]->(b)

Output 1

13:17:53.189 [Test worker] DEBUG o.a.t.g.driver.Client - CREATE (a:Player), (b:Team)
CREATE (a)-[:PLAYS_FOR]->(b)}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.189 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: CREATE (a:Player), (b:Team) CREATE (a)-[:PLAYS_FOR]->(b)
13:17:53.191 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.addV('Player').as('a').addV('Team').as('b').addE('PLAYS_FOR').from('a').to('b').barrier().limit(0)

When executing query: 0.000

Doc string

MATCH (p:Player)-[:PLAYS_FOR]->(team:Team)
OPTIONAL MATCH (p)-[s:SUPPORTS]->(team)
RETURN count(*) AS matches, s IS NULL AS optMatch

Output 1

13:17:53.213 [Test worker] DEBUG o.a.t.g.driver.Client - MATCH (p:Player)-[:PLAYS_FOR]->(team:Team)
OPTIONAL MATCH (p)-[s:SUPPORTS]->(team)
RETURN count(*) AS matches, s IS NULL AS optMatch}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.213 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: MATCH (p:Player)-[:PLAYS_FOR]->(team:Team) OPTIONAL MATCH (p)-[s:SUPPORTS]->(team) RETURN count(*) AS matches, s IS NULL AS optMatch
13:17:53.217 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.V().as('p').hasLabel('Player').outE('PLAYS_FOR').inV().as('team').hasLabel('Team').choose(__.select('p').outE('SUPPORTS').as('s').inV().as('  GENERATED6').where(__.select('  GENERATED6').where(eq('team'))), __.select('p').outE('SUPPORTS').as('s').inV().as('  GENERATED6').where(__.select('  GENERATED6').where(eq('team'))), __.constant('  cypher.null').as('s')).select('s').group().by(__.choose(__.is(eq('  cypher.null')), __.constant(true), __.constant(false))).by(__.fold().project('matches', 'optMatch').by(__.unfold().count()).by(__.unfold().choose(__.is(eq('  cypher.null')), __.constant(true), __.constant(false)))).unfold().select(values)

Then the result should be: 0.000

matches	optMatch
1	true

And no side effects 0.000

Output 1

13:17:53.218 [Test worker] DEBUG o.a.t.g.driver.Client - MATCH (n) RETURN id(n)}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.219 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: MATCH (n) RETURN id(n)
13:17:53.220 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.V().project('id(n)').by(__.id())
13:17:53.221 [Test worker] DEBUG o.a.t.g.driver.Client - MATCH ()-[r]->() RETURN id(r)}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.222 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: MATCH ()-[r]->() RETURN id(r)
13:17:53.224 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.E().project('id(r)').by(__.id())
13:17:53.225 [Test worker] DEBUG o.a.t.g.driver.Client - MATCH (n)
UNWIND labels(n) AS label
RETURN DISTINCT label}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.225 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: MATCH (n) UNWIND labels(n) AS label RETURN DISTINCT label
13:17:53.228 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.V().map(__.label().is(neq('vertex')).fold()).unfold().project('label').by(__.identity()).dedup()
13:17:53.228 [Test worker] DEBUG o.a.t.g.driver.Client - g.V().as('V').properties().project('nodeId', 'key', 'value').by(__.select('V').id()).by(__.key()).by(__.value())}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.233 [Test worker] DEBUG o.a.t.g.driver.Client - g.V().outE().as('E').properties().project('relId', 'key', 'value').by(__.select('E').id()).by(__.key()).by(__.value())}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
-labels:        0
+labels:        0
+nodes:         0
-nodes:         0
-properties:    0
+properties:    0
-relationships: 0
+relationships: 0

0.000

Scenario Satisfies the open world assumption, relationships between different nodes

Steps

Given an empty graph 0.000

Output 1

13:17:53.238 [Test worker] DEBUG o.a.t.g.driver.Client - g.V().drop()}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}

And having executed: 0.000

Doc string

CREATE (a:Player), (b:Team), (c:Team)
CREATE (a)-[:PLAYS_FOR]->(b),
       (a)-[:SUPPORTS]->(c)

Output 1

13:17:53.238 [Test worker] DEBUG o.a.t.g.driver.Client - CREATE (a:Player), (b:Team), (c:Team)
CREATE (a)-[:PLAYS_FOR]->(b),
       (a)-[:SUPPORTS]->(c)}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.239 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: CREATE (a:Player), (b:Team), (c:Team) CREATE (a)-[:PLAYS_FOR]->(b),        (a)-[:SUPPORTS]->(c)
13:17:53.244 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.addV('Player').as('a').addV('Team').as('b').addV('Team').as('c').addE('PLAYS_FOR').from('a').to('b').addE('SUPPORTS').from('a').to('c').barrier().limit(0)

When executing query: 0.000

Doc string

MATCH (p:Player)-[:PLAYS_FOR]->(team:Team)
OPTIONAL MATCH (p)-[s:SUPPORTS]->(team)
RETURN count(*) AS matches, s IS NULL AS optMatch

Output 1

13:17:53.272 [Test worker] DEBUG o.a.t.g.driver.Client - MATCH (p:Player)-[:PLAYS_FOR]->(team:Team)
OPTIONAL MATCH (p)-[s:SUPPORTS]->(team)
RETURN count(*) AS matches, s IS NULL AS optMatch}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.272 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: MATCH (p:Player)-[:PLAYS_FOR]->(team:Team) OPTIONAL MATCH (p)-[s:SUPPORTS]->(team) RETURN count(*) AS matches, s IS NULL AS optMatch
13:17:53.277 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.V().as('p').hasLabel('Player').outE('PLAYS_FOR').inV().as('team').hasLabel('Team').choose(__.select('p').outE('SUPPORTS').as('s').inV().as('  GENERATED6').where(__.select('  GENERATED6').where(eq('team'))), __.select('p').outE('SUPPORTS').as('s').inV().as('  GENERATED6').where(__.select('  GENERATED6').where(eq('team'))), __.constant('  cypher.null').as('s')).select('s').group().by(__.choose(__.is(eq('  cypher.null')), __.constant(true), __.constant(false))).by(__.fold().project('matches', 'optMatch').by(__.unfold().count()).by(__.unfold().choose(__.is(eq('  cypher.null')), __.constant(true), __.constant(false)))).unfold().select(values)

Then the result should be: 0.000

matches	optMatch
1	true

And no side effects 0.000

Output 1

13:17:53.278 [Test worker] DEBUG o.a.t.g.driver.Client - MATCH (n) RETURN id(n)}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.279 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: MATCH (n) RETURN id(n)
13:17:53.281 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.V().project('id(n)').by(__.id())
13:17:53.281 [Test worker] DEBUG o.a.t.g.driver.Client - MATCH ()-[r]->() RETURN id(r)}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.281 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: MATCH ()-[r]->() RETURN id(r)
13:17:53.283 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.E().project('id(r)').by(__.id())
13:17:53.284 [Test worker] DEBUG o.a.t.g.driver.Client - MATCH (n)
UNWIND labels(n) AS label
RETURN DISTINCT label}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.284 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Cypher: MATCH (n) UNWIND labels(n) AS label RETURN DISTINCT label
13:17:53.286 [gremlin-server-worker-1] INFO  o.o.g.s.o.c.CypherOpProcessor - Gremlin: g.V().map(__.label().is(neq('vertex')).fold()).unfold().project('label').by(__.identity()).dedup()
13:17:53.286 [Test worker] DEBUG o.a.t.g.driver.Client - g.V().as('V').properties().project('nodeId', 'key', 'value').by(__.select('V').id()).by(__.key()).by(__.value())}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
13:17:53.290 [Test worker] DEBUG o.a.t.g.driver.Client - g.V().outE().as('E').properties().project('relId', 'key', 'value').by(__.select('E').id()).by(__.key()).by(__.value())}} to - Connection{host=Host{address=localhost/127.0.0.1:36715, hostUri=ws://localhost:36715/gremlin}}
-labels:        0
+labels:        0
+nodes:         0
-nodes:         0
-properties:    0
+properties:    0
-relationships: 0
+relationships: 0

	Steps						Scenarios			Features
Feature	Passed	Failed	Skipped	Pending	Undefined	Total	Passed	Failed	Total	Duration	Status
OptionalMatch	15	0	0	0	0	15	3	0	3	0.000	Passed

Feature Report