From derby-dev-return-66391-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Fri Feb 20 04:04:24 2009 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 72214 invoked from network); 20 Feb 2009 04:04:24 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 20 Feb 2009 04:04:24 -0000 Received: (qmail 383 invoked by uid 500); 20 Feb 2009 04:04:24 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 360 invoked by uid 500); 20 Feb 2009 04:04:24 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 350 invoked by uid 99); 20 Feb 2009 04:04:24 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Feb 2009 20:04:24 -0800 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Feb 2009 04:04:23 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 203BD234C4AC for ; Thu, 19 Feb 2009 20:04:03 -0800 (PST) Message-ID: <1392826747.1235102643131.JavaMail.jira@brutus> Date: Thu, 19 Feb 2009 20:04:03 -0800 (PST) From: "Bryan Pendleton (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-2487) Enhance Derby with EXPLAIN Functionality In-Reply-To: <11016305.1174903532140.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-2487?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-2487: ----------------------------------- Attachment: startRegressionTest.diff Attached 'startRegressionTest.diff' patch differs in two meaningful respects from the previous patch: - it incorporates the workaround that Knut suggested for DERBY-4062; namely, to directly construct SQLInteger objects for the integer data values rather than calling DataValueFactory.getDataValue(). This seems like a reasonable approach to me, and means that this work won't be blocked while we discuss the preferred approach to take with DERBY-4062. - it includes an initial, incomplete, partial new regression test to be run as part of the derbylang junit test suites. At this point, I'm just writing the most simple tests of the new feature, trying to ensure that in some straightforward scenarios, reasonable values are captured and written to the new system tables. So far, this testing seems to be going well and I think it should be possible to continue adding additional regression tests along these lines to this suite. I haven't re-run the full regression suite in a while, so it's possible that this patch breaks some of the tests, although hopefully not since I haven't done much to the patch other than the two changes mentioned above. > Enhance Derby with EXPLAIN Functionality > ---------------------------------------- > > Key: DERBY-2487 > URL: https://issues.apache.org/jira/browse/DERBY-2487 > Project: Derby > Issue Type: New Feature > Components: SQL > Affects Versions: 10.2.2.0 > Reporter: Felix Beyer > Assignee: Bryan Pendleton > Priority: Minor > Attachments: Derby physical XPLAIN schema.png, incorporateTrunkChanges.diff, RSProtocolNew.pdf, rts.xls, small logical xplain schema.pdf, startRegressionTest.diff, updateRegressionTests.diff, updateRegressionTests.diff, usage.txt, xplain_patch_v1.txt, xplainClasses.pdf > > > This enhancement extends Derby with EXPLAIN functions. Users want to have more feedback than they`re getting with the current RuntimeStatistics facility. This extension is based on the RuntimeStatistics/ResultSetStatistics functions / classes. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.