db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bergquist, Brett" <BBergqu...@canoga.com>
Subject RE: Is there a unit test in Derby for the XPLAIN feature
Date Fri, 17 May 2013 12:11:51 GMT
Okay, I looked at the unit test. The unit test does not include a test where 

	call syscs_util.syscs_set_xplain_mode(1);

is used.  When this is used, then you get:

	ERROR XCL16: ResultSet not open. Operation 'getMetaData' not permitted. Verify that autocommit
is OFF.

Using XPLAIN in NOEXECUTE mode to me is the most important function especially when trying
to figure out why a query that might be taking hours to run is doing so.   Without this working
you have to wait hours for the query to run to figure out why.

I will update the JIRA with this information.

-----Original Message-----
From: Rick Hillegas [mailto:rick.hillegas@oracle.com] 
Sent: Saturday, May 11, 2013 8:43 AM
To: derby-dev@db.apache.org
Subject: Re: Is there a unit test in Derby for the XPLAIN feature

On 5/11/13 4:28 AM, Bergquist, Brett wrote:
> Is there a unit test in Derby for the XPLAIN feature?  I would be interested in know
if it is passing if there is.
Hi Brett,

The following XPLAIN test passes cleanly for me: 
org.apache.derbyTesting.functionTests.tests.lang.XplainStatisticsTest

Hope this is useful,
-Rick


> ________________________________________
> From: Bergquist, Brett [BBergquist@canoga.com]
> Sent: Tuesday, May 07, 2013 8:11 PM
> To: derby-dev@db.apache.org
> Subject: RE: Does the XPLAIN feature work in Derby 10.9.1.0
>
> Okay, thanks.   I will open a JIRA on it.
> ________________________________________
> From: Bryan Pendleton [bpendleton.derby@gmail.com]
> Sent: Tuesday, May 07, 2013 7:54 PM
> To: derby-dev@db.apache.org
> Subject: Re: Does the XPLAIN feature work in Derby 10.9.1.0
>
> I get the same result:
>
> $ java -cp ~/derby/db-derby-10.9.1.0-bin/lib/derbyrun.jar 
> org.apache.derby.tools.ij ij version 10.9
> ij>  connect 'jdbc:derby:xplaindb;create=true';
> ij>  call syscs_util.syscs_set_runtimestatistics(1);
> 0 rows inserted/updated/deleted
> ij>  call syscs_util.syscs_set_xplain_schema('STATS');
> 0 rows inserted/updated/deleted
> ij>  call syscs_util.syscs_set_xplain_mode(1);
> 0 rows inserted/updated/deleted
> ij>  select sql_text from syscs_diag.transaction_table where status != 
> ij> 'IDLE';
> ERROR XCL16: ResultSet not open. Operation 'getMetaData' not permitted. Verify that autocommit
is OFF.
>
> I don't know what's wrong, sorry.
>
> But it's happening for me, too.
>
> bryan
>
>
>
>
>
>




Mime
View raw message