Uploaded image for project: 'ONgDB'
  1. ONgDB
  2. ONGDB-80

UsingAcceptanceTest failure | should handle join hint solved multiple times

    XMLWordPrintable

Details

    Description

      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)

      Attachments

        Issue Links

          Activity

            People

              bradnussbaum Brad Nussbaum
              bradnussbaum Brad Nussbaum
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: