[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1255) Execution plan without executing the query
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
Mark Drilling commented on TEIIDDES-1255:
-----------------------------------------
I committed an additional change to TeiidAdHocScriptRunnable - the code patch is attached.
This change populates the Execution Plan view when a query is executed. So there are two
fixes for this issue:
1) "Teiid_7.x > Get Execution Plan" - SET NOEXEC ON in
TeiidPlanSupportRunnable. This allows the user to get the Execution Plan without running
the query.
2) Execute SQL in scrapbook - added code to populate the Execution Plan View, each time a
query is executed. Code Patch for TeiidAdHocScriptRunnable is attached.
Execution plan without executing the query
------------------------------------------
Key: TEIIDDES-1255
URL: https://issues.jboss.org/browse/TEIIDDES-1255
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview, Transformations
Affects Versions: 7.6
Reporter: Ramesh Reddy
Assignee: Mark Drilling
Fix For: 7.7
Attachments: patch-TeiidAdHocScriptRunnable.txt
DTP execution panel, when user right clicks on the query and ask for execution plan then
no execution plan is returned. Only if the user executes the query then the execution
plan, then user requests for plan it is returned. A query plan can be retrived by
excuting
SET NOEXEC ON
<query>
SET NOEXEC OFF
Also, when I tried to manually do the above steps in the DTP SQL Scrap Book, then it
seemed like it is using a separate connection for each of the abouve commands. so to check
that we did
SET NOEXEC OFF
SHOW NOEXEC -> result was -> NULL (should have been ON)
--
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