[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1156) Cache hint not being displayed after validation of Virtual Procedure in JBoss Developer Studio
[
https://issues.jboss.org/browse/TEIIDDES-1156?page=com.atlassian.jira.plu...
]
Steven Hawkins commented on TEIIDDES-1156:
------------------------------------------
The real fix for this will need to be on the Teiid side. However this is somewhat of a
trivial issue for Teiid as the will be seen on the initial parsing, so the fix will be in
7.6. If needed designer can override SQLStringVisitor.visit(CreateUpdateProcedureCommand
obj) as:
public void visit(CreateUpdateProcedureCommand obj) {
addCacheHint(obj.getCacheHint());
super.visit(obj);
}
Which would need to be removed when upgrading to a fixed Teiid.
Cache hint not being displayed after validation of Virtual Procedure
in JBoss Developer Studio
----------------------------------------------------------------------------------------------
Key: TEIIDDES-1156
URL: https://issues.jboss.org/browse/TEIIDDES-1156
Project: Teiid Designer
Issue Type: Bug
Components: Teiid Integration
Affects Versions: 7.2, 7.3, 7.4, 7.5
Environment: JBoss Developer Studio 4.0
JBoss Developer Studio 4.1
Reporter: Johnathon Lee
/*+ 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();
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira