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

Copy paste sql to the transformation editor is not parsable

    XMLWordPrintable

    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
    • Release Notes Text:

      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

            is related to

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

            • Critical - An upcoming version that is affected by this issue cannot be released until it's addressed. A critical bug is one that crashes the application, causes loss of data or severe memory leak.
            • Closed

              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: