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

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Done
    • 7.2
    • 7.6
    • 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.

    Description

      /*+ 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();

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: