Uploaded image for project: 'Red Hat CodeReady Studio (devstudio)'
  1. Red Hat CodeReady Studio (devstudio)
  2. JBDS-1934

(Teiid) Cache hint not being displayed after validation of Virtual Procedure in JBoss Developer Studio

XMLWordPrintable

    • Hide

      Create a model Project
      Add a virtual procedure and set the tranformation to:
      /*+ cache */
      CREATE VIRTUAL PROCEDURE
      SELECT 'winning';
      BEGIN
      END

      Save the transformation. The cache hint will not be displayed.

      Show
      Create a model Project Add a virtual procedure and set the tranformation to: /*+ cache */ CREATE VIRTUAL PROCEDURE SELECT 'winning'; BEGIN END Save the transformation. The cache hint will not be displayed.

      /*+ cache */
      CREATE VIRTUAL PROCEDURE
      SELECT 'winning';
      BEGIN
      END

      The cache hint is saved w/the Command Object even though it is not reflected in the display of the text after validation.

      com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent:313 & 314

      The Command object on these lines has a member cacheHint, holding the reference to the cacheHint, this is ignored when the sqlText is set with the line:

      this.sqlText = sqlDisplayNode.toDisplayString();

              blafond Barry LaFond
              rhn-support-jolee Johnathon Lee
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: