Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4033

View model - named attributes in mapping statement are not automatically mapped to the corresponding column in the table definition

    Details

    • Type: Feature Request
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Rejected
    • Affects Version/s: 8.7.2.6_2
    • Fix Version/s: None
    • Component/s: VDB
    • Labels:
      None

      Description

      Unexpected sequential dependency between virtual table column order and mapping column sequence.

      The TEIID statement to create a virtual table goes like:

      CREATE VIEW TargetModelViewName (
      ColumnA … 1
      ColumnB … 2
      ColumnC …) … 3
      AS SELECT
      SourceModel.SourceTable.ColX AS ColumnA, 1
      SourceModel.SourceTable.ColY AS ColumnB, 2
      SourceModel.SourceTable.ColZ AS ColumnC; 3

      In any 4th+ generation query language a positional dependency is not expected, and therefore the following statement should also work, but fails in the TEIID

      CREATE VIEW TargetModelViewName (
      ColumnA … 1
      ColumnB … 2
      ColumnC …) … 3
      AS SELECT
      SourceModel.SourceTable.ColX AS ColumnA, 1
      SourceModel.SourceTable.ColZ AS ColumnC, 3
      SourceModel.SourceTable.ColY AS ColumnB; 2

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                dsteigne Deborah Steigner
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: