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

Copy paste sql to the transformation editor is not parsable

XMLWordPrintable

    • 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

      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.

        1. endOfFile.mkv
          3.16 MB
        2. XmlStagingProject.zip
          16 kB

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

              Created:
              Updated:
              Resolved: