[DERBY-4116] SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.6.1.0
• Fix Version/s: 10.5.1.1, 10.6.1.0
• Component/s: SQL
• Issue & fix info: High Value Fix
• Assignee: Katherine Marsden
• Reporter: Katherine Marsden
• Created: 24/Mar/09 21:43
• Updated: 30/Jun/09 16:02
• Resolved: 02/Apr/09 12:33

Description

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

Issue Links

• blocks: DERBY-3955 test lang/selectivity.sql can be revived
• is related to: DERBY-269 Provide some way to update index cardinality statistics (e.g. reimplement update statistics)