Bug #100516 Workbench - Database Info - Rows Count gives wrong Number

• Submitted: 13 Aug 2020 13:57
• Modified: 19 Aug 2020 6:16
• Reporter: Jürgen Riehl
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 6.3.7
• OS: Windows
• CPU Architecture: Other (x64)
• Tags: Record Count, tables

[13 Aug 2020 13:57] Jürgen Riehl

Description:
Calling the Database-Info-Page, you get several tabs with Database Infos. One Tab is called "Tables" and gives some Infos on the Tables in the respective Database. One of these Infos ist the row count, i.e. the number of records in a Table. In most cases it fits to the real number of records but sometimes it doesn't. What does this effect depend on? How can it be avoided? Thankful for any hints, 

JR 

How to repeat:
Import a dump-File of an Access-Database generated by Migration Wizard of the workbench into a MySQL-Database.
Then open the Info-Page to the migrated Database within the Workbench
and choose tab "tables"
There exists a column called "rows" reporting the count of records contained within each table. 
In most cases these record counts are correct but sometimes they aren't

[13 Aug 2020 14:32] MySQL Verification Team

Thank you for the bug report. I couldn't repeat with version 8.0.21, please try it, your version 6.3.7 is quite older.

[14 Aug 2020 7:50] Jürgen Riehl

Sample Data to reproduce the issue

Attachment: mysql-bug-data-100516.zip (application/x-zip-compressed, text), 370.19 KiB.

[14 Aug 2020 7:51] Jürgen Riehl

Thanks for quick Answer.
I have uploaded some example data to reproduce the issue

[14 Aug 2020 7:52] Jürgen Riehl

Table 'auftraege' is the interesting one

[17 Aug 2020 12:12] MySQL Verification Team

Hello Jürgen Riehl,

Thank you for the details.
I tried to reproduce your issue on windows 10 with workbench 8.0.21 with the example data provided. My suggestion is click on "Analyze table" button to update the data as the information is sometime outdated. Report us back if issue persist even after updating the data.
Also, Please upgrade to 8.0.21. Thanks.

Regards,
Ashwini Patil

[17 Aug 2020 12:13] MySQL Verification Team

8.0.21 test results

Attachment: 100516_test_results.png (image/png, text), 246.21 KiB.

[19 Aug 2020 6:16] Jürgen Riehl

Hello Ashwini Patil,

thanks for your feedback. The issue remains even after analyzing the Table.
For some reason I am forced to use MySQL 5.7. Is this version compatible to Workbench 8.0.21?

Regards,
Jürgen Riehl