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

Copy paste sql to the transformation editor is not parsable

    Details

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

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  tjones Ted Jones
                  Reporter:
                  mkralik Matej Kralik
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: