[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=12560402#action_12560402 ] 

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

I think the main problem here is that the SQL (or DDL) pasted into the Transformation Editor contains mostly non-supported SQL/DDL commands. Note that SQL comments are also not supported.

The Transformation Editor was designed to help users model SELECT, INSERT, UPDATE, DELETE statements for directly accessing and modifying tables.

The Editor does interpret line feeds and returns, but the final formatting is determined by the underlying Teiid Query engine/parser framework. Typing in the following, for instance will be fully parsed:

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

Recommend reading documentation on Transformation Editor for starters:  http://docs.jboss.org/teiid/designer/6.0/user-guide/editing-model-objects-chapter.html#transformation-editor-section

> 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