| Showing 1-30 of 51 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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) |
| 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(*) |
| 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 |
| 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) |
| 112284 | 2023-09-07 7:58 | 2023-09-07 12:04 | MySQL Workbench | Not a Bug (225 days) | S3 | 8.0.34 | MacOS | x86 | COUNT function causing error code: 1064 |
| 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 |
| 61668 | 2011-06-28 10:37 | 2014-11-04 3:41 | MySQL Workbench: SQL Editor | Closed (3454 days) | S3 | 5.2.34 | Any | Any | SQL_CACHE COUNT not allowed inside a stored procedure sub query |
| 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) |
| 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 |
| 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 |
| 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 |
| 111528 | 2023-06-22 2:04 | 2023-06-22 13:27 | MySQL Server | Not a Bug (302 days) | S3 | 8.0.33 | Ubuntu (22.04) | x86 (x86_64) | Count queries cardinality mismatch |
| 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 |
| 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 |
| 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 |
| 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 |
| 81686 | 2016-06-02 10:01 | 2016-07-03 1:00 | MySQL Server: DML | No Feedback (2848 days) | S1 | 5.6.30 | CentOS | Any | COUNT(PRIMARY_KEY) returns 0 with more than one WHERE clause |
| 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 |
| 104411 | 2021-07-25 13:35 | 2021-08-13 15:23 | MySQL Server: DML | Closed (980 days) | S2 | 8.0.26 | MacOS (Mac OS X 10.14) | x86 | No result set returned when using HAVING COUNT(DISTINCT ...) |
| 105648 | 2021-11-21 20:41 | 2021-11-25 13:04 | MySQL Server: DML | Not a Bug (877 days) | S3 | 8.0.15 | Windows | x86 | select count(*) process runs for hours and remains in the list after 'KILL' |
| 71028 | 2013-11-27 21:26 | 2014-02-02 17:38 | MySQL Server: DML | Closed (3748 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 (3803 days) | S2 | 5.1+, 5.5+, 5.6.14, 5.7.2-m12 | Any | Any | count distinct get error result |
| 69590 | 2013-06-26 15:59 | 2018-03-14 20:53 | MySQL Server: DML | Closed (2228 days) | S3 | 5.5.32 | Any | Any | Problem using between with group by functions |
| 52582 | 2010-04-04 3:51 | 2014-08-06 17:47 | MySQL Server: DML | Closed (3957 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 (4376 days) | S2 | 5.5.21 | Any | Any | Incorrect select results when using index and complicated select count(distinct( |
| 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 |
| 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 |
| Showing 1-30 of 51 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
