Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1632

validation problems with trim and concat used together - 7.7.x

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 7.7.3
    • 7.7
    • Validation
    • None

      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

            rhn-support-jolee Johnathon Lee
            rhn-support-jolee Johnathon Lee
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: