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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.7
    • Fix Version/s: 7.7.3
    • Component/s: Validation
    • Labels:
      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

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  jolee Johnathon Lee
                  Reporter:
                  jolee Johnathon Lee
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: