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