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

Transformation editor removes cache hint in SQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • 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 */ ========================================

    Description

      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.

      Attachments

        Issue Links

          is related to

          Feature Request - Feature requests from customers and/or users TEIIDDES-52 Allow comments in Virtual Procedures

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Feature Request - Feature requests from customers and/or users TEIIDDES-344 Transformation editor in Designer should support comments and preserve user formatting

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          relates to

          Bug - A problem that impairs or prevents the functions of the product. TEIIDDES-2801 Cache hint is disappeared in the transformation editor

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Bug - A problem that impairs or prevents the functions of the product. TEIIDDES-2199 Designer deletes materialization setting in transformation Editor

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: