| Showing 1-30 of 51 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 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( |
| 32361 | 2007-11-14 9:37 | 2007-11-14 10:22 | MySQL Server | Can't repeat (6007 days) | S2 | 5.0.45 | Linux (SLES9 SP3) | Any | Strange behaviour in counting rows |
| 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 |
| 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 ...) |
| 41283 | 2008-12-06 23:05 | 2019-11-02 13:44 | MySQL Server: General | Closed (1636 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 |
| 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 |
| 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 |
| 61668 | 2011-06-28 10:37 | 2014-11-04 3:41 | MySQL Workbench: SQL Editor | Closed (3460 days) | S3 | 5.2.34 | Any | Any | SQL_CACHE COUNT not allowed inside a stored procedure sub query |
| 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 |
| 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 |
| 28695 | 2007-05-25 22:30 | 2013-11-14 15:32 | MySQL Server: Views | Closed (3815 days) | S3 | 5.0.41 | MacOS | Any | spurious error when counting rows in view with order by clause |
| 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 |
| 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 |
| 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 |
| 54040 | 2010-05-27 19:03 | 2011-02-16 23:44 | Connector / NET | Closed (5050 days) | S2 | mysql-connector-net-6.3.1-alpha | Windows (Windows 7) | Any | The NET connector causes an unhandled exception (TEXT > 32767) |
| 21849 | 2006-08-26 10:07 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5132 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. |
| 47650 | 2009-09-25 16:53 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5158 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 |
| 35745 | 2008-04-01 16:21 | 2008-07-23 12:41 | MySQL Server: Partitions | Closed (5755 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 (5782 days) | S2 | mysql-connector-java-5.1.6 | Windows | Any | bad updated rows count |
| 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 |
| 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 |
| 26209 | 2007-02-09 6:47 | 2007-02-26 20:54 | MySQL Server: Views | Closed (6268 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 |
| 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 |
| 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 |
| 68716 | 2013-03-19 10:24 | 2013-03-19 12:06 | MySQL Server: Optimizer | Duplicate (4055 days) | S2 | 5.6.10 | Linux | Any | select count(distinct N1), count(distinct N2) works incorrectly |
| 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 |
| 58062 | 2010-11-08 20:30 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (4914 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 |
| 42174 | 2009-01-16 22:46 | 2011-02-16 23:43 | MySQL Server: General | Duplicate (5575 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 |
| 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 |
| 42596 | 2009-02-04 15:21 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5530 days) | S3 | 5.1.30-community | Linux (CentOS release 5.2 (Final)) | Any | select count(*) |
| Showing 1-30 of 51 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
