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: