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

Copy paste sql to the transformation editor is not parsable

    XMLWordPrintable

Details

    • Hide
      1. import project from the attachment
      2. open transformation editor in the producer (SchemaModel/ResultSetDocument)
      3. copy the query from this 
        SELECT  
        convert(ID, double) AS producerID, NAME  
    FROM  
        TvGuideStaging.PRODUCTION_HOUSES
      4. Validate SQL

      Alternate SQL

      SELECT  
        'A' as x
      Show
      import project from the attachment open transformation editor in the producer (SchemaModel/ResultSetDocument) copy the query from this SELECT convert(ID, double ) AS producerID, NAME FROM TvGuideStaging.PRODUCTION_HOUSES Validate SQL Alternate SQL SELECT 'A' as x

    Description

      When I copy a sql query from any source (notepad, web browser ...) and paste it to the transformation editor show me that "The query is not parsable.Error in parsing of sql - null ."
      When I deleted all newlines from sql query or I wrote it myself to the editor, sql query was validated.

      Attachments

        Issue Links

          is related to

          Bug - A problem that impairs or prevents the functions of the product. TEIIDDES-2916 Create temporary table results in "Error in parsing of sql - null"

          • Critical - To be worked on immediately following BLOCKER issues.
          • Closed

          Activity

            People

              tjones_jira Ted Jones (Inactive)
              mkralik@redhat.com Matej Kralik
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: