You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <ji...@apache.org> on 2009/03/24 22:43:52 UTC
[jira] Created: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
--------------------------------------------------------------------------------------------
Key: DERBY-4116
URL: https://issues.apache.org/jira/browse/DERBY-4116
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.5.1.0, 10.6.0.0
Reporter: Kathey Marsden
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.
[jira] Updated: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ 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 table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> 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.
[jira] Commented: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12689472#action_12689472 ]
Knut Anders Hatlen commented on DERBY-4116:
-------------------------------------------
With the latest patch, I think the row count estimate will always be set to 0 if you call SYSCS_UPDATE_STATISTICS on a table with no indexes, even if the table is not empty. Would it be possible to initialize rowCount to -1, so that we can detect that the row count was not calculated, and then add "if (rowCount >= 0)" around the call to setEstimatedRowCount()?
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> 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.
[jira] Commented: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12689454#action_12689454 ]
Knut Anders Hatlen commented on DERBY-4116:
-------------------------------------------
The arguments to openScan() look correct to me. Since we don't actually scan the conglomerate, many of them wouldn't make any difference anyway, I think.
Now we update the heap conglomerate inside the for loop, which means that we'll update it once per index. Would it be enough to update it once, after we have gone through the last index?
Nit: openScan() should be called outside the try block (if it fails, there's no open scan to close). If it's moved out of the try block, the check for heapSC!=null in the finally block can be removed too.
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Attachments: derby-4116_diff.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.
[jira] Commented: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12689068#action_12689068 ]
Knut Anders Hatlen commented on DERBY-4116:
-------------------------------------------
I guess it's only implemented for heap conglomerates because the row count should really be the same in the base table and all its indexes, and there's no need to store the estimated row count for a table more than one place. The optimizer will probably always look for the estimate in the heap conglomerate, so it doesn't notice the estimate in the index.
Does it work as expected if you do something like this near the end of the method?
ScanController heapSC = tc.openScan(td.getHeapConglomerateId(), ...);
heapSC.setEstimatedRowCount(rowCount);
heapSC.close();
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
>
> 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.
[jira] Updated: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-4116:
----------------------------------
Attachment: derby-4116_diff2.txt
Here is an updated patch for this issue. I am rerunning tests and will check in later today if all goes well.
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> 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.
[jira] Updated: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-4116:
----------------------------------
patch looks good to me. The only thing I noticed is that the current index scans use an open for read (argument 0), but your new heap open does an open for update. It seems like both
opens should use the same - either read or write, and since the existing scans and update of the estimate seems to work it seems better to open the heap for read also.
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Attachments: derby-4116_diff.txt, derby-4116_diff2.txt, derby-4116_diff3.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.
[jira] Commented: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12688935#action_12688935 ]
Kathey Marsden commented on DERBY-4116:
---------------------------------------
Well just to see if this was a really easy fix, so I could continue my testing, I tried the trivial patch below:
--- java/engine/org/apache/derby/impl/sql/execute/AlterTableConstantAction.java (revision 757498)
+++ java/engine/org/apache/derby/impl/sql/execute/AlterTableConstantAction.java (working copy)
@@ -744,6 +744,7 @@
rowBufferArray[GROUP_FETCH_SIZE - 1] = lastUniqueKey;
lastUniqueKey = tmp;
} // while
+ gsc.setEstimatedRowCount(numRows);
} // try
finally
{
but it doesn't affect my test case. I verified that with this change the code goes through
OpenBTree.setEstimatedRowCount and sets the count to 4000, but there is this comment in OpenBTree.setEstimatedRowCount():
* This call is currently only supported on Heap conglomerates, it
* will throw an exception if called on btree conglomerates.
*
It doesn't throw an exception, but it doesn't seem to do too much either. Any ideas what's wrong?
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
>
> 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.
[jira] Commented: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12694163#action_12694163 ]
Kathey Marsden commented on DERBY-4116:
---------------------------------------
I made the change recommended by Mike and committed revision 760497 to trunk. I will wait for clean nightly results and backport to 10.5. Meanwhile I'll leave this issue open. Thanks for the reviews!
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Attachments: derby-4116_diff.txt, derby-4116_diff2.txt, derby-4116_diff3.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.
[jira] Updated: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-4116:
----------------------------------
Attachment: derby-4116_diff.txt
Attached is a patch for this issue. derby-4116_diff.txt. It also included the initial partial conversion of selectivity.sql DERBY-3955 which tests this issue. suites.All and derbyall passed except for DERBY-3993, a known issue.
Please review. Especially, please check my arguments to openScan to make sure I got that right.
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Attachments: derby-4116_diff.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.
[jira] Assigned: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden reassigned DERBY-4116:
-------------------------------------
Assignee: Kathey Marsden
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
>
> 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.
[jira] Commented: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12689462#action_12689462 ]
Kathey Marsden commented on DERBY-4116:
---------------------------------------
Thanks Knut for reviewing the changes, especially catching that I was doing the update inside the loop. I will make the changes and post a new patch soon.
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Attachments: derby-4116_diff.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.
[jira] Commented: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12694008#action_12694008 ]
Knut Anders Hatlen commented on DERBY-4116:
-------------------------------------------
Patch 3 looks good to me too. Thanks for all the work.
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Attachments: derby-4116_diff.txt, derby-4116_diff2.txt, derby-4116_diff3.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.
[jira] Updated: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-4116:
----------------------------------
Attachment: derby-4116_diff3.txt
The patch derby-4116_diff3.txt is the current patch as of this comment. Somehow it did not get attached with my last attempt.
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Attachments: derby-4116_diff.txt, derby-4116_diff2.txt, derby-4116_diff3.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.
[jira] Updated: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-4116:
----------------------------------
Derby Info: (was: [Patch Available])
Unchecking patch available. I will make a new patch with Knut's suggestion., but it is looking like that won't happen today. Thanks again Knut for your valuable input.
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> 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.
[jira] Updated: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ 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]
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Attachments: derby-4116_diff.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.
[jira] Commented: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12689098#action_12689098 ]
Kathey Marsden commented on DERBY-4116:
---------------------------------------
Thanks Knut, that seemed to do the trick. I will make a proper patch for the issue and do testing. I think I'll keep the index estimatedRowCount update since it does seem to be being set, just in case someone is using it for something.
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
>
> 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.
[jira] Closed: (DERBY-4116) SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
should update the store estimated row count for the table
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden closed DERBY-4116.
---------------------------------
Resolution: Fixed
Fix Version/s: 10.6.0.0
10.5.1.1
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Fix For: 10.5.1.1, 10.6.0.0
>
> Attachments: derby-4116_diff.txt, derby-4116_diff2.txt, derby-4116_diff3.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.