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
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 4.1/4.0/5.0/5.1
• OS: Any
• 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:[e-mail]-20100505145753-ivlt4hclbrjy8eye) (version source revid:[e-mail]-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:[e-mail]-20100524190136-egaq7e8zgkwb9aqi) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (pib:16)

[28 May 2010 6:34] Bugs System

Pushed into 6.0.14-alpha (revid:[e-mail]-20100524190941-nuudpx60if25wsvx) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[28 May 2010 7:01] Bugs System

Pushed into 5.5.5-m3 (revid:[e-mail]-20100524185725-c8k5q7v60i5nix3t) (version source revid:[e-mail]-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:[e-mail]-20100617114014-bva0dy24yyd67697) (version source revid:[e-mail]-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:[e-mail]-20100617115448-idrbic6gbki37h1c) (version source revid:[e-mail]-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:[e-mail]-20100617114611-61aqbb52j752y116) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)