Bug #28528 MySQL Administrator reports different number of rows then MySQL QueryBrowser

• Submitted: 18 May 2007 17:54
• Modified: 22 Jun 2007 7:30
• Reporter: Heinz Schweitzer (Gold Quality Contributor)
• Status: Not a Bug
• Category: MySQL Administrator
• Severity: S3 (Non-critical)
• Version: 1.2.12
• OS: Windows (XP Home)
• CPU Architecture: Any

[18 May 2007 17:54] Heinz Schweitzer

Description:
MySQL Administrator reports different number of rows then MySQL QueryBrowser

MySQL Administrator 1.2.12
MySQL QueryBrowser   1.2.12

MySQL Server Information
--------------------------------------------------------------------------------
Connected to MySQL Server Instance
  Username:                root
  Hostname:                127.0.0.1
  Port:                    3306
--------------------------------------------------------------------------------
Server Information
  MySQL Version:           MySQL 5.0.24a-community-nt via TCP/IP
  Network Name:            localhost
  IP:                      127.0.0.1
--------------------------------------------------------------------------------
Client Information
  Version:                 MySQL Client Version 5.1.11
  Network Name:            hgs
  IP:                      192.168.2.5
  Operating System:        Windows XP
  Hardware:                Intel(R) Pentium(R) 4 CPU 2.00GHz, 504 MB RAM

How to repeat:

I have a table that has more then 10500 rows.

Selecting this table in MA gives me a count of 10669 rows,
doing a select * in MySQL QueryBrowser gives me 10598 rows.

In addition to this doing a refresh in MA changes the count  of rows for
this table every time.

[19 May 2007 7:52] Heinz Schweitzer

changed version

[21 Jun 2007 10:31] Sveta Smirnova

Thank you for the report.

Problem table is InnoDB table?

[22 Jun 2007 6:09] Heinz Schweitzer

The table engine use is of type InnoDB .

[22 Jun 2007 7:30] Sveta Smirnova

Thank you for the feedback.

But this is not a bug. Problem is InnoDB doesn't have special field with value of count(*) and 2 queries can get different result on same query. See also http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html