Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Medium Medium
    • Resolution: Unresolved
    • Affects Version/s: 3.2.0 GA (3.6.0 GA Suite Release)
    • Fix Version/s: Mondrian Backlog
    • 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

      Native evaluation does not respect ordering. MDX sets, unlike SQL sets, are deterministically ordered. So for instance {X, Y} * {A, B} must return {(X, A), (X, B), (Y, A), (Y, B)}.

      Pushing the evaluation down to SQL is very desirable for performance reasons. However, the SQL results may come back in a different order. If the SQL is generated without an ORDER BY clause the results may be different for different databases.

      One example of this failure is mondrian.test.clearview.SummaryTest.testRankExpandNonNative. It occurs on MySQL with mondrian.native.crossjoin.enable=true.

      For other examples, search for this bug number, or uses of Bug.<ThisBug>Fixed.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Julian Hyde
            Reporter:
            Julian Hyde
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: