[JBoss JIRA] Created: (JBIDE-7418) Teiid -> Model editor -> SQL (Transformation Editor) can't understand "\n" & "\r\n" Windows and Linux lines separation
1:24 p.m.
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
Priority: Minor
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
1:26 p.m.
New subject: [JBoss JIRA] Updated: (JBIDE-7418) Teiid -> Model editor -> SQL (Transformation Editor) can't understand "\n" & "\r\n" Windows and Linux lines separation
[
https://jira.jboss.org/browse/JBIDE-7418?page=com.atlassian.jira.plugin.s...
]
Vitali Yemialyanchyk updated JBIDE-7418:
----------------------------------------
Attachment: SCOTT.sql
SCOTT.sql - is a file for tests with Windows line separation
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
Priority: Minor
Attachments: SCOTT.sql
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
1:28 p.m.
New subject: [JBoss JIRA] Updated: (JBIDE-7418) Teiid -> Model editor -> SQL (Transformation Editor) can't understand "\n" & "\r\n" Windows and Linux lines separation
[
https://jira.jboss.org/browse/JBIDE-7418?page=com.atlassian.jira.plugin.s...
]
Vitali Yemialyanchyk updated JBIDE-7418:
----------------------------------------
Attachment: screenshot-1.jpg
screenshot-1 - it is opened incorrectly
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
Priority: Minor
Attachments: SCOTT.sql, screenshot-1.jpg, screenshot-1.jpg, screenshot-2.jpg
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
1:28 p.m.
New subject: [JBoss JIRA] Updated: (JBIDE-7418) Teiid -> Model editor -> SQL (Transformation Editor) can't understand "\n" & "\r\n" Windows and Linux lines separation
[
https://jira.jboss.org/browse/JBIDE-7418?page=com.atlassian.jira.plugin.s...
]
Vitali Yemialyanchyk updated JBIDE-7418:
----------------------------------------
Attachment: screenshot-1.jpg
screenshot-1 - it is opened incorrectly
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
Priority: Minor
Attachments: SCOTT.sql, screenshot-1.jpg, screenshot-1.jpg, screenshot-2.jpg
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
1:28 p.m.
New subject: [JBoss JIRA] Updated: (JBIDE-7418) Teiid -> Model editor -> SQL (Transformation Editor) can't understand "\n" & "\r\n" Windows and Linux lines separation
[
https://jira.jboss.org/browse/JBIDE-7418?page=com.atlassian.jira.plugin.s...
]
Vitali Yemialyanchyk updated JBIDE-7418:
----------------------------------------
Attachment: screenshot-2.jpg
screenshot-2 - how it should be
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
Priority: Minor
Attachments: SCOTT.sql, screenshot-1.jpg, screenshot-1.jpg, screenshot-2.jpg
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
11:58 a.m.
New subject: [JBoss JIRA] Updated: (JBIDE-7418) Teiid -> Model editor -> SQL (Transformation Editor) can't understand "\n" & "\r\n" Windows and Linux lines separation
[
https://jira.jboss.org/browse/JBIDE-7418?page=com.atlassian.jira.plugin.s...
]
Brian Fitzpatrick updated JBIDE-7418:
-------------------------------------
Original Estimate: 0 minutes
Remaining Estimate: 0 minutes
Fix Version/s: 3.2.0.Beta2
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
10:53 p.m.
New subject: [JBoss JIRA] Commented: (JBIDE-7418) Teiid -> Model editor -> SQL (Transformation Editor) can't understand "\n" & "\r\n" Windows and Linux lines separation
[
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
8:30 a.m.
New subject: [JBoss JIRA] Commented: (JBIDE-7418) Teiid -> Model editor -> SQL (Transformation Editor) can't understand "\n" & "\r\n" Windows and Linux lines separation
[
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
11:03 a.m.
New subject: [JBoss JIRA] Resolved: (JBIDE-7418) Teiid -> Model editor -> SQL (Transformation Editor) can't understand "\n" & "\r\n" Windows and Linux lines separation
[
https://jira.jboss.org/browse/JBIDE-7418?page=com.atlassian.jira.plugin.s...
]
Barry LaFond resolved JBIDE-7418.
---------------------------------
Resolution: Rejected
Per my last comment, this is designed functionality. The Transformation Editor is not a
full DDL/SQL editor, so rejecting defect.
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
11:39 a.m.
New subject: [JBoss JIRA] Closed: (JBIDE-7418) Teiid -> Model editor -> SQL (Transformation Editor) can't understand "\n" & "\r\n" Windows and Linux lines separation
[
https://jira.jboss.org/browse/JBIDE-7418?page=com.atlassian.jira.plugin.s...
]
Pavol Srna closed JBIDE-7418.
-----------------------------
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.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5062
days inactive
5092
days old
jbosstools-issues@lists.jboss.org
9 comments
4 participants
participants (4)
-
Barry LaFond (JIRA) -
Brian Fitzpatrick (JIRA)
-
Pavol Srna (JIRA)
-
Vitali Yemialyanchyk (JIRA)