Bug #19542 InnoDB doesn't increase the Handler_read_prev counter
Submitted: 4 May 2006 19:16 Modified: 20 Jun 2010 0:44
Reporter: Evgeny Potemkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:4.1/4.0/5.0/5.1 OS:Any
Assigned to: CPU Architecture:Any

[4 May 2006 19:16] Evgeny Potemkin
Description:
The ha_innobase::index_prev() function is defined in sql/ha_innodb.cc at about 3427 line as 
{
  return(general_fetch(buf, ROW_SEL_PREV, 0));
}
should be
{
  statistic_increment(ha_read_prev_count, &LOCK_status);
  return(general_fetch(buf, ROW_SEL_PREV, 0));
}

How to repeat:
See description.

Suggested fix:
Add the line
 statistic_increment(ha_read_prev_count, &LOCK_status);
[4 May 2006 19:41] MySQL Verification Team
Thank you for the bug report. I noticed that in all versions.
[5 May 2006 14:30] Heikki Tuuri
Osku,

please fix this little bug in 4.1, 5.0, 5.1.

regards,

Heikki
[9 May 2006 7:40] Osku Salerma
Fixed in 4.1, 5.0 and 5.1 in InnoDB's Subversion repositories.
[10 May 2006 12:19] Heikki Tuuri
Patch approved.
[15 May 2006 4:44] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/6368
[15 May 2006 4:51] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/6369
[1 Jun 2006 9:55] Alexander Ivanov
Pushed to 4.1.20, 5.0.22, 5.1.11
[5 Jun 2006 21:19] Mike Hillyer
Documented in changelogs:

      <listitem>
        <para>
          InnoDB did not increment the
          <literal>handler_read_prev</literal> counter. (Bug #19542)
        </para>
      </listitem>
[21 Jun 2006 14:18] Lars Thalmann
This was pushed into 5.1.12
[22 Jun 2006 7:55] MC Brown
This bug report has been into the 5.1.12 Changelog.
[5 May 2010 15:04] Bugs System
Pushed into 5.1.47 (revid:joro@sun.com-20100505145753-ivlt4hclbrjy8eye) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[6 May 2010 2:06] Paul DuBois
Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug. Re-closing.
[28 May 2010 6:05] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100524190136-egaq7e8zgkwb9aqi) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (pib:16)
[28 May 2010 6:34] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100524190941-nuudpx60if25wsvx) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[28 May 2010 7:01] Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100524185725-c8k5q7v60i5nix3t) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[29 May 2010 22:54] Paul DuBois
Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug.
Re-closing.
[17 Jun 2010 12:10] Bugs System
Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 12:57] Bugs System
Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 13:37] Bugs System
Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)