Bug #18449 count(*)
Submitted: 23 Mar 2006 8:32 Modified: 19 Oct 2008 10:07
Reporter: iFecisi yang Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version:5.0.19 OS:Windows (win 2000 pro and win 2000 server)
Assigned to: CPU Architecture:Any

[23 Mar 2006 8:32] iFecisi yang
Description:
at this time only me use this database;
and use the old ver 4.0.22-nt, have the some err;
--------------------------------------
use left();

mysql> select  count(*)  from  imei  where  left(imei, 8) = "imei 012" ;
+----------+
| count(*) |
+----------+
|   108756 |
+----------+
1 row in set (0.06 sec)

mysql> select  count(*)  from  imei;
+----------+
| count(*) |
+----------+
|   108718 |
+----------+
1 row in set (0.00 sec)

--------------------------
use "%"

mysql> select count(*) from imei;
+----------+
| count(*) |
+----------+
| 108718   |
+----------+
1 row in set (0.02 sec)

mysql> select count(*) from imei where imei like "imei 012%"
    -> ;
+----------+
| count(*) |
+----------+
| 108756   
+----------+
1 row in set (0.09 sec)

How to repeat:
any time

Suggested fix:
none
[23 Mar 2006 8:34] iFecisi yang
sorry!

108756 >  108718
[19 Sep 2008 10:07] Susanne Ebrecht
Many thanks for writing a bug report.

MySQL 5.0.19 is very old. Please use our newest version MySQL 5.0.67 and let us know if this crazy behaviour still occurs.
[19 Oct 2008 23:00] Bugs System
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".