Barry LaFond created TEIIDDES-1632: -------------------------------------- Summary: validation problems with trim and concat used together - 7.7.x Key: TEIIDDES-1632 URL: https://issues.jboss.org/browse/TEIIDDES-1632 Project: Teiid Designer Issue Type: Bug Components: Validation Affects Versions: 7.7 Reporter: Johnathon Lee Assignee: Barry LaFond Fix For: 7.7.3, 8.1 Attachments: Trimtest.zip Using the latest JBDS 5.0 and the attached simplified Model Project Set (Trimtest.zip). On the view model CCH_V.memmasV change the transformation to [1] and perform a Save/Validate. It will be rewritten to [2] and give a parsing error. [1] SELECT ltrim(Memb.LSTNAM) || ', ' || trim('foo') ||' '|| trim(Memb.MIDNAM) AS MEMBER_NAME FROM CCH.MEMMAS AS Memb [2] SELECT ((((ltrim(Memb.LSTNAM) || ', ') || trim( FROM )) || ' ') || trim( FROM Memb.MIDNAM)) AS MEMBER_NAME FROM CCH.MEMMAS AS Memb -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira