db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: Is there a unit test in Derby for the XPLAIN feature
Date Sat, 11 May 2013 12:42:44 GMT
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 != '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