Bug #22225 MySQL Administrator row count is wrong and unstable
Submitted: 10 Sep 2006 20:22 Modified: 11 Sep 2006 9:40
Reporter: Michael Lasevich Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.3rc OS:Windows (XP)
Assigned to: CPU Architecture:Any

[10 Sep 2006 20:22] Michael Lasevich 
Description:
In MySQL Administrator when viewing the "Schema Tables" tab, row count is not correct. Further more, after each refresh the rows count changes. Doing "SELECT COUNT(*) ... " query returns proper result every time.

Server: 4.1.20 on Linux
Client: MySQL Admin 1.2.3rc (also seen in 1.1.2, maybe server-side error?)

Exported the schema and imported into another one - same experience. 0 row tables do not seem to be affected.

I know its a minor thing, but a bit annoying.

How to repeat:
Load attached schema, browse in MySQL Administrator to Catalogs, select schema, open Schema Tables tab and hit refresh button a few times.
[10 Sep 2006 20:23] Michael Lasevich 
Schema with problem

Attachment: STBUR 20060910 1255.sql (application/octet-stream, text), 32.31 KiB.
[11 Sep 2006 9:40] Sveta Smirnova 
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicates bug #7341