[jbosstools-issues] [JBoss JIRA] Commented: (JBIDE-7418) Teiid -> Model editor -> SQL (Transformation Editor) can't understand "\n" & "\r\n" Windows and Linux lines separation

[Barry LaFond (JIRA)]

    [ https://jira.jboss.org/browse/JBIDE-7418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12560444#action_12560444 ] 

Barry LaFond commented on JBIDE-7418:
-------------------------------------

The Transformation Editor is designed to help users construct standardized SQL statements that comply with the Teiid query engine/sql framework. This framework is backed by a process of parsing SQL based on a finite set of Standard SQL language tree, resolving the objects to known model objects in your Teiid Designer workspace, validating the SQL based on a set of both SQL rules and rules defined by the Teiid's metamodel constructs and finally the consistent user display of these resulting SQL.

Typing in SQL that contains unsupported objects (comments, unsupported statements (i.e. CREATE ROLE, DROP VIEW, CREATE EVENT, PARTITION BY....)) will probably result in a reformmatting of the SQL string.

An example of this consistency can be demonstrated by typing in two different formats for the simple select below:

SELECT A, B, C
FROM Table_A, Table_B WHERE A = B

or 

SELECT A, B, C FROM Table_A, Table_B WHERE A = B 

the resulting displayed valid SQL will be:

SELECT
		A, B, C
	FROM
		Table_A, Table_B
	WHERE
		A = B

> Teiid -> Model editor -> SQL (Transformation Editor) can't understand "\n" & "\r\n" Windows and Linux lines separation
> ----------------------------------------------------------------------------------------------------------------------
>
>                 Key: JBIDE-7418
>                 URL: https://jira.jboss.org/browse/JBIDE-7418
>             Project: Tools (JBoss Tools)
>          Issue Type: Bug
>          Components: teiid
>    Affects Versions: 3.2.0.Beta2
>            Reporter: Vitali Yemialyanchyk
>            Assignee: Barry LaFond
>            Priority: Minor
>             Fix For: 3.2.0.Beta2
>
>         Attachments: SCOTT.sql, screenshot-1.jpg, screenshot-1.jpg, screenshot-2.jpg
>
>   Original Estimate: 0 minutes
>  Remaining Estimate: 0 minutes
>
> it does not work in most cases:
> 1) for open;
> 2) for save;
> 3) for reopen;

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira