4:28 a.m.
Ramesh Reddy created TEIIDDES-1255:
--------------------------------------
Summary: Execution plan without executing the query
Key: TEIIDDES-1255
URL: https://issues.jboss.org/browse/TEIIDDES-1255
Project: Teiid Designer
Issue Type: Bug
Reporter: Ramesh Reddy
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
10:37 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
Barry LaFond updated TEIIDDES-1255:
-----------------------------------
Fix Version/s: 7.7
Assignee: Mark Drilling
Affects Version/s: 7.6
Component/s: Data Preview
Transformations
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
12:06 a.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
Mark Drilling commented on TEIIDDES-1255:
-----------------------------------------
I entered a query in Scrapbook and requested a plan - it returned. Need more info - is
this on first execution or all the time?
As far as the 'separate connection' issue, I think you have to execute the
statements as a group in DTP.
SET NOEXEC OFF;
<query>
select the text, then rt-click > "Execute All"
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
12:20 a.m.
[
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
3:45 a.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
Steven Hawkins commented on TEIIDDES-1255:
------------------------------------------
There are some behavioral differences with later versions. All of what Ramesh describes
was on 7.4.
It could be that past 7.4 the query plan logic was cleaned up. Mark can you confirm that
Designer is ensuring that the query is not executed to produce the plan? If so the
relevant changes should be prioritized for a CP.
Execute all did not work until https://issues.jboss.org/browse/TEIIDDES-1202 in 7.7
Beyond just the simple expectation that the interaction with the scrapbook represents a
single connection/session, it is inefficient to obtain a new connection each time. Unless
there is some DTP is requirement to obtain a new connection each time it would make more
sense to work off of a single one (then transactional statements, temp tables, set
statements, etc. become meaningful when executed singularly).
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
5:43 p.m.
[
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
5:51 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
Ramesh Reddy commented on TEIIDDES-1255:
----------------------------------------
1) Yes. It is worse to execute the query to get just the query plan.
2) When you have (1) resolved, this is not that important for this execution plan usecase
any more. However it is still a concern when user wants execute multiple commands using
single connection in DTP scrap book. Since 7.7 solves the blocked execution, may be this
can be ignored as nuance from 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
8:13 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
Mark Drilling commented on TEIIDDES-1255:
-----------------------------------------
Went back to JBDS 4.1.0 and 4.1.0 with EDS 5.2. In both cases I did get a query plan.
I did commit the change to TeiidPlanSupportRunnable - to disable the query execution when
the user just wants the plan. I will talk to GSS about getting this pulled back.
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
4:37 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
Mark Drilling updated TEIIDDES-1255:
------------------------------------
Attachment: patch-TeiidAdHocScriptRunnable.txt
code patch for TeiidAdHocScriptRunnable
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
4:37 p.m.
[
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
4:37 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
Mark Drilling resolved TEIIDDES-1255.
-------------------------------------
Resolution: Done
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
3:51 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
Johnathon Lee commented on TEIIDDES-1255:
-----------------------------------------
backported to the 7.4.x branch as r2319 & r2320.
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
6:49 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
RH Bugzilla Integration updated TEIIDDES-1255:
----------------------------------------------
Bugzilla Update: Perform
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
6:49 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
RH Bugzilla Integration updated TEIIDDES-1255:
----------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=780267
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
6:51 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
RH Bugzilla Integration updated TEIIDDES-1255:
----------------------------------------------
Bugzilla References: (was: https://bugzilla.redhat.com/show_bug.cgi?id=780267)
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
6:51 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
RH Bugzilla Integration updated TEIIDDES-1255:
----------------------------------------------
Bugzilla Update: (was: Perform)
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=780267 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=780267)
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
6:51 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
RH Bugzilla Integration commented on TEIIDDES-1255:
---------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> made a comment on [bug
780267|https://bugzilla.redhat.com/show_bug.cgi?id=780267]
The usability issue isn't being resolved by TEIIDDES-1255, only its execution. Reset
status.
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
2:56 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
Nick Boldt commented on TEIIDDES-1255:
--------------------------------------
If this was fixed in 7.4.4, please update this JIRA to set the correct Fix Versions.
You'll need project lead to add a new target version because currently only 7.4 and
7.4.2 are available as Fix Versions.
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
3:33 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1255?page=com.atlassian.jira.plu...
]
Barry LaFond updated TEIIDDES-1255:
-----------------------------------
Fix Version/s: 7.4.4
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, 7.4.4
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
4655
days inactive
4696
days old
teiid-designer-issues@lists.jboss.org
18 comments
7 participants
participants (7)
-
Barry LaFond (JIRA) -
Johnathon Lee (JIRA)
-
Mark Drilling (JIRA)
-
Nick Boldt (JIRA)
-
Ramesh Reddy (JIRA)
-
RH Bugzilla Integration (JIRA)
-
Steven Hawkins (JIRA)