Hi Sergey,
approved. I just ask to consider including the math cange as proposed by
the bug reporter. It could increase accuracy. OTOH it might reduce
accuracy if rec_per_key_part[idx] overflows during accumulation. I leave
it to you. No new review required for this change.
Sergey Vojtovich, 05.02.2009 14:03:
...
> 2785 Sergey Vojtovich 2009-02-05
> BUG#39185 - Cardinality for merge tables calculated incorrectly.
>
> Every subsequent query to a merge table with indexes was lowering
> down cardinality.
>
> The problem was that key statistics was not cleared when merge
> children were detached. Causing next attach children perform
> incremental key statistics calculation.
>
> Fixed by clearing key statistics when attaching first child.
Regards
Ingo
--
Ingo Strüwing, Database Group
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schröder, Wolfgang Engels, Dr. Roland Bömer
Vorsitzender des Aufsichtsrates: Martin Häring HRB München 161028
