Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-741

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

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • 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
    • Component/s: Store
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              mikem Mike Matrigali
              Reporter:
              mikem Mike Matrigali
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: