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 [[email protected]] Sent: Tuesday, May 07, 2013 8:11 PM To: [email protected] 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 [[email protected]] Sent: Tuesday, May 07, 2013 7:54 PM To: [email protected] 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
