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

Bad export of carriage return in SQL transformation

    XMLWordPrintable

    Details

    • Steps to Reproduce:
      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.
    • Workaround Description:
      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.

      Description

      Carriage returns characters makes errors with export + import SQL.

      Can be related to TEIIDDES-735.

        Gliffy Diagrams

          Attachments

          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

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                jpmat Jean-Pierre Matsumoto
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: