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

After importing older models transformation SQL is missing "AS columnName" part

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 9.0.4
    • None
    • None

      After I imported some older VDB and exported models from this VDB, there seem to be some validation errors.
      It is necessary to add "AS ColumnName" to transformation sql.
      See screenshots

      Is there a possibility that TD would do this automatically? Or could we have at least some Quick fix for this?

        1. Screen Shot 2016-01-12 at 10.30.37 (2).png
          Screen Shot 2016-01-12 at 10.30.37 (2).png
          453 kB
        2. Screen Shot 2016-01-12 at 10.30.21 (2).png
          Screen Shot 2016-01-12 at 10.30.21 (2).png
          479 kB
        3. QT_MySql50_Push.vdb
          224 kB

              Unassigned Unassigned
              mmakovy@redhat.com Matus Makovy
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: