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

Transformation editor removes cache hint in SQL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 9.0, 8.6.1, 9.0.1
    • 8.6, 9.0
    • Transformations
    • None
    • Hide

      1. Create a virtual (view) model
      2. Add Child -> table, in transformation window write simple select, prepend it with /+ cache(ttl:180000)/ or even /* comment */. Save the changes.
      (Same happens afterwards in Transformation editor)

      Show
      1. Create a virtual (view) model 2. Add Child -> table, in transformation window write simple select, prepend it with / + cache(ttl:180000) / or even /* comment */. Save the changes. (Same happens afterwards in Transformation editor)
    • Hide
      Designer Transformation Editor now supports adding comments to the start and end of SQL statements as well as hints within certain parts of SQL statements. (See Teiid docs for details)
      Here is an example of a SELECT statement with comments and cache hint:
      ========================================
      /*
      leading comment string
      multi-line comment
       */
      /*+ cache(ttl:180000) */
      SELECT
      col1
      FROM
      tbl
      WHERE
      col2 IN /*+ MJ */ (SELECT col1 FROM tbl2)
       /* trailing comment */
      ========================================
      Show
      Designer Transformation Editor now supports adding comments to the start and end of SQL statements as well as hints within certain parts of SQL statements. (See Teiid docs for details) Here is an example of a SELECT statement with comments and cache hint: ======================================== /* leading comment string multi-line comment  */ /*+ cache(ttl:180000) */ SELECT col1 FROM tbl WHERE col2 IN /*+ MJ */ (SELECT col1 FROM tbl2)  /* trailing comment */ ========================================

      When adding a comment in transformation editor, the comment disappears after saving its content. It happens with any comment. This disables usage of cache hints.

            blafond Barry LaFond
            jstastny@redhat.com Jan Stastny
            Votes:
            1 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: