[
https://issues.jboss.org/browse/TEIIDDES-2383?page=com.atlassian.jira.plu...
]
Barry LaFond updated TEIIDDES-2383:
-----------------------------------
Release Notes Text:
Designer Transformation Editor now supports adding comments to the start and end of SQL
statements as well as hints within certain parts of SQL statements. (See Teiid docs for
details)
Here is an example of a SELECT statement with comments and cache hint:
========================================
/*
leading comment string
multi-line comment
*/
/*+ cache(ttl:180000) */
SELECT
col1
FROM
tbl
WHERE
col2 IN /*+ MJ */ (SELECT col1 FROM tbl2)
/* trailing comment */
========================================
was:
Designer Transformation Editor now supports adding comments to the start and end of SQL
statements as well as hints within certain parts of SQL statements. (See Teiid docs for
details)
Here is an example of a SELECT statement with comments and cache hint:
{code}
/*
leading comment string
multi-line comment
*/
/*+ cache(ttl:180000) */
SELECT
col1
FROM
tbl
WHERE
col2 IN /*+ MJ */ (SELECT col1 FROM tbl2)
/* trailing comment */
{code}
Transformation editor removes cache hint in SQL
-----------------------------------------------
Key: TEIIDDES-2383
URL:
https://issues.jboss.org/browse/TEIIDDES-2383
Project: Teiid Designer
Issue Type: Bug
Components: Transformations
Affects Versions: 8.6, 9.0
Reporter: Jan Stastny
Assignee: Barry LaFond
Fix For: 9.0, 8.6.1, 9.0.1
When adding a comment in transformation editor, the comment disappears after saving its
content. It happens with any comment. This disables usage of cache hints.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)