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

Problem with the MID function getting last character in a string.

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 3.0.5
    • Fix Version/s: 3.1.1 GA
    • Component/s: None
    • 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.
    • Operating System/s:
      Windows Vista

      Description

      The following MDX:

      with
      member measures.x as 'Mid("yahoo",5, 1)'
      select

      {measures.x}

      ON COLUMNS from [Sales]

      returns the empty string.

      On previous versions (2.7) it would return "o" - the expected value.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: