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

Concatenation operator || incompatible with import SQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • None
    • 9.0.3
    • Transformations
    • None
    • Hide

      Change transformation SQL to use ||. Example:
      SELECT col1 || 'abc'
      Select the model > choose option Modelling / Transformations - Export SQL
      Save as a file
      Select the model > choose option Modelling / Transformations - Import SQL
      Select the file
      Popup error is shown: Problem importing the transformation SQL from a file. 2

      Show
      Change transformation SQL to use ||. Example: SELECT col1 || 'abc' Select the model > choose option Modelling / Transformations - Export SQL Save as a file Select the model > choose option Modelling / Transformations - Import SQL Select the file Popup error is shown: Problem importing the transformation SQL from a file. 2

    Description

      When an SQL transformation contains concatenation operator ||, it cannot be imported. Error raised is: Problem importing the transformation SQL from a file. 2

      Attachments

        Activity

          People

            Unassigned Unassigned
            jpmat_jira Jean-Pierre Matsumoto (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: