Bug #24931 | count(*) messed up | ||
---|---|---|---|
Submitted: | 9 Dec 2006 4:09 | Modified: | 10 Dec 2006 14:53 |
Reporter: | Vlad Kudelin | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: General | Severity: | S1 (Critical) |
Version: | 14.7 Distrib 4.1.14, for pc-l | OS: | Linux (RH Linux) |
Assigned to: | CPU Architecture: | Any |
[9 Dec 2006 4:09]
Vlad Kudelin
[9 Dec 2006 4:11]
Vlad Kudelin
... Sorry, forgot to supply the simplest form (maybe to make it clearer): mysql> select count(*) from T where the_id=966; +----------+ | count(*) | +----------+ | 2 | +----------+ 1 row in set (0.01 sec) // And I *know* that it's not 2...:).
[9 Dec 2006 11:48]
MySQL Verification Team
Hello Vlad, Your bug report looks similar to: http://bugs.mysql.com/bug.php?id=14980 Please, try the latest 4.1 version.
[9 Dec 2006 17:17]
Vlad Kudelin
Thanks, Viktoria, that helps. How do I close the bug?..
[10 Dec 2006 14:53]
Hartmut Holzgraefe
14980