Uploaded image for project: 'Pentaho Metadata'
  1. Pentaho Metadata
  2. PMD-175

SQL Generation creates column aliases that are too long

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: Pentaho 1.6 GA, 1.7.1.GA, 2.0.GA
    • Fix Version/s: 3.5.1
    • Component/s: SQL Generator
    • 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

      SQL generation in the metadata layer uses business column ids for sql column aliases. Certain database systems, such as oracle, have strict character limitations on the length of these fields. Oracle has a limit of 30 characters.

      Some other mechanism for column alias generation will need to be used that guarantees reasonable alias lengths. WAQR is deeply coupled to the business column id as the sql alias name, so work will most likely need to be done at the resultset metadata layer.

        Attachments

          Activity

            People

            Assignee:
            gmoran Gretchen Moran (Inactive)
            Reporter:
            wgorman Will Gorman (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: