db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
Date Fri, 27 Mar 2009 17:04:51 GMT

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

Kathey Marsden updated DERBY-4116:

    Derby Info: [Patch Available]

Attached is an updated patch for this issue.  This patch will not update the store estimated
row count if no index scan was performed.

I tried to add a test to UpdateStatisticsTest to verify this, but ran into some trouble because
the estimated row counts we get back from runtime statistics do not return this information
directly.  I did manually verify that we do not go thre setEstimatedRowCount for update statistics
on a table with no index.

Regarding the use of internal interfaces in checkEstimatedRowCount, Myrna suggested that I
clobber and build and make sure there were no build order issues and also that I make sure
derbyTesting.jar didn't pick up the product classes.  I checked both and the change seems
ok from a build perspective.

I ran SelectivityTest and UpdateStatisticsTest and  am running tests  now but don't anticipate
any problems since they don't exercise this code.  Please review.

> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the
> --------------------------------------------------------------------------------------------
>                 Key: DERBY-4116
>                 URL: https://issues.apache.org/jira/browse/DERBY-4116
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions:,
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>         Attachments: derby-4116_diff.txt, derby-4116_diff2.txt
> When SYSCS_UTIL.SYSCS_UPDATE_STATISTICS is run, it doesn't update the store estimated
row count.  The program oldSelectivity.java attached to DERBY-3955 shows that the statistics
are not updated.
> See discussions in DERBY-3955
> https://issues.apache.org/jira/browse/DERBY-3955?focusedCommentId=12688789&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_12688789
> https://issues.apache.org/jira/browse/DERBY-3955?focusedCommentId=12688813&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_12688813

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message