Bug #18449 count(*)

• Submitted: 23 Mar 2006 8:32
• Modified: 19 Oct 2008 10:07
• Reporter: iFecisi yang
• Status: No Feedback
• Category: MySQL Server: DML
• Severity: S4 (Feature request)
• Version: 5.0.19
• OS: Windows (win 2000 pro and win 2000 server)
• 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".