| Showing 1-30 of 51 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 29630 | 2007-07-08 19:27 | 2007-07-09 13:07 | MySQL Server | Closed (6135 days) | S2 | 5.0.41-community-nt | Windows | Any | "group by" doesnt work with subselects |
| 62504 | 2011-09-22 19:44 | 2013-06-12 16:30 | MySQL Server: Optimizer | Closed (3970 days) | S2 | 5.5.15-log, 5.5.17, 5.6.10 | Linux | Any | "select count(distinct N1), count(distinct N2) from test.AA" works incorrectly |
| 37658 | 2008-06-26 8:45 | 2008-06-26 15:38 | Connector / J | Closed (5782 days) | S2 | mysql-connector-java-5.1.6 | Windows | Any | bad updated rows count |
| 111415 | 2023-06-14 9:39 | 2023-06-19 14:12 | MySQL Server: Optimizer | Verified (311 days) | S3 | 8.0 | Any | Any | Correlated group query wrong result |
| 70930 | 2013-11-16 15:51 | 2013-11-20 14:01 | MySQL Server: DML | Closed (3809 days) | S2 | 5.1+, 5.5+, 5.6.14, 5.7.2-m12 | Any | Any | count distinct get error result |
| 112284 | 2023-09-07 7:58 | 2023-09-07 12:04 | MySQL Workbench | Not a Bug (231 days) | S3 | 8.0.34 | MacOS | x86 | COUNT function causing error code: 1064 |
| 111528 | 2023-06-22 2:04 | 2023-06-22 13:27 | MySQL Server | Not a Bug (308 days) | S3 | 8.0.33 | Ubuntu (22.04) | x86 (x86_64) | Count queries cardinality mismatch |
| 87051 | 2017-07-13 7:26 | 2017-07-13 9:22 | MySQL Server: Optimizer | Duplicate (2478 days) | S3 | 5.7.18 | Ubuntu | Any | Count query without key FROM keyword, executes successfully, returns 1 as count |
| 69285 | 2013-05-20 3:48 | 2013-06-10 10:28 | MySQL Server: Optimizer | Verified (3972 days) | S3 | 5.5+ | Any | Any | count upon not null field can not treated as count(*) |
| 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 |
| 27219 | 2007-03-16 15:48 | 2008-04-07 17:24 | MySQL Server | Closed (5862 days) | S3 | 5.0.38 | Linux (Linux) | Any | count(*) in order by |
| 80580 | 2016-03-02 6:43 | 2019-09-03 15:58 | MySQL Server: Optimizer | Closed (2625 days) | S3 | 5.7.2, 5.7.10, 5.7.11 | Any (Amazon Linux AMI) | Any | count(*) much slower on 5.7 than 5.6 |
| 81686 | 2016-06-02 10:01 | 2016-07-03 1:00 | MySQL Server: DML | No Feedback (2854 days) | S1 | 5.6.30 | CentOS | Any | COUNT(PRIMARY_KEY) returns 0 with more than one WHERE clause |
| 64185 | 2012-01-31 17:21 | 2012-02-09 13:54 | MySQL Workbench: SQL Editor | Duplicate (4466 days) | S3 | 5.2.37 | Windows (XP SP3) | Any | Crash using count combined with math operation |
| 64445 | 2012-02-24 15:10 | 2013-03-26 6:13 | MySQL Server: Optimizer | Closed (4048 days) | S3 | 5.5.21, 5.5.23 | Linux (Ubuntu 11.10) | Any | Different execution plan alter results with Loose Index Scan with Aggregate |
| 62495 | 2011-09-22 0:38 | 2011-09-22 11:18 | MySQL Server: DML | Not a Bug (4599 days) | S2 | 5.1.44 | MacOS (10.6.8) | Any | Discrepant results when using UNION and COUNT |
| 26087 | 2007-02-05 15:27 | 2007-02-05 18:23 | MySQL Server | Closed (6289 days) | S3 | 5.0 | Unix | Any | Empty Result Set Returned When COUNT(), GROUP BY, and WHERE Are Used Together |
| 71028 | 2013-11-27 21:26 | 2014-02-02 17:38 | MySQL Server: DML | Closed (3754 days) | S3 | 5.5+ | Any | Any | error result when "count + distinct + case when" need merge_walk |
| 106414 | 2022-02-09 5:15 | 2022-02-26 0:08 | MySQL Server: XML functions | Closed (789 days) | S3 | 8.0.27, 8.0.28 | Ubuntu (Ubuntu 20.04.3 LTS) | x86 (Intel(R) Core(TM) i7-10700 CPU @ 2.90GHz) | ExtractValue not working properly with COUNT |
| 80711 | 2016-03-12 11:04 | 2016-03-12 11:06 | MySQL Server: JSON | Not a Bug (2966 days) | S3 | 5.7.11 | Any | Any | GeoJSON considered invalid if COUNT function is used. |
| 52582 | 2010-04-04 3:51 | 2014-08-06 17:47 | MySQL Server: DML | Closed (3963 days) | S2 | 4.1.25, 5.0.91, 5.1.54, 5.5.10 | Any (IBM System i 32 bit, Linux) | Any | Incorrect results with COUNT DISTINCT and BIG_TABLES |
| 65053 | 2012-04-20 10:52 | 2012-04-26 8:53 | MySQL Server: DML | Can't repeat (4382 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 (4166 days) | S2 | 5.0.32 | Linux (Debian) | Any | INSERT followed by SELECT on fields not null having a default value |
| 31798 | 2007-10-23 19:47 | 2007-10-23 20:49 | MySQL Server: Optimizer | Not a Bug (6029 days) | S3 | 5.0.45 | Linux (Debian) | Any | LEFT JOIN query with COUNT() and GROUP BY produces wrong result |
| 35209 | 2008-03-11 12:53 | 2008-03-19 13:32 | MySQL Server | Not a Bug (5881 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 |
| 34360 | 2008-02-06 19:06 | 2008-02-07 0:43 | Connector / NET | Not a Bug (5922 days) | S2 | 5.1.4.0 | Any | Any | MySqlDataReader returns zero instead of actual value when doing count(*) |
| 104411 | 2021-07-25 13:35 | 2021-08-13 15:23 | MySQL Server: DML | Closed (986 days) | S2 | 8.0.26 | MacOS (Mac OS X 10.14) | x86 | No result set returned when using HAVING COUNT(DISTINCT ...) |
| 29941 | 2007-07-20 19:19 | 2013-02-20 22:37 | Connectors: DBD::mysql ( Perl ) | Unsupported (4082 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 |
| 69590 | 2013-06-26 15:59 | 2018-03-14 20:53 | MySQL Server: DML | Closed (2234 days) | S3 | 5.5.32 | Any | Any | Problem using between with group by functions |
| 43777 | 2009-03-21 7:54 | 2009-03-21 15:36 | MySQL Administrator | Not a Bug (5514 days) | S3 | 1.2.16 | Windows (XP and Vista 64) | Any | Problem with counting rows in MySQL Administrator (INNODB Only) |
| Showing 1-30 of 51 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
