validation problems with trim and concat used together. ------------------------------------------------------- Key: TEIIDDES-1623 URL: https://issues.jboss.org/browse/TEIIDDES-1623 Project: Teiid Designer Issue Type: Bug Components: Validation Affects Versions: 7.7 Reporter: Johnathon Lee Assignee: Barry LaFond Fix For: 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