[
https://issues.apache.org/jira/browse/DERBY-2487?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bryan Pendleton updated DERBY-2487:
-----------------------------------
Attachment: userSchemaPrototyping.diff
Attached 'userSchemaPrototyping.diff' is a substantially modified patch. I've
been
working on prototyping a new approach, placing the XPLAIN tables into a user
schema.
This patch is not ready; it barely compiles, and definitely doesn't work. But
I've
done a lot of investigation into the new approach, and wanted to post the patch
to keep the work on the community's radar.
The new code:
- renames the system procedures to SET_XPLAIN_SCHEMA and GET_XPLAIN_SCHEMA.
- SET_XPLAIN_SCHEMA now takes a schema name, and creates that schema if
it doesn't yet exist.
- then the system procedure creates the six XPLAIN tables in that schema.
I still need to do the work so that the captured XPLAIN data is stored into
those tables.
Plus there's an enormous amount of error-handling, testing, and clean up that
will need to be done.
But I'm pleased with the progress so far, and felt it was worthy of posting.
> 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, 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,
> 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.
