[
https://issues.apache.org/jira/browse/DERBY-4115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kristian Waagan updated DERBY-4115:
-----------------------------------
Attachment: derby-4115-7a-move_test.diff
Attaching patch 7a, which moves the upgrade test from BasicSetup to
Changes10_9. With the changes going in for DERBY-3790 there are more states to
consider, and it makes more sense to move the test such that you don't have to
consider all states (i.e. the expected number of statistics entries).
I also corrected a bug which would fail if the test ever ran on 10.9 (it
expected to fail when trying to invoke SYSCS_DROP_STATISTICS, but this would
have suceeded on 10.9).
The upgrade tests passed for 10.1.1.0 and 10.8.2.2.
I expect to commit this patch shortly, since I have basically only moved code
(I also removed some ifs).
Patch ready for review.
> Provide a way to drop statistics information
> --------------------------------------------
>
> Key: DERBY-4115
> URL: https://issues.apache.org/jira/browse/DERBY-4115
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.6.1.0
> Reporter: Kathey Marsden
> Assignee: Mamta A. Satoor
> Labels: derby_backport_reject_10_8
> Fix For: 10.9.0.0
>
> Attachments: DERBY4115_patch1_diff.txt, DERBY4115_patch2_diff.txt,
> DERBY4115_patch3_diff.txt, DERBY4115_patch4_diff.txt,
> DERBY4115_patch5_diff.txt, DERBY4115_patch6_diff.txt,
> derby-4115-7a-move_test.diff
>
>
> Now that DERBY-269 has been resolved, users can update statistics, but once
> they do, they are committed to using and maintaining the statistics, even if
> it doesn't improve performance or they have difficulty maintaining the
> statistics on a regular basis. It would be good to have a way to drop
> statistics information so that users could revert to the prior behavior if
> needed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira