Showing 1-30 of 43 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
218492006-08-26
10:07
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3942 days)
S55.0.32-BK, 4 and 5, 5.1.42-bzrLinux (linux)Anyselect count distinct has rotten performance on at least versions 4&5 of mysql.
260872007-02-05
15:27
2007-02-05
18:23
MySQL ServerClosed
(5099 days)
S35.0UnixAnyEmpty Result Set Returned When COUNT(), GROUP BY, and WHERE Are Used Together
262092007-02-09
6:47
2007-02-26
20:54
MySQL Server: ViewsClosed
(5078 days)
S25.0.36-BK, 5.0.27Linux (Linux, winXP)Anywrong result using COUNT(DISTINCT ?) querying a VIEW with GROUP BY and ORDER BY
272192007-03-16
15:48
2008-04-07
17:24
MySQL ServerClosed
(4672 days)
S35.0.38Linux (Linux)Anycount(*) in order by
296302007-07-08
19:27
2007-07-09
13:07
MySQL ServerClosed
(4945 days)
S25.0.41-community-ntMicrosoft WindowsAny"group by" doesnt work with subselects
299412007-07-20
19:19
2013-02-20
22:37
Connectors: DBD::mysql ( Perl )Unsupported
(2892 days)
S34.005Any (Sun Solaris 8, Mac OS X)AnyPerl affected row count incorrect for certain cases of ON DUPLICATE KEY UPDATE
304022007-08-14
8:35
2014-03-10
14:31
MySQL Server: DMLVerified
(2969 days)
S25.0.37 CommunityLinux (RedHat 9.0)AnySELECT count(distinct) from mytable return 0
317322007-10-21
1:14
2020-05-03
20:45
MySQL Server: DMLVerified
(4790 days)
S25.0.45Linux (SuSE 10.3 x86_64)Anyrow count(*) overflows after 32-bit integer precision in spite of being bigint
317982007-10-23
19:47
2007-10-23
20:49
MySQL Server: OptimizerNot a Bug
(4839 days)
S35.0.45Linux (Debian)AnyLEFT JOIN query with COUNT() and GROUP BY produces wrong result
323612007-11-14
9:37
2007-11-14
10:22
MySQL ServerCan't repeat
(4817 days)
S25.0.45 Linux (SLES9 SP3)AnyStrange behaviour in counting rows
343602008-02-06
19:06
2008-02-07
0:43
Connector / NETNot a Bug
(4732 days)
S25.1.4.0AnyAnyMySqlDataReader returns zero instead of actual value when doing count(*)
352092008-03-11
12:53
2008-03-19
13:32
MySQL ServerNot a Bug
(4691 days)
S25.0.45Linux (Trustix Secure Linux 3.0 / 2.6.19.2-1trsmp / glibc-2.3.5-10tr)Anymaximum number of threads with MySQL binary RPMs
357452008-04-01
16:21
2008-07-23
12:41
MySQL Server: PartitionsClosed
(4565 days)
S25.1.23AnyAnySELECT COUNT(*) is not correct for some partitioned tables.
376582008-06-26
8:45
2008-06-26
15:38
Connector / JClosed
(4592 days)
S2mysql-connector-java-5.1.6Microsoft WindowsAnybad updated rows count
379052008-07-06
16:19
2008-07-07
18:02
MySQL ServerUnsupported
(4581 days)
S35.0.51aMac OS X (part of XAMPP 0.7.2)AnySELECT COUNT with GROUP BY bug (see #7128)
412832008-12-06
23:05
2019-11-02
13:44
MySQL Server: GeneralClosed
(446 days)
S35.0.67-log, 5.1.30, 6.0.7LinuxAnyWarning count reported to be 1 and 0 at the same time
437772009-03-21
7:54
2009-03-21
15:36
MySQL AdministratorNot a Bug
(4324 days)
S31.2.16Microsoft Windows (XP and Vista 64)AnyProblem with counting rows in MySQL Administrator (INNODB Only)
421742009-01-16
22:46
2011-02-16
23:43
MySQL Server: GeneralDuplicate
(4385 days)
S25.0.67 & 4.1.22LinuxAnySelect count(*) with subquery consuming multi-gigs of memory, 5.0.67 & 4.1.22
425962009-02-04
15:21
2011-02-16
23:43
MySQL Server: OptimizerNo Feedback
(4340 days)
S35.1.30-communityLinux (CentOS release 5.2 (Final))Anyselect count(*)
462832009-07-18
15:22
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0, 5.1, 5.4, 6.0AnyAnyCOUNT() returning bad values when LIMIT 1 clause added to query
463292009-07-22
2:27
2011-02-16
23:44
MySQL Cluster: Cluster (NDB) storage engineVerified
(4201 days)
S25.1.34-ndb-7.0.6-cluster-gplLinux (x86_64)Anyupdate query returns incorrect number of rows matched when no fields are updated
476502009-09-25
16:53
2011-02-16
23:44
MySQL Server: DMLClosed
(3968 days)
S35.0.X, 5.1.39, next-mrAny (Mac OS X Snow leopard, Linux)Anyusing group by with rollup without indexes returns incorrect results with where
530782010-04-22
19:03
2010-04-28
20:32
MySQL Server: GeneralNot a Bug
(3921 days)
S25.1.45-communityMicrosoft WindowsAnySELECT WITH LIMIT PROBLEM
540402010-05-27
19:03
2011-02-16
23:44
Connector / NETClosed
(3860 days)
S2mysql-connector-net-6.3.1-alphaMicrosoft Windows (Windows 7)AnyThe NET connector causes an unhandled exception (TEXT > 32767)
580622010-11-08
20:30
2011-02-16
23:44
MySQL Server: PartitionsDuplicate
(3724 days)
S35.1.41-3, 5.1.54, 5.1, 5.6.99 bzrLinux (ubuntu12.1)AnyResults incorrect after rollback on Partitioned table
624952011-09-22
0:38
2011-09-22
11:18
MySQL Server: DMLNot a Bug
(3409 days)
S25.1.44Mac OS X (10.6.8)AnyDiscrepant results when using UNION and COUNT
641852012-01-31
17:21
2012-02-09
13:54
MySQL Workbench: SQL EditorDuplicate
(3276 days)
S35.2.37Microsoft Windows (XP SP3)AnyCrash using count combined with math operation
650532012-04-20
10:52
2012-04-26
8:53
MySQL Server: DMLCan't repeat
(3192 days)
S25.5.21AnyAnyIncorrect select results when using index and complicated select count(distinct(
677432012-11-28
14:42
2012-11-28
16:45
MySQL ServerNot a Bug
(2976 days)
S25.0.32Linux (Debian)AnyINSERT followed by SELECT on fields not null having a default value
687162013-03-19
10:24
2013-03-19
12:06
MySQL Server: OptimizerDuplicate
(2865 days)
S25.6.10LinuxAnyselect count(distinct N1), count(distinct N2) works incorrectly
  Showing 1-30 of 43 (Edit, Save, CSV, Feed) Show Next 30 Entries »