Bug #44646 is INFORMATION_SCHEMA.PARTITIONS.TABLE_ROWS exact?
Submitted: 4 May 2009 15:59 Modified: 30 May 2009 5:23
Reporter: Axel Schwenke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S4 (Feature request)
Version:5.1+ OS:Any
Assigned to: Jon Stephens CPU Architecture:Any
Tags: information schema, partition

[4 May 2009 15:59] Axel Schwenke 
Description:
In http://dev.mysql.com/doc/refman/5.1/en/partitions-table.html the manual says:

"TABLE_ROWS: The number of table rows in the partition"

but it is not clear if that number is exact. The manual is more verbose in the documentation of the INFORMATION_SCHEMA.TABLES table - the row count is only an estimate for InnoDB. Probably the same is true for the I_S.PARTITIONS table.

How to repeat:
n/a

Suggested fix:
Add a clear statement if (and when) TABLE_ROWS is exact.
[20 May 2009 10:43] Jon Stephens 
See also BUG#37532 for possibly (?) related documentation issue.
[30 May 2009 5:23] Jon Stephens 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.