Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-587

testCrossjoinWithOneDimensionThatDoesNotJoinToBothBaseCubes fails on Oracle/JDK1.5

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.1.0 GA
    • Component/s: Native SQL
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      NonEmptyTest,testCrossjoinWithOneDimensionThatDoesNotJoinToBothBaseCubes produces output in the wrong order against Oracle on JDK 1.5. It works correctly on JDK 1.6.

      Here is the output:

      mondrian.rolap.NonEmptyTest,testCrossjoinWithOneDimensionThatDoesNotJoinToBothBaseCubes
      log4j:WARN No appenders could be found for logger (mondrian.olap.MondrianProperties).
      log4j:WARN Please initialize the log4j system properly.

      junit.framework.ComparisonFailure: Expected:
      Axis #0:
      {}
      Axis #1:

      {[Store].[All Stores].[USA].[CA].[Beverly Hills].[Store 6], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[CA].[Beverly Hills].[Store 6], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[CA].[Los Angeles].[Store 7], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[CA].[Los Angeles].[Store 7], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[CA].[San Diego].[Store 24], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[CA].[San Diego].[Store 24], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[CA].[San Francisco].[Store 14], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[CA].[San Francisco].[Store 14], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[OR].[Portland].[Store 11], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[OR].[Portland].[Store 11], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[OR].[Salem].[Store 13], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[OR].[Salem].[Store 13], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Bellingham].[Store 2], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[WA].[Bellingham].[Store 2], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Bremerton].[Store 3], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[WA].[Bremerton].[Store 3], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Seattle].[Store 15], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[WA].[Seattle].[Store 15], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Spokane].[Store 16], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[WA].[Spokane].[Store 16], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Tacoma].[Store 17], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[WA].[Tacoma].[Store 17], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Walla Walla].[Store 22], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[WA].[Walla Walla].[Store 22], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Yakima].[Store 23], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[WA].[Yakima].[Store 23], [Gender].[All Gender].[M]}
      Axis #2: {[Measures].[Unit Sales]} {[Measures].[vm]}
      Row #0: 10,771
      Row #0: 10,562
      Row #0: 12,089
      Row #0: 13,574
      Row #0: 12,835
      Row #0: 12,800
      Row #0: 1,064
      Row #0: 1,053
      Row #0: 12,488
      Row #0: 13,591
      Row #0: 20,548
      Row #0: 21,032
      Row #0: 1,096
      Row #0: 1,141
      Row #0: 11,640
      Row #0: 12,936
      Row #0: 13,513
      Row #0: 11,498
      Row #0: 12,068
      Row #0: 11,523
      Row #0: 17,420
      Row #0: 17,837
      Row #0: 1,019
      Row #0: 1,184
      Row #0: 5,007
      Row #0: 6,484
      Row #1: 10759.0
      Row #1: 10759.0
      Row #1: 24587.0
      Row #1: 24587.0
      Row #1: 23835.0
      Row #1: 23835.0
      Row #1: 1696.0
      Row #1: 1696.0
      Row #1: 8515.0
      Row #1: 8515.0
      Row #1: 32393.0
      Row #1: 32393.0
      Row #1: 2348.0
      Row #1: 2348.0
      Row #1: 22734.0
      Row #1: 22734.0
      Row #1: 24110.0
      Row #1: 24110.0
      Row #1: 11889.0
      Row #1: 11889.0
      Row #1: 32411.0
      Row #1: 32411.0
      Row #1: 1860.0
      Row #1: 1860.0
      Row #1: 10589.0
      Row #1: 10589.0

      Actual:
      Axis #0:
      {}
      Axis #1:{[Store].[All Stores].[USA].[WA].[Bellingham].[Store 2], [Gender].[All Gender].[F]}{[Store].[All Stores].[USA].[OR].[Salem].[Store 13], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[WA].[Spokane].[Store 16], [Gender].[All Gender].[M]}{[Store].[All Stores].[USA].[CA].[San Diego].[Store 24], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Tacoma].[Store 17], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Bremerton].[Store 3], [Gender].[All Gender].[M]}{[Store].[All Stores].[USA].[CA].[Los Angeles].[Store 7], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[OR].[Salem].[Store 13], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Yakima].[Store 23], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Walla Walla].[Store 22], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[WA].[Seattle].[Store 15], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Tacoma].[Store 17], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[WA].[Walla Walla].[Store 22], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Yakima].[Store 23], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[OR].[Portland].[Store 11], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[OR].[Portland].[Store 11], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[CA].[San Francisco].[Store 14], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Seattle].[Store 15], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[CA].[San Diego].[Store 24], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[WA].[Bremerton].[Store 3], [Gender].[All Gender].[F]}{[Store].[All Stores].[USA].[CA].[Beverly Hills].[Store 6], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[CA].[San Francisco].[Store 14], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[CA].[Beverly Hills].[Store 6], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[CA].[Los Angeles].[Store 7], [Gender].[All Gender].[M]} {[Store].[All Stores].[USA].[WA].[Spokane].[Store 16], [Gender].[All Gender].[F]} {[Store].[All Stores].[USA].[WA].[Bellingham].[Store 2], [Gender].[All Gender].[M]}
      Axis #2: {[Measures].[Unit Sales]} {[Measures].[vm]}
      Row #0: 1,096
      Row #0: 20,548
      Row #0: 11,523
      Row #0: 12,800
      Row #0: 17,837
      Row #0: 12,936
      Row #0: 12,089
      Row #0: 21,032
      Row #0: 6,484
      Row #0: 1,019
      Row #0: 11,498
      Row #0: 17,420
      Row #0: 1,184
      Row #0: 5,007
      Row #0: 12,488
      Row #0: 13,591
      Row #0: 1,053
      Row #0: 13,513
      Row #0: 12,835
      Row #0: 11,640
      Row #0: 10,771
      Row #0: 1,064
      Row #0: 10,562
      Row #0: 13,574
      Row #0: 12,068
      Row #0: 1,141
      Row #1: 2348.0
      Row #1: 32393.0
      Row #1: 11889.0
      Row #1: 23835.0
      Row #1: 32411.0
      Row #1: 22734.0
      Row #1: 24587.0
      Row #1: 32393.0
      Row #1: 10589.0
      Row #1: 1860.0
      Row #1: 24110.0
      Row #1: 32411.0
      Row #1: 1860.0
      Row #1: 10589.0
      Row #1: 8515.0
      Row #1: 8515.0
      Row #1: 1696.0
      Row #1: 24110.0
      Row #1: 23835.0
      Row #1: 22734.0
      Row #1: 10759.0
      Row #1: 1696.0
      Row #1: 10759.0
      Row #1: 24587.0
      Row #1: 11889.0
      Row #1: 2348.0

      Actual java:
      "Axis #0:\n"
      + "{}\n"
      + "Axis #1:\n"
      + "{[Store].[All Stores].[USA].[WA].[Bellingham].[Store 2], [Gender].[All Gender].[F]}\n"
      + "{[Store].[All Stores].[USA].[OR].[Salem].[Store 13], [Gender].[All Gender].[F]}\n"
      + "{[Store].[All Stores].[USA].[WA].[Spokane].[Store 16], [Gender].[All Gender].[M]}\n"
      + "{[Store].[All Stores].[USA].[CA].[San Diego].[Store 24], [Gender].[All Gender].[M]}\n"
      + "{[Store].[All Stores].[USA].[WA].[Tacoma].[Store 17], [Gender].[All Gender].[M]}\n"
      + "{[Store].[All Stores].[USA].[WA].[Bremerton].[Store 3], [Gender].[All Gender].[M]}\n"
      + "{[Store].[All Stores].[USA].[CA].[Los Angeles].[Store 7], [Gender].[All Gender].[F]}\n"
      + "{[Store].[All Stores].[USA].[OR].[Salem].[Store 13], [Gender].[All Gender].[M]}\n"
      + "{[Store].[All Stores].[USA].[WA].[Yakima].[Store 23], [Gender].[All Gender].[M]}\n"
      + "{[Store].[All Stores].[USA].[WA].[Walla Walla].[Store 22], [Gender].[All Gender].[F]}\n"
      + "{[Store].[All Stores].[USA].[WA].[Seattle].[Store 15], [Gender].[All Gender].[M]}\n"
      + "{[Store].[All Stores].[USA].[WA].[Tacoma].[Store 17], [Gender].[All Gender].[F]}\n"
      + "{[Store].[All Stores].[USA].[WA].[Walla Walla].[Store 22], [Gender].[All Gender].[M]}\n"
      + "{[Store].[All Stores].[USA].[WA].[Yakima].[Store 23], [Gender].[All Gender].[F]}\n"
      + "{[Store].[All Stores].[USA].[OR].[Portland].[Store 11], [Gender].[All Gender].[F]}\n"
      + "{[Store].[All Stores].[USA].[OR].[Portland].[Store 11], [Gender].[All Gender].[M]}\n"
      + "{[Store].[All Stores].[USA].[CA].[San Francisco].[Store 14], [Gender].[All Gender].[M]}\n"
      + "{[Store].[All Stores].[USA].[WA].[Seattle].[Store 15], [Gender].[All Gender].[F]}\n"
      + "{[Store].[All Stores].[USA].[CA].[San Diego].[Store 24], [Gender].[All Gender].[F]}\n"
      + "{[Store].[All Stores].[USA].[WA].[Bremerton].[Store 3], [Gender].[All Gender].[F]}\n"
      + "{[Store].[All Stores].[USA].[CA].[Beverly Hills].[Store 6], [Gender].[All Gender].[F]}\n"
      + "{[Store].[All Stores].[USA].[CA].[San Francisco].[Store 14], [Gender].[All Gender].[F]}

      \n"
      + "

      {[Store].[All Stores].[USA].[CA].[Beverly Hills].[Store 6], [Gender].[All Gender].[M]}

      \n"
      + "

      {[Store].[All Stores].[USA].[CA].[Los Angeles].[Store 7], [Gender].[All Gender].[M]}

      \n"
      + "

      {[Store].[All Stores].[USA].[WA].[Spokane].[Store 16], [Gender].[All Gender].[F]}

      \n"
      + "

      {[Store].[All Stores].[USA].[WA].[Bellingham].[Store 2], [Gender].[All Gender].[M]}

      \n"
      + "Axis #2:\n"
      + "

      {[Measures].[Unit Sales]}

      \n"
      + "

      {[Measures].[vm]}

      \n"
      + "Row #0: 1,096\n"
      + "Row #0: 20,548\n"
      + "Row #0: 11,523\n"
      + "Row #0: 12,800\n"
      + "Row #0: 17,837\n"
      + "Row #0: 12,936\n"
      + "Row #0: 12,089\n"
      + "Row #0: 21,032\n"
      + "Row #0: 6,484\n"
      + "Row #0: 1,019\n"
      + "Row #0: 11,498\n"
      + "Row #0: 17,420\n"
      + "Row #0: 1,184\n"
      + "Row #0: 5,007\n"
      + "Row #0: 12,488\n"
      + "Row #0: 13,591\n"
      + "Row #0: 1,053\n"
      + "Row #0: 13,513\n"
      + "Row #0: 12,835\n"
      + "Row #0: 11,640\n"
      + "Row #0: 10,771\n"
      + "Row #0: 1,064\n"
      + "Row #0: 10,562\n"
      + "Row #0: 13,574\n"
      + "Row #0: 12,068\n"
      + "Row #0: 1,141\n"
      + "Row #1: 2348.0\n"
      + "Row #1: 32393.0\n"
      + "Row #1: 11889.0\n"
      + "Row #1: 23835.0\n"
      + "Row #1: 32411.0\n"
      + "Row #1: 22734.0\n"
      + "Row #1: 24587.0\n"
      + "Row #1: 32393.0\n"
      + "Row #1: 10589.0\n"
      + "Row #1: 1860.0\n"
      + "Row #1: 24110.0\n"
      + "Row #1: 32411.0\n"
      + "Row #1: 1860.0\n"
      + "Row #1: 10589.0\n"
      + "Row #1: 8515.0\n"
      + "Row #1: 8515.0\n"
      + "Row #1: 1696.0\n"
      + "Row #1: 24110.0\n"
      + "Row #1: 23835.0\n"
      + "Row #1: 22734.0\n"
      + "Row #1: 10759.0\n"
      + "Row #1: 1696.0\n"
      + "Row #1: 10759.0\n"
      + "Row #1: 24587.0\n"
      + "Row #1: 11889.0\n"
      + "Row #1: 2348.0\n"
      <Click to see difference>
      at mondrian.test.TestContext.assertEqualsVerbose(TestContext.java:1014)
      at mondrian.test.TestContext.assertEqualsVerbose(TestContext.java:972)
      at mondrian.test.TestContext.assertEqualsVerbose(TestContext.java:950)
      at mondrian.test.TestContext.assertQueryReturns(TestContext.java:918)
      at mondrian.test.FoodMartTestCase.assertQueryReturns(FoodMartTestCase.java:125)
      at mondrian.rolap.NonEmptyTest.testCrossjoinWithOneDimensionThatDoesNotJoinToBothBaseCubes(NonEmptyTest.java:3537)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:40)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at com.intellij.rt.execution.application.AppMain.main(AppMain.java:90)

      Process finished with exit code 255

        PractiTest Integration




          Attachments

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              jhyde Julian Hyde (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: