db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2487) Enhance Derby with EXPLAIN Functionality
Date Sun, 22 Feb 2009 21:49:01 GMT

     [ 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

Thanks Knut, I think that's a good idea. I had noticed the awkwardness
of querying against the stmt_text field, and I agree with you that the
small amount of reduction in field size is worth it to be able to issue queries like :

  select stmt_id, stmt_text from sys.sysxplain_statements where stmt_text like '% from countries%'

I've uploaded a new version of the patch as 'startRegressionTest.diff'.

I'm beginning to feel like the regression test is at least establishing broad
basic-level coverage of the new feature.

I think that as we get more experience with this feature, there will be a variety of
more advanced issues that we'll want to have tests for, but at least we now have
a test suite which verifies basic reasonableness of almost all the columns in
the new system tables.

The test development that I've done has identified a number of small items that
I want to follow up on, mostly noted by 'fixme' or 'todo' comments in either the
code itself or in the docs.

I think I'll turn my attention to these items next, making sure that we have
regression tests which explore these items in detail, and then trying to
figure out how to address the particular issue in either the code or the docs.

> 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:
>            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, 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.

View raw message