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 "Mike Matrigali (JIRA)" <de...@db.apache.org> on 2005/12/02 01:57:31 UTC
[jira] Created: (DERBY-741) row estimates from btree code can sometimes return more row than exist in table
row estimates from btree code can sometimes return more row than exist in table
-------------------------------------------------------------------------------
Key: DERBY-741
URL: http://issues.apache.org/jira/browse/DERBY-741
Project: Derby
Type: Bug
Components: Store
Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.1.1, 10.1.1.2, 10.1.2.0, 10.1.2.1
Reporter: Mike Matrigali
Assigned to: Mike Matrigali
Priority: Minor
In BTreeCostController the recursive row estimate can sometimes return more rows than exists in the table. In Sane server an ASSERT would be thrown. Simple change is to just always make the max estimation be all the rows in the table.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Resolved: (DERBY-741) row estimates from btree code can sometimes return more row than exist in table
Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-741?page=all ]
Mike Matrigali resolved DERBY-741:
----------------------------------
Fix Version: 10.2.0.0
10.1.3.0
Resolution: Fixed
svn 354106 fixes it in 10.1
svn 351846 fixes it in the trunk
fix for DERBY-741.
Insure that row estimates from btree cost function never return more rows than
the btree thinks it has. Before this change an ASSERT might fire where the
fraction estimating the percentage of rows became larger than 1 (like 1.000001).
> row estimates from btree code can sometimes return more row than exist in table
> -------------------------------------------------------------------------------
>
> Key: DERBY-741
> URL: http://issues.apache.org/jira/browse/DERBY-741
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.1.1, 10.1.1.2, 10.1.2.0, 10.1.2.1
> Reporter: Mike Matrigali
> Assignee: Mike Matrigali
> Priority: Minor
> Fix For: 10.2.0.0, 10.1.3.0
>
> In BTreeCostController the recursive row estimate can sometimes return more rows than exists in the table. In Sane server an ASSERT would be thrown. Simple change is to just always make the max estimation be all the rows in the table.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Closed: (DERBY-741) row estimates from btree code can
sometimes return more row than exist in table
Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-741?page=all ]
Mike Matrigali closed DERBY-741:
--------------------------------
> row estimates from btree code can sometimes return more row than exist in table
> -------------------------------------------------------------------------------
>
> Key: DERBY-741
> URL: http://issues.apache.org/jira/browse/DERBY-741
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.1.1, 10.1.1.2, 10.1.2.0, 10.1.2.1
> Reporter: Mike Matrigali
> Assignee: Mike Matrigali
> Priority: Minor
> Fix For: 10.2.0.0, 10.1.3.0
>
> In BTreeCostController the recursive row estimate can sometimes return more rows than exists in the table. In Sane server an ASSERT would be thrown. Simple change is to just always make the max estimation be all the rows in the table.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira