Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Severe Severe
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      When a numerical number contains many significant digits in MDX query, it causes overflow.

      For example, the following query causes exception in version 2.2.2.

      with member [Measures].[Small Number] as '[Measures].[Store Sales] / 9000'
      select
          {[Measures].[Small Number]} on columns,
          {Filter([Product].[Product Department].members, [Measures].[Small Number] >= 0.3
      and [Measures].[Small Number] <= 0.5000001234)} on rows
      from Sales
      where ([Time].[1997].[Q2].[4])


      By changing data type from int to long for variables n and exponent in class Scanner (line 456) seems to fix this problem.

        Activity

        Hide
        Mondrian Importer User added a comment -
        {houchenlm}, 03/26/2007: IP, Artifact Created: 12.183.217.250 |
        {jhyde}, 03/27/2007: IP, Comment Added: 66.92.12.96 |
        {jhyde}, 03/27/2007: status_id, 1 |
        {jhyde}, 03/27/2007: resolution_id, 100 |
        {jhyde}, 03/27/2007: assigned_to, 100 |
        {jhyde}, 03/27/2007: close_date, 0
        Show
        Mondrian Importer User added a comment - {houchenlm}, 03/26/2007: IP, Artifact Created: 12.183.217.250 | {jhyde}, 03/27/2007: IP, Comment Added: 66.92.12.96 | {jhyde}, 03/27/2007: status_id, 1 | {jhyde}, 03/27/2007: resolution_id, 100 | {jhyde}, 03/27/2007: assigned_to, 100 | {jhyde}, 03/27/2007: close_date, 0
        Hide
        Mondrian Importer User added a comment -
        {jhyde}, 03/27/2007: Logged In: YES
        user_id=312935
        Originator: NO

        Fixed in change 8951. Will be in mondrian-2.3.3 or mondrian-2.4. Thanks for the great testcase and the hints how to fix this!
        Show
        Mondrian Importer User added a comment - {jhyde}, 03/27/2007: Logged In: YES user_id=312935 Originator: NO Fixed in change 8951. Will be in mondrian-2.3.3 or mondrian-2.4. Thanks for the great testcase and the hints how to fix this!

          People

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

            Dates

            • Created:
              Updated:
              Resolved: