[teiid-designer-issues] [JBoss JIRA] Commented: (TEIIDDES-735) Designer is not preserving newlines (and possibly other characters) in literals

From the SqlUtil.normalize method any literal or quoted identifier containing a new line, tab, carriage return, or double spaces will be mangled. While tab and cr should be rare (and probably never used in identifiers) the usage of new lines or double spaces in literals should be expected. Unfortunately the workaround isn't immediately obvious to the user - since the transformation sql is not modified (they are unaware that the server query has been changed). The user will more than likely deploy the vdb and get the wrong data or a resolver error (if an identifier has been mangled).

Designer is not preserving newlines (and possibly other characters) in literals ------------------------------------------------------------------------------- Key: TEIIDDES-735 URL: https://issues.jboss.org/browse/TEIIDDES-735 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Barry LaFond Fix For: 7.1.1 If I enter the transformation sql: select ' ' as x It will be saved in the index as "select ' ' as x" with the new line stripped.