MySQL Bugs: #71823: select count(*) return zero

Bug #71823	select count(*) return zero
Submitted:	24 Feb 2014 21:48	Modified:	25 Mar 2014 14:53
Reporter:	Lionel Iturri	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.1.49-3	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
select * from table where xxx retrieve 4 registers and select count(*) from table where xxxx  with the same where return 0.

Engine InnoDB

How to repeat:
select version();
select count(1) from table1 where id_lote=683 and estado=1;
select * from table1 where id_lote=683 and estado=1;
+--------------+
| version()    |
+--------------+
| 5.1.49-3-log |
+--------------+
1 row in set (0.01 sec)

+----------+
| count(1) |
+----------+
|        0 |
+----------+
1 row in set (0.01 sec)

+---------+------------+--------+
| id_lote | id_tramite | estado |
+---------+------------+--------+
|     683 |  244055935 |      1 |
|     683 |  245305015 |      1 |
|     683 |  244793252 |      1 |
|     683 |  245052826 |      1 |
+---------+------------+--------+
4 rows in set (0.01 sec)

ENGINE=InnoDB

Thank you for the bug report. You are using a very ancient MySQL Server version
5.1.49 the current release is 5.1.73:

http://dev.mysql.com/downloads/mysql/5.1.html#downloads

Please setup a test machine or a second instance with 5.1.73 also I recommend
you to upgrade at least for 5.5/5.6 versions. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".