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

Mondrian 4 generating broken SQL with shared dimensions

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Incomplete
    • Affects Version/s: 4.0.0 (5.1.0 GA Suite Release)
    • Fix Version/s: Backlog - Mondrian 4.0
    • 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.

      Description

      Alright I've got a repro path in Foodmart, use my attached version

      run warehouse and sales and slap Store 3.StoreID on columns and Sales Count on rows.

      You'll see a MySQLSyntaxErrorException: Unknown column 'store.store_id' in 'field list' when running with MySQL.

      This is occurring when you have 2 dimensions that share part of the same table, but link to different FK's if they happen to link to the same FK's you don't see the issue.

        PractiTest Integration




          Attachments

          1. FoodMart.mondrian.xml
            8 kB
            Tom Barber
          2. FoodMart.xml
            43 kB
            Tom Barber

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              bugg_tb Tom Barber (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: