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

Bad export of carriage return in SQL transformation

XMLWordPrintable

    • Hide
      1. Open attached project or create a new with connection to Oracle ready.
      2. In views folder:
        1. New > Teiid Metadata Model
        2. Model Name: Model1
        3. Model Type: View Model
        4. Click on button Finish
        5. Save with CRTL-S
      3. In Model1 model
        1. Model1 > New Child > Table...
        2. Name: DUAL2
        3. SQL: Copy / Paste content of attached sql.txt file opened from Windows Notepad
        4. Save
      4. Export SQL
        1. Model1 > Modeling > Transformations - Export SQL
        2. Save as file ExportedTransformationSQL.txt
      5. Import SQL
        1. Model1 > Modeling > Transformations - Import SQL
        2. Choose file ExportedTransformationSQL.txt

      Result
      Error "Problem importing the transformation SQL from a file. 2"
      Capture attached to this JIRA entry

      Expected result
      SQL imported successfully.

      Show
      Open attached project or create a new with connection to Oracle ready. In views folder: New > Teiid Metadata Model Model Name: Model1 Model Type: View Model Click on button Finish Save with CRTL-S In Model1 model Model1 > New Child > Table... Name: DUAL2 SQL: Copy / Paste content of attached sql.txt file opened from Windows Notepad Save Export SQL Model1 > Modeling > Transformations - Export SQL Save as file ExportedTransformationSQL.txt Import SQL Model1 > Modeling > Transformations - Import SQL Choose file ExportedTransformationSQL.txt Result Error "Problem importing the transformation SQL from a file. 2" Capture attached to this JIRA entry Expected result SQL imported successfully.
    • Hide

      Before import, delete all carriage returns that are in middle of SQL queries.

      Show
      Before import, delete all carriage returns that are in middle of SQL queries.

      Carriage returns characters makes errors with export + import SQL.

      Can be related to TEIIDDES-735.

        1. error.png
          error.png
          34 kB
        2. SimpleOracle.zip
          18 kB
        3. sql.txt
          0.0 kB
        4. TEIIDDES-2729-fix.patch
          2 kB

              blafond Barry LaFond
              jpmat_jira Jean-Pierre Matsumoto (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: