db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-4115) Provide a way to drop statistics information
Date Mon, 21 May 2012 13:50:42 GMT

     [ 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

        

Mime
View raw message