db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2487) Enhance Derby with EXPLAIN Functionality
Date Sun, 26 Apr 2009 07:16:31 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2487?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Knut Anders Hatlen updated DERBY-2487:
--------------------------------------

    Attachment: jdbc4tests.diff

Thanks for all the work on this issue, Bryan. I'm looking forward to testing the new functionality.

I noticed that there were some failures in jdbc4/TestDbMetaData after the check-in:

http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/768597-org.apache.derbyTesting.functionTests.suites.All_diff.txt

The test is only run when you use Java 6, so it's easy to miss. I took the liberty to add
the new XPLAIN functions SYSCS_GET_XPLAIN_MODE and SYSCS_GET_XPLAIN_SCHEMA to the list of
expected functions in that test (see jdbc4tests.diff) and committed revision 768671.

> 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, finalReview.diff, incorporateTrunkChanges.diff,
jdbc4tests.diff, refactorVisitor.diff, refactorVisitor.diff, removeSourceDepth.diff, RSProtocolNew.pdf,
rts.xls, small logical xplain schema.pdf, startRegressionTest.diff, startRegressionTest.diff,
startUpgradeTests.diff, updateRegressionTests.diff, updateRegressionTests.diff, usage.txt,
userSchemaPrototyping.diff, userSchemaPrototyping.diff, userSchemaPrototyping.diff, 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.


Mime
View raw message