Issue Details (XML | Word | Printable)

Key: DERBY-741
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Mike Matrigali
Reporter: Mike Matrigali
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

row estimates from btree code can sometimes return more row than exist in table

Created: 02/Dec/05 09:56 AM   Updated: 12/Jul/06 03:24 AM
Return to search
Component/s: Store
Affects Version/s: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1
Fix Version/s: 10.1.3.1, 10.2.1.6

Time Tracking:
Not Specified

Resolution Date: 06/Dec/05 03:40 AM


 Description  « Hide
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.

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mike Matrigali made changes - 06/Dec/05 03:40 AM
Field Original Value New Value
Resolution Fixed [ 1 ]
Fix Version/s 10.1.3.0 [ 12310616 ]
Fix Version/s 10.2.0.0 [ 11187 ]
Status Open [ 1 ] Resolved [ 5 ]
Mike Matrigali made changes - 12/Jul/06 03:24 AM
Status Resolved [ 5 ] Closed [ 6 ]