[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...
]
Ramesh Reddy commented on TEIIDDES-1255:
----------------------------------------
All the time. enter a query like "select * from foo", right click and ask it to
show the plan, it did not, when the query was not executed first. If user wants to just
see the query plan, it should allow it without execution.
Separate connection issue is, since the above did not work, we then executed
SET NOEXEC OFF
then executed
<query>
then look for the query plan -> no query plan.
All the commands executed in a scrap book must be part of single connection, it does not
seem to be. selecting multiple commands and executing is not an option. This was an
alternative we tried because first case did not work.
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