Menu ▾ ▴

#403 (ok 2.11.7) no tilde for InnoDB row counter where not needed

Finished,_needs_serious_tests
closed-accepted
Marc Delisle
Interface (183)
1
2008-06-23
2008-05-05
Vladyslav Bakayev
No

phpMA would always show a tilde sign in front of InnoDB table, even if the estimated rows was below MaxExactCount and we counted rows with "SELECT COUNT(*) FROM ...".

This tiny patch introduces an additional record into table properties set, so we know for sure if the row count was estimated or properly measured.

no tilde for InnoDB row counter where we know it for sure

Discussion

  • Vladyslav Bakayev

    Vladyslav Bakayev - 2008-05-05
     
    phpMA-InnoDB-rowcount-tilde.patch

  • Marc Delisle

    Marc Delisle - 2008-05-07
    • assigned_to: nobody --> lem9
     

  • Marc Delisle

    Marc Delisle - 2008-05-08

    Logged In: YES
    user_id=210714
    Originator: NO

    Merged for 2.11.7 with a small modification: a ELSE to avoid an undefined variable later. Thanks.

     

  • Marc Delisle

    Marc Delisle - 2008-05-08
    • priority: 5 --> 1
    • summary: no tilde for InnoDB row counter where we know it for sure --> (ok 2.11.7) no tilde for InnoDB row counter where not needed
    • status: open --> open-accepted
     

  • Marc Delisle

    Marc Delisle - 2008-06-23
    • status: open-accepted --> closed-accepted