[
https://jira.jboss.org/browse/JBIDE-7418?page=com.atlassian.jira.plugin.s...
]
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...
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