[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:
-----------------------------------------
1) The current 'Get Plan' action in Designer scrapbook does this:
stmt.execute("SET SHOWPLAN DEBUG");
stmt.executeQuery(sql);
ResultSet planRs = stmt.executeQuery("SHOW PLAN");
planRs.next();
result = planRs.getString("PLAN_XML");
So it does force execution of the query to get the plan... We can just preface this with
"SET NOEXEC ON", correct?
2) I am looking into scrapbook single connection question. I'm not sure we have
control over this - DTP.
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
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