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

Concatenation operator || incompatible with import SQL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major 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

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

        1. 2015-12-01_14-19-28.png
          2015-12-01_14-19-28.png
          29 kB

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

                Created:
                Updated:
                Resolved: