| Showing 1-30 of 51 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 21849 | 2006-08-26 10:07 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5126 days) | S5 | 5.0.32-BK, 4 and 5, 5.1.42-bzr | Linux (linux) | Any | select count distinct has rotten performance on at least versions 4&5 of mysql. |
| 26087 | 2007-02-05 15:27 | 2007-02-05 18:23 | MySQL Server | Closed (6283 days) | S3 | 5.0 | Unix | Any | Empty Result Set Returned When COUNT(), GROUP BY, and WHERE Are Used Together |
| 26209 | 2007-02-09 6:47 | 2007-02-26 20:54 | MySQL Server: Views | Closed (6262 days) | S2 | 5.0.36-BK, 5.0.27 | Linux (Linux, winXP) | Any | wrong result using COUNT(DISTINCT ?) querying a VIEW with GROUP BY and ORDER BY |
| 27219 | 2007-03-16 15:48 | 2008-04-07 17:24 | MySQL Server | Closed (5856 days) | S3 | 5.0.38 | Linux (Linux) | Any | count(*) in order by |
| 29941 | 2007-07-20 19:19 | 2013-02-20 22:37 | Connectors: DBD::mysql ( Perl ) | Unsupported (4076 days) | S3 | 4.005 | Any (Sun Solaris 8, Mac OS X) | Any | Perl affected row count incorrect for certain cases of ON DUPLICATE KEY UPDATE |
| 29630 | 2007-07-08 19:27 | 2007-07-09 13:07 | MySQL Server | Closed (6129 days) | S2 | 5.0.41-community-nt | Windows | Any | "group by" doesnt work with subselects |
| 30402 | 2007-08-14 8:35 | 2014-03-10 14:31 | MySQL Server: DML | Verified (4153 days) | S2 | 5.0.37 Community | Linux (RedHat 9.0) | Any | SELECT count(distinct) from mytable return 0 |
| 31732 | 2007-10-21 1:14 | 2020-05-03 20:45 | MySQL Server: DML | Verified (5974 days) | S2 | 5.0.45 | Linux (SuSE 10.3 x86_64) | Any | row count(*) overflows after 32-bit integer precision in spite of being bigint |
| 31798 | 2007-10-23 19:47 | 2007-10-23 20:49 | MySQL Server: Optimizer | Not a Bug (6023 days) | S3 | 5.0.45 | Linux (Debian) | Any | LEFT JOIN query with COUNT() and GROUP BY produces wrong result |
| 32361 | 2007-11-14 9:37 | 2007-11-14 10:22 | MySQL Server | Can't repeat (6001 days) | S2 | 5.0.45 | Linux (SLES9 SP3) | Any | Strange behaviour in counting rows |
| 35209 | 2008-03-11 12:53 | 2008-03-19 13:32 | MySQL Server | Not a Bug (5875 days) | S2 | 5.0.45 | Linux (Trustix Secure Linux 3.0 / 2.6.19.2-1trsmp / glibc-2.3.5-10tr) | Any | maximum number of threads with MySQL binary RPMs |
| 35745 | 2008-04-01 16:21 | 2008-07-23 12:41 | MySQL Server: Partitions | Closed (5749 days) | S2 | 5.1.23 | Any | Any | SELECT COUNT(*) is not correct for some partitioned tables. |
| 37658 | 2008-06-26 8:45 | 2008-06-26 15:38 | Connector / J | Closed (5776 days) | S2 | mysql-connector-java-5.1.6 | Windows | Any | bad updated rows count |
| 37905 | 2008-07-06 16:19 | 2008-07-07 18:02 | MySQL Server | Unsupported (5765 days) | S3 | 5.0.51a | MacOS (part of XAMPP 0.7.2) | Any | SELECT COUNT with GROUP BY bug (see #7128) |
| 34360 | 2008-02-06 19:06 | 2008-02-07 0:43 | Connector / NET | Not a Bug (5916 days) | S2 | 5.1.4.0 | Any | Any | MySqlDataReader returns zero instead of actual value when doing count(*) |
| 41283 | 2008-12-06 23:05 | 2019-11-02 13:44 | MySQL Server: General | Closed (1630 days) | S3 | 5.0.67-log, 5.1.30, 6.0.7 | Linux | Any | Warning count reported to be 1 and 0 at the same time |
| 43777 | 2009-03-21 7:54 | 2009-03-21 15:36 | MySQL Administrator | Not a Bug (5508 days) | S3 | 1.2.16 | Windows (XP and Vista 64) | Any | Problem with counting rows in MySQL Administrator (INNODB Only) |
| 42174 | 2009-01-16 22:46 | 2011-02-16 23:43 | MySQL Server: General | Duplicate (5569 days) | S2 | 5.0.67 & 4.1.22 | Linux | Any | Select count(*) with subquery consuming multi-gigs of memory, 5.0.67 & 4.1.22 |
| 42596 | 2009-02-04 15:21 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5524 days) | S3 | 5.1.30-community | Linux (CentOS release 5.2 (Final)) | Any | select count(*) |
| 46329 | 2009-07-22 2:27 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified (5385 days) | S2 | 5.1.34-ndb-7.0.6-cluster-gpl | Linux (x86_64) | Any | update query returns incorrect number of rows matched when no fields are updated |
| 46283 | 2009-07-18 15:22 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0, 5.1, 5.4, 6.0 | Any | Any | COUNT() returning bad values when LIMIT 1 clause added to query |
| 47650 | 2009-09-25 16:53 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5152 days) | S3 | 5.0.X, 5.1.39, next-mr | Any (Mac OS X Snow leopard, Linux) | Any | using group by with rollup without indexes returns incorrect results with where |
| 53078 | 2010-04-22 19:03 | 2010-04-28 20:32 | MySQL Server: General | Not a Bug (5105 days) | S2 | 5.1.45-community | Windows | Any | SELECT WITH LIMIT PROBLEM |
| 54040 | 2010-05-27 19:03 | 2011-02-16 23:44 | Connector / NET | Closed (5044 days) | S2 | mysql-connector-net-6.3.1-alpha | Windows (Windows 7) | Any | The NET connector causes an unhandled exception (TEXT > 32767) |
| 58062 | 2010-11-08 20:30 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (4908 days) | S3 | 5.1.41-3, 5.1.54, 5.1, 5.6.99 bzr | Linux (ubuntu12.1) | Any | Results incorrect after rollback on Partitioned table |
| 62495 | 2011-09-22 0:38 | 2011-09-22 11:18 | MySQL Server: DML | Not a Bug (4593 days) | S2 | 5.1.44 | MacOS (10.6.8) | Any | Discrepant results when using UNION and COUNT |
| 64185 | 2012-01-31 17:21 | 2012-02-09 13:54 | MySQL Workbench: SQL Editor | Duplicate (4460 days) | S3 | 5.2.37 | Windows (XP SP3) | Any | Crash using count combined with math operation |
| 65053 | 2012-04-20 10:52 | 2012-04-26 8:53 | MySQL Server: DML | Can't repeat (4376 days) | S2 | 5.5.21 | Any | Any | Incorrect select results when using index and complicated select count(distinct( |
| 67743 | 2012-11-28 14:42 | 2012-11-28 16:45 | MySQL Server | Not a Bug (4160 days) | S2 | 5.0.32 | Linux (Debian) | Any | INSERT followed by SELECT on fields not null having a default value |
| 64445 | 2012-02-24 15:10 | 2013-03-26 6:13 | MySQL Server: Optimizer | Closed (4042 days) | S3 | 5.5.21, 5.5.23 | Linux (Ubuntu 11.10) | Any | Different execution plan alter results with Loose Index Scan with Aggregate |
| Showing 1-30 of 51 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
