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

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.7.3
    • 7.7
    • Validation
    • 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

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: