Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1845

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Minor Minor
    • 7.6
    • 7.2
    • Query Engine
    • None
    • 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
      BEGIN
      SELECT 'winning';
      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();

            rhn-engineering-shawkins Steven Hawkins
            rhn-support-jolee Johnathon Lee
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: