Details
-
Bug
-
Resolution: Done
-
Major
-
7.7
-
None
Description
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
Attachments
Issue Links
- clones
-
TEIIDDES-1623 validation problems with trim and concat used together.
- Closed