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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Major Major
    • 7.7
    • 7.2, 7.3, 7.4, 7.5
    • Teiid Integration
    • None
    • Hide

      Create a model Project
      Add a virtual procedure and set the tranformation to:
      /*+ cache */
      CREATE VIRTUAL PROCEDURE
      BEGIN
      SELECT 'winning';
      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 BEGIN SELECT 'winning'; 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();

              mdrillin1@redhat.com Mark Drilling (Inactive)
              rhn-support-jolee Johnathon Lee
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: