org.scalatest.exceptions.TestFailedException: plan for <default version> <default planner> runtime=slottedPlan should use NodeHashJoin 3 times:Compiler CYPHER 3.4
Planner COST
Runtime SLOTTED
Runtime version 3.4
+--------------------+----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| Operator | Estimated Rows | Variables | Other |+--------------------+----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| +ProduceResults | 1 | c | || | +----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| +EagerAggregation | 1 | c | || | +----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| +Filter | 2 | anon[15], anon[30], anon[50], anon[60], c, a, b, d, e | not PrimitiveEquals(IdFromSlot(5),IdFromSlot(7)); e:Node; not PrimitiveEquals(IdFromSlot(1),IdFromSlot(7)); not PrimitiveEquals(IdFromSlot(4),IdFromSlot(7)) || | +----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| +Expand(All) | 2 | anon[60], e -- anon[15], anon[30], anon[50], c, a, b, d | (b)-->(e) || | +----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| +Filter | 3 | anon[15], anon[30], anon[50], c, a, b, d | a:Node; not PrimitiveEquals(IdFromSlot(5),IdFromSlot(4)); not PrimitiveEquals(IdFromSlot(5),IdFromSlot(1)) || | +----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| +Expand(All) | 3 | anon[15], a -- anon[30], anon[50], c, b, d | (b)<--(a) || | +----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| +Filter | 3 | anon[30], anon[50], c, b, d | not PrimitiveEquals(IdFromSlot(1),IdFromSlot(4)) || | +----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| +NodeHashJoin | 3 | anon[30], c -- anon[50], b, d | b || |\ +----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| | +Expand(All) | 4 | anon[50], b -- d | (d)-->(b) || | | +----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| | +NodeByLabelScan | 5 | d | :Node || | +----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| +Filter | 4 | anon[30], c, b | b:Node || | +----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| +Expand(All) | 4 | anon[30], b -- c | ( c@33)<--(b) || | +----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+| +NodeByLabelScan | 5 | c | :Node |+--------------------+----------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
Total database accesses: ? at org.scalatest.MatchersHelper$.newTestFailedException(MatchersHelper.scala:160) at org.scalatest.Matchers$ShouldMethodHelper$.shouldMatcher(Matchers.scala:6231) at org.scalatest.Matchers$AnyShouldWrapper.should(Matchers.scala:6265) at org.neo4j.internal.cypher.acceptance.UsingAcceptanceTest$$anonfun$51$$anonfun$70.apply(UsingAcceptanceTest.scala:820) at org.neo4j.internal.cypher.acceptance.UsingAcceptanceTest$$anonfun$51$$anonfun$70.apply(UsingAcceptanceTest.scala:819) at org.neo4j.internal.cypher.acceptance.CypherComparisonSupport$ComparePlansWithAssertion$$anonfun$compare$1.apply$mcV$sp(CypherComparisonSupport.scala:483) at org.neo4j.internal.cypher.acceptance.CypherComparisonSupport$ComparePlansWithAssertion$$anonfun$compare$1.apply(CypherComparisonSupport.scala:483) at org.neo4j.internal.cypher.acceptance.CypherComparisonSupport$ComparePlansWithAssertion$$anonfun$compare$1.apply(CypherComparisonSupport.scala:483) at org.scalatest.Assertions$class.withClue(Assertions.scala:1471) at org.neo4j.internal.cypher.acceptance.CypherComparisonSupport$ComparePlansWithAssertion.withClue(CypherComparisonSupport.scala:477) at org.neo4j.internal.cypher.acceptance.CypherComparisonSupport$ComparePlansWithAssertion.compare(CypherComparisonSupport.scala:482) at org.neo4j.internal.cypher.acceptance.CypherComparisonSupport$$anonfun$executeWith$1.apply(CypherComparisonSupport.scala:172) at org.neo4j.internal.cypher.acceptance.CypherComparisonSupport$$anonfun$executeWith$1.apply(CypherComparisonSupport.scala:170) at scala.collection.immutable.HashSet$HashSet1.foreach(HashSet.scala:316) at scala.collection.immutable.HashSet$HashTrieSet.foreach(HashSet.scala:972) at scala.collection.immutable.HashSet$HashTrieSet.foreach(HashSet.scala:972) at org.neo4j.internal.cypher.acceptance.CypherComparisonSupport$class.executeWith(CypherComparisonSupport.scala:170) at org.neo4j.internal.cypher.acceptance.UsingAcceptanceTest.executeWith(UsingAcceptanceTest.scala:30) at org.neo4j.internal.cypher.acceptance.UsingAcceptanceTest$$anonfun$51.apply$mcV$sp(UsingAcceptanceTest.scala:819) at org.neo4j.internal.cypher.acceptance.UsingAcceptanceTest$$anonfun$51.apply(UsingAcceptanceTest.scala:810) at org.neo4j.internal.cypher.acceptance.UsingAcceptanceTest$$anonfun$51.apply(UsingAcceptanceTest.scala:810) at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22) at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85) at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104) at org.scalatest.Transformer.apply(Transformer.scala:22) at org.scalatest.Transformer.apply(Transformer.scala:20) at org.scalatest.FunSuiteLike$$anon$1.apply(FunSuiteLike.scala:166) at org.scalatest.Suite$class.withFixture(Suite.scala:1122) at org.neo4j.cypher.internal.util.v3_4.test_helpers.CypherFunSuite.withFixture(CypherFunSuite.scala:28) at org.scalatest.FunSuiteLike$class.invokeWithFixture$1(FunSuiteLike.scala:163) at org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:175) at org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:175) at org.scalatest.SuperEngine.runTestImpl(Engine.scala:306) at org.scalatest.FunSuiteLike$class.runTest(FunSuiteLike.scala:175) at org.neo4j.cypher.internal.util.v3_4.test_helpers.CypherFunSuite.org$scalatest$BeforeAndAfterEach$$super$runTest(CypherFunSuite.scala:28) at org.scalatest.BeforeAndAfterEach$class.runTest(BeforeAndAfterEach.scala:255) at org.neo4j.cypher.internal.util.v3_4.test_helpers.CypherFunSuite.runTest(CypherFunSuite.scala:28) at org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:208) at org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:208) at org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:413) at org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:401) at scala.collection.immutable.List.foreach(List.scala:392) at org.scalatest.SuperEngine.traverseSubNodes$1(Engine.scala:401) at org.scalatest.SuperEngine.org$scalatest$SuperEngine$$runTestsInBranch(Engine.scala:396) at org.scalatest.SuperEngine.runTestsImpl(Engine.scala:483) at org.scalatest.FunSuiteLike$class.runTests(FunSuiteLike.scala:208) at org.neo4j.cypher.internal.util.v3_4.test_helpers.CypherFunSuite.runTests(CypherFunSuite.scala:28) at org.scalatest.Suite$class.run(Suite.scala:1424) at org.neo4j.cypher.internal.util.v3_4.test_helpers.CypherFunSuite.org$scalatest$FunSuiteLike$$super$run(CypherFunSuite.scala:28) at org.scalatest.FunSuiteLike$$anonfun$run$1.apply(FunSuiteLike.scala:212) at org.scalatest.FunSuiteLike$$anonfun$run$1.apply(FunSuiteLike.scala:212) at org.scalatest.SuperEngine.runImpl(Engine.scala:545) at org.scalatest.FunSuiteLike$class.run(FunSuiteLike.scala:212) at org.neo4j.cypher.internal.util.v3_4.test_helpers.CypherFunSuite.run(CypherFunSuite.scala:28) at org.scalatest.junit.JUnitRunner.run(JUnitRunner.scala:99) at org.junit.runner.JUnitCore.run(JUnitCore.java:137) at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69) at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33) at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:220) at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:53)