Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-490

Validation of transformation SQL with sub-select and alias incorrectly adds model name to alias.column name

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Done
    • Affects Version/s: 7.0
    • Fix Version/s: 7.1
    • Component/s: Transformations
    • Labels:
      None
    • Environment:

      Fedora 12, OpenJDK, Designer 6/28

      Description

      This is from teh TPCR metadata text import test. A series of transformations is built for query testing. When I ran it, several transformations were affected similarly. The Hawkman looked at it and believes the issue lies within the Designer. Here's a simplified version of the SQL:

      SELECT supp_nation, cust_nation
      FROM (SELECT n1.N_NAME AS supp_nation, n2.N_NAME AS cust_nation FROM TPCR.SUPPLIER, TPCR.NATION AS n1, TPCR.NATION AS n2
      WHERE (S_NATIONKEY = n1.N_NATIONKEY) ) AS shipping

      Upon validation, it changes to:

      SELECT
      SHIPPING.supp_nation, SHIPPING.cust_nation
      FROM
      (SELECT n1.TPCR.NATION.N_NAME AS supp_nation, n2.TPCR.NATION.N_NAME AS cust_nation FROM TPCR.SUPPLIER, TPCR.NATION AS n1, TPCR.NATION AS n2 WHERE TPCR.SUPPLIER.S_NATIONKEY = n1.TPCR.NATION.N_NATIONKEY) AS shipping

      The error is:
      The query is parsable but not resolvable.
      Resolver Error: Symbol n1.TPCR.NATION.N_NATIONKEY is specified with an unknown group context

      The element in question should be referred to as: n1.N_NATIONKEY. (I'll attach the model project set.)

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                pnittel Paul Nittel
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: