Showing 1-1000 of 2262 (Edit, Save, CSV, Feed) Show Next 1000 Entries »
The following words were ignored: by
ID# Date Updated Type Status Sev Version Target OS Summary Assigned
335062007-12-25
10:04
2012-05-18
20:19
Tests: ServerDuplicate
(3510 days)
S26.0.56.0Linux (Debian x86_64)crash on stack overrun Assigned Account
332662007-12-16
7:33
2008-04-02
15:41
MySQL Server: TestsClosed
(3547 days)
S25.0.54,5.1.23, 5.1.24-BK, 6.0-BKAnyregression test subselect fails Evgeny Potemkin
564702010-09-01
19:28
2016-10-16
20:45
MySQL Server: Row Based Replication ( RBR )No Feedback
(2626 days)
S15.6.99-m5AnyStop slave at middle of the transaction can cause fatal error  
498432009-12-21
9:59
2015-01-09
14:42
MySQL Cluster: NDB APIWon't fix
(1074 days)
S3mysql-cluster-7.0.6Linuxndb_mgm_get_status() returning invalid node_group information for starting node Magnus Blåudd
175902006-02-20
17:44
2006-02-23
9:32
MySQL Server: OptimizerCan't repeat
(4316 days)
S25.1.7-betaAny (All)Different key-len and # rows reported on all platforms  
220202006-09-05
13:50
2013-10-06
20:45
MySQL Cluster: Disk DataDuplicate
(4122 days)
S15.1Linux (Linux)ndb_dd_<various> tests fail, amd64 Linux Assigned Account
740952014-09-26
8:04
2014-10-27
14:04
MySQL Server: DocumentationClosed
(1148 days)
S3mysql 5.7.5m15Any"MySQL Extensions to GROUP BY" documentation needs update Paul Dubois
290582007-06-12
19:14
2007-06-13
12:14
MySQL Server: TestsCan't repeat
(3841 days)
S35.0.41IBM AIX (5.3)type_float test fails on AIX 5.3 using vac  
806602016-03-08
16:38
2016-03-08
16:52
MySQL Server: OptimizerOpenS45.7AnyMySQL could detect functional dependency on group expressions  
554532010-07-21
18:01
2011-02-16
23:44
MySQL Enterprise Monitor: AgentClosed
(2680 days)
S12.2.2.1729AnyAgent resends the same example query over and over every 2 minutes Jan Kneschke
787492015-10-08
6:25
2015-12-03
14:05
MySQL Server: Group ReplicationClosed
(746 days)
S10.5.0-dmrUbuntu (14.04)Assertion `!flags.finalized' failed with group replication plugin  
729312014-06-10
9:18
2014-09-10
0:35
MySQL FabricClosed
(1195 days)
S31.4.3Linux (CentOS 6.5)mysqlfabric group destroy --force does not work, Error in _destroy_group.  
711992013-12-21
18:16
2014-01-28
17:45
MySQL Server: OptimizerVerified
(1456 days)
S35.6.14, 5.6.15, 5.5.35AnyOptimizer's estimated number of rows is 2 times wrong for (loose?) index scans  
351742008-03-10
0:00
2008-05-28
15:09
MySQL ServerNo Feedback
(3491 days)
S15.0.37Linux (Redhat)Query w/ Many Subqueries and Views Causes Crash  
70422004-12-06
16:29
2004-12-15
13:05
MySQL AdministratorClosed
(4751 days)
S31.0.16Microsoft Windows (Win XP)MySQL Administrator writes mysqladmin_options.xml on exit Mike Lischke
155622005-12-07
21:22
2006-02-14
3:29
MySQL ServerClosed
(4325 days)
S35.0.16Solaris (Solaris 10 / SPARC)Package for Solaris 10 has invalid unix group 'wheel' reference Kent Boortz
857252017-03-31
6:17
2017-04-07
23:00
Tests: Group ReplicationNot a Bug
(255 days)
S35.7.17Microsoft Windowsmysql group replication  
258342007-01-24
16:52
2007-03-13
1:49
MySQL Server: TestsClosed
(3933 days)
S25.0-currentLinux (Linux)Test failure in "func_group" Ramil Kalimullin
813882016-05-12
6:32
2016-05-13
15:32
MySQL Server: OptimizerNot a Bug
(584 days)
S35.6.29Anymin/max optimization ignores group by  
715122014-01-29
15:34
2014-02-28
8:05
MySQL FabricClosed
(1389 days)
S31.4.0AnyServers in the same group should use a single user/password Alfranio Correia
740932014-09-26
7:18
2014-09-30
17:54
MySQL Server: DocumentationClosed
(1175 days)
S35.7.5m15AnyONLY_FULL_GROUP_BY documentation not up to date Paul Dubois
805542016-02-29
9:43
2016-04-26
5:53
MySQL Cluster: Cluster (NDB) storage engineClosed
(628 days)
S37.4.11AnyBinlog schema distribution timeout and fails when another mysql node start  
304772007-08-17
15:12
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3773 days)
S4all, or asapTBDAnyAllow returning unordered result from GROUP BY  
702032013-08-30
16:38
2013-08-31
12:32
MySQL Server: DocumentationNot a Bug
(1570 days)
S35.5.32AnyGROUP BY is consistent with ORDER BY in subquery  
714952014-01-27
20:34
2016-10-27
8:30
MySQL Server: ReplicationVerified
(1112 days)
S35.6.14AnyLogging of MTS breakage is insufficient.  
620532011-08-02
4:14
2011-08-02
4:22
MySQL Server: DMLNot a Bug
(2330 days)
S15.5Anycolumns in SELECT clause not affected by group fn must be declared in GROUP BY  
781832015-08-24
9:01
2015-09-01
8:37
MySQL Server: DMLNot a Bug
(839 days)
S35.6.22AnySimilar query with aggregate functions returns inconsistent result  
710972013-12-05
18:26
2014-08-01
15:55
MySQL Server: OptimizerClosed
(1291 days)
S25.1.70, 5.5.33, 5.5.35, 5.6.14, 5.6.15AnyWrong results for a simple query with GROUP BY  
852212017-02-28
8:51
2017-07-11
11:44
MySQL Server: PackagingClosed
(160 days)
S35.7.17Red HatGroup Replication : Error while adding instance in group.  
307322007-08-30
19:03
2007-09-30
19:09
MySQL Server: CompilingNo Feedback
(3732 days)
S25.0.32Microsoft Windows (XP Professional)Really long query can't handle use of GROUP function  
752872014-12-22
13:44
2015-03-30
15:58
Connector / PythonClosed
(1028 days)
S12.0AnyPython does not work with HASH sahrding in MySQL Fabric Peeyush Gupta
223162006-09-13
15:49
2006-10-26
17:22
MySQL Cluster: Cluster (NDB) storage engineNo Feedback
(4071 days)
S15.0.24aLinux (CentOS 4.4 x86_64)Four-node cluster loses Node Group 1  
6182003-06-06
22:46
2003-07-03
5:51
MySQL ServerClosed
(5282 days)
S24.0.12Microsoft Windows (Windows NT)UNION clause does not work properly.  
3942003-05-07
20:59
2003-05-09
13:23
MySQL Server: MyISAM storage engineClosed
(5337 days)
S24.0.12Microsoft Windows (Win 2000/ 98)Creating table  
303932007-08-13
16:27
2007-10-09
0:53
MySQL Server: OptimizerClosed
(3723 days)
S35.1.23IBM AIX (5.2, only 32 bit)Test "group_by" fails with a difference in "row count" and strategy (explain) Georgi Kodinov
163412006-01-10
14:23
2006-06-28
5:49
MySQL Cluster: Disk DataClosed
(4191 days)
S35.1.5-alphaLinux (Linux)DD: Failed CREATE LOGFILE GROUP/TABLESPACE should back out all changes Jonas Oreland
578152010-10-28
14:52
2012-05-18
20:19
MySQL Enterprise Monitor: WebVerified
(2608 days)
S32.3.0.2036AnyThere was a problem generating the Support Report for Group "". Assigned Account
685682013-03-05
3:17
2017-07-19
15:42
MySQL Server: ReplicationVerified
(1495 days)
S35.6.10Linux (CentOS 5.8 X64)Stop Slave statement will timeout not waiting the event group complete  
494322009-12-03
22:25
2011-02-16
23:44
MySQL Workbench: ModelingClosed
(2799 days)
S25.2.10 BetaWB52Linux (mysql-workbench-oss-5.2.10-1ubu804-amd64.deb)Routines SQL not updated if new Routine Group opened in editor Maksym Yehorov
20852003-12-10
14:00
2003-12-11
14:24
MySQL ServerCan't repeat
(5121 days)
S24.1.1Microsoft Windows (Windows 2000 sp6)InnoDB MySQL crashes when doing certain nested subqueries Dean Ellis
346592008-02-19
10:36
2008-03-11
12:01
MySQL Server: ErrorsNot a Bug
(3569 days)
S35.0+AnyUnexpected error & wrong msg.: 1054: Unknown column '...' in 'having clause' Evgeny Potemkin
336552008-01-03
16:06
2008-07-31
17:19
MySQL Server: DocumentationClosed
(3427 days)
S3AnyUDF documentation is unclear on pre-5.0 and 5.0 differences Paul Dubois
367982008-05-19
13:05
2008-06-12
15:33
MySQL Server: DocumentationClosed
(3476 days)
S25.1.23/5.1.24Anyaggregate functions with columns and aggregate functions works (shouldn't?)  
831362016-09-24
15:47
2016-11-18
1:00
MySQL Server: C API (client library)No Feedback
(396 days)
S35.7.15Anyfor libmysql the [client] group may be read twice Chiranjeevi Battula
785342015-09-23
17:29
2015-09-23
20:44
MySQL Server: DMLCan't repeat
(817 days)
S3AnyDifferent results are coming when ran a same Query in two different applications  
578332010-10-29
8:05
2012-05-18
20:19
MySQL Enterprise Monitor: WebOpenS32.3.0.2036AnyMEM Dashboard: You must log in to access the requested resource... Assigned Account
286912007-05-25
20:16
2007-08-23
16:42
MySQL Server: OptimizerNot a Bug
(3770 days)
S35.1.18AnyGROUP BY optimization ignores functional dependency on unique/primary key Martin Hansson
711912013-12-20
15:30
2013-12-20
20:20
MySQL Server: OptimizerVerified
(1459 days)
S35.5.33AnyLoose index scan is used even though full table scan/tight index scan is faster  
77182005-01-06
21:59
2014-03-13
13:33
MySQL Cluster: Cluster (NDB) storage engineWon't fix
(4725 days)
S34.1.9Linux (Fedora Core 1)NDB Fails On Loading Complex Data Warehouse Assigned Account
49072004-08-05
9:23
2004-08-08
1:03
MySQL ServerClosed
(4880 days)
S4anyAny (any)feature request - SQL extensions  
289772007-06-08
14:35
2007-06-08
14:46
MySQL Server: GeneralNot a Bug
(3846 days)
S25.0.37, 5.0.22Anycannot change the group mysqld runs as Magnus Blåudd
167382006-01-24
1:46
2006-01-26
0:45
MySQL Cluster: Cluster (NDB) storage engineClosed
(4344 days)
S15.1.6-alphaLinux (Linux)DD: Cluster does not handle running out of space in disk data file Jonas Oreland
845872017-01-20
13:43
2017-06-01
16:21
MySQL Server: OptimizerClosed
(209 days)
S28.0AnyWL#9236: including or excluding columns from SELECT list makes results wrong  
420942009-01-13
23:01
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3192 days)
S35.15.6+AnyOptimizer chooses a wrong index when group by, order by and limit is present  
566902010-09-09
13:30
2011-03-24
22:51
MySQL Server: OptimizerClosed
(2461 days)
S35.0, 5.1, 5.5AnyWrong results with subquery with GROUP BY inside < ANY clause Ole John Aske
551882010-07-12
21:01
2011-02-16
23:44
MySQL Server: DMLClosed
(2621 days)
S25.1.46sp15.1+AnyGROUP BY, GROUP_CONCAT and TEXT - inconsistent results Georgi Kodinov
623722011-09-07
11:48
2016-03-03
13:16
MySQL Server: DMLVerified
(2294 days)
S35.5.15, 5.5.17AnyWrong query results with SQL_CALC_FOUND_ROWS, GROUP BY, LIMIT and Using index  
728712014-06-04
12:08
2014-06-16
9:42
MySQL FabricNot a Bug
(1281 days)
S41.4.3Linux (CentOS 6.5)mysqlfabric changes slave connection to master and breaks replication.  
775082015-06-26
14:12
2016-04-27
15:05
MySQL Server: ReplicationClosed
(902 days)
S35.7.8AnyUpdate new rpl tests to work with Group Replication  
191412006-04-17
15:43
2006-04-23
1:15
MySQL Cluster: Cluster (NDB) storage engineClosed
(4257 days)
S25.1.10Linux (Linux 32 Bit OS)DD: CREATE LFG during DROP of a NDB table cause DN failure and corruption Jonas Oreland
644542012-02-25
20:49
2012-02-28
10:12
MySQL Workbench: ModelingVerified
(2121 days)
S45.2.37, 5.2.38AnyRoutine Groups Can Not Be Resized  
545152010-06-15
14:14
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2585 days)
S15.5.5-m3-Celosia, 5.6.99-Dahlia, 6.0.145.5+AnyCrash in opt_range.cc::get_best_group_min_max on SELECT from VIEW with GROUP BY Jørgen Løland
35872004-04-28
12:30
2004-05-02
18:14
MySQL ServerClosed
(4978 days)
S25.0.0alphaMicrosoft Windows (WinXP)Server crushes after executing query with connecting two subquery on two fields  
798752016-01-08
2:05
2016-02-20
1:00
MySQL Enterprise MonitorNo Feedback
(668 days)
S33.1.1.7806CentOSone random server missing from group while assigning assets in event handler  
873002017-08-03
10:18
2017-11-09
11:24
MySQL Server: Shell ( Core Client )Closed
(39 days)
S2mysqlsh Ver 1.0.10 for Linux on x86_64Anymysql-shell dba.checkInstanceConfiguration()  
171572006-02-06
14:53
2006-03-08
2:22
MySQL Server: InstallingClosed
(4303 days)
S35.0.17a-certSolaris (Solaris10)pkg install on Solaris doesn't reject a user 'mysql' in group 'mysql2' Kent Boortz
783492015-09-06
12:12
2015-12-03
14:22
MySQL Server: DMLClosed
(746 days)
S35.6.22, 5.6.26Anyw/ ONLY_FULL_GROUP_BY, having/order by + column alias have different results  
48852004-08-04
2:16
2011-02-16
23:42
MySQL Server: OptimizerNo Feedback
(3241 days)
S44.1.3Microsoft Windows (windows)combining subqueries with group by  
156432005-12-09
18:42
2006-09-06
19:12
MySQL Server: DocumentationClosed
(4121 days)
S25.0.15/5.0.18 BK/5.0.22Any (All)Can't group on calculated field aliased as other field Paul Dubois
77332005-01-07
16:36
2005-01-07
23:09
MySQL Cluster: Cluster (NDB) storage engineNot a Bug
(4728 days)
S34.1.9Linux (Fedora Core 1)[mysql_cluster] section connect-string confusion Tomas Ulin
317982007-10-23
19:47
2007-10-23
20:49
MySQL Server: OptimizerNot a Bug
(3709 days)
S35.0.45Linux (Debian)LEFT JOIN query with COUNT() and GROUP BY produces wrong result  
108152005-05-24
7:36
2012-03-26
19:34
MySQL Server: OptimizerClosed
(2093 days)
S24.1.12Linux (Linux)Sub-queries failure when using GROUP BY Roy Lyseng
487032009-11-11
21:58
2011-02-16
23:44
MySQL Server: OptimizerIn progress
(2751 days)
S35.0+Anynontrivial ORDER/GROUP BY expressions: ambiguous statements not detected Gleb Shchepa
784022015-09-11
2:23
2015-09-11
4:15
MySQL Server: ParserDuplicate
(829 days)
S35.6.22AnyGROUP BY with expression fails (should succeed)  
510172010-02-09
9:07
2010-02-13
19:12
MySQL Server: OptimizerNot a Bug
(2865 days)
S36.0-codebase-bugfixingAnyBatched key access gives wrong results for SELECT with LEFT JOIN, GROUP BY Evgeny Potemkin
423222009-01-24
15:46
2009-01-24
15:56
MySQL ServerNot a Bug
(3250 days)
S25.1.30Microsoft Windows (SP3)5.1.30-community allows mixing of group and no group columns without group by  
200522006-05-24
19:15
2012-05-18
20:19
MySQL Cluster: Disk DataDuplicate
(4218 days)
S35.1.12Linux (Linux 32 Bit OS)Failure of CREATE TABLE SPACE should rollback TS name from cluster db  
128852005-08-30
16:05
2005-09-15
19:12
MySQL Server: OptimizerClosed
(4477 days)
S34.1.14, 5.0.11FreeBSD (freebsd, Windows)rollup / subquery and creat table, causes incorrect cannot be null Igor Babaev
807262016-03-14
10:49
2016-11-19
16:27
MySQL Server: OptimizerClosed
(397 days)
S35.7AnyGROUP BY on derived table, expression of aggregate and group column: error  
784242015-09-14
2:29
2015-09-14
10:50
MySQL Server: DMLCan't repeat
(826 days)
S35.7.7Anyw/ c1&&c2 appears in select list, group by clause and order by clause, SQL fails  
151982005-11-23
19:58
2006-03-24
7:52
MySQL Server: OptimizerNot a Bug
(4287 days)
S35.0.16-ntMicrosoft Windows (Windows 2000)Dropping then adding an index changes group by optimization behaviour Georgi Kodinov
817602016-06-07
20:27
2016-08-09
14:52
MySQL Cluster: Cluster (NDB) storage engineClosed
(553 days)
S37.5.2AnyRename RealFragment to Partition in Ndb kernel code.  
36862004-05-07
12:24
2004-05-12
16:18
MySQL ServerClosed
(4968 days)
S34.1.2 prepared statement, union + group by, inconsistent behaviour during prepare Oleksandr Byelkin
876702017-09-05
9:32
2017-09-06
7:54
MySQL Server: OptimizerVerified
(103 days)
S35.7.18, 5.6.37, 5.7.19AnyForce index for group by is not always honored  
421162009-01-14
15:35
2011-02-16
23:43
MySQL Server: OptimizerClosed
(2922 days)
S15.0.68 entreprise/5.15.0+Linux (RHEL 5 x86_64)Mysql crash on specific query Georgi Kodinov
400942008-10-16
22:59
2009-02-04
10:29
MySQL Server: DDLNot a Bug
(3239 days)
S45.1LinuxAllow group read/write/execute at filesystem on database create  
587822010-12-07
10:46
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2531 days)
S3bzr_WL1393AnyMissing rows with SELECT .. WHERE .. IN subquery with full GROUP BY and no aggr Tor Didriksen
234622006-10-19
13:42
2007-06-14
14:21
MySQL ServerNot a Bug
(3840 days)
S3mysql 5.0AnyGroup BY and MAX not selecting MAX result  
198832006-05-17
13:58
2006-08-16
8:49
MySQL Cluster: Disk DataCan't repeat
(4142 days)
S15.1Linux (Linux)ndbd seg fault with gcc 4.0.2  
117042005-07-02
18:52
2011-02-16
23:43
MySQL Server: OptimizerClosed
(2738 days)
S25.0.9, 4.1Linux (Linux/x86)Found locks from different threads in write -> crash with OPTIMIZE table?  
94012005-03-25
9:04
2005-04-07
2:05
MySQL ServerClosed
(4638 days)
S34.1Linux (linux)type_timestamp segfaults mysqld Ramil Kalimullin
347512008-02-21
22:19
2011-02-16
23:43
MySQL Server: DMLVerified
(3588 days)
S35.0+AnyInside HAVING clause subqueries with aggregates and without GROUP BY rise error Evgeny Potemkin
191362006-04-17
9:23
2006-05-13
4:45
MySQL Server: ReplicationClosed
(4237 days)
S24.1.18,5.0.19, 5.0.20, 5.0-bkLinux (RHEL4, Windows)Crashing log-bin and uninitialized user variables in a derived table Andrei Elkin
787852015-10-09
12:54
2017-10-24
14:32
MySQL Server: OptimizerClosed
(180 days)
S35.7.9AnyGrouping on aggregated results not always rejected  
544812010-06-14
11:10
2012-10-15
13:43
MySQL Server: OptimizerClosed
(1890 days)
S25.1-bzr, 5.6.99-m4, mysql-next-mr-opt-backportingAnyGROUP BY loses effect with JOIN + ORDER BY + LIMIT and join caching Guilhem Bichot
452672009-06-02
13:01
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2583 days)
S35.45.4+AnyGROUP BY does not group NULLs on certain JOINs Evgeny Potemkin
222282006-09-11
5:23
2006-09-14
12:28
MySQL ServerCan't repeat
(4113 days)
S15.0.xLinux (Linux)Group by with join, view and concat gives wrong answer  
491112009-11-25
20:11
2012-08-30
14:32
MySQL Server: OptimizerClosed
(1936 days)
S35.5.0-beta, 5.15.5+AnyChange in execution plan for count_distinct_group_on_key causes peformance drop  
278852007-04-17
15:13
2011-02-16
23:43
MySQL Server: Command-line ClientsVerified
(3666 days)
S35.0.38Anycommand line clients puke on 'init-command' in my.cnf  
458092009-06-28
15:18
2011-02-16
23:44
MySQL Server: DocumentationClosed
(3040 days)
S35.1.35-community,5.1.36-communityMicrosoft Windows (XP Pro)Use "COUNT()" without "GROUP BY" has no error message Paul Dubois
92102005-03-15
22:14
2005-04-20
1:44
MySQL Server: OptimizerClosed
(4625 days)
S35.0Linux (SuSE Linux 9.1)Server crash with a simple query with GROUP BY Igor Babaev
657982012-07-03
15:16
2012-11-14
20:54
MySQL Server: DMLClosed
(1860 days)
S35.5.26AnyONLY_FULL_GROUP_BY documentation doesn't mention implicit group by  
248382006-12-05
20:59
2006-12-05
21:27
MySQL ServerNot a Bug
(4031 days)
S35.0.22-standardLinux (linux)group by compares strings case-insensitively  
786002015-09-28
9:44
2015-12-11
15:22
MySQL Server: Group ReplicationNo Feedback
(738 days)
S10.5.0-dmrUbuntu (14.04)Compiling group replication plugin will fail because of boost_1_58_0 package  
335552007-12-28
15:00
2008-10-10
13:09
MySQL Server: PartitionsClosed
(3356 days)
S25.1.26RC5.1.29+Linux (CENTOS5.2)Group By Query does not correctly aggregate partitions Mattias Jonsson
248602006-12-06
18:17
2007-11-28
19:03
MySQL Server: ReplicationClosed
(3673 days)
S35.1.125.1+AnyIncorrect SLAVE_TRANSACTION_RETRIES code can result in slave stuck Mats Kindahl
763192015-03-13
19:36
2017-07-06
19:19
MySQL FabricWon't fix
(1008 days)
S41.5AnyMySQL Fabric Service - Monitoring from external monitoring software  
284492007-05-15
15:50
2007-06-14
19:26
MySQL Server: GeneralClosed
(3840 days)
S25.0, 5.1.19AnyServer crashes on closing a temporary table after SELECT ... GROUP BY Igor Babaev
832392016-10-02
4:16
2016-10-06
21:28
MySQL Server: OptimizerNot a Bug
(438 days)
S35.7.15-0ubuntu0.16.04.1Ubuntu (16.04)Inconsistent nonaggregated field in SELECT not in GROUP BY  
840082016-11-29
18:24
2017-11-08
10:21
MySQL Server: Group ReplicationClosed
(262 days)
S38.0.1AnyGR+MTS: ER1755 can be improved for MTS LC -> MTS DATABASE  
356282008-03-28
1:41
2011-02-16
23:43
MySQL Server: DocumentationClosed
(3332 days)
S35.0.52Any5.0.52+ undocumented incompatible change in default GROUP BY behavior Paul Dubois
341022008-01-28
12:53
2011-02-16
23:43
MySQL Cluster: Disk DataClosed
(3224 days)
S35.1.23 ndb 6.3.7; ndb 6.3.13LinuxCreating LOGFILE group crashes cluster Jonas Oreland
720032014-03-11
7:55
2014-03-11
11:04
MySQL ServerCan't repeat
(1378 days)
S15.6.12Linux (openSuse 13.1)Query fails JOIN in case of use of GROUP BY  
202932006-06-06
13:12
2007-03-15
3:10
MySQL ServerClosed
(3931 days)
S24.1-BK, 5.0-BK, 4.1.20 and 5.0.22Any (*)group by cuts off value from time_format Alexey Kopytov
315592007-10-12
9:23
2007-10-12
17:57
MySQL Server: TestsClosed
(3720 days)
S25.0.505.0+Any"group by" changed the implicit ordering Matthias Leich
717622014-02-18
15:51
2014-02-26
9:49
MySQL Enterprise Monitor: InstallingVerified
(1391 days)
S43.0.6AnyAllow the agent installer to hint at the replication group name  
814942016-05-19
3:22
2017-02-02
14:47
MySQL Server: mysqldump Command-line ClientVerified
(353 days)
S45.7.10, 5.7.17Anymysqldump can't get all databases backup with Group Replication  
300392007-07-25
13:35
2011-02-16
23:43
MySQL Server: DMLVerified
(3799 days)
S4AnyAdd "Using group-by" to Extra column in EXPLAIN output  
648552012-04-03
14:53
2012-05-16
13:20
MySQL Server: Stored RoutinesVerified
(2042 days)
S25.5.21, 5.6.5-m8, 5.1.64, 5.6.6, 5.5.25, 5.5.20-ndb-7.2.5AnyStored Procedure with GROUP/ORDER BY return unpredicatable results with CASE/IF  
484722009-11-02
13:39
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2838 days)
S35.0.88, 5.1.415.0+AnyLoose index scan inappropriately chosen for some WHERE conditions Alexey Kopytov
241562006-11-09
21:59
2006-12-14
4:26
MySQL Server: OptimizerClosed
(4022 days)
S55.0.30-BK, 5.0.28Linux (Linux, Mac OS X)Loose index scan not used with CREATE TABLE ...SELECT and similar statements Georgi Kodinov
228812006-10-02
8:43
2006-10-24
9:05
MySQL Cluster: Disk DataNot a Bug
(4073 days)
S35.1.11Linux (ubuntu dapper drake linux)CREATE LOGFILE GROUP ADD UNDOFILE incompatible with local datanodes  
54782004-09-08
16:07
2004-11-24
18:15
MySQL ServerNot a Bug
(4772 days)
S34.1.3 betaLinux (Linux (2.4.x) (Mandrake 9.2))order by sum(xxx) fails but order by N on selected sum(xxx) works  
582182010-11-16
7:23
2011-02-16
23:44
Connector / NETDuplicate
(2589 days)
S16.3.4Any"Key" groupped by cannot be used in linq2e, group by subquery cannot be executed  
44602004-07-08
13:41
2011-02-16
23:42
MySQL Server: OptimizerVerified
(4608 days)
S44.1.3 BetaMicrosoft Windows (Win2k/linux/AIX)Query having subqueries (having group by clause) take too much of time  
333912007-12-20
5:38
2008-01-20
11:38
MySQL Server: ParserNo Feedback
(3620 days)
S2Mysql 5.0.45Linux INSERT into table SELECT fields from table2 giving inconsistent/corrupt data  
802412016-02-02
19:35
2016-08-02
19:31
MySQL Server: Group ReplicationClosed
(503 days)
S30.7.0-labsCentOS (el7-x86-64bit)Starting group replication causes MySQL to crash with sig 6 with selinux  
459402009-07-03
14:58
2011-02-16
23:44
MySQL Server: ReplicationClosed
(3066 days)
S35.1+5.4+Anyissues around rli->last_event_start_time Andrei Elkin
234172006-10-18
10:04
2007-02-13
19:03
MySQL ServerClosed
(3961 days)
S35.0.27-BK, 5.0.24aLinux (Linux, opensuse 10.0)(ONLY_FULL_GROUP_BY) function of aggregate is still an aggregate [S3/S2] Evgeny Potemkin
334172007-12-20
19:38
2011-02-16
23:43
MySQL Server: GeneralNo Feedback
(2962 days)
S35.0.46, 5.0.52Microsoft Windowsgroup by 3 columns with MAX() produces incorrect results  
887172017-11-30
14:10
2017-12-01
6:47
MySQL Server: DocumentationVerified
(17 days)
S35.7.19AnyMySQL Group Replication Large Transactions Limit  
331702007-12-12
15:45
2008-07-30
13:14
MySQL Server: DocumentationClosed
(3428 days)
S36.0.5AnyNew CREATE TABLESPACE behavoir with Falcon MC Brown
306122007-08-24
0:42
2008-07-24
12:54
MySQL Enterprise Monitor: WebClosed
(3434 days)
S31.2.0.72142.0AnyRename "remove all from group" to "delete group"  
746462014-10-31
9:51
2014-10-31
10:27
MySQL Server: DMLVerified
(1144 days)
S35.6.20-debug, 5.6.22, 5.7.6Linux (CentOS 7)Assertion `((Item_result_field*)item)->result_field' failed in create_tmp_field  
27132004-02-11
13:33
2004-02-23
7:05
MySQL ServerCan't repeat
(5047 days)
S24.1.1Solaris (Solaris 2.8)SELECT on derived table with no outer GROUP BY causes sig11  
603152011-03-03
14:03
2013-01-15
14:40
MySQL Server: OptimizerNot a Bug
(1798 days)
S55.1.51, 5.5.8LinuxSlow ORDER BY function() if using GROUP BY  
75962004-12-30
21:51
2004-12-31
1:47
MySQL Server: MyISAM storage engineNot a Bug
(4735 days)
S14.1.8ntMicrosoft Windows (Win2k)group by function returning diverse column values for a row in a group  
851642017-02-24
9:31
2017-11-08
10:22
MySQL Server: Group ReplicationClosed
(91 days)
S35.7.18AnyGR SHOULD BLOCK OPERATIONS ON NON-COMPLAINT TABLES IN GR+ASYNC SETUP  
869562017-07-05
12:04
2017-08-25
10:48
MySQL Server: Group ReplicationVerified
(165 days)
S35.7.18AnyJoining group timeout on permissions error  
293602007-06-26
13:49
2007-07-27
4:52
MySQL ServerClosed
(3797 days)
S34.1, 5.0, 5.1AnySELECT aggregate function GROUP BY enum returns incorrect result Gleb Shchepa
751882014-12-12
2:47
2017-07-06
19:19
MySQL FabricWon't fix
(1099 days)
S31.5.3Linux (3.10.0-123.el7.x86_64)MySQLFabric doesn't work properly with Application User that has SUPER privilege  
455042009-06-15
15:11
2016-01-20
15:47
MySQL Enterprise Monitor: WebClosed
(698 days)
S42.1.0.1060AnySupport batch add-to-group on Manager servers' tab Assigned Account
831422016-09-25
18:38
2017-02-11
14:38
MySQL Server: DocumentationClosed
(310 days)
S35.7.15AnyDocumentation clarifications about how default option files are used  
746952014-11-05
5:25
2017-08-14
1:50
MySQL Server: DMLClosed
(932 days)
S35.6.20-debug, 5.6.22, 5.7.6Linux (CentOS 7)Asser tion `args[0]->fixed' failed | sig 6 abort in sql/item_strfunc.h:882  
17392003-11-03
2:18
2003-11-18
3:22
MySQL ServerWon't fix
(5144 days)
S34.0.16FreeBSD (FreeBSD 4.8)Strange results when using @vars with GROUP BY Sergei Golubchik
864752017-05-26
10:51
2017-08-16
18:12
MySQL Server: OptimizerVerified
(202 days)
S45.7.18AnyError with functions and group by with ONLY_FULL_GROUP_BY  
718912014-02-28
20:27
2014-03-05
20:37
MySQL Server: OptimizerNot a Bug
(1384 days)
S35.6.15AnyGROUP BY performance differs wildly for tautologically equal columns  
711252013-12-11
8:38
2013-12-13
1:54
MySQL FabricClosed
(1466 days)
S31.4.0AnyA server must belong to a single group Alfranio Correia
480892009-10-15
15:41
2012-05-18
20:19
MySQL Cluster: Disk DataIn progress
(2840 days)
S3mysql-5.1-telco-7.0AnyCan't change UNDO_BUFFER_SIZE with ALTER LOGFILE GROUP ... Assigned Account
373442008-06-11
13:59
2008-09-30
20:08
MySQL Server: Falcon storage engineClosed
(3366 days)
S16.0-falcon6.0.6AnyCrash in IndexWalker::rebalanceDelete Ann Harrison
107222005-05-18
22:05
2007-02-19
23:07
MySQL Server: OptimizerClosed
(3955 days)
S54.1.11Linux (linux)SELECT .. MAX(t1.b) .. GROUP BY t2.a .. ORDER BY t1.b should not use filesort  
109842005-05-31
14:11
2005-07-19
12:37
MySQL Server: InstallingClosed
(4535 days)
S34.0.20-0Linux (CentOS 3.4)install fails if group mysql exists but not user Lenz Grimmer
309532007-09-11
13:05
2007-10-29
12:10
MySQL Server: Data TypesNot a Bug
(3703 days)
S36.0.2-alpha, 5.0.48Microsoft Windows (XP 64-bit)suspicious results from LOG(B,X) functions Alexey Botchkov
678212012-12-05
22:37
2013-01-07
1:00
MySQL Server: DMLNo Feedback
(1807 days)
S35.5.28Microsoft Windows (7 Ultimate 64bit)GROUP BY not working in stored procedure  
711492013-12-16
9:37
2014-08-06
17:44
MySQL Server: OptimizerClosed
(1301 days)
S35.6.15, 5.7.3-m13AnyAssertion `((Item_result_field*)item)->result_field' fails in create_tmp_field  
294212007-06-28
13:43
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3826 days)
S25.1.14-beta/5.0AnyMySQL allows mixing of GROUP columns with no GROUP columns in complex terms  
680792013-01-14
12:01
2014-02-28
6:40
MySQL Server: InnoDB storage engineClosed
(1432 days)
S25.5.29, 5.6.9-rc5.6Linux (x86_64)InnoDB does not scale well on 12 core system for specific all in memory SELECT Arnaud Adant
373622008-06-12
11:30
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3059 days)
S16.0-falcon, 5.0, 5.1, 6.0 bzr5.1.36, 5.0.82AnyCrash in do_field_eq Gleb Shchepa
463282009-07-21
20:54
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2583 days)
S36.06.0AnyUse of aggregate function without GROUP BY clause returns many rows (vs. one ) Jørgen Løland
660452012-07-27
10:28
2012-08-28
1:00
MySQL Cluster: Cluster (NDB) storage engineNo Feedback
(1939 days)
S25.5.22-ndb-7.2.6Other (debian 5 (2.6.26-2-amd64))5.5.22-ndb-7.2.6 CREATE LOGFILE GROUP failed  
128032005-08-25
13:24
2013-06-17
14:31
MySQL ServerClosed
(1645 days)
S4nextAny (all)selecting a consistent row of aggrigate data during a group Matt Lord
143432005-10-26
18:25
2005-12-10
11:45
MySQL ServerClosed
(4391 days)
S2mysql 4.1.14, php 5.0.4Linux (Linux RH4)mysqli php-extension Andrey Hristov
194632006-05-01
18:48
2006-05-01
19:58
MySQL ServerNot a Bug
(4249 days)
S25.xMicrosoft Windows (windows)Bug in executing SQL scripts that has a key named Group  
302192007-08-03
3:40
2007-08-25
16:19
MySQL Server: MyISAM storage engineClosed
(3768 days)
S25.0 (all)AnyGROUP BY with DISTINCT broken with BIT type in MyISAM in many cases Igor Babaev
379052008-07-06
16:19
2008-07-07
18:02
MySQL ServerUnsupported
(3451 days)
S35.0.51aMac OS X (part of XAMPP 0.7.2)SELECT COUNT with GROUP BY bug (see #7128)  
100052005-04-19
17:40
2006-01-09
14:46
EventumClosed
(4361 days)
S3currentAny (All)RFE - security patch, to prevent plaintext passwords in config files from leaki  
289502007-06-07
15:22
2007-06-07
18:11
MySQL Server: OptimizerCan't repeat
(3847 days)
S35.0.40, 5.0.41Linux (x86, x86-64)Using EXISTS and a GROUP BY incorrectly yields no results  
128232005-08-26
7:29
2005-10-19
15:00
MySQL ServerClosed
(4443 days)
S3MySQL-server-4.1.14-0.i386.rpmLinux (SuSE 8.1 (2.4.21-273-default))RPM Installation does not change group of existing mysql user during upgrade Lenz Grimmer
212712006-07-25
11:07
2006-09-01
15:11
MySQL Cluster: Cluster (NDB) storage engineClosed
(4126 days)
S15.1.11Linux (RHEL-ES4 (Nahant))2 Node cluster can't recover from bringing one node down Jonas Oreland
292092007-06-19
12:54
2007-08-01
12:21
MySQL Server: OptimizerNot a Bug
(3792 days)
S35.0.44/5.1BKAnyLoose index scan is not used if key parts are in different order in the GROUP BY Martin Hansson
724742014-04-28
17:42
2014-04-29
14:00
MySQL ServerNot a Bug
(1329 days)
S25.5.35Linux (Debian 5.5.35-0+wheezy1-log)Query crash when selecting fixed value column on group by  
161542006-01-03
14:52
2006-02-13
17:42
MySQL Cluster: Cluster (NDB) storage engineClosed
(4326 days)
S35.1Linux (Linux)DD: Duplicate LOGFILE GROUP creates results in error unkown by perror Nikolay Grishakin
135952005-09-29
6:23
2005-09-29
12:19
MySQL ServerClosed
(4463 days)
S15.0.13Microsoft Windows (WIN-NT2003)MySQL server crashes when querying view with group by.. having clause  
151312005-11-22
11:44
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3184 days)
S44.1,5.0AnyOn-disk temporary tables created for GROUP BY should use indexes  
161582006-01-03
17:11
2006-02-13
20:24
MySQL Cluster: Cluster (NDB) storage engineClosed
(4326 days)
S25.1Linux (Linux)DD: ALTER TABLESPACE fails if Duplicate CREATE TABLESPACE done before Nikolay Grishakin
860472017-04-23
7:58
2017-05-02
17:23
MySQL Server: Query CacheClosed
(230 days)
S25.6,5.7,8.0, 5.6.365.6,5.7.8.0AnyFROM sub query with 'group by' is cached by mistake  
394552008-09-15
15:01
2011-02-16
23:43
MySQL Server: ParserVerified
(3239 days)
S45.0.51a-3ubuntu5.1AnyWould be useful to ORDER BY arithmetic expressions on GROUP BY columns  
786272015-09-29
16:45
2015-10-08
4:50
MySQL Server: Group ReplicationNot a Bug
(802 days)
S10.5.0-dmrCentOS (6.4)Segmentation fault after running START GROUP_REPLICATION on Oracle Linux 6  
476522009-09-25
17:39
2009-09-25
17:49
MySQL ServerNot a Bug
(3006 days)
S35.1 comunity serverLinuxsub query and grouping results  
806822016-03-10
8:44
2016-03-10
11:50
MySQL Server: DMLVerified
(648 days)
S35.7.8, 5.7.11AnyInconsistent behavior with GROUP BY alias, w/ different sequence in select list  
44022004-07-04
8:21
2011-02-16
23:42
MySQL Server: OptimizerVerified
(3363 days)
S44.1, 5.1.28, 6.0.6Any (all)Equivalence is not considered in group by and order by  
248862006-12-07
13:41
2011-02-16
23:43
MySQL Server: Data TypesClosed
(2685 days)
S25.0.27Linux (Linux)Wrong data type in the resultset if using GROUP BY and CONCAT Alexander Barkov
850472017-02-17
11:03
2017-07-17
12:30
MySQL Server: Group ReplicationClosed
(189 days)
S25.7.18AnySecondaries allows transactions through ASYNC setup into the group  
205362006-06-19
13:36
2006-09-25
15:00
MySQL Server: CharsetsClosed
(4102 days)
S35.0.23BK, 4.1Any (*)md5() with GROUP BY and UCS2 return different results on myisam/innodb Timothy Smith
801862016-01-28
13:15
2016-01-28
13:54
MySQL Server: DMLNot a Bug
(690 days)
S35.5.38-logMicrosoft Windowsthe group by colunm is trimed when do group by  
346202008-02-16
17:16
2008-03-15
8:41
MySQL Server: DMLClosed
(3565 days)
S35.0+, 5.0.58-BK5.0+Anyitem_row.cc:50: Item_row::illegal_method_call(const char*): Assertion `0' failed Gleb Shchepa
161932006-01-04
16:21
2006-01-20
16:05
MySQL Cluster: Cluster (NDB) storage engineClosed
(4350 days)
S15.1Linux (Linux)DD: drop logfile group corrupts NDB File system and cause NDBD crash Jon Stephens
218282006-08-25
8:50
2006-09-25
11:42
MySQL ServerNo Feedback
(4102 days)
S15.0.16Linux (redhat )Wrong results when select using "into variable" with group by in stored procedur Godofredo Miguel Solorzano
223422006-09-14
12:37
2006-10-26
3:14
MySQL ServerClosed
(4071 days)
S25.0.22-pro-nt-log No results returned for query using max and group by Georgi Kodinov
425672009-02-03
12:39
2011-02-16
23:43
MySQL Server: GeneralClosed
(3197 days)
S25.1.30-community-log5.1+Microsoft Windows (2003)Invalid GROUP BY error Bernt Johnsen
827642016-08-28
14:02
2017-11-24
14:48
MySQL ServerCan't repeat
(24 days)
S25.17FreeBSD[Regression] MySQL server corrupts install if mysql user exists in FreeBSD  
433422009-03-03
21:54
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3212 days)
S25.1, 6.0AnyFORCE INDEX hint does not differentiate between ORDER BY and GROUP BY  
149272005-11-14
16:30
2006-05-10
16:28
MySQL ServerClosed
(4240 days)
S14.1.12aMicrosoft Windows (Windows XP)HAVING ignores conditions Igor Babaev
720162014-03-12
4:15
2014-03-26
4:12
MySQL FabricClosed
(1363 days)
S2LinuxAutomatic Failover is not happening when global group master is failed  
784172015-09-12
9:48
2015-09-14
11:44
MySQL Server: OptimizerWon't fix
(826 days)
S35.6.22AnyValid select with expression in group by under "only_full_group_by" fails  
720182014-03-12
11:02
2014-08-01
16:35
MySQL Server: Command-line ClientsClosed
(1242 days)
S35.5.33-cll-lve, 5.6.16Linux (RHEL 6.4)SHOW CREATE VIEW output inccorrect  
272192007-03-16
15:48
2008-04-07
17:24
MySQL ServerClosed
(3542 days)
S35.0.385.0+,5.1.24Linux (Linux)count(*) in order by Evgeny Potemkin
430922009-02-22
21:09
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3216 days)
S35.0.67-0ubuntu6Linux (Ubuntu 8.10)Group by still optimizing out extra nulls  
164712006-01-13
1:28
2013-10-06
20:45
MySQL Cluster: Cluster (NDB) storage engineNo Feedback
(4312 days)
S25.1.6-alphaLinux (Linux)DD: Maximum path for undofile in CREATE LOGFILE GROUP is 167 bytes Assigned Account
863592017-05-17
14:53
2017-11-08
10:27
MySQL Server: Group ReplicationClosed
(94 days)
S35.7.18AnyAvoid setting group_replication_force_members in a partition that holds majority  
41842004-06-17
13:51
2004-09-01
16:26
MySQL ServerClosed
(4856 days)
S24.1.2HP/UX (HP-UX 11)mysql_stmt_fetch() fetches wrong MSQL_TIME values Konstantin Osipov
195442006-05-04
19:29
2006-06-21
5:01
MySQL Server: BackupClosed
(4198 days)
S25.1Linux (Linux)mysqldump does not backup TS and LG information correctly. Stewart Smith
722812014-04-09
0:02
2017-07-06
19:19
MySQL FabricWon't fix
(1344 days)
S3Anymysqlfabric group promote may break replication Assigned Account
290172007-06-11
11:43
2007-06-26
8:04
MySQL ServerCan't repeat
(3828 days)
S25.0.41AnyProblem with subqueries and GROUP BY  
379772008-07-08
20:38
2011-02-16
23:43
MySQL Server: OptimizerClosed
(2589 days)
S16.06.0-betaAnyWrong result returned on GROUP BY + OR + Innodb Sergey Petrunya
292852007-06-21
20:32
2008-08-25
10:01
MySQL ServerNot a Bug
(3402 days)
S15.0.36, 5.0.37, 5.0.60Any ((Linux, Windows))--log-slow-queries + --log-queries-not-using-indexes works incorrect Tatiana Azundris Nuernberg
131602005-09-14
0:40
2005-09-14
5:23
MySQL ServerNot a Bug
(4478 days)
S24.1.14Linux (Linux Fedora Core 4)Incorrect result with MIN and GROUP BY after DELETE and re-INSERT of same data  
730662014-06-20
15:45
2015-02-26
13:30
MySQL Server: ReplicationVerified
(1274 days)
S25.6.17AnyReplication stall with multi-threaded replication  
623142011-09-01
2:00
2011-09-01
6:41
MySQL WorkbenchDuplicate
(2300 days)
S35.2.34 CE (7780)Microsoft Windows (7 Home Premium, 64 bit)Workbench flags GROUP BY modifier WITH ROLLUP as bad.  
748592014-11-14
9:50
2015-02-02
15:45
MySQL Server: DMLClosed
(1050 days)
S25.6.20, 5.6.23, 5.7.6AnyAssertion `scale >= 0 && precision > 0 && scale <= precision' failed  
187972006-04-05
12:55
2006-04-12
23:02
MySQL Server: InstallingClosed
(4268 days)
S35.0.17a-certOther (SCO OpenServer 6.0)Adding of default user/group for VOLS packages is not explicitly described  
735822014-08-14
12:18
2014-09-29
16:48
MySQL Server: DocumentationClosed
(1176 days)
S35.6 5.7AnyDocumentation says group commit for the binary log works only if sync_binlog=0 David Moss
44632004-07-08
15:01
2007-05-04
12:13
MySQL Server: ReplicationNot a Bug
(3881 days)
S4<4.1Any (doesn't matter)GROUP takes the first-found values  
825442016-08-11
14:36
2016-08-17
14:57
MySQL Server: DocumentationClosed
(488 days)
S35.7.14AnyDuplicate entry '' for key '<group_key>' while doing group by  
525922010-04-05
8:45
2011-02-16
23:44
MySQL ServerNo Feedback
(2784 days)
S35.1.42-communityMicrosoft Windows (7 )wrong warning in KEY_COLUMN_USAGE  
843372016-12-26
8:50
2017-07-11
11:52
MySQL Server: Group ReplicationClosed
(160 days)
S2mysql 5.7.17AnyConfigure mgr with out root user encounter an error  
520812010-03-16
8:38
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2684 days)
S35.1.41, 5.1.44, 5.6.99AnyIndex hint/forcing for GROUP BY / ORDER BY is broken Jørgen Løland
636092011-12-05
17:18
2011-12-12
18:25
MySQL Server: GeneralDuplicate
(2198 days)
S3Distrib 5.5.17, for FreeBSD7.4 (amd64)FreeBSD (not tested on other OS)Query with GROUP by , ORDER BY and LIMIT return one row , not expected count  
172762006-02-09
14:51
2006-03-23
17:13
MySQL ServerWon't fix
(4288 days)
S4 Unwanted behaviour WITH ROLLUP  
231712006-10-11
10:09
2007-04-12
16:04
MySQL Server: ReplicationClosed
(3903 days)
S35.1AnyIllegal slave restart (group) position Mats Kindahl
305962007-08-23
14:07
2007-10-23
15:59
MySQL Server: OptimizerClosed
(3709 days)
S25.1.23AnyGROUP BY optimization gives wrong result order Martin Hansson
608082011-04-08
15:06
2011-04-08
16:35
MySQL Server: GeneralDuplicate
(2446 days)
S25.5.11, 5.1.54, 5.1.41Any (win7 64bit, ubuntu 10.04 64 bit)Duplicate entry for key 'group_key'; Can't write, duplicate key in table  
679782012-12-27
6:13
2012-12-29
16:21
MySQL Server: Memory storage engineVerified
(1815 days)
S35.1, 5.5, 5.6AnySigned zero is handled incorrectly by HASH indexes and GROUP BY  
628582011-10-21
9:59
2014-04-07
9:05
MySQL Cluster: Disk DataClosed
(1351 days)
S35.5.15-ndb-7.2.1LinuxCREATE LOGFILE GROUP / CREATE TABLESPACE accept only bytes as unit Magnus Blåudd
216482006-08-15
6:12
2006-09-01
8:09
MySQL Server: TestsClosed
(4126 days)
S35.1.12bk information_schema test fails --with-ndbcluster Stewart Smith
692682013-05-17
14:51
2013-06-24
8:29
MySQL Server: OptimizerDuplicate
(1638 days)
S25.6AnyLEFT JOIN plus GROUP BY incorrectly returns NULL  
80862005-01-22
6:38
2005-02-26
21:25
MySQL ServerNo Feedback
(4678 days)
S24.1.8Linux (Linux)Mysterious very poor performance w/ IN (select...) vs. =(correlated subquery)  
846312017-01-24
1:38
2017-02-02
0:48
MySQL Server: DocumentationVerified
(319 days)
S35.7AnyGroup Replication Installation Documentation  
29682004-02-26
3:18
2004-02-26
8:59
MySQLCCNot a Bug
(5044 days)
S34.0.17Microsoft Windows (Windows XP)The use of the word "group" as a field name, seems to cause insert errors. Dean Ellis
342012008-01-31
17:59
2008-04-02
19:31
MySQL Cluster: Cluster (NDB) storage engineClosed
(3547 days)
S25.0, 5.1LinuxUnable stop a node when a node in a different group is in "not started" state Tomas Ulin
175632006-02-19
22:56
2006-02-20
5:49
EventumDuplicate
(4319 days)
S31.7Microsoft Windows (XP)Getting this missmatch error  
224312006-09-18
6:05
2006-10-27
14:59
MySQL AdministratorClosed
(4070 days)
S21.2.4 rc, 1.2.3 rcMicrosoft Windows (Windows XP SP2)MySQL Administrator improperly updates my.ini when modifying logging information Mike Lischke
24672004-01-21
1:56
2012-05-18
20:19
MySQL ServerNo Feedback
(4424 days)
S44.0.17Any (All)Use of an alias in a 'group by function'? Assigned Account
759392015-02-17
21:24
2015-09-05
1:00
MySQL Server: Group ReplicationNo Feedback
(836 days)
S1 5.7.5-labs-group-replicationLinux (ubuntu 14.04)mysql 5.7.5 group replication failed Nuno Carvalho
718442014-02-26
13:31
2014-07-24
23:40
MySQL FabricClosed
(1243 days)
S41.4.1Anyoption to join FAULTY MySQL instance back into group  
50292004-08-13
11:49
2013-06-27
15:39
MySQL Server: Command-line ClientsClosed
(1635 days)
S4allAny (all)mysql command to be able to use different configuration groups Matt Lord
595572011-01-17
15:26
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2527 days)
S25.1, 5.5AnyMySQL uses order of fields in GROUP BY when ORDER BY NULL is specified  
86142005-02-19
0:53
2005-06-22
2:29
MySQL Server: OptimizerClosed
(4562 days)
S34.1.10Any (*)distinct sometimes ignored with group by "CONST" Igor Babaev
452242009-05-31
22:34
2009-06-01
10:28
MySQL Server: OptimizerNot a Bug
(3122 days)
S35.4AnySELECT col_1 WHERE column(s) IN (subquery) AND condition GROUP BY col_n fails  
331932007-12-13
2:15
2007-12-20
8:17
MySQL Enterprise Monitor: WebClosed
(3651 days)
S21.3.0.8528Anygroup name is not displayed Joshua Ganderson
531612010-04-26
13:12
2013-01-18
1:51
MySQL Server: OptimizerClosed
(1795 days)
S15.1.37, 5.1.46, 5.1.47AnyLeft join optimized into join leads to incorrect results  
452262009-05-31
22:42
2011-02-16
23:44
MySQL Server: OptimizerNo Feedback
(2977 days)
S35.4Anyextra rows returned for queries using IN,GROUP BY and HAVING clauses  
457382009-06-25
8:41
2011-02-16
23:44
MySQL WorkbenchWon't fix
(3097 days)
S35.1.14WB51RC3Anyroutine object is deleted when its code is removed from routine-groups code Sergei Tkachenko
452282009-05-31
22:56
2011-02-16
23:44
MySQL Server: OptimizerNo Feedback
(2977 days)
S35.4AnyQueries with WHERE <col_1> AND <condition> GROUP BY <col_2> produce bad results  
777422015-07-15
22:02
2015-09-11
1:00
MySQL ServerNo Feedback
(830 days)
S25.7.7Anyjoin query returns in-correct result Chiranjeevi Battula
744152014-10-16
7:34
2015-04-14
12:04
MySQL Enterprise Monitor: Advisors/RulesCan't repeat
(994 days)
S33.0.14AnyAdvisor doesn't use the correct thresholds  
14582003-10-01
13:47
2005-05-09
11:52
MySQL ServerWon't fix
(4606 days)
S44.0.13 configure options outside [group] works in 3.23.x but not 4.0.13 Brian Aker
178442006-03-01
22:19
2006-03-08
14:05
MySQL Cluster: Cluster (NDB) storage engineClosed
(4303 days)
S25.1.8Linux (Linux 32 Bit OS)DD: INFORMATION_SCHEMA.FILES not showing correct free space information  
598312011-01-31
6:06
2011-02-16
23:44
MySQL Cluster: Cluster (NDB) storage engineClosed
(2511 days)
S37.1.6Anyndbinfo - counters not increasing after first query Magnus Blåudd
296302007-07-08
19:27
2007-07-09
13:07
MySQL ServerClosed
(3815 days)
S25.0.41-community-ntMicrosoft Windows"group by" doesnt work with subselects  
245162006-11-22
18:44
2011-02-16
23:43
MySQL Cluster: NDB APIVerified
(3904 days)
S4mysql-5.1Linux (Linux)MGMAPI reports bad data for down datanodes  
219572006-08-31
22:18
2006-10-01
9:02
MySQL ServerNo Feedback
(4096 days)
S25.0.15Linux (Linux)Replication fails with "Error 'Invalid use of group function' on query."  
45502004-07-14
20:10
2004-07-16
18:00
MySQL Query BrowserClosed
(4903 days)
S11.0.2 AlphaMicrosoft Windows (Win2k)count(*) query causes invalid 'must group by' error Alfredo Kojima
270792007-03-13
12:16
2007-04-04
5:38
MySQL Server: CharsetsClosed
(3911 days)
S24.1.22/5.0/5.1BKLinux (Linux)Crash while grouping empty ucs2 strings Alexander Barkov
7142003-06-24
14:11
2003-08-26
9:49
MySQL ServerClosed
(5228 days)
S24.1.1Linux (Linux)WITH ROLLUP crashes server Michael Widenius
173552006-02-13
23:37
2006-03-21
13:31
MySQL ServerNo Feedback
(4290 days)
S15.0.18-linux-x86_64-glibc23Linux (Red Hat Enterprise AS 4 Update 2)Combination of "Group By" query crashes server  
770062015-05-11
21:03
2015-12-22
10:40
MySQL Server: OptimizerNot a Bug
(727 days)
S25.6.24, 5.6.26, 5.6.10, 5.7.8Any 5.6 incompatible change in DELETE/SELECT ... WHERE NOT IN (subquery)  
388622008-08-18
15:34
2012-05-18
20:19
MySQL WorkbenchVerified
(3396 days)
S45.0.24WB60AnyUsability: Drag/Drop options for routines - routine groups  
537122010-05-17
16:13
2011-02-16
23:44
MySQL Server: GeneralNo Feedback
(2740 days)
S25.1.46SolarisORDER BY causes incorrect query result  
181312006-03-10
11:03
2006-03-28
17:26
MySQL Server: DocumentationNot a Bug
(4283 days)
S1MySQL 5.0.18Microsoft Windows (Windows XP & Linux Fedora core 4)GROUP BY doesn't always work  
765012015-03-27
6:50
2015-03-27
15:11
MySQL Server: OptimizerVerified
(997 days)
S35.6.22Any"select + distinct + group by " works incorrectly  
859772017-04-18
2:02
2017-04-18
4:10
MySQL Server: DocumentationVerified
(244 days)
S35.7 and 8.0AnyThe doc. of slave-parallel-type=LOGICAL_CLOCK wrongly reference Group Commit.  
194192006-04-28
9:53
2006-09-25
20:02
MySQL Server: ReplicationClosed
(4102 days)
S25.0.20/5.0BK/5.1BKMicrosoft Windows (windows xp & linux)VIEW: View that the column name is different by master and slave is made Alexander Ivanov
378512008-07-03
20:20
2011-02-16
23:43
MySQL Server: OptimizerClosed
(2585 days)
S16.06.0-betaAnyCrash in test_if_skip_sort_order tab->select is zero Sergey Petrunya
806042016-03-03
12:36
2017-07-06
19:20
MySQL Fabric: Command-lineWon't fixS41.5.6AnyThe command line doesn't show the full status of a group  
496302009-12-11
16:30
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2582 days)
S36.0AnySegfault in select_describe() with double nested subquery and materialization Jørgen Løland
724172014-04-22
7:04
2014-04-24
11:03
MySQL ServerOpenS4Linuxexecute semi join get incorrect result.  
399052008-10-07
10:43
2008-10-07
11:31
MySQL Server: InnoDB storage engineNot a Bug
(3359 days)
S35.0AnyIncorrect result with HAVING and no GROUP BY  
616662011-06-28
8:44
2011-06-28
9:01
MySQL ServerNot a Bug
(2365 days)
S3mysql Ver 14.12 Distrib 5.0.45Linux (Red Hat Enterprise Linux Server release 5.3 (Tikanga))#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns  
509162010-02-04
15:14
2011-02-16
23:44
MySQL Enterprise Monitor: ServerClosed
(2821 days)
S32.1.1.1138AnyTrying to remove a server that has QUAN inventory, but purged data, fails  
465672009-08-05
14:24
2011-02-16
23:44
MySQL Server: DocumentationClosed
(3055 days)
S35.0, 5.1, 5.4/6.0AnyAggregate function documentation needs clarification for non-GROUP BY behavior Paul Dubois
378682008-07-04
11:42
2012-05-18
20:19
MySQL Server: OptimizerDuplicate
(2969 days)
S16.0AnyCrash in test_if_skip_sort_order, bad value for used_key_parts  
819102016-06-17
16:35
2016-11-02
13:34
MySQL Server: ReplicationClosed
(479 days)
S35.7.14AnyWRITE SET HASHES SHOULD HAVE A 64BITS OPTION TO REDUCE WRITE CONFLICTS  
481182009-10-16
14:22
2011-02-16
23:44
MySQL Server: OptimizerDuplicate
(2849 days)
S35.1, 6.0AnyServer processing HAVING clauses incorrectly without a LIMIT clause Sergey Glukhov
345512008-02-14
15:43
2008-03-15
15:59
MySQL Server: Stored RoutinesNo Feedback
(3565 days)
S15.0.51aLinux (el5)*** glibc detected *** mysqld: corrupted double-linked list: 0x0b4ae810 ***  
97202005-04-07
14:23
2013-05-30
12:40
Connector / ODBCClosed
(1663 days)
S33.51.11Microsoft Windows (Windows 2000)Problems with sum() and group by with Magic Development  
627122011-10-13
0:54
2011-12-12
14:34
Tools: MTR / mysql-test-runClosed
(2198 days)
S25.5.17AnyRPM-based install of the test suite is useless for non-root users. Bjørn Munch
791002015-11-03
17:01
2015-11-17
18:52
MySQL Server: DocumentationClosed
(762 days)
S3any, 5.5, 5.6, 5.7AnyMySQL Manual does not explain when ORDER BY NULL does NOT prevent filesort Paul Dubois
721912014-04-01
17:54
2014-04-01
22:09
MySQL FabricCan't repeat
(1357 days)
S31.4.1-1Linuxmysqlfabric help does not work as documented  
391682008-09-01
19:54
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(2622 days)
S2any5.1+AnyERROR: the age of the last checkpoint ... exceeds the log group capacity Inaam Rana
192012006-04-19
17:08
2006-05-13
14:46
MySQL Cluster: Cluster (NDB) storage engineClosed
(4237 days)
S24.1 ->Linux (Linux)TRUNCATE table with blobs fails with 1205 Pekka Nousiainen
391692008-09-01
22:17
2008-10-10
8:06
MySQL Server: DMLNo Feedback
(3356 days)
S16.0.4alpha, 6.0.6alphaMicrosoft Windows (Windows XP Home)Unexpected behaviour when using GROUP BY and/or WHERE clauses  
640012012-01-11
18:35
2012-12-13
18:23
MySQL Workbench: AdministrationDuplicate
(1831 days)
S35.2.37Linux (Ubuntu 10.10, 11.10)Moving a connection to a group makes it dissappear  
163862006-01-11
20:40
2006-03-14
10:34
MySQL Cluster: Cluster (NDB) storage engineClosed
(4297 days)
S25.1.6-alphaLinux (Linux)DD: Cluster fails to create more then 5 logfile groups in extended dll testing Jonas Oreland
471062009-09-03
16:44
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2922 days)
S35.1, 5.4/6.05.0+AnyCrash / segfault on adding EXPLAIN to a non-crashing query Georgi Kodinov
640022012-01-11
20:01
2012-01-19
11:52
MySQL Server: OptimizerVerified
(2167 days)
S15.5.19Any (Debian, Windows XP)Aggregate queries with multiple columns and no GROUP BY produce bogus results  
801312016-01-24
21:05
2016-02-01
15:43
MySQL Server: OptimizerNot a Bug
(686 days)
S15.7.10Microsoft Windows (i) The 'group' statement has changed it's behaviour in 5.7.10  
401952008-10-21
8:35
2008-10-21
17:46
MySQL Server: InnoDB storage engineNot a Bug
(3345 days)
S55.1.28Linux (SLES10)Slowdown queries by the use of groupby in Innodb  
38452004-05-21
11:24
2004-05-28
13:52
MySQL ServerClosed
(4952 days)
S14.0.18-standardLinux (Suse Linux 9.0/WinXP)wrong FOUND_ROWS result Ramil Kalimullin
719422014-03-05
15:21
2014-03-05
15:53
MySQL ServerNot a Bug
(1384 days)
S5AnySelect * -- does it have to be "indeterminate" when using ORDER BY and GROUP BY  
192062006-04-19
22:02
2006-05-02
21:59
MySQL Server: DocumentationClosed
(4248 days)
S25.1Linux (Linux)Engine hangs trying to read from table that was locked for writing Paul Dubois
463442009-07-23
8:08
2015-01-09
10:37
MySQL Enterprise Monitor: WebClosed
(1074 days)
S4Any[graphs]: Show hint with instance name which caused maximum contribution Assigned Account
745052014-10-22
12:22
2014-10-22
12:46
MySQL Server: DMLVerified
(1153 days)
S35.6.20-debugLinux (CentOS 7)Assertion tab->select->quick->index==(uint)best_key' in test_if_skip_sort_order  
747632014-11-10
12:39
2015-02-03
3:14
MySQL WorkbenchClosed
(1049 days)
S26.2.3.12312 build 2280, 64bitMicrosoft Windows (8.1)Can't see all connections in a group  
125562005-08-12
18:04
2005-09-09
0:44
MySQL ServerCan't repeat
(4483 days)
S24.0.25Linux (Linux FC3)upgrading to 4.0.25 removed mysql user and stops server  
46232004-07-19
10:43
2004-07-22
15:40
MySQL ServerNot a Bug
(4897 days)
S34.0.0.18Microsoft Windows (Win 2000 Prof)bad optimization "group by" clause  
338082008-01-10
20:52
2008-03-14
18:43
Connector / ODBCClosed
(3566 days)
S25.1.15.1Microsoft Windows (xp2 sp2)MyODBC 51/Access ODBC CONVERT() causes error Jim Winstead
670892012-10-04
18:50
2014-11-19
7:51
MySQL Server: LoggingVerified
(1125 days)
S45.1.54, 5.6.21AnyMysql error log group owned by root.  
166572006-01-20
0:16
2006-03-14
8:22
MySQL Cluster: Cluster (NDB) storage engineClosed
(4297 days)
S35.1Linux (Linux)DD: The max. value for UNDO_BUFFER_SIZE is 17M only. Jonas Oreland
222922006-09-13
2:18
2006-09-23
11:40
MySQL Cluster: Cluster (NDB) storage engineClosed
(4104 days)
S25.0.24aLinux (CentOS 4.4 x86_64)Cluster node dies while loading large dump file  
187092006-04-01
17:23
2006-04-04
14:48
MySQL ServerCan't repeat
(4276 days)
S25.0.19Microsoft Windows (Win32)group by doesn't work  
187102006-04-01
17:25
2006-04-01
17:58
MySQL ServerDuplicate
(4279 days)
S25.0.19Microsoft Windows (Win32)group by doesn't work  
299752007-07-23
9:51
2007-07-23
10:52
MySQL Server: GeneralNot a Bug
(3801 days)
S35.0.37Linux (Fedora 7.9 (dev))TIME_TO_SEC does never return more than 3020399 (838:59:59)  
494312009-12-03
22:05
2016-02-25
12:24
MySQL Workbench: ModelingNo Feedback
(2826 days)
S25.2.10 r4680WB52Any (XP)Routine groups seems busted  
330492007-12-06
21:52
2008-03-15
9:14
MySQL Server: ViewsClosed
(3565 days)
S35.0.56-debug, 5.1.24-rc-debug, 6.0.4-debug, 6.0.5pre-DEBUG5.0+AnyAssert while running test-as3ap test(mysql-bench suite) Alexey Kopytov
729882014-06-12
15:36
2015-03-24
18:04
MySQL Server: ReplicationClosed
(1103 days)
S25.7AnySlave thread fails with MTS + GTID + replicate_same_server_id  
317722007-10-23
2:33
2011-02-16
23:43
MySQL Cluster: Disk DataClosed
(3224 days)
S35.1.22CGEAnySelect statement got warning after add a long name log/data file Jonas Oreland
253732007-01-02
19:48
2007-03-15
15:32
MySQL ServerClosed
(3931 days)
S25.0.30, 5.1bkLinux (linux)rollup grand total not have NULL for group by field basd on stored function Evgeny Potemkin
607022011-03-30
23:25
2011-04-05
14:55
MySQL Server: OptimizerVerified
(2454 days)
S55.1.57AnyGROUP BY orders when used inside a UNION query, though it should not  
686402013-03-11
20:01
2013-03-14
13:44
MySQL Server: OptimizerNot a Bug
(1740 days)
S35.5.29Linux (RHEL 6.3)Optimizer does not handle group by properly in insert...select  
243522006-11-16
6:11
2007-11-20
9:12
MySQL ServerCan't repeat
(3681 days)
S24.1.22, 4.1.9-nt-max-logMicrosoft Windows (Windows XP)"=" operator failed rather than "LIKE" operator in GROUP BY statement  
624962011-09-22
1:09
2012-07-27
8:37
MySQL Workbench: ModelingClosed
(1970 days)
S35.2.34 CEMicrosoft Windows (Win7 Pro, 64 bit)Synchronization issue in data modeling when adding routine in a routine group.  
476492009-09-25
13:25
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2838 days)
S35.1,6.0.145.1+Anycrash during CALL procedure Sergey Glukhov
476502009-09-25
16:53
2011-02-16
23:44
MySQL Server: DMLClosed
(2838 days)
S35.0.X, 5.1.39, next-mr5.1+Any (Mac OS X Snow leopard, Linux)using group by with rollup without indexes returns incorrect results with where Martin Hansson
811882016-04-24
11:16
2016-04-25
7:38
Connector / JDuplicate
(602 days)
S35.1.37Anyselect json type get garbled reason  
712062013-12-22
17:13
2013-12-31
20:00
MySQL Server: OptimizerVerified
(1456 days)
S15.5.32-0ubuntu0.12.04.1-log, 5.6.15, 5.1.72, 5.5.35, 5.7.3Linux (ubuntu 12.04)GROUP_CONCAT changes GROUP BY behavior  
317822007-10-23
10:58
2011-02-16
23:43
MySQL Cluster: Disk DataClosed
(2867 days)
S3mysql-5.1CGELinuxNo way to detect empty tablespaces using SQL Pekka Nousiainen
8072003-07-07
19:10
2003-07-09
6:22
MySQL ServerClosed
(5276 days)
S24.0.12pc-linux (i686)Crash using CASE INTERVAL(...) ... GROUP BY Sinisa Milivojevic
138632005-10-08
14:02
2006-01-25
20:03
MySQL Server: DocumentationClosed
(4345 days)
S35.0.13Microsoft Windows (Win XP Professional SP2)Alternative INTO OUTFILE syntax not documented Paul Dubois
438152009-03-24
0:47
2011-02-16
23:43
MySQL Enterprise Monitor: ServerClosed
(3132 days)
S22.0.5.7153AnyNew topology is not discovered after previous replication group is renamed Darren Oldag
307602007-09-02
3:30
2008-02-10
5:28
MySQL ServerNo Feedback
(3599 days)
S55.0.45Linuxmysql 5.0.45 is slower than 5.0.41 and more than 5.0.33  
535442010-05-10
16:50
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2583 days)
S25.1.47, 5.6.99-m4 Dahlia, bzr_mysql-6.0-codebase-bugfixing5.1+AnyServer hangs during JOIN query in stored procedure called twice in a row Alexey Kopytov
343472008-02-06
12:29
2008-02-06
13:27
MySQL Server: GeneralCan't repeat
(3603 days)
S25.0.51Linux (Debian AMD64)ORDER BY fails if result is grouped with GROUP BY  
791492015-11-06
5:54
2015-12-17
8:30
Connector / NETCan't repeat
(732 days)
S1MySQL 5.7Microsoft WindowsConnecting MySQL Fabric through Connector/NET 6.9.8  
159172005-12-21
21:43
2006-04-14
14:36
MySQL ServerClosed
(4266 days)
S25.0.17Microsoft Windows (Windows 2003, Windows XP, OXS)wrong result in NIST test on Windows for nested SELECT with GROUP BY Igor Babaev
210372006-07-13
14:09
2006-08-13
18:52
MySQL Server: ViewsNo Feedback
(4145 days)
S15.0.17Microsoft Windows (XP)View With group by -- sql-mode : Only_Full_Group_By  
453612009-06-07
21:58
2009-06-11
19:19
MySQL Server: ParserNot a Bug
(3112 days)
S3anyAnyparser behaves too primitive here!  
241142006-11-08
23:43
2007-05-10
13:08
MySQL Enterprise Monitor: WebClosed
(3875 days)
S41.0.0Any (all)selecting no notifcations and a notification group results in an error Joshua Ganderson
412662008-12-05
15:36
2011-02-16
23:43
MySQL Enterprise Monitor: WebClosed
(3260 days)
S32.0.0.7119Anyrename group fails if the new name differs only in case from existing name Darren Oldag
556022010-07-28
13:35
2011-02-16
23:44
MySQL ServerNo Feedback
(2669 days)
S25.1.46Solaris (10, 64 bit)select count(*) + order by desc + limit + partitioning delivers not all results  
696842013-07-07
10:44
2014-06-02
14:33
MySQL Server: DMLClosed
(1308 days)
S25.5, 5.6AnyThe update and select behave differently under the same conditions.  
8212003-07-09
15:59
2003-07-16
2:52
MySQL ServerClosed
(5269 days)
S24.1.0-alphaLinux (Linux (Redhat 6.1) 2.2.12-20)Aggregate function or group by in derived table causes disconnect from server Oleksandr Byelkin
561182010-08-19
13:12
2011-02-16
23:44
MySQL Server: ReplicationClosed
(2590 days)
S35.1.49, 5.5.6-m3, 5.6.995.1+AnySTOP SLAVE does not wait till trx with CREATE TMP TABLE ends, replication aborts Libing Song
809522016-04-04
21:31
2016-04-05
5:56
Connector / NETDuplicate
(622 days)
S16.9.8Microsoft Windows (7 64 bits)linq generate wring query with group by: Unknown column 'GroupBy1.K1' in 'field  
842812016-12-20
15:44
2017-01-10
7:48
Tests: Group ReplicationNot a Bug
(342 days)
S2mysql-5.7.17 CentOS (6.6)group replication can not work Bogdan Kecman
845372017-01-17
14:11
2017-10-24
14:31
MySQL Server: OptimizerClosed
(104 days)
S38.0.1AnyGROUP BY DESC gives wrong result when groups on DECIMAL and sees a NULL  
412742008-12-06
2:50
2011-02-16
23:43
MySQL Cluster: Disk DataVerified
(3299 days)
S3mysql-5.1-telco-6.3Linuxerror 1504 'Out of logbuffer memory' message is too vague  
184922006-03-24
15:53
2006-05-02
22:35
MySQL Server: Prepared statementsClosed
(4248 days)
S35.1.8, 5.0.21, 4.1.19 mysqld reports ER_ILLEGAL_REFERENCE in --ps-protocol Georgi Kodinov
830052016-09-15
6:56
2017-05-03
3:47
MySQL Server: OptimizerClosed
(343 days)
S15.6.10, 5.6.33, 5.7.15, 5.5.52AnyWhen the Optimiser is using index for group-by it often gives wrong results  
415332008-12-17
9:50
2011-02-16
23:43
MySQL ServerNo Feedback
(3257 days)
S25.1.24LinuxDuplicated rows  
453732009-06-08
13:14
2011-02-16
23:44
MySQL Server: OptimizerVerified
(3104 days)
S35.1.35-community, 5.1.36-bzrAnyINDEX FOR GROUP BY is not used if there is a LIMIT clause in the query Gleb Shchepa
520292010-03-13
12:26
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2828 days)
S55.1.44AnyGROUP BY results in much slower query  
110712005-06-03
12:59
2005-06-27
13:27
MySQL Server: OptimizerNot a Bug
(4557 days)
S14.1 bk treeLinux (linux)SELECT crashes MySQL server Evgeny Potemkin
269432007-03-07
23:57
2011-02-16
23:43
MySQL Server: OptimizerNo Feedback
(2949 days)
S25.0.27, 5.0.22, 5.0.68Linux (linux(centos 4.4 server))64bit mysql 5 hangs on removing duplicate after query distinct,group by,order by  
819842016-06-23
9:21
2016-07-05
12:44
MySQL FabricNot a Bug
(531 days)
S21.5.6Debian (8.5)FABRIC Picks the wrong master and fails to failover  
456322009-06-20
7:49
2012-05-18
20:19
MySQL Server: Query CacheNo Feedback
(3061 days)
S35.1 bzr5.1+Linux (x86)query_cache_debug.test fails Assigned Account
379542008-07-08
2:22
2011-02-16
23:43
MySQL Enterprise MonitorClosed
(3437 days)
S31.3.2.91261.3 investigateAnyjava.lang.NullPointerException when creating server group Sloan Childers
760992015-03-02
14:20
2015-04-07
22:57
MySQL Server: ReplicationClosed
(1008 days)
S35.7.7AnyMake rpl.rpl_sp_privileges test work with Group Replication  
277212007-04-09
20:12
2012-05-30
7:05
MySQL Server: Stored RoutinesVerified
(2029 days)
S45.1AnyIn current Event Scheduler you cannot relate one temporal event to another one  
382172008-07-17
21:35
2012-05-18
20:19
MySQL Server: OptimizerDuplicate
(2961 days)
S35.0.60, 5.0.64, 5.1.28AnyGROUP BY with subquery fails. Assigned Account
458972009-07-02
5:51
2013-02-05
15:15
MySQL WorkbenchCan't repeat
(1777 days)
S25.1.16WB60AnyDo not add the name of the stored procedure in the routine group  
868582017-06-29
3:19
2017-11-08
10:32
MySQL Server: Group ReplicationClosed
(101 days)
S25.7.18AnyConfusing GR error message: check credentials, but issue is hostnanme resolving  
233702006-10-17
13:32
2006-10-20
9:11
MySQL ServerDuplicate
(4077 days)
S1mysql-5.1.11-beta-win32 and 5.1.26Linux (Linux and Win)Bad nested group by performance  
453862009-06-09
3:52
2011-02-16
23:44
MySQL Server: DMLClosed
(3002 days)
S35.0.81, 5.0, 5.1, 6.0 bzr5.0+SolarisWrong query result with MIN function in field list, WHERE and GROUP BY clause Georgi Kodinov
469232009-08-25
18:07
2011-02-16
23:44
MySQL Server: PartitionsClosed
(2835 days)
S25.1.37, 5.1.39, 5.4.x5.1+Anyselect count(*) from partitioned table fails with ONLY_FULL_GROUP_BY Mattias Jonsson
410362008-11-25
22:23
2011-02-16
23:43
MySQL Cluster: Disk DataVerifiedS4mysql-5.1-telco-7.0AnyEasier Configuration Change On Cluster Disk Objects  
773922015-06-17
16:22
2016-04-27
15:05
MySQL Server: ReplicationClosed
(833 days)
S35.7.7AnySlave group event parser does not recognize XA ROLLBACK as a boundary  
167212006-01-23
10:15
2006-01-24
15:12
MySQL ServerCan't repeat
(4346 days)
S15.0.16-Debian_1-logLinux (Linux debian 2.6.15 sarge)ERROR 1062 (23000): Duplicate entry in a view (GROUP BY)  
318252007-10-24
20:35
2007-10-25
17:13
MySQL Server: GeneralCan't repeat
(3707 days)
S25.0.41 Microsoft Windows (Not tested on other OS'es)GROUP BY problem  
28982004-02-20
0:21
2004-02-20
12:11
MySQL ServerNot a Bug
(5050 days)
S34.1.1-alphaFreeBSD (FreeBSD 4.9-STABLE)Unexpected result: max() with group by Dean Ellis
254282007-01-05
7:06
2012-05-18
20:19
MySQL Cluster: Disk DataDuplicate
(4000 days)
S2MySQL 5.1.14Linux (RHEL 4)The Text column, not being indexed, although it is still stored in memory  
717662014-02-19
0:06
2014-03-11
6:39
MySQL FabricClosed
(1378 days)
S21.4.0Linux (2.6.39-200.24.1.el6uek.x86_64)mysqlfabric group destroy command failure Alfranio Correia
236392006-10-25
17:35
2006-10-31
4:41
MySQL Enterprise Monitor: WebClosed
(4066 days)
S2mysqlnetwork-0.6.33Linux (Fedora Core 3 (i386))Filter events by rule group Joshua Ganderson
164722006-01-13
1:54
2006-01-26
2:30
MySQL Cluster: Cluster (NDB) storage engineClosed
(4344 days)
S25.1Linux (Linux)DD: Maximum path for datafile in CREATE TABLESPACE cannot be more than 167 bytes Jonas Oreland
295302007-07-03
20:15
2007-07-27
12:59
MySQL Server: DocumentationClosed
(3797 days)
S35.1Anyundocumented options in 'create logfile group' & 'create tablespace' statements Jon Stephens
6032003-06-06
4:35
2003-06-06
7:21
MySQL ServerNot a Bug
(5309 days)
S3Linux (Linux)strange behaviour with MAX without GROUP BY  
484752009-11-02
14:06
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2838 days)
S35.0.88, 5.1.415.0+AnyDISTINCT is ignored with GROUP BY WITH ROLLUP and only const tables Alexey Kopytov
272292007-03-16
21:25
2007-04-11
1:59
MySQL ServerClosed
(3904 days)
S35.0.38/5.1BKFreeBSD (freebsd)crash/incorrect result in subquery with aggregate(outer_column) (debug server) Igor Babaev
694702013-06-14
9:33
2013-06-14
13:08
MySQL Server: DMLDuplicate
(1648 days)
S35.6.10LinuxUse "group by", but no aggregate function, get weird result  
802242016-02-01
19:13
2016-02-15
9:00
MySQL Server: OptimizerVerified
(672 days)
S35.5.46, 5.6.28, 5.7.11AnyCONCAT_WS duplication of arguments when used in conjunction with HAVING  
152012005-11-23
20:34
2006-01-27
15:32
MySQL ServerNo Feedback
(4343 days)
S25.0.15Linux (Linux)Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COE  
262092007-02-09
6:47
2007-02-26
20:54
MySQL Server: ViewsClosed
(3948 days)
S25.0.36-BK, 5.0.27Linux (Linux, winXP)wrong result using COUNT(DISTINCT ?) querying a VIEW with GROUP BY and ORDER BY Igor Babaev
297962007-07-13
20:39
2007-08-13
21:49
MySQL ServerNo Feedback
(3780 days)
S35.0.41Microsoft Windows (XP Professional 5.1.2600)Correlated subquery return zero rows when Group By included in the outer query  
26612004-02-06
2:59
2004-02-24
14:35
MySQL ServerCan't repeat
(5046 days)
S24.0.15Solaris (Solaris 8 SPARC)Using same key on distinct and group by seems to create a busy-loop in mysql Timothy Smith
72692004-12-14
14:36
2005-01-14
18:45
MySQL ServerClosed
(4721 days)
S35.0.3-preLinux (Linux / Athlon)Test failure: 'having' (using '--ps-protocol'), server process crash Ramil Kalimullin
400372008-10-15
9:34
2011-10-20
3:46
MySQL Server: OptimizerClosed
(2251 days)
S35.x, 6.xAnyIncorrect result from MIN/MAX when no GROUP, and independent subquery predicate  
725532014-05-06
15:00
2014-05-23
3:50
MySQL FabricClosed
(1305 days)
S31.4.0AnyConcurrency control is not locking the right objects Alfranio Correia
131612005-09-14
5:30
2005-11-04
4:04
EventumClosed
(4427 days)
S21.6.1Microsoft Windows (XP and IE)Cannot See the Created Issue Bryan Alsdorf
728142014-05-30
9:31
2014-07-18
18:56
MySQL Server: OptimizerVerified
(1295 days)
S35.6.17AnyAssertion `!(ordered_index_usage == ordered_index_void && ... fails  
595022011-01-14
13:13
2011-02-16
23:44
MySQL Cluster: Disk DataClosed
(2518 days)
S3Anyrace condition in drop logfile group Jonas Oreland
410742008-11-27
15:55
2011-02-16
23:43
MySQL Server: PackagingClosed
(3251 days)
S35.1.30, 5.0.70, 6.0.85.1+SolarisGrammatical error in error message from install/request in Solaris package Kent Boortz
802442016-02-02
23:30
2016-09-01
13:18
MySQL Server: OptimizerClosed
(587 days)
S25.7.10, but at least as far back as 5.6Any"Using index for group-by" queries can return no data with LE/LEQ and rounding  
75412004-12-27
10:35
2005-01-23
15:34
MySQL ServerCan't repeat
(4712 days)
S15.0.3-preLinux (Linux 2.4 / Athlon)Test failure: Hang in 'having' (using '--ps-protocol') Konstantin Osipov
513182010-02-19
10:48
2011-02-16
23:44
MySQL Server: DDLVerifiedS45.1Anyimplement "if exists" for DROP LOGFILE GROUP, DROP TABLESPACE commands  
600232011-02-08
21:45
2014-05-22
12:13
MySQL Server: OptimizerVerifiedS55.5.8 , 5.1.51AnyNo Loose Index Scan for GROUP BY / DISTINCT on InnoDB partitioned table  
134322005-09-23
16:05
2005-10-13
18:37
MySQL ServerClosed
(4449 days)
S4ANYAny (ANY)C API: sending a group of rows at a time  
203442006-06-08
15:46
2011-02-16
23:43
MySQL Server: DMLVerified
(4211 days)
S45.0.21-maxMac OS X (OS X)Order BY requires column presence in SELECT  
57542004-09-26
20:38
2008-10-03
16:23
MySQL Server: Security: PrivilegesNot a Bug
(3363 days)
S45.0Linux (Linux & Windows)Please: SCHEMA & GROUP support  
300752007-07-26
15:33
2014-03-13
13:36
MySQL Enterprise Monitor: WebWon't fix
(3776 days)
S41.2.0AnyAllow reordering of servers within a group Assigned Account
188132006-04-05
14:57
2012-05-18
20:19
MySQL ServerDuplicate
(4268 days)
S35.0.21-BK, 5.0.19Linux (Linux)WITH ROLLUP displays empty string instead of NULL if string columns grouped Evgeny Potemkin
851192017-02-22
3:08
2017-03-14
3:06
MySQL Server: InnoDB storage engineOpen
(279 days)
S45.6 5.7AnyInnodb needs an instant checksum.  
139532005-10-12
8:16
2005-10-12
9:44
MySQL ServerNot a Bug
(4450 days)
S35.0.xLinux (Linux)CREATE TABLE with field list and SELECT makes more columns than expected  
175372006-02-17
23:44
2006-03-27
17:17
MySQL Cluster: Cluster (NDB) storage engineNo Feedback
(4284 days)
S25.1.8Linux (Linux 64 bit OS)DD: Drop Tables seemed to be locked into cluster cache  
90902005-03-10
10:30
2011-02-16
23:43
MySQL Server: OptimizerClosed
(2693 days)
S34.1.x, 5.xAnyOptimization Problem with a subquery in an IN Operation Sergey Petrunya
3872003-05-07
6:02
2003-05-13
9:16
MySQL ServerClosed
(5333 days)
S34.0.12pc-linux (i686)ERROR 1055: 'NULL' isn't in GROUP BY -- in ANSI mode Oleksandr Byelkin
462112009-07-15
18:16
2012-05-18
20:19
MySQL Server: ParserVerified
(3078 days)
S3AnySQL_BIG_RESULT, SQL_SMALL_RESULT, SQL_BUFFER_RESULT should be mutually exclusive Assigned Account
9042003-07-23
20:53
2003-08-07
22:21
MySQL Server: MyISAM storage engineNot a Bug
(5247 days)
S14.0.14Linux (debian linux)query jumped from 4 seconds to several minutes, join order changed in explain Igor Babaev
439122009-03-27
13:56
2012-10-16
5:00
MySQL Server: DMLWon't fix
(1889 days)
S35.0.91Any'Column * cannot be null' when derived table has count() with no results  
300892007-07-27
3:33
2007-07-27
18:17
MySQL Server: User-defined functions ( UDF )Can't repeat
(3797 days)
S25.1.20Linux (SuSE Enterprise 9.0, OpenSuSE 10.2)UDF aggregate functions crash when included in order by clause  
247142006-11-30
7:30
2007-08-20
15:40
MySQL Server: OptimizerWon't fix
(3773 days)
S14.1.22, 4.1 BKLinux (Linux, FreeBSD)Mathematical SELECT queries no longer return consistent results  
469862009-08-28
22:08
2012-05-18
20:19
MySQL Enterprise Monitor: WebVerified
(2922 days)
S32.0.6.7159AnySQL formatter fails for SELECT ... WHERE .. NOT IN ( SELECT ... ) GROUP BY Assigned Account
459632009-07-06
8:48
2009-07-06
10:41
MySQL Server: DMLNot a Bug
(3087 days)
S45.0.75-0ubuntu10.2 (Ubuntu)AnyDWIM: Allow group functions in WHERE clause, by doing GROUP BY first  
823172016-07-22
7:42
2016-07-22
15:04
MySQL Server: ParserVerified
(514 days)
S35.5.49Any (v14.04.1)Unrelevant error message: Unknown column in 'having' clause  
206212006-06-22
8:09
2006-06-22
9:07
MySQL ServerCan't repeat
(4197 days)
S25.021Linux (Linux fedora core 4)query with adddate in group by makes server crash  
231822006-10-11
16:18
2006-12-15
22:24
MySQL ServerCan't repeat
(4021 days)
S15.0.27-BK, 5.0.24aLinux (Linux app 2.6.18 )Got an error when using aliases in a view, thought the select works Evgeny Potemkin
738732014-09-10
9:44
2014-09-30
19:15
MySQL FabricClosed
(1175 days)
S2AnyLocking error in the failure detector  
843712016-12-29
19:14
2016-12-30
3:22
MySQL Server: DocumentationVerified
(353 days)
S35.7.17AnyMissing documentation for backup/recover when using MySQL Group Replication  
756682015-01-28
16:21
2015-01-28
20:10
MySQL Server: OptimizerVerified
(1055 days)
S25.6.22/5.7FreeBSD (FreeBSD 8.4)Use of Distinct, Group_concat, and Group by together produces 1 NULL row result.  
265162007-02-21
4:21
2007-02-21
15:15
MySQL Enterprise Monitor: ConfigurationClosed
(3953 days)
S11.1.0.4789Linux (linux)server inst - group # syntax error in httpd.conf Keith Russell
134612005-09-24
15:22
2005-10-14
8:28
MySQL Cluster: Cluster (NDB) storage engineClosed
(4448 days)
S25.1 4.1? 5.0?Linux (Linux)Slave Cluster crashed on restart of two data nodes in seperate groups Tomas Ulin
825812016-08-15
10:21
2017-01-09
10:55
MySQL Server: Group ReplicationVerified
(343 days)
S15.7.14CentOS (7)altering table engine from innodb to memory will break group replication  
298452007-07-17
13:10
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3688 days)
S46.0.0-alphaAnyGROUP BY does not make best use of indicies when evaluating SUM aggregates  
436692009-03-16
9:16
2013-11-19
18:19
MySQL Server: Data TypesUnsupported
(1490 days)
S36.0.11AnyFalcon returns diff. no of digits than other engines with MIN() for YEAR values  
114142005-06-17
13:05
2005-07-25
20:04
MySQL Server: OptimizerClosed
(4529 days)
S14.1.13Microsoft Windows (Windows NT)Crash on Windows with a simple group by query Igor Babaev
871902017-07-26
3:07
2017-08-03
8:14
Tests: ServerVerified
(137 days)
S38.0.2AnyTest main.group_by is unstable  
467422009-08-15
13:30
2011-06-09
20:49
Connector / NETClosed
(2384 days)
S36.0.4, 6.3.6Microsoft Windows (windows 7)use " group by" statement in ado.net enetiy framework Julio Casal
669672012-09-26
8:17
2012-09-27
11:37
MySQL Server: OptimizerDuplicate
(1908 days)
S25.5.27LinuxIndex is not used for MyISAM table with SELECT+GROUP BY  
587752010-12-07
0:55
2010-12-07
4:19
MySQL Server: ErrorsNot a Bug
(2568 days)
S35.1.52AnyTable Field Name - Group  
531442010-04-25
17:09
2010-04-25
17:29
MySQL Server: GeneralNot a Bug
(2794 days)
S35.0.88AnyGROUP BY with ROLLUP includes previous data in rollup  
382972008-07-22
20:04
2014-12-21
3:15
MySQL Server: User-defined functions ( UDF )Verified
(3435 days)
S35.0, 5.1Microsoft Windows (Vista Ultimat)aggregate UDF xxx_init / deinit only called once for aggregation with rollup  
342032008-01-31
19:31
2008-03-01
8:38
MySQL WorkbenchNo Feedback
(3579 days)
S25.0.12AnyStops responding  
508432010-02-02
18:12
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2738 days)
S25.1.425.1+AnyOptimizer ignores clustered index for GROUP BY even when it improves performance Evgeny Potemkin
80932005-01-22
20:08
2005-01-24
17:19
MySQL Server: MyISAM storage engineClosed
(4711 days)
S34.1.8Any (*)GROUP BY can alter some values of a grouped by column Sergey Petrunya
301092007-07-27
23:29
2007-07-30
14:37
MySQL Server: GeneralNot a Bug
(3794 days)
S24.1.20,4.1.23 - 5.0LinuxAmbiguous ORDER BY behavior change Evgeny Potemkin
365112008-05-05
16:09
2008-05-05
16:41
MySQL Server: GeneralNot a Bug
(3514 days)
S25.0.51AnyMySQL allows fields in SELECT list that are not in the GROUP BY statement  
201282006-05-29
15:55
2006-06-30
11:14
MySQL Server: OptimizerNot a Bug
(4189 days)
S25.0 outer JOIN + GROUP BY: wrong result Igor Babaev
165452006-01-16
18:32
2013-10-06
20:45
MySQL Cluster: Cluster (NDB) storage engineDuplicate
(4351 days)
S25.1Linux (Linux)DD: NDB engine does not support long file names (up to 256 bytes) Assigned Account
329312007-12-03
14:38
2008-02-06
16:03
MySQL WorkbenchClosed
(3603 days)
S35.0.10Microsoft WindowsRoutines Group Editor does not handle dragging routines correctly Andrii Nikitin
882282017-10-25
19:22
2017-11-15
21:52
MySQL Server: DocumentationClosed
(33 days)
S38.0Any"ORDER BY Optimization" doc contradiction re: GROUP BY  
367722008-05-16
23:04
2011-02-16
23:43
MySQL Server: CharsetsClosed
(3297 days)
S25.0BK/5.1BK/6.0BK5.0+Any (Ubuntu (5.0.38-Ubuntu_0ubuntu1.4-log) and WinXP (5.0.45-community-nt))When using UTF8, CONVERT with GROUP BY returns truncated results Ramil Kalimullin
723572014-04-16
13:22
2014-08-26
18:14
MySQL Workbench: ModelingCan't repeat
(1210 days)
S36.1.4Microsoft Windows (7 64bit)Crash-prone Routine Groups.  
106612005-05-16
11:05
2005-05-17
5:50
Connector / ODBCNot a Bug
(4598 days)
S11Microsoft Windows (Windows xp)Connection poblem B/w PHP 4.3, apache 2 and Mysql 4.1.11  
232052006-10-12
9:36
2006-10-12
14:00
MySQL ServerCan't repeat
(4085 days)
S34.1.20Linux (Linux)Incorrect SUBSTRING result if using negative lenghts with InnoDB and GROUP BY  
296062007-07-06
18:57
2009-07-20
9:44
MySQL Server: GeneralNot a Bug
(3073 days)
S45.1AnyLAST ENTRY of a GROUP BY sql statement  
511112010-02-11
16:21
2011-02-16
23:44
MySQL Cluster: Disk DataClosed
(2845 days)
S3mysql-5.1-telco-6.3AnyALTER LOGFILE GROUP missing error message Maitrayi Sabaratnam
872082017-07-26
14:05
2017-07-31
12:24
MySQL Server: Group ReplicationNot a Bug
(140 days)
S35.7.18AnyFlow control mechanism does not prevent nodes from lagging further behind Bogdan Kecman
186032006-03-29
4:01
2006-04-26
10:35
MySQL Cluster: Cluster (NDB) storage engineClosed
(4254 days)
S15.1.9-BK, 5.1.7Linux (Linux)Invalid CREATE LOGFILE GROUP or CREATE TABLESPACE crashes server Tomas Ulin
779962015-08-08
23:55
2017-07-06
19:20
MySQL Fabric: ExecutorWon't fix
(846 days)
S31.5.3Ubuntu (14.04LTS)Fabric does not stop replication when server is removed from active group.  
826042016-08-17
3:41
2016-08-17
6:36
Connector / NETDuplicate
(488 days)
S36.9.9Microsoft WindowsLINQ conditional Group By column excluded from select list  
183482006-03-20
6:36
2006-03-23
17:07
MySQL ServerWon't fix
(4288 days)
S4 AGGREGATE BY clause as alternative to GROUP BY  
186042006-03-29
5:29
2006-04-26
10:50
MySQL Cluster: Cluster (NDB) storage engineClosed
(4254 days)
S35.1.9-BK, 5.1.7Linux (Linux)Illegal values permitted for ENGINE in CREATE LOGFILE GROUP  
887492017-12-05
2:41
2017-12-05
6:11
MySQL Server: DMLVerified
(13 days)
S15.5.58AnyAssertion `item->type() == Item::FIELD_ITEM || (item->type() == Item::REF_ITEM &  
605892011-03-22
15:06
2011-03-22
17:12
Connector / NETDuplicate
(2463 days)
S16.3.6AnyLINQ Group By Generating Broken Query  
493262009-12-02
5:22
2012-07-04
14:49
MySQL Server: ReplicationClosed
(1993 days)
S45.0,5.1AnySupport group commit for the binlog Alfranio Correia
257772007-01-23
11:44
2012-05-18
20:19
MySQL Cluster: Cluster (NDB) storage engineNo Feedback
(3840 days)
S25.0.37FreeBSD (FreeBSD 6.2)mysqld segfaults when used in NDB cluster  
55552004-09-14
0:23
2004-10-05
11:52
MySQL ServerClosed
(4822 days)
S14.1.4-gamma-standard-logLinux (Linux 2.6)"GROUP BY enum_field" returns incorrect results Sergey Glukhov
211722006-07-20
3:47
2006-09-01
13:29
MySQL Cluster: Disk DataClosed
(4126 days)
S25.1.11Linux (Debian Sarge 3.1)Cluster will not restart, configuration error Jonas Oreland
408842008-11-20
13:16
2011-02-16
23:43
Tests: ServerClosed
(3253 days)
S36.0-TRUNK6.0-betaSolaris (Solaris 10)main.group_min_max crashes regularly on some Solaris 10 boxes Timour Katchaounov
460042009-07-07
12:33
2012-05-18
20:19
MySQL Server: InnoDB storage engineDuplicate
(2639 days)
S25.1AnyCrash in row_sel_field_store_in_mysql_format on a SELECT + LIMIT  
58142004-09-29
21:52
2004-10-04
13:26
MySQL ServerClosed
(4823 days)
S14.1.5-gamma-standardLinux (Fedora Core 1)Sub-Select with Group by would return a wrong result Oleksandr Byelkin
498462009-12-21
12:42
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2919 days)
S35.0.90, 5.1.34-log, 5.1.41AnyValid dependent views result with ERROR 1055 (42000): 'xxx' isn't in GROUP BY  
60712004-10-13
18:43
2004-10-13
20:08
MySQL ServerNot a Bug
(4814 days)
S34.0.21Linux (Fedora Core 1)ORDER BY does not work correctly when combined with GROUP BY and LEFT JOIN Matt Lord
286012007-05-22
16:49
2007-05-23
9:04
MySQL Server: ParserCan't repeat
(3862 days)
S35.0.41AnyIncoherent results when using GROUP BY (regression)  
350022008-03-03
14:17
2011-02-16
23:43
MySQL Server: DMLVerified
(3576 days)
S25.1.23-rc/5.1BK/5.0/6.0Linux (2.6.22.9-61.fc6)Wrong results returned when using derived table and group by  
521562010-03-17
19:09
2011-02-16
23:44
MySQL Cluster: Cluster (NDB) storage engineVerified
(2765 days)
S3mysql-5.1-telco-6.3AnyIncomplete log message shows wrong log group  
19812003-11-28
14:42
2003-12-11
10:31
MySQL Server: MyISAM storage engineNot a Bug
(5121 days)
S34.0.16Mac OS X (Mac OS X)Unneccessary use of filesort and temporary table when using GROUP BY  
885092017-11-16
1:53
2017-11-16
1:53
Connector / NETOpenS46.10.4Microsoft WindowsExecuteScalar, ExecuteNonQuery and ExecuteReader suspended  
879982017-10-05
16:42
2017-10-10
15:07
MySQL Server: OptimizerNot a Bug
(69 days)
S35.7AnyMySQL Group By slow even when indexed  
206722006-06-23
22:51
2006-08-16
8:40
MySQL Cluster: Cluster (NDB) storage engineCan't repeat
(4142 days)
S25.1Linux (Linux)NDB regression fails if mysql-5.1 compiled with gcc4 Stewart Smith
140192005-10-13
22:45
2006-10-26
3:17
MySQL Server: OptimizerClosed
(4071 days)
S34.1.14 / 5.1.13Any (*)group by converts literal string to column name Georgi Kodinov
790442015-10-31
19:28
2015-10-31
19:28
MySQL Server: OptimizerOpenS45.7Anygroup by WITH CUBE  
19912003-12-01
12:26
2003-12-01
12:59
MySQL ServerClosed
(5131 days)
S34.1.0Linux (Debian3.0)Maybe an error in count syntax with GROUP BY  
831442016-09-26
6:48
2016-10-18
13:05
MySQL Server: mysqlpump Command-line ClientVerified
(448 days)
S35.7.15, 8.0.0Anymysqlpump reads mysql_dump group, not mysqlpump in config-group  
22492004-01-01
13:33
2004-01-02
6:39
MySQL Server: InnoDB storage engineCan't repeat
(5099 days)
S14.1.0-alphaLinux (Linux Redhat 8.0)Signal 11 Running Join Query Dean Ellis
168422006-01-27
14:12
2006-01-28
14:02
MySQL Cluster: Cluster (NDB) storage engineClosed
(4342 days)
S35.1.6 DD : Crash on drop logfile group after SR Jonas Oreland
388582008-08-18
13:56
2011-02-16
23:43
MySQL Server: ParserVerified
(3408 days)
S4AnyORDERGROUP BY construct  
347632008-02-22
19:20
2008-04-14
19:22
MySQL Server: OptimizerClosed
(3535 days)
S35.0+5.0+,5.1.24Anyitem_subselect.cc:1235:Item_in_subselect::row_value_transformer:Assertion failed Gleb Shchepa
388592008-08-18
14:17
2011-02-16
23:43
MySQL Server: ParserVerified
(3408 days)
S46.0Anylimiting a group - LIMITGROUP  
429552009-02-18
4:07
2011-02-16
23:43
MySQL Server: OptimizerClosed
(2583 days)
S26.0-bzr5.4+AnyWrong results returned by join queries with group by/order by when BKA is used  
452612009-06-02
10:47
2011-02-16
23:44
MySQL Server: Stored RoutinesClosed
(2838 days)
S35.1,5.45.1+AnyCrash, stored procedure + decimal Georgi Kodinov
53262004-08-31
21:25
2004-09-16
16:11
MySQL ServerClosed
(4841 days)
S24.1.4gammaMicrosoft Windows (Windows 2000/Slackware Linux)subselect with group by causes incorrect ERROR 1054 (42S22): Unknown column Oleksandr Byelkin
268302007-03-04
5:43
2007-03-15
3:00
MySQL Server: GeneralClosed
(3931 days)
S15.0.38BK, 5.1.17BKAny (*)subquery, group by .. with rollup crashes server Igor Babaev
493602009-12-02
17:53
2013-02-03
19:22
MySQL Server: OptimizerNo Feedback
(2451 days)
S35.0.66 , 5.0.84 , 5.0.84 , 5.1.41, 5.1.43AnyIn some circumstances, GROUP BY WITH ROLLUP is faster then GROUP BY  
869932017-07-09
18:28
2017-07-18
20:04
MySQL Server: DocumentationClosed
(153 days)
S35.6, 5.7AnyIncorrect statement about InnoDB group commit in the manual  
434742009-03-07
16:55
2012-05-18
20:19
MySQL Server: Falcon storage engineDuplicate
(3170 days)
S16.0-falcon-team6.0-betaAnyInvalid page number referenced from IndexRootPage::findLeaf() Assigned Account
578132010-10-28
14:40
2012-05-18
20:19
MySQL Enterprise Monitor: WebVerified
(2608 days)
S32.3.0.2036AnyMEM Dashboard: could not insert: [com.mysql.etools.monitor.pom.hib.HibNamed Assigned Account
695902013-06-26
15:59
2013-06-26
16:50
MySQL Server: DMLVerified
(1636 days)
S35.5.32AnyProblem using between with group by functions  
94302005-03-28
7:39
2005-04-28
13:51
MySQL ServerNo Feedback
(4617 days)
S35.0.3-betaMicrosoft Windows (windows 2000 server)can't group by view fields  
460382009-07-08
11:12
2011-02-16
23:44
MySQL Enterprise Monitor: ServerClosed
(3072 days)
S32.1.0.1074AnyMEM Admin setting does not save when creating a notification group Eric Herman
588382010-12-09
12:05
2011-03-03
2:27
MySQL Server: OptimizerClosed
(2482 days)
S35.6.1-m5AnyWrong results with HAVING + LIMIT without GROUP BY when ICP is enabled Olav Sandstå
20072003-12-03
18:58
2004-06-01
0:32
MySQLCCClosed
(4948 days)
S30.9.3Any (all)mysqlcc doesn't read [client] group Jorge del Conde
363142008-04-24
11:16
2008-04-24
11:47
MySQL Server: DocumentationNot a Bug
(3525 days)
S3allAnyGRANT is missing in SQL documentation  
649882012-04-15
22:10
2012-04-24
19:06
MySQL ServerClosed
(2064 days)
S35.5.23LinuxFLUSH LOGS failed when large_pages is on  
350382008-03-04
15:40
2010-05-26
18:00
MySQL Server: Falcon storage engineUnsupported
(2763 days)
S36.0-falcon-teamAnyFalcon crash on I_S query in RecordVersion::fetchVersion line 98 Christopher Powers
509102010-02-04
12:05
2011-02-16
23:44
MySQL Server: DocumentationClosed
(2874 days)
S35.1+Anyconfusing docs lines about replication group termination wth stop slave Jon Stephens
163512006-01-10
19:34
2006-01-11
7:19
MySQL Cluster: Cluster (NDB) storage engineCan't repeat
(4359 days)
S25.1.5-alphaLinux (Linux)DD: Invaild Table Space locked in memory Jonas Oreland
708802013-11-11
14:31
2013-12-13
1:00
MySQL ServerNo Feedback
(1467 days)
S25.5.24-logAnyGROUP BY function produces truncated columns in combination with CONV() or BIN()  
130242005-09-06
23:04
2011-02-16
23:43
MySQL Server: OptimizerVerified
(4485 days)
S44.1.14, 5.0.11Anyoptimizer does not use index when where has (field1,field2,..)=(value1,value2,.  
317142007-10-19
11:35
2011-02-16
23:43
MySQL Cluster: Disk DataVerified
(3706 days)
S3mysql-5.1CGELinuxNo usefull feedback when trying to create tablespace with nonexistant log group  
324822007-11-18
17:45
2008-01-14
19:09
MySQL Server: DMLClosed
(3626 days)
S25.1.22-rc-logLinuxcrash with GROUP BY alias_of_user_variable WITH ROLLUP Evgeny Potemkin
109822005-05-31
12:02
2005-06-01
3:49
MySQL ServerClosed
(4583 days)
S25.0Any (all)A query from olap.test returns a wrong result set Igor Babaev
97032005-04-07
2:26
2005-05-12
20:17
MySQL Server: OptimizerClosed
(4603 days)
S24.1.11Linux (RedHat EL3)Error 1032 with GROUP BY query and large tables Evgeny Potemkin
447752009-05-11
7:47
2011-02-16
23:43
Tools: MTR / mysql-test-runClosed
(3105 days)
S1Microsoft WindowsMTR fails to bootstrap mysqld on Windows in Pushbuild 2 Vladislav Vaintroub
432412009-02-26
17:54
2011-02-16
23:43
MySQL Cluster: Disk DataVerifiedS3mysql-5.1-telco-6.3AnyInconsistancy in warnings on create table / create tablespace with unknown engin  
859982017-04-19
9:02
2017-04-19
9:58
MySQL Server: DocumentationVerified
(243 days)
S35.7AnySELECT ... FOR UPDATE not listed as possibe limitation with Group Replication  
378702008-07-04
13:00
2008-11-11
21:35
MySQL Server: OptimizerClosed
(3324 days)
S15.0 -r2646, 5.1 - r2673 , 6.0 - r27646.0-betaAnyAssertion in convert_constant_item: result = 0 Evgeny Potemkin
514392010-02-24
1:43
2011-02-16
23:44
MySQL Proxy: DocumentationClosed
(2852 days)
S30.8.0Anydoc refers to [proxy] group in config file instead of [mysql-proxy] MC Brown
245602006-11-23
21:48
2007-04-30
9:30
MySQL Cluster: Disk DataClosed
(3885 days)
S25.1.14-bkLinux (Linux FC4)UNDO_BUFFER_SIZE <= 64K in CREATE LOGFILE GROUP -> data node failure justin he
424802009-01-30
14:13
2011-02-16
23:43
MySQL Cluster: Disk DataVerified
(3244 days)
S3mysql-5.1-telco-6.3LinuxLow setting for SharedGlobalMemory gives erroneous error 707 msg  
680862013-01-15
8:41
2013-01-15
19:28
MySQL Server: Memory storage engineVerified
(1798 days)
S35.5.29, 5.5.30, 5.7.1AnyHeap tables don't use index for group by  
573342010-10-08
4:58
2011-02-16
23:44
MySQL ServerCan't repeat
(2628 days)
S35.1.45AnyFULL OUTER JOIN is not working  
619432011-07-21
13:16
2012-07-11
9:38
MySQL Server: DMLVerified
(1990 days)
S45.5.12AnySyntax to specify a field from select_expr for Group By  
762832015-03-12
9:50
2017-10-24
14:22
MySQL Server: OptimizerClosed
(119 days)
S35.7AnyIncorrect result for DISTINCT SELECT  
821712016-07-08
19:24
2016-07-27
2:20
MySQL Server: DocumentationClosed
(509 days)
S3AnyGROUP BY Optimization clarification  
847312017-01-31
8:56
2017-09-18
10:30
MySQL Server: Group ReplicationClosed
(91 days)
S35.7.17AnyGroup Replication: mysql client connections hang during group replication start  
194522006-04-30
23:49
2006-09-02
1:55
MySQL Server: InstallingClosed
(4125 days)
S35.0, 5.1 mysql_upgrade: reads [client] group, but doesn't understand host option Alexey Botchkov
422362009-01-21
11:02
2009-01-23
9:18
MySQL Server: ViewsNot a Bug
(3251 days)
S35.1.30-communityMicrosoft WindowsORDER BY and/or GROUP BY behaves badly together with views.  
294382007-06-29
3:36
2007-07-29
8:21
MySQL Server: GeneralNo Feedback
(3795 days)
S35.0.41Anyrollup with multiple "group by" column repeats last grouping column final rollup  
20482003-12-08
12:12
2004-01-17
3:04
MySQL ServerClosed
(5084 days)
S24.1.2-alfaLinux (Linux slackware 9.0)some subselect queries crashes mysqld in case of innodb tables Oleksandr Byelkin
842242016-12-16
7:16
2017-01-31
5:04
MySQL Server: Group ReplicationCan't repeat
(321 days)
S35.7.17-logLinux (centos 6.6)mysql group replication bug Bogdan Kecman
322562007-11-10
11:56
2007-11-11
18:40
MySQL ServerNot a Bug
(3690 days)
S35.0.52-BK, 5.0.45Anymalfunction of JOIN with 'GROUP BY ... HAVING ...' clause  
706572013-10-18
16:55
2014-08-06
17:43
MySQL Server: OptimizerClosed
(1410 days)
S25.6.14LinuxSELECT DISTINCT...GROUP BY returns wrong results in some cases  
148502005-11-10
23:13
2005-12-09
19:09
MySQL Server: ViewsClosed
(4392 days)
S25.0.17-BK, 5.0.15Linux (Linux)ERROR 1062 when a quering a view using a Group By on a column that can be null. Evgeny Potemkin
808982016-03-30
5:00
2016-11-16
6:49
MySQL Server: InnoDB storage engineClosed
(626 days)
S35.7AnyReplication stops after transaction is rolled back asynchronously in master  
56352004-09-17
19:55
2004-09-20
12:46
MySQL AdministratorClosed
(4837 days)
S31.0.12Microsoft Windows (Windows XP SP2)'Add a Group' option does nothing is variable tabs of health section  
353312008-03-17
11:18
2008-11-28
15:02
MySQL Server: ViewsCan't repeat
(3307 days)
S36.0-falcon-team6.0-betaAnyCrash in Field::maybe_null on view updates Alexey Kopytov
368682008-05-22
1:17
2008-05-23
18:30
MySQL Server: GeneralNot a Bug
(3496 days)
S25.051b-community-ntMicrosoft WindowsUNIQUE contraint reports violation when with VARCHAR field  
273972007-03-23
13:12
2012-05-18
20:19
MySQL Server: TestsDuplicate
(3704 days)
S35.0.37 CommunityLinux (Linux, Solaris 8 SPARC,Solaris 10 x86)information_schema test fails  
752702014-12-19
1:33
2016-02-02
19:26
MySQL Server: OptimizerClosed
(983 days)
S35.6.16Anyquery results are different when opening or closing semijoin optimizer_switch  
99902005-04-19
5:24
2007-09-25
10:14
MySQL Server: Command-line ClientsNot a Bug
(3737 days)
S15.0.4Linux (Linux)CHANGE IN BEHAVIOR OF GROUP BY WORKING BY PARSER Geert Vanderkelen
225342006-09-21
0:18
2006-09-21
17:41
MySQL ServerCan't repeat
(4106 days)
S2any > 5Linux (linux)multiple aliases in a SELECT from a view with a GROUP BY clause has issues  
381502008-07-15
19:51
2008-09-03
17:41
MySQL Server: FULLTEXT searchNo Feedback
(3393 days)
S15.1.25-rcLinux (Suse 10.3)match ... against () never returns IN BOOLEAN MODE with characters like "-", "."  
48712004-08-03
14:45
2004-08-04
10:12
MySQL ServerNot a Bug
(4884 days)
S34.1.3Microsoft Windows (Windows NT4)MAX(COUNT(*))...GROUP BY  
138312005-10-07
8:39
2005-10-07
9:00
MySQL ServerCan't repeat
(4455 days)
S34.1.12aMicrosoft Windows (Windows XP)GROUP BY and AGGREGATE FUNCTION bug  
412232008-12-04
11:53
2011-02-16
23:43
MySQL Enterprise Monitor: WebClosed
(3300 days)
S32.0.0.7105Anycannot remove server from self-created goup: Error U0002: You must log in to ... Josh Sled
473672009-09-16
12:00
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2582 days)
S36.0AnyCrash in Name_resolution_context::process_error Roy Lyseng
540232010-05-27
9:54
2011-02-16
23:44
MySQL Server: OptimizerDuplicate
(2762 days)
S15.5.5_Celosia, 5.6.99_Dahlia, bzr_mysql-next-mr-opt-backportingAnycrash in fix_semijoin_strategies_for_picked_join_order with semijoin=off  
875602017-08-28
9:14
2017-12-14
6:21
MySQL Server: XA transactionsVerified
(5 days)
S2mysql-5.7.17AnyXA PREPARE log order error in replication and binlog recovery  
289362007-06-07
0:33
2007-06-07
7:51
MySQL Server: GeneralCan't repeat
(3847 days)
S15.0.41-MaxLinuxGroup by returning incorrect values when sub-query is involved  
389202008-08-20
16:09
2011-02-16
23:43
MySQL ServerVerified
(3061 days)
S45.0.32-7etch6Linux (Debian etch)Increasing innodb_log_file_size silently disables InnoDB Engine  
128092005-08-25
15:41
2005-09-15
19:19
MySQL ServerClosed
(4477 days)
S1MySQL-server-standard-4.1.13-0.rhel3.i38Linux (RHAS-3)server RPM fails to start because of install script Jim Winstead
212582006-07-24
19:38
2006-07-27
12:31
MySQL Cluster: Cluster (NDB) storage engineNot a Bug
(4162 days)
S25.1Linux (Linux)Cluster will not start if new nodes added to the cluster with existing database.  
56442004-09-18
20:01
2004-11-18
20:46
MySQL Server: MyISAM storage engineNo Feedback
(4778 days)
S24.1.4-gamma-ntMicrosoft Windows (Windows XP Pro + all patches)LIKE brings a MySQL Server to hang with 100% cpu  
806532016-03-08
6:43
2016-03-15
10:10
MySQL ServerClosed
(643 days)
S25.7.10AnyCOUNT DISTINCT GROUP BY ROLLUP return wrong number  
481412009-10-19
8:55
2011-02-16
23:44
MySQL Enterprise Monitor: WebClosed
(2943 days)
S32.2.0.1514AnyUI: add servers to a group shows all servers and not only the selected ones Josh Sled
379022008-07-06
15:14
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3431 days)
S35.0.45, 5.0.68Mac OS XBug (2) in the query optimizer (explain)  
20632003-12-09
12:45
2003-12-10
5:58
MySQL ServerWon't fix
(5122 days)
S34.0.17 Strange GROUP BY behavior with user variables  
146072005-11-03
14:25
2006-11-02
7:02
MySQL ServerCan't repeat
(4064 days)
S35.1.7Linux (Linux, Windows)count(substring) cannot return value if we use rollup in group statement Georgi Kodinov
325272007-11-20
14:40
2012-09-02
20:45
MySQL Server: OptimizerNo Feedback
(3632 days)
S55.0.42Solaris (Solaris 10 U4 patch 120012-14)when selecting from a view, filesort is needlessly used Assigned Account
368792008-05-22
8:32
2008-05-23
12:37
MySQL Server: DocumentationClosed
(3496 days)
S35.0.51a-3ubuntu5.1-logLinux (Kubuntu 8.04)mysql monitor "help max" and "help min" provider no help but "help min max" does Paul Dubois
419992009-01-09
15:30
2011-02-16
23:43
MySQL Server: GeneralDuplicate
(3198 days)
S15.0.67, 5.0.74, 5.1.305.0+LinuxSHOW CREATE VIEW returns invalid SQL if subquery is used in SELECT list Gleb Shchepa
443032009-04-16
1:55
2011-02-16
23:43
MySQL Server: OptimizerClosed
(2585 days)
S16.0.10-debug, 6.0.12-debug, 5.4.4-alpha-debug5.4+AnyAssertion failures in Field_xxx::store_xxx for materialized InsideOut semijoins Øystein Grøvlen
389282008-08-20
21:58
2008-08-20
22:52
MySQL Server: DMLNot a Bug
(3407 days)
S25.0.67-community-ntMicrosoft Windows (XP SP2)select ... count(*) not enforcing group by clause when obtaining other fields  
169132006-01-30
18:48
2006-03-14
9:05
MySQL Cluster: Cluster (NDB) storage engineClosed
(4297 days)
S25.1Linux (Linux)DD: Cluster fails to create more then 9 table spaces. Jonas Oreland
210092006-07-12
17:38
2006-07-17
18:12
MySQL ServerCan't repeat
(4172 days)
S15.0.22FreeBSD (FreeBSD)mysql crashing on signal 11 Sveta Smirnova
565932010-09-06
12:20
2010-09-06
16:24
MySQL Server: ParserNot a Bug
(2660 days)
S35.1.41Linuxscope issue in "ON DUPLICATE KEY UPDATE" when using aggregation functions  
701622013-08-27
12:57
2013-08-28
2:12
MySQL Server: OptimizerNot a Bug
(1573 days)
S25.1 5.5 5.6AnyWrong result for @i:=@i+1 in query while using group by and order by  
210102006-07-12
17:38
2006-07-12
20:34
MySQL ServerDuplicate
(4177 days)
S34.0 4.1 5.0 5.1 GROUP BY clause resolves a string as an identifier  
15552003-10-15
3:44
2003-10-18
14:04
MySQL ServerClosed
(5175 days)
S14.1.0-alpha-max-ntMicrosoft Windows (Windows 2000 Advanced Server SP4)SELECT statement with HAVING clause, but no GROUP BY clause crashes Service Godofredo Miguel Solorzano
23232004-01-08
9:20
2004-02-26
13:46
MySQL ServerNo Feedback
(5044 days)
S14.0.15Mac OS X (OSX 10.3.2)Table caching problem? data doesn't update  
69312004-12-02
3:45
2005-02-04
13:26
MySQL ServerClosed
(4700 days)
S34.1.8Any (any)Date Type column problem when using UNION-Table. Sergey Glukhov
240832006-11-08
11:02
2012-05-18
20:19
MySQL Server: DMLVerified
(3364 days)
S45.0.29-BK, 5.0.26-communityTBDLinux (Linux, WinXP)GROUP BY expressions should be allowed in the HAVING clause Assigned Account
430272009-02-19
16:09
2012-05-18
20:19
MySQL Enterprise Monitor: Advisors/RulesVerified
(3223 days)
S42.0AnyGlobal changes of notifications and Advisors in Enterprise Dashboard Mark Leith
642752012-02-09
10:29
2012-02-22
13:10
MySQL Server: ParserNot a Bug
(2126 days)
S15.1.xLinuxBad row counter under 5.1.x  
816842016-06-02
6:05
2016-06-02
13:22
MySQL Server: DMLVerified
(564 days)
S15.7.8, 5.6.30, 5.7.12Anyselect + where exists( select + group by + limit) works incorrectly  
463562009-07-23
14:06
2012-05-18
20:19
MySQL Server: OptimizerDuplicate
(2980 days)
S35.4, 6.05.4+AnyCertain queries aren't recognizing GROUP BY w/ join_cache_level = 1  
13012003-09-16
8:26
2004-03-12
6:16
MySQL ServerClosed
(5029 days)
S14.1Linux (Linux RH 7.3)func_gconcat test fails in valgrind-max build Michael Widenius
20692003-12-09
20:17
2003-12-10
13:52
MySQL Server: User-defined functions ( UDF )Closed
(5122 days)
S24.0.16Linux (Linux (Gentoo))using an aggregate udf, the order by clause changes NULL to 0  
711892013-12-20
14:56
2014-01-13
9:53
MySQL Server: DocumentationVerified
(1459 days)
S35.5, anyAnyManual does not provide enough details on how loose index scan really works Paul Dubois
734952014-08-07
8:27
2017-07-06
19:19
MySQL FabricWon't fix
(1228 days)
S31.4.4AnyMySQL Fabric database permissions need to be more clearly documented Assigned Account
115432005-06-24
9:08
2005-07-25
20:38
MySQL Server: OptimizerClosed
(4529 days)
S3 4.1.11-Debian_0.dotdeb.0-logLinux (Linux - Debian)Error in GROUP BY .. WITH ROLLUP Igor Babaev
79602005-01-17
16:17
2005-01-19
19:26
MySQL ServerNot a Bug
(4716 days)
S35.0.0-alphaMicrosoft Windows (Windows XP)Lost Connection during SQL Select  
783602015-09-08
6:14
2015-09-08
12:29
MySQL Server: DMLVerified
(832 days)
S35.6.22, 5.6.26AnyMore than 1 row is returned when using "having count(alias)"  
875772017-08-29
10:23
2017-08-29
10:25
MySQL Server: DMLDuplicate
(111 days)
S15.7.19Any Field* Item::tmp_table_field_from_field_type(TABLE*, bool):Assertion `0' failed  
420092009-01-10
1:44
2011-02-16
23:43
MySQL Server: DMLClosed
(3098 days)
S25.1.30-log, 4.1, 5.0, 5.1, 6.0 bzr5.0+Linux (Ubuntu 8.10 with 2.6.27-9-generic kernel)SELECT into variable gives different results to direct SELECT Ramil Kalimullin
494332009-12-03
22:30
2011-02-16
23:44
MySQL WorkbenchClosed
(2677 days)
S35.2.10 BetaWB52Linux (mysql-workbench-oss-5.2.10-1ubu804-amd64.deb)Display too small in Routines tab in Routine Group editor Alfredo Kojima
601852011-02-20
15:58
2011-03-03
8:35
MySQL Server: OptimizerVerified
(2493 days)
S35.0.51, 5.5.11Linuxindex DEPENDENT SUBQUERY  
151302005-11-22
11:19
2007-07-27
16:23
MySQL Server: OptimizerClosed
(3797 days)
S55.0.16, 4.1.15Linux (Linux)CREATE TABLE ... SELECT SQL_BIG_RESULT looses filesort optimization Evgeny Potemkin
548122010-06-25
14:58
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2538 days)
S35.1, 5.5Anyassert in Diagnostics_area::set_ok_status during EXPLAIN Jørgen Løland
614682011-06-09
21:54
2015-08-10
14:34
MySQL Server: mysqldump Command-line ClientVerified
(2383 days)
S4Anymysqldump values() group size  
701732013-08-28
7:58
2013-11-15
18:08
MySQL Server: OptimizerClosed
(1494 days)
S45.7.3Anyplease remove sort aborted errors from the error log  
251172006-12-17
8:19
2012-05-18
20:19
MySQL Cluster: Disk DataVerified
(4010 days)
S3mysql-5.1CGELinux (Linux FC4)mysql hangs if during creating logfile group or tablespace one ndbd was stopped Assigned Account
535342010-05-10
8:50
2011-12-06
1:05
MySQL Server: OptimizerClosed
(2204 days)
S25.1.44, 5.1.47, 5.1.49, 5.0, 5.6.99AnyIncorrect 'select SQL_BIG_RESULT...' with GROUP BY on subquery columns  
151352005-11-22
14:28
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3194 days)
S54.1.14Any (NT)Dependent subquery performs very badly Sergey Petrunya
215352006-08-09
10:58
2006-11-02
8:38
MySQL Cluster: Cluster (NDB) storage engineClosed
(4064 days)
S2MySQL cluster 5.0.22Linux (Redhat Linux 2.6.9-34.ELsmp #1 )3r: The failure handling of node 1 ends up in an infinite loop. Jonas Oreland
586552010-12-02
12:38
2011-06-13
12:54
MySQL ServerClosed
(2380 days)
S35.1.55-debug5.1+AnyAssertion failed, server crashes with mysqld got signal 6  
607032011-03-31
7:26
2015-11-19
16:59
MySQL Server: OptionsVerified
(2365 days)
S2MySQL Community 5.5.9Microsoft Windows (Windows Server 2003 Standard Edition)" --verbose --help" seems don't read the options in service name based group  
161602006-01-03
17:57
2006-01-04
13:45
MySQL Cluster: Cluster (NDB) storage engineClosed
(4366 days)
S15.1Linux (Linux)DD: CREATE LOGFILE GROUP cause core Jonas Oreland
712012013-12-21
20:01
2014-01-16
5:36
MySQL Server: Performance SchemaClosed
(1432 days)
S35.6.14, 5.6.15AnyMore than one stage named "stage/sql/init"? Marc Alff
773452015-06-14
9:26
2015-06-14
9:26
MySQL ServerOpenS4AllAnyThe aggregate functions of MySQL is too slow, too much CPU for type convertion  
138572005-10-07
22:06
2005-10-21
10:55
MySQL ServerNot a Bug
(4441 days)
S25.0.13-rc-ntMicrosoft Windows (Windows 2003)Comparison operator semantics changed, does not convert string date literals  
297292007-07-11
18:06
2007-07-23
0:44
MySQL Server: GeneralClosed
(3801 days)
S25.0.44, 5.0.45Linuxdatetime compared with date failing to add zero time on group by query Evgeny Potemkin
517452010-03-05
4:29
2010-03-05
4:34
MySQL Server: GeneralNot a Bug
(2845 days)
S2Community 5.1AnyLack of GROUP BY fails to stop query execution with non-aggregated column  
38742004-05-24
17:28
2005-10-13
14:42
MySQL ServerClosed
(4449 days)
S33.23.58FreeBSD (Free BSD)A Group By Field is not considered Alexey Botchkov
194902006-05-02
20:17
2006-05-15
19:42
MySQL ServerClosed
(4235 days)
S15.0.21 and 5.1.10Linux (Linux)View on a date column with calculated INTERVAL crashes the server Igor Babaev
41312004-06-14
20:12
2004-09-26
21:58
MySQL ServerClosed
(4831 days)
S24.0.20Linux (Linux)TIMESTAMP columns missing minutes and seconds when using GROUP BY Dmitry Lenev
752992014-12-23
15:45
2017-03-23
12:11
MySQL Server: ReplicationDuplicate
(326 days)
S35.6Anygroup commit with GTID enabled need more optimization  
412512008-12-05
9:49
2011-02-16
23:43
MySQL Enterprise Monitor: ServerNo Feedback
(3234 days)
S32.0.0.????Solaris (10u6 x86_64)Dashboard repeatedly fails to recognize replication group  
25962004-01-31
11:17
2005-04-28
2:29
MySQL ServerClosed
(4617 days)
S35.0 alphaSolaris (Solaris 9 sparc 64)MySQL Client Segmentation Fault on Solaris 9 Magnus Blåudd
712042013-12-22
15:42
2014-01-06
13:43
MySQL Server: Performance SchemaVerified
(1455 days)
S35.6.14, 5.6.16AnyTiming for stages in P_S is different from what SHOW PROFILE reports Marc Alff
72042004-12-12
17:20
2004-12-13
7:50
MySQL ServerClosed
(4753 days)
S24.1.8-preIBM AIX (AIX 4.3.3)"func_str" fails on AIX 4.3 when using --ps-protocol Sergei Golubchik
530282010-04-21
15:49
2011-02-16
23:44
MySQL ServerNo Feedback
(2752 days)
S15.1.42ceLinuxmysqld got signal 7  
100212005-04-20
2:46
2005-06-01
18:31
MySQL Server: OptimizerCan't repeat
(4583 days)
S35.0.4/5.0.5 BKMicrosoft Windows (win2000)group by fields must on a index ? Evgeny Potemkin
302452007-08-05
20:44
2007-09-14
15:17
MySQL ServerClosed
(3748 days)
S35.0/5.15.1.23AnyBIT type gets cast to LONG when DISTINCT or GROUP BY is used Evgeny Potemkin
732542014-07-10
9:00
2014-11-03
15:11
MySQL FabricCan't repeat
(1141 days)
S31.4.3Linux (ubuntu 3.11.0-18-generic)Can mysql fabric automatically restart replication after failover? Mats Kindahl
778632015-07-28
19:00
2015-07-30
13:05
MySQL Server: Performance SchemaClosed
(872 days)
S55.6.26Anyslowdown caused by memset in sql_digest_storage.reset() Marc Alff
409992008-11-25
5:34
2011-02-16
23:43
MySQL Cluster: Disk DataVerifiedS4mysql-5.1-telco-6.3AnyCluster cannot increase undo log buffer size.  
481672009-10-19
18:54
2011-02-16
23:44
MySQL Enterprise Monitor: WebClosed
(2978 days)
S3Anydashboard full-graph popup doesn't reflect group/server selection Josh Sled
678802012-12-12
1:20
2012-12-12
5:17
MySQL Server: InstallingVerified
(1832 days)
S15.6.9Microsoft Windowsmysql 5.6.9 on windows does not start if my.ini file is in utf8 format  
61842004-10-20
20:49
2004-10-21
13:58
MySQL ServerCan't repeat
(4806 days)
S24.0.20Linux (Gentoo Linux 2.6.8)FOUND_ROWS() returns the wrong value when GROUP BY and HAVING clauses are used Victoria Reznichenko
120722005-07-20
21:02
2005-07-21
0:38
MySQL ServerClosed
(4533 days)
S15.0.9Microsoft Windows (WinXP)Incorrect results when using GROUP BY after applying an index  
438162009-03-24
0:57
2011-02-16
23:43
MySQL Enterprise Monitor: ServerClosed
(3132 days)
S32.0.5.7153AnyReplication group is renamed back to default after new topology discovered Darren Oldag
540562010-05-28
6:43
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2761 days)
S35.1.47, 5.1.48, 5.6.99AnyIncorrect number format in output from SELECT  
271772007-03-15
15:14
2007-07-03
15:05
MySQL Server: DocumentationClosed
(3821 days)
S3All VersionsAnySHOW PROCESSLIST Syntax - add descriptions for state Paul Dubois
814502016-05-17
5:28
2016-05-18
13:24
MySQL Server: DMLVerified
(580 days)
S15.5.49Anyvoid make_sortkey(SORTPARAM*, uchar*, uchar*): Assertion `0' failed make_sortkey  
251302006-12-18
5:46
2012-03-26
19:41
MySQL Server: OptimizerClosed
(2093 days)
S55.0.34-BK, 5.0.27, 5.1, 5.5.0Microsoft Windows (Windows, Sparc & Linux)Extremely Slow "Where in (Select... )" Subqueries GROUP BY / HAVING related  
479142009-10-08
9:10
2012-03-26
19:30
MySQL Server: OptimizerClosed
(2093 days)
S24.1 and 5.1Microsoft Windows (Windows Server 2003)Performance Issue with Subquery  
794032015-11-25
7:35
2015-11-25
7:36
MySQL RouterOpenS12.0.2AnySwitchover does not work with fabric plugin  
568752010-09-20
15:44
2011-02-16
23:44
MySQL Workbench: ModelingCan't repeat
(2646 days)
S25.2.26 rev 6432Mac OS X (10.5.8)dropping dragged routines in the wrong place crashes the workbench  
783802015-09-09
10:58
2016-04-27
15:07
Tests: ReplicationClosed
(831 days)
S35.7.9AnyUpdate rpl suite tests to work on Group Replication  
133562005-09-20
18:49
2005-09-30
17:10
MySQL Server: OptimizerClosed
(4462 days)
S15.0.10-beta/5.0 BK sourceLinux (linux)server crash Evgeny Potemkin
325562007-11-21
5:11
2008-01-14
18:59
MySQL Server: OptimizerClosed
(3626 days)
S15.0.50,5.1.23,6.0.3Anyassert in "using index for group-by" : is_last_prefix <= 0, file .\opt_range.cc Gleb Shchepa
417722008-12-28
19:37
2008-12-30
17:59
MySQL Server: ParserNot a Bug
(3275 days)
S35.0.41Mac OS X (Leopard 10.5.5)Using a timestamp in ORDER BY on a GROUP BY SQL doesn't work properly  
494532009-12-04
10:31
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2582 days)
S36.0Anyre-execution of prepared statement with view and semijoin crashes Jørgen Løland
832462016-10-03
13:43
2017-09-21
14:50
MySQL Server: Document Store: ShellVerified
(440 days)
S45.7.15-labs-gr090AnyImprove dba.validateInstance() error output to include my.cnf format  
325582007-11-21
6:46
2007-12-12
19:43
MySQL Server: GeneralClosed
(3659 days)
S15.1.23Anygroup by null-returning expression with rollup causes crash Ramil Kalimullin
471502009-09-05
11:13
2014-09-10
6:59
MySQL Server: OptimizerClosed
(2922 days)
S25.1,5.45.1+AnyAssertion in Field_long::val_int() on MERGE + TRIGGER + multi-table UPDATE Sergey Glukhov
783832015-09-09
14:51
2015-09-10
14:28
MySQL Server: GeneralNot a Bug
(830 days)
S35.5 / 5.6AnyBug with group by & group_concat  
875992017-08-30
7:58
2017-09-26
11:37
MySQL Server: Shell ( AdminAPI InnoDB Cluster )Verified
(83 days)
S31.10Red Hat (7.3)The instance is already part of a Replication Group (RuntimeError)  
484312009-10-30
9:31
2011-02-16
23:44
MySQL Cluster: Cluster (NDB) storage engineClosed
(2912 days)
S3mysql-5.1-telco-6.3Linux (RHEL 5.2)Loop in linked list when printing crash dump Jonas Oreland
691682013-05-07
19:20
2013-09-18
6:38
MySQL Server: InnoDB storage engineClosed
(1552 days)
S25.6.11, 5.6.12Any (FreeBSD, Linux)COUNT(*)...GROUP BY sometimes returns wrong results on partitioned InnoDB tables  
44002004-07-03
20:52
2004-07-17
1:42
MySQL ServerClosed
(4902 days)
S34.1Any (all)incorrect error message about aggregate function in subquery Oleksandr Byelkin
847842017-02-02
3:06
2017-11-16
8:12
MySQL Server: Group ReplicationVerified
(290 days)
S25.7.17AnyGroup Replication nodes do not rejoin cluster after network connectivity issues Filipe Campos
379362008-07-07
16:07
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3245 days)
S15.1.28-bzr, 6.0, 6.0.7-bzr5.1+AnyASSERT_COLUMN_MARKED_FOR_WRITE in Field_datetime::store , Field_varstring::store Georgi Kodinov
394722008-09-16
8:59
2015-01-09
10:03
MySQL Enterprise Monitor: WebClosed
(1074 days)
S41.x, 2.0Anydirectly access a group or host  
507362010-01-29
15:55
2011-02-16
23:44
MySQL Cluster: Cluster (NDB) storage engineClosed
(2792 days)
S1mysql-5.1-telco-7.0LinuxGROUP BY does not use index on ndbcluster tables Jonas Oreland
824812016-08-06
17:28
2016-12-02
13:01
MySQL Server: Group ReplicationClosed
(381 days)
S15.7.14AnyMySQL Group Replication 0.8 is asynchronous Nuno Carvalho
847852017-02-02
3:38
2017-06-09
9:37
MySQL Server: Group ReplicationClosed
(192 days)
S25.7.17AnyPrevent Large Transactions in Group Replication  
312812007-09-28
15:09
2007-10-28
15:24
MySQL Server: DMLNo Feedback
(3704 days)
S15.0.41-community-nt-logMicrosoft WindowsGroup by and subquery issue in 5.0.41-community-nt-log  
15862003-10-17
6:32
2003-10-19
15:00
MySQL ServerNot a Bug
(5174 days)
S33.23.49Linux (RH 7.3)group by not working with an aggregate function on date field  
317942007-10-23
18:03
2007-11-29
0:47
MySQL Server: OptimizerClosed
(3672 days)
S35.1.20-betaAnyno syntax error on SELECT id FROM t HAVING count(*)>2; Georgi Kodinov
397302008-09-29
14:30
2008-10-04
14:14
MySQL Server: InnoDB storage engineDuplicate
(3362 days)
S15.0.67Microsoft Windows (XP 5.1.2600)Query Crash Mysql Server 5.0.67  
115712005-06-25
13:40
2005-06-25
14:02
MySQL ServerCan't repeat
(4559 days)
S15.0.4-betaMicrosoft Windows (Windows XP)server-crash while performing subquery with "group by" and "where"  
758282015-02-09
18:32
2015-02-24
21:17
Connector / NETNot a Bug
(1028 days)
S36.9.5Microsoft Windows (Win7, x64)Incorrect sorting when using GROUP BY and COUNT Roberto Ezequiel Garcia Ballesteros
817162016-06-03
16:19
2016-11-02
13:32
MySQL Server: ReplicationClosed
(495 days)
S35.7AnyTX_ISOLATION INFORMATION SHOULD BE ADDED TO TRAN_CONTEXT_INFO (REQUIRED FOR GR)  
307722007-09-03
16:34
2007-09-07
16:47
MySQL Enterprise Monitor: ServerClosed
(3755 days)
S31.2.0.7406AnyExceptions in catalina.out for support zip feature as replication info disabled Mark Matthews
865812017-06-05
4:48
2017-06-14
3:37
MySQL Server: Group ReplicationVerified
(187 days)
S45.7.18AnyGCS timeout waiting for executing stop group_replication when loss majority  
179742006-03-06
16:16
2006-03-21
10:08
MySQL ServerWon't fix
(4290 days)
S34.1.18Any (Any)INSERT ... SELECT with GROUP BY causes truncation of DECIMAL Ramil Kalimullin
271902007-03-15
21:30
2007-03-15
21:54
MySQL Server: CompilingCan't repeat
(3931 days)
S25.0.37Linux (Linux (tar.gz download))Information Schema test fails  
422942009-01-23
9:51
2011-02-16
23:43
EventumClosed
(3248 days)
S32.2Anyerrors in the upgrade process while converting the database to UTF-8 Bryan Alsdorf
13352003-09-18
10:06
2003-12-09
14:21
MySQL ServerClosed
(5123 days)
S34.0.15 "Filesort" is missing in EXPLAIN Konstantin Osipov
246312006-11-27
19:57
2007-05-23
15:50
MySQL Cluster: Disk DataClosed
(3862 days)
S25.1.14-bkLinux (Linux FC4)DD files aren't deleted when stopped node started again Jonas Oreland
21042003-12-12
6:02
2004-01-30
5:45
MySQL Server: MyISAM storage engineCan't repeat
(5071 days)
S14.0.16Linux (RH 9, Apache 1.3.29)after deleting row index got fragmented Michael Widenius
200242006-05-23
16:36
2006-05-23
22:19
MySQL ServerNot a Bug
(4227 days)
S35.0.19Linux (RHEL4)Single Column Distict Query not performing as expected  
8252003-07-10
2:34
2003-09-19
15:38
MySQL ServerCan't repeat
(5204 days)
S24.1-AlphaLinux (Linux)GROUP_CONCAT returns weird sets of data Vasily Kishkin
753212014-12-28
8:44
2015-01-09
13:50
MySQL FabricDuplicate
(1074 days)
S11.5.3Linux (CentOS 7)fabric commands hang indefinitely during fabric setup  
3142003-04-22
17:01
2003-04-26
4:22
MySQL ServerClosed
(5350 days)
S34.0 GROUP BY forces functions to treat multy-byte charset values as single-byte Alexander Barkov
730182014-06-17
3:20
2015-06-22
10:02
MySQL Server: ReplicationVerified
(910 days)
S55.6Any improve performance when binlog_order_commits=0 and sync_binlog >1  
184902006-03-24
15:46
2006-04-05
4:41
MySQL Cluster: Cluster (NDB) storage engineClosed
(4275 days)
S25.1.8 bk src cluster: binlog events lost on remote mysqld (asynchronous) Tomas Ulin
236102006-10-25
3:28
2006-11-03
18:52
MySQL Enterprise Monitor: InstallingClosed
(4063 days)
S1Linux (linux)Server - files in the /usr/sbin dir are being set to group 'mysql' (br 1787) Keith Russell
256582007-01-16
19:34
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3277 days)
S15.2.0 falcon-alpha and now 5.2.36.0-rcLinux (Linux Fedora Core 6)Group by Performance is slow Sergey Petrunya
348742008-02-27
9:47
2011-02-16
23:43
MySQL Server: DMLVerified
(3582 days)
S35.0+AnyWrong result with IN(SELECT aggregate FROM DUAL)  
678992012-12-13
18:26
2013-02-24
19:43
MySQL Server: OptimizerClosed
(1758 days)
S55.5.27Linux (CentOS 6.3)Adding LIMIT to query increases time from 2 seconds to 42 minutes  
128592005-08-29
18:59
2005-09-06
15:52
MySQL Server: OptimizerClosed
(4486 days)
S34.1.14, 5.0.11Microsoft Windows (Windows, freebsd)group_concat in subquery cause incorrect not null Evgeny Potemkin
310352007-09-14
20:47
2007-10-23
0:26
MySQL Server: GeneralClosed
(3709 days)
S15.0.50, 5.1.235.0.50,5.1Anyselect from function, group by result crasher Alexander Nozdrin
41562004-06-16
0:26
2004-06-16
13:58
MySQL ServerNot a Bug
(4933 days)
S34.1.2 ALphaMicrosoft Windows (Win XP Pro)Error 1250 Table from one of the SELECT's cannot be used in global ORDER clause Oleksandr Byelkin
766042015-04-07
4:29
2015-04-07
6:15
MySQL Server: OptimizerVerified
(986 days)
S35.6.23, 5.6.24, 5.6.25, 5.7.8Linux (CentOS 7)Assertion `length > 0 && keyparts != 0' failed in create_ref_for_key  
123482005-08-03
14:46
2005-08-08
16:20
MySQL Server: InstallingClosed
(4515 days)
S24.1.13Linux (CentOS 4.1)Installation RPM fails because of groupadd on CentOS Linux. Lenz Grimmer
202842006-06-06
7:57
2006-07-27
2:47
MySQL Server: DocumentationClosed
(4162 days)
S45.0.20Any (All)There is no description of "copying to group table" Paul Dubois
732772014-07-11
13:23
2014-07-15
13:55
MySQL Server: ParserVerified
(1252 days)
S35.537-35.1-log, 5.0.97, 5.1.74, 5.5.39, 5.6.21, 5.7.5AnyREGEXP escape of - not escaped properly in character group  
105572005-05-11
14:44
2005-05-11
15:41
MySQL Server: OptimizerNot a Bug
(4604 days)
S35.0.4-beta-debugLinux (linux 2.6.8-24.14 smp)Too few results when "Using index for group-by"  
184932006-03-24
17:01
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3776 days)
S45.0.18TBDLinux (Linux)"Using index for group-by" not used in subqueries  
312932007-09-29
16:57
2011-02-16
23:43
MySQL Server: DDLClosed
(2623 days)
S35.1.22-ndb-6.3.2-telco-logAnycreate logfile group/tablespace returns OK with warning when engine=myisam  
330852007-12-08
13:22
2012-05-18
20:19
MySQL Server: Stored RoutinesDuplicate
(3654 days)
S25.1-BKAnyStored functions crash server when used in select list and group by Georgi Kodinov
840302016-12-01
18:40
2017-01-02
1:00
MySQL Server: DMLNo Feedback
(351 days)
S35.6.34LinuxDuplicate entry error when doing GROUP BY with UTF collation  
847982017-02-02
14:32
2017-09-22
15:41
MySQL Server: Group ReplicationClosed
(87 days)
S35.7.17AnyGroup Replication can use some verbosity in the error log  
215662006-08-10
12:25
2006-09-10
12:35
MySQL ServerNo Feedback
(4117 days)
S1VERSION 5.1.17Linux (LINUX 2.4.20-8)Query Working With Windows XP is not Working in LINUX 2.4.20-8  
694392013-06-11
9:00
2013-06-11
14:15
MySQL Server: DocumentationClosed
(1651 days)
S35.1.70, 5.5.32AnyDocumented minimal value of innodb_log_file_size is wrong in 5.1 and 5.5  
776322015-07-06
19:07
2015-08-26
13:29
MySQL Server: DMLClosed
(845 days)
S25.7.7Linuxcount distinct returns in-correct result  
277122007-04-09
10:02
2007-04-27
12:30
MySQL Cluster: Disk DataClosed
(3888 days)
S35.1.18-bkLinux (FC4 64bit)Single user mode. Creating logfile group and tablespace is allowed Tomas Ulin
615042011-06-13
17:38
2011-06-14
21:22
MySQL Server: ViewsClosed
(2379 days)
S25.1.41Linux (Ubuntu 10.04)Error generating view code  
167052006-01-22
1:09
2006-06-01
12:06
MySQL Server: OptimizerNot a Bug
(4218 days)
S25.0.19Linux (Linux)User variable in GROUP BY causes unpredictable results Georgi Kodinov
13462003-09-19
5:03
2003-09-19
7:45
MySQL Server: Command-line ClientsNot a Bug
(5204 days)
S34.0.12Microsoft Windows (Windows 2000)Finding Duplicates with GROUP BY  
154262005-12-02
9:34
2011-06-25
0:41
MySQL Server: DMLWon't fix
(2368 days)
S44.1,5.05.5+Linux (Linux)SQL_CALC_FOUND_ROWS Geir Høydalsvik
400022008-10-13
14:18
2008-10-22
9:30
MySQL ServerCan't repeat
(3344 days)
S15.0.18AnyWrong result using group by  
453792009-06-08
18:00
2015-08-05
8:22
MySQL Server: OptionsDuplicate
(866 days)
S45.1.31, 5.0, 5.1, 6.0 bzrLinuxMySQL shouldn't "guess" at the variable names  
213162006-07-27
13:34
2006-07-27
15:39
MySQL ServerClosed
(4162 days)
S25.0.21Linux (Linux)a group by clause crash the server  
208052006-07-01
16:25
2006-07-05
13:55
MySQL ServerClosed
(4184 days)
S25.0.22Linux (linux)select with order by date_add crashes the server  
799422016-01-13
0:57
2017-07-06
19:20
MySQL Fabric: Installation and ConfigurationWon't fix
(705 days)
S31.6.3AnyMySQL Fabric log-bin or gtid requirement logic failure  
259262007-01-29
19:34
2008-01-23
18:19
MySQL Server: OptimizerClosed
(3617 days)
S55.0.18, 5.0.24, 5.0.27, 5.0.37Microsoft Windows (windows xp)dependent suqbuery takes too long Sergey Petrunya
438462009-03-24
23:04
2011-02-16
23:43
MySQL Enterprise Monitor: ServerClosed
(3132 days)
S32.0.5.71532.0.6AnyError when renaming replication group to a previous name Darren Oldag
87752005-02-24
11:15
2006-04-14
13:49
MySQL ServerClosed
(4266 days)
S24.1.10Microsoft Windows (windows/linux)Using string literal with a name of a column makes query return too few rows Georgi Kodinov
261832007-02-08
12:02
2014-01-05
20:45
MySQL Websites: bugs.mysql.comVerified
(3966 days)
S2http://bugs.mysql.com/search.phpAny (www)Can't find a bug using up-level category Assigned Account
407752008-11-17
9:26
2012-05-18
20:19
MySQL Enterprise Monitor: ServerVerified
(3275 days)
S42.0.0.7088AnyProvide rules to enable agents to be automatically added to server groups  
377042008-06-27
22:03
2008-06-28
16:47
MySQL ServerNot a Bug
(3460 days)
S35.1.22-rcLinuxSetting wait_timeout using my.cnf error  
663772012-08-14
13:17
2012-08-21
10:28
MySQL Workbench: ModelingClosed
(1945 days)
S15.2.41, 5.2.42Mac OS X (Snow Leopard)Workbench crashes when Routine-Group (Editor) is closed  
146662005-11-05
2:05
2005-11-05
4:31
Connector / ODBCClosed
(4426 days)
S13.51Microsoft Windows (Windows XP Pro)SELECT statement works in MySQL but not through ODBC Godofredo Miguel Solorzano
456422009-06-21
20:35
2011-02-16
23:44
MySQL WorkbenchClosed
(3098 days)
S25.1.14RCAnyGenerated INSERT statements don't have database name Alexander Musienko
474342009-09-18
10:18
2011-02-16
23:44
MySQL Server: DMLVerified
(3008 days)
S35.0.51a-24+lenny1-log, 5.1.38LinuxAmbigous field name in group by clause does not cause an error  
36592004-05-05
10:34
2004-07-19
13:39
MySQL Cluster: Cluster (NDB) storage engineClosed
(4900 days)
S1mysql-4.1.2-alpha bkFermiLinux LTS 3.01>1 concurrent update causes deadlock Magnus Blåudd
758512015-02-10
19:21
2015-08-04
9:43
MySQL Server: DDLVerified
(867 days)
S25.6.22, 5.6.25, 5.6.27AnySHOW CREATE VIEW should retain original view formatting and definition  
868592017-06-29
4:23
2017-11-21
9:44
MySQL Server: Group ReplicationWon't fix
(125 days)
S25.7.18AnyGroup Replication does not honor skip-name-resolve  
548592010-06-28
9:12
2011-02-16
23:44
MySQL Cluster: Cluster (NDB) storage engineClosed
(2730 days)
S3Any>2 replica: Hanging if 1 node can not be restored using REDO log during SR Jonas Oreland
702202013-09-03
6:14
2015-10-26
15:51
MySQL Server: OptimizerClosed
(784 days)
S25.1,5.5, 5.6, 5.7.2-m12AnyGrouping with a view may report 'Invalid use of group function'  
712442013-12-30
9:48
2014-03-29
8:31
MySQL Server: DMLClosed
(1385 days)
S25.6.15, 5.5.35, 5.1.72, 5.7.3AnyWrong result computation using ALL() and GROUP BY  
758522015-02-10
20:15
2015-05-11
1:00
MySQL Server: Group ReplicationNo Feedback
(953 days)
S3server:5.7.5-labs-group-replicationLinuxmysql5.7.5 fail to start command-line client Nuno Carvalho
34052004-04-06
22:04
2004-04-07
7:15
MySQL Server: DocumentationClosed
(5003 days)
S35 No explanation of "formula" for Group By/Order By in Select  
407812008-11-17
12:27
2009-02-24
7:20
MySQL Enterprise Monitor: WebNot a Bug
(3219 days)
S32.0.0.70882.0 investigateAnyBrowser behaviour appears different on Safari when adding servers to group Josh Sled
5902003-06-05
3:02
2003-06-11
9:31
MySQL ServerNot a Bug
(5304 days)
S24.0.13Linux (Linux (Debian))Different results with 4.0.13 and 3.23.51 versions Alexey Botchkov
174872006-02-16
17:20
2006-02-19
9:25
MySQL ServerNot a Bug
(4320 days)
S4MySQL 5.0.18-ntMicrosoft Windows (Windows XP Professional with SP2)CASE and IF() used in a group function (e.g. SUM ) results in error #1305  
423192009-01-24
6:32
2011-02-16
23:43
MySQL Server: DocumentationClosed
(3249 days)
S35.1.30 / NDB 6.3.20 AnyALTER LOGFILE GROUP is not in online help Jon Stephens
668962012-09-20
20:24
2012-09-21
0:12
MySQL Server: OptimizerVerified
(1914 days)
S25.5.24Linux (ubuntu 12.04)Distinct not distinguishing 0 from NULL when GROUP BY is used  
656172012-06-14
12:48
2012-07-15
1:00
MySQL Server: ReplicationNo Feedback
(1983 days)
S15.5.21Linux (Ubuntu 11.0.4)SQL update statement hangs during replication on slave  
13632003-09-21
9:18
2008-09-27
9:17
MySQL ServerCan't repeat
(3369 days)
S34.0.15aLinux (Linux 2.4.21-SMP-686 (Debian))Not expected behaviour of CREATE TEMPORARY TABLE...SELECT  
72512004-12-14
7:27
2005-01-16
4:07
MySQL ServerCan't repeat
(4719 days)
S35.0.3-preLinux (Linux/PPC)"myisam" test fails in current 5.0 tree Igor Babaev
249152006-12-08
15:38
2006-12-11
21:48
MySQL Server: ViewsClosed
(4025 days)
S35.0.16 using a view to retrieve a large number of entries  
497472009-12-16
20:03
2009-12-17
15:46
MySQL Server: DDLNot a Bug
(2923 days)
S35.1.37LinuxERROR CREATE VIEW  
535872010-05-11
22:57
2016-08-17
14:51
MySQL Server: DocumentationClosed
(488 days)
S35.0,5.1Anywhat are the semantics of the rand function Paul Dubois
200532006-05-24
19:42
2006-07-03
16:53
MySQL Cluster: Disk DataClosed
(4186 days)
S25.1.12Linux (Linux 32 Bit OS)TABLESPACE should only be allowed to drop files that are created for that TS Jonas Oreland
441172009-04-06
19:22
2009-04-07
10:19
MySQL Server: ParserNot a Bug
(3177 days)
S35.1.33AnyORDER BY does nor work for a GROUP BY alias  
180062006-03-07
1:07
2006-03-07
1:34
MySQL ServerNot a Bug
(4304 days)
S25.0.16Microsoft Windows (Windows 2003)GROUP BY can corrupt BIT values when multiple bits returned Godofredo Miguel Solorzano
46952004-07-22
13:29
2004-07-23
21:31
MySQL AdministratorNot a Bug
(4896 days)
S44.1Microsoft Windows (Windows 2000 advance server)About creating user groups and assigning a user to his/her group  
802152016-02-01
4:33
2016-02-01
17:07
MySQL ServerNot a Bug
(686 days)
S25.7.10UbuntuORDER BY with GROUP BY no longer working on MySQL 5.7.10  
374632008-06-17
21:33
2008-06-17
21:55
MySQL ServerNot a Bug
(3471 days)
S35.0.51bAnyCOLLATE possible in ORDER BY and GROUP BY, but not in both at same time  
745852014-10-27
9:39
2015-12-22
6:07
MySQL Server: DDLDuplicate
(727 days)
S35.6.20-debug, 5.6.22, 5.7.6, 5.5.40Linux (CentOS 7)Failing assertion: *mbmaxlen < 5 in ha_innodb.cc line 1588  
141692005-10-20
9:18
2006-04-14
18:30
MySQL ServerClosed
(4266 days)
S35.0.13-rc, 5.0.15-BK, 5.0.16-nightly-20051017-debugLinux (Linux, Windows)ORDER BY changes field type to BLOB for GROUP_CONCAT Evgeny Potemkin
208252006-07-03
15:46
2006-10-25
19:24
MySQL ServerClosed
(4072 days)
S34.1.20 and 5.0.22, 5.0.24-BKLinux (Linux, freebsd)rollup puts non-equal values together Evgeny Potemkin
23942004-01-14
21:21
2004-01-14
22:16
MySQL ServerCan't repeat
(5087 days)
S35.0.0Microsoft Windows (winxp)Crash MySQL  
157062005-12-13
8:08
2006-02-28
0:55
MySQL Server: Prepared statementsClosed
(4311 days)
S3bk mysql-5.0 treeLinux (Linux/x86)Test case 'subselect' fails in --ps-protocol mode Evgeny Potemkin
228742006-10-01
17:23
2006-10-05
9:24
MySQL ServerNot a Bug
(4092 days)
S35.0.24aLinux (opensuse 10.0)ONLY_FULL_GROUP_BY conflicts with column alias  
174992006-02-17
1:51
2006-02-28
19:37
MySQL Server: PartitionsClosed
(4311 days)
S1 Alter table of ndb partitioned tables causes mysqld to core Tomas Ulin
175002006-02-17
2:28
2006-12-16
14:09
MySQL Server: OptimizerCan't repeat
(4020 days)
S35.0.19-BK, 5.0.18-LOGLinux (Linux, Freebsd 6.0)Format() + GROUP BY + PHP error Evgeny Potemkin
187802006-04-04
19:47
2006-06-14
0:39
MySQL Cluster: Disk DataClosed
(4205 days)
S15.1.9Linux (Linux)DD: DBT2 causes cluster failure using disk data in dbtup/DbtupDiskAlloc.cpp Jonas Oreland
118692005-07-11
19:18
2005-08-08
15:49
MySQL Server: OptimizerClosed
(4515 days)
S14.1.12-nt, 5.0.7-nt-beta/5.0.10Microsoft Windows (Windows XP1/Linux)Server crashes making a union join query with fulltext search Sergey Petrunya
218532006-08-27
20:36
2006-10-05
16:57
MySQL Server: OptimizerClosed
(4092 days)
S25.0Linux (Linux)Query with "ALL" keyworkd doesnt return what's expected Igor Babaev
361892008-04-17
22:44
2008-07-09
20:24
MySQL Server: GeneralCan't repeat
(3449 days)
S35.0.51aLinux (RHES 4 and RHES 5)Order by is not being evaluated when a group by exists on the primary key  
23982004-01-15
7:02
2004-01-15
7:26
MySQL Server: MyISAM storage engineCan't repeat
(5086 days)
S14.0.17Linux (Linux 2.6.0)MySQL crashes on boolean fulltext search  
39342004-05-30
8:43
2004-06-08
12:37
MySQL Server: User-defined functions ( UDF )Closed
(4941 days)
S24.0.20aMicrosoft Windows (XP)UDF on Windows crash the server Vasily Kishkin
884142017-11-09
7:42
2017-12-15
7:13
MySQL Server: Group ReplicationAnalyzing
(3 days)
S2mysql5.7.20Red Hat (7.3)After online node is restored, the state has not changed to mysql5.7.20 Bogdan Kecman
113592005-06-15
19:36
2005-08-26
9:43
MySQL Migration ToolkitClosed
(4497 days)
S11.0.10Microsoft Windows (Windows2000)INFORMATION_SCHEMA.ROUTINES doesn't exist in source Michael G. Zinner
231352006-10-10
12:10
2006-10-10
13:39
MySQL ServerDuplicate
(4087 days)
S55.0.19Linux (Linux)Slow views performance  
305592007-08-22
11:21
2007-08-23
13:35
MySQL Cluster: Cluster (NDB) storage engineClosed
(3770 days)
S35.1.215.1.22AnySome NDB space management commands do not fail as expected Jonathan Miller
231362006-10-10
12:17
2006-10-11
6:31
MySQL Server: ViewsNot a Bug
(4086 days)
S15.0.19Linux (Linux)Views performance  
256962007-01-18
15:22
2007-03-05
19:54
MySQL Server: DocumentationClosed
(3941 days)
S4 Alternatives to rows with group-wise maximum Paul Dubois
487362009-11-12
16:03
2011-02-16
23:44
MySQL Cluster: Cluster (NDB) storage engineCan't repeat
(2916 days)
S3mysql-5.1-telco-6.3.26Anymissing node group error sometimes causes Sig 11 instead Andrew Hutchings
164812006-01-13
14:07
2006-02-14
9:15
MySQL Cluster: Cluster (NDB) storage engineClosed
(4325 days)
S15.1.6-alphaLinux (Linux)DD: Cluster fails during load of TPC-B tables Jonas Oreland
571862010-10-01
21:40
2011-02-16
23:44
Connector / NETDuplicate
(2611 days)
S26.3.4Microsoft WindowsLinq query fails when selecting both the key and an aggregate from a grouping  
31712004-03-15
1:27
2004-03-26
7:02
MySQL Server: MyISAM storage engineNot a Bug
(5015 days)
S24.1.1-alphaMicrosoft Windows (WinXP Professional)A bug in getting table name from result set (for given field) in PHP Georg Richter
745952014-10-28
2:02
2014-11-05
4:11
MySQL FabricClosed
(1139 days)
S21.5.2Linux (Centos 6.3)MySQL fabric command problems  
249312006-12-09
4:09
2006-12-10
14:53
MySQL Server: GeneralDuplicate
(4026 days)
S1 14.7 Distrib 4.1.14, for pc-lLinux (RH Linux)count(*) messed up  
21482003-12-18
1:26
2003-12-18
4:08
MySQL Server: Command-line ClientsNot a Bug
(5114 days)
S2MySQL 4.0.15Microsoft Windows (Windows)Subqueries in the FROM clause  
82922005-02-03
15:57
2006-01-27
15:42
Connector / NETClosed
(4343 days)
S21.0.4Microsoft Windows (Windows 2000)GROUP BY / WITH ROLLUP with DataSet causes System.Data.ConstraintException Reggie Burnett
244202006-11-18
22:49
2007-02-07
19:11
MySQL Server: OptimizerClosed
(3967 days)
S2 (a,b) IN (SELECT a,min(b) FROM t GROUP BY a) can produce wrong results Igor Babaev
70132004-12-05
0:15
2005-02-18
17:57
MySQL ServerClosed
(4686 days)
S35.0.3-alpha-debugLinux (SUSE 9.2)Stored procedure crash if group by ... with rollup Per-Erik Martin
769012015-04-30
9:42
2015-08-25
10:19
MySQL Server: OptionsClosed
(846 days)
S35.7.6Anybinlog_max_flush_queue_time variable is not used in current MySQL 5.7  
781812015-08-24
6:59
2015-08-24
9:23
MySQL Server: DMLVerified
(847 days)
S25.6.21, 5.6.26, 5.7.9AnyGroup by different behavior in mysql 5.6.21  
136692005-09-30
19:18
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3050 days)
S45.0Any (all)Group commit is broken in 5.0 Inaam Rana
172532006-02-09
0:32
2006-03-16
15:03
MySQL ServerNo Feedback
(4295 days)
S15.0.18, 5.0.15Linux (Linux 2.4.21-32)free(): invalid pointer, mysqld got signal 11  
254452007-01-06
2:44
2007-01-06
3:08
MySQL ServerClosed
(3999 days)
S25.0.24aLinux (Ubuntu (Debian))LIMIT returns incorrect result when used with LEFT JOIN, GROUP BY, and DISTINCT  
313332007-10-02
9:43
2008-05-19
6:25
MySQL Cluster: Disk DataClosed
(3500 days)
S25.1.22 RCSolaris (SunOS 5.11 snv_40)I can't create logfile group in MySQL 5.1.22 of SunOS.  
356852008-03-30
15:53
2011-02-16
23:43
MySQL Server: OptimizerClosed
(2585 days)
S16.0-BKALinuxCrash in JOIN_CACHE::init when using the SONY Query Igor Babaev
423412009-01-26
9:37
2009-05-15
16:15
MySQL Server: Falcon storage engineClosed
(3139 days)
S16.0-falcon-team6.0-betaAnyFalcon assertion (key - (UCHAR*) indexNode < 14) in IndexNode::parseNode Lars-Erik Bjørk
482292009-10-22
13:22
2011-02-16
23:44
MySQL Server: PartitionsClosed
(2740 days)
S55.1.37,5.1.385.1+Linux (CentOS 4.4)group by performance issue of partitioned table Mattias Jonsson
561652010-08-21
8:12
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2674 days)
S35.0.not_sure, 5.0, 5.1, 5.6.99 bzrAnyBad Optimization  
72702004-12-14
15:11
2005-01-14
18:48
MySQL ServerClosed
(4721 days)
S35.0.3-preLinux (Linux / Athlon)Test failure: 'select' (using '--ps-protocol': results re-ordered) Ramil Kalimullin
228872006-10-02
11:55
2006-12-07
12:57
MySQL Server: Information schemaNo Feedback
(4029 days)
S35.1.11Linux (ubuntu dapper drake linux)information_schema.FILES.TABLESPACE_NAME not null for UNDOFILEs  
162322006-01-05
17:11
2006-08-31
16:26
MySQL Server: ViewsCan't repeat
(4127 days)
S35.0.17/5.0.19 BKLinux (Linux 2.6)GROUP BY on a view with a WHERE restriction gives incorrect results Igor Babaev
825362016-08-11
4:17
2016-09-12
1:00
MySQL WorkbenchNo Feedback
(463 days)
S26.3.7Microsoft Windows (Microsoft Windows 10 Pro)Opening Up a Recent Made Model File  
346662008-02-19
14:11
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3521 days)
S35.0/5.1/6.0.4AnyIncomplete metadata returned to client on view + group by + Innodb/Falcon Evgeny Potemkin
121392005-07-24
14:32
2005-08-26
8:25
MySQL ServerCan't repeat
(4497 days)
S35.0.9-ntMicrosoft Windows (winXP)MyISAM: DISTINCT/GROUP BY return duplicates  
505392010-01-22
10:36
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2843 days)
S25.5.0, 5.5.2-m2, 6.0.14-bzr5.5+Any (64bit)GROUP BY + COUNT(DISTINCT ) on an int column shows results off by one Evgeny Potemkin
364602008-05-02
0:14
2008-05-02
15:03
MySQL ServerClosed
(3517 days)
S25.1AnySubqueries eliminating duplicates needed by group by  
6212003-06-08
23:10
2003-08-09
6:41
MySQL ServerClosed
(5245 days)
S44.0.13Linux (RedHat Linux)Groups of users Sergei Golubchik
144452005-10-28
22:36
2005-11-01
12:21
MySQL ServerClosed
(4430 days)
S35.0 ANALYSE() computes wrong STD value for integer types Alexey Botchkov
351812008-03-10
12:52
2008-03-19
13:36
MySQL Server: GeneralDuplicate
(3561 days)
S25.0.51Linux (RHEL 5)MySQL 5.0.51 and 51a are severely broken when a GROUP BY and ORDER BY are applie  
285262007-05-18
17:15
2012-05-18
20:19
MySQL ServerDuplicate
(3854 days)
S25.0.40, 5.0.41, 5.0.42-20070517AnyCorrelated subquery with GROUP BY on outer query returns no results in 5.0.40+ Assigned Account
29272004-02-23
10:49
2005-08-10
17:28
MySQL ServerWon't fix
(4513 days)
S23.23.58Linux (Linux)EXTRACT() with GROUP BY produces wrong results Ramil Kalimullin
170072006-02-01
14:56
2006-02-03
13:58
MySQL ServerCan't repeat
(4336 days)
S15.0.18-ntMicrosoft Windows (windows2003 web edition)sum crashes MySQL  
280152007-04-22
11:23
2007-05-22
16:26
MySQL ServerNo Feedback
(3863 days)
S14.x & 5.xMac OS X (x86)Order By + Group by does not Sort - Mac OS x x86  
510552010-02-10
10:43
2011-02-16
23:44
MySQL Server: ReplicationClosed
(2737 days)
S3mysql-5.15.1+AnyReplication failure on duplicate key + traditional SQL mode Luis Soares
531032010-04-23
9:34
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2582 days)
S36.0.14AnyMTR test ps crashes in optimize_cond() when running with --debug Jørgen Løland
615512011-06-17
12:26
2011-06-18
8:34
MySQL Server: OptimizerVerified
(2376 days)
S35.1.56AnyLoose index scan is not used for select COUNT(distinct a)  
717922014-02-21
19:01
2014-05-23
3:29
MySQL FabricClosed
(1305 days)
S31.4.0Linux (2.6.39-200.24.1.el6uek.x86_64)MysqlFabric additional parameters only support lower case  
113762005-06-16
11:19
2005-08-16
19:19
MySQL ServerCan't repeat
(4507 days)
S25.0.7Microsoft Windows (win2k)Problem with Group By Evgeny Potemkin
164962006-01-13
21:04
2006-02-01
16:28
MySQL ServerCan't repeat
(4338 days)
S25.0.18-logLinux (SUSE LINUX Enterprise Server 9)segfault when combining DISTINCT and GROUP BY in one query  
620642011-08-02
22:41
2011-08-03
22:35
MySQL Server: GeneralClosed
(2329 days)
S15.5.11-logLinuxEmbedded group by query with CURSOR_TYPE_READ_ONLY crashes the server  
88172005-02-26
0:26
2005-02-26
1:14
MySQL ServerClosed
(4678 days)
S25.0.2-alpha-max-logMicrosoft Windows (WinXp Professional)coalesce() with max() or count() in stored proc. does not work next time  
167532006-01-24
17:45
2006-02-02
12:37
MySQL Cluster: Cluster (NDB) storage engineClosed
(4337 days)
S25.1.6-alphaLinux (Linux)DD: mysqldump does not support Cluster Disk Data backups Tomas Ulin
213612006-07-31
11:55
2006-09-05
13:39
MySQL ServerDuplicate
(4122 days)
S45.0.22Linux (Linux)Patch: create coredumps on linux when --user or --group is used  
674422012-10-31
23:15
2012-11-26
12:59
MySQL Server: ReplicationClosed
(1848 days)
S35.6.7LinuxStress tests causes DBUG server to exit with signal 6  
700022013-08-12
19:23
2013-08-19
7:38
MySQL Server: OptimizerDuplicate
(1582 days)
S25.6.13, 5.5, 5.1Anyvery low performance join - eq_ref and ref access broken for compound indexes  
717942014-02-21
20:41
2017-07-06
19:19
MySQL FabricWon't fix
(1393 days)
S31.4.0Linux (2.6.39-200.24.1.el6uek.x86_64)MysqlFabric foreign key error when omitting group in sharding create_definition  
758902015-02-13
9:41
2015-09-18
9:20
MySQL Server: Row Based Replication ( RBR )OpenS45.6.xAnyA new feature request of slave mts apply  
359542008-04-10
6:12
2011-02-16
23:43
MySQL Cluster: Cluster (NDB) storage engineClosed
(3136 days)
S25.1.22-rcAnycluster 5.1.22-rc rolling upgrade to 5.1.23-rc broken Sean Pringle
531062010-04-23
11:07
2011-03-07
13:01
MySQL Cluster: Disk DataClosed
(2478 days)
S3mysql-5.1-telco-7.0LinuxWeird behavior with undo_buffer_size to large for SharedGlobalMemory Maitrayi Sabaratnam
80512005-01-20
16:40
2013-10-06
20:45
MySQL Cluster: Cluster (NDB) storage engineNo Feedback
(4661 days)
S34.1.8/4.1.9HP/UX (HP-UX 11i11 PARISC 64bit)Cannot restart ndbd with large table (20 000 000 rows) Assigned Account
269952007-03-09
12:20
2007-05-10
16:05
MySQL Server: InnoDB storage engineNo Feedback
(3875 days)
S25.0.16-ntMicrosoft Windows (Win XP)Recordset Does Not Select the Value from View in MySQL 5.0.16-nt  
303242007-08-08
23:31
2007-10-23
16:34
MySQL Server: OptimizerClosed
(3709 days)
S25.0-bk, 5.1-bk5.1.23AnyGrouping queries with COUNT(DISTINCT bit column) return wrong results Sergey Petrunya
257182007-01-19
12:32
2007-01-19
13:57
MySQL ServerCan't repeat
(3986 days)
S34.1.22 and 5.0.27 group by with alias in expression (follow up bug #11694)  
395432008-09-19
16:56
2015-03-12
1:11
MySQL Server: DMLVerified
(3377 days)
S35.0.67/5.1/6.0Linux (debian 4.0)Group by with case and lpad inside concat truncates values  
408232008-11-18
13:40
2011-02-16
23:43
MySQL Enterprise Monitor: WebClosed
(2835 days)
S42.0.0AnyAdd number of servers affected in mouse over of heatchart icons on groups Josh Sled
116402005-06-29
13:29
2008-10-03
20:22
MySQL Server: DDLWon't fix
(3363 days)
S4Anyautomatic key creation on CREATE TABLE ... SELECT  
193202006-04-25
6:11
2013-10-06
20:45
MySQL ServerNo Feedback
(4161 days)
S25.1.9Linux (RHEL4u2)Failing to create disk database Assigned Account
398002008-10-02
3:51
2011-02-16
23:43
MySQL Enterprise Monitor: ServerCan't repeat
(3359 days)
S2AnyNotification emails fail when using more than one address in the group Mark Matthews
487602009-11-13
13:36
2012-05-18
20:19
MySQL Server: Stored RoutinesDuplicate
(2890 days)
S35.15.1+Anyassert in __cxa_pure_virtual called by Item_field::result_type Georgi Kodinov
541362010-06-01
11:17
2011-02-16
23:44
MySQL Enterprise Monitor: WebClosed
(2719 days)
S32.2.0.1709Solaris (Solaris 10)MEM: Can't generate diag zip if the group name contains '/'. Mark Matthews
24252004-01-16
6:40
2005-10-04
17:22
MySQL ServerDuplicate
(4458 days)
S44.0.17Linux (Linux)feat. requ. GROUP BY-Function FIRST  
113852005-06-16
14:28
2005-06-23
18:18
MySQL ServerClosed
(4561 days)
S35.0.7/4.1.11Linux (Linux/x86, Windows)crash in group by and DIV Igor Babaev
275132007-03-29
8:47
2007-06-27
13:17
MySQL Server: ErrorsClosed
(3827 days)
S15.0.26, 5.0.34, 5.0.40-debugLinux (Gentoo Linux)mysql 5.0.x + NULL pointer DoS Georgi Kodinov
408252008-11-18
15:32
2011-02-16
23:43
MySQL Server: ViewsClosed
(3098 days)
S25.0.70, 5.0, 5.1, 6.0 bzr5.1+LinuxError 1356 while selecting from a view with a "HAVING" clause though query works Gleb Shchepa
129222005-09-01
1:57
2005-09-08
19:15
MySQL Server: OptimizerClosed
(4484 days)
S25.0.11Linux (Linux)wrong results with GROUP BY on VIEW Evgeny Potemkin
799942016-01-15
0:10
2017-07-06
19:20
MySQL Fabric: ShardingWon't fix
(700 days)
S3AnyHASH sharding not true HASH; implemented as RANGE  
221382006-09-09
3:13
2006-10-23
14:23
MySQL Server: OptimizerClosed
(4074 days)
S35.0.24a,5.0BK,5.1BKAny (*)Server crash on complex select Evgeny Potemkin
305872007-08-23
8:45
2007-11-05
3:13
MySQL Server: Data TypesClosed
(3696 days)
S24.1, 5.0, 5.1Anymysql crashes when trying to group by TIME div NUMBER Georgi Kodinov
3802003-05-06
10:14
2003-06-19
12:59
MySQL ServerClosed
(5296 days)
S24.1.0Any (any)MySQL crashes with InnoDB + group Oleksandr Byelkin
671962012-10-11
21:00
2012-10-12
12:22
MySQL Server: InnoDB storage engineVerified
(1893 days)
S35.5, 5.6AnyENUM type not treated correctly in HAVING w/ MAX()  
718042014-02-22
22:29
2014-10-20
8:53
MySQL Server: OptimizerVerified
(1155 days)
S55.6.6 m9, 5.5.32, 5.1.61Any (sqlfiddle.com)Unnecessary filesort when joining on unique column using group by. Guilhem Bichot
820442016-06-29
7:59
2016-07-12
15:19
MySQL Server: OptimizerNot a Bug
(524 days)
S35.7.9Ubuntu (12.04.4 LTS)COUNT(DISTINCT) query with WHERE clause returns an Incorrect number of rows  
431342009-02-24
10:10
2011-02-16
23:43
MySQL Server: PartitionsNo Feedback
(2959 days)
S25.1.24 and 5.1.31Linux (Centos 4)select with distinct or group by yields incorrect records  
561902010-08-23
14:23
2013-08-25
20:45
MySQL Server: InnoDB storage engineVerifiedS45.1.50, 5.5.5Anyimprove error messages for 'the age of the last checkpoint ..which exceeds the ' Assigned Account
14072003-09-26
3:26
2003-11-04
11:53
MySQL ServerNo Feedback
(5158 days)
S34.1.0-alphaMicrosoft Windows (Win2k)IF in WHERE-clause  
162552006-01-06
16:07
2006-09-07
0:34
MySQL Server: OptimizerClosed
(4120 days)
S34.1.16Microsoft Windows (windows and linux)Subquery in where Georgi Kodinov
167672006-01-25
3:23
2006-02-08
23:48
MySQL Cluster: Cluster (NDB) storage engineClosed
(4331 days)
S35.1Linux (Linux)DD: ALTER LG that does not exist returns wrong error code Jonas Oreland
810242016-04-09
19:53
2016-04-09
21:45
MySQL Server: DMLVerified
(618 days)
S55.0/5.1/5.5/5.6/5.7Microsoft Windows (Microsoft Windows 7 Enterprise Service Pack 1)HAVING without GROUP BY should imply an aggregation of a single group  
477442009-09-30
13:19
2011-02-16
23:44
Tests: EngineClosed
(3001 days)
S35.4.5 (mysql-trunk)Anyinnodb.innodb-timeout fails sporadically  
395542008-09-20
9:08
2011-02-16
23:43
MySQL Server: PartitionsCan't repeat
(2951 days)
S35.1.28-rc-community-logMicrosoft Windows (2003 Server)select statement with joins and group by seems to be an endless loop  
451862009-05-29
10:48
2011-02-16
23:44
MySQL ServerNo Feedback
(3093 days)
S1 5.1.36-debugLinux (suse-linux-gnu on i686)Select...lock in share mode caused a crash.  
477462009-09-30
13:27
2011-02-16
23:44
Tests: EngineClosed
(2922 days)
S35.15.1+Anymain.innodb_mysql fails sporadically John Embretsen
6442003-06-12
14:56
2004-03-11
8:59
MySQL ServerCan't repeat
(5030 days)
S14.1Linux (linux 2.4)crash in add_key_field when using prepared statements Oleksandr Byelkin
208682006-07-05
14:19
2006-08-02
19:08
MySQL ServerClosed
(4156 days)
S35.0.22/5.0BK/5.1BKLinux (Fedora Core 5 (64-bit))Client connection is broken on SQL query error Georgi Kodinov
218922006-08-29
5:40
2013-10-06
20:45
MySQL Cluster: Cluster (NDB) storage engineDuplicate
(4128 days)
S15.1.11Linux (Debian 2.6.17 (32bit))Cluster restart fails with disk tables Assigned Account
523562010-03-25
9:16
2011-02-16
23:44
MySQL Server: LockingClosed
(2782 days)
S1Celosia (M3), Dahlia (M4)5.5+Linuxquery_cache_debug fails on Linux Alexander Nozdrin
111412005-06-07
16:03
2005-06-10
18:01
MySQL ServerNot a Bug
(4574 days)
S24.1.12FreeBSD (FreeBSD 4/5)Group quota for databases, Mysql hang up when quota exceed  
293172007-06-23
13:42
2007-06-25
13:05
MySQL Server: DocumentationClosed
(3829 days)
S35.0AnyCOUNT() listed in other functions Peter Lavin
108862005-05-26
14:59
2005-06-22
2:36
MySQL Server: OptimizerClosed
(4562 days)
S24.1.12Linux (Linux)INSERT ... SELECT ... ON DUPLICATE KEY UPDATE produces bad results Evgeny Potemkin
26952004-02-09
22:28
2004-04-05
3:20
MySQL ServerClosed
(5005 days)
S24.1.1-alpha-ntMicrosoft Windows (Windows XP)Strange behaviour with GROUP_CONCAT() using ORDER BY Michael Widenius
183112006-03-17
15:42
2006-08-27
10:37
MySQL ServerNo Feedback
(4131 days)
S15.0.21, 5.0.19Linux (Linux-2.6.12)MySQL Server crashes with "got signal 6"  
544072010-06-10
19:45
2010-06-10
20:43
MySQL Server: ErrorsNot a Bug
(2748 days)
S1AnyMy SQL frequent errors# 144, 2006  
707922013-10-31
16:04
2015-01-17
1:00
MySQL ProxyNo Feedback
(1067 days)
S20.8.3Solarismysql-proxy crashing with libiconv  
375122008-06-19
1:34
2008-07-23
23:13
MySQL Server: ParserCan't repeat
(3435 days)
S3mysql-5.1.24 ndb-6.3.15Linux (redhat as5)the 'M' and 'G' abbreviations should work for INITIAL_SIZE Marc Alff
649042012-04-08
0:35
2013-02-28
16:05
MySQL Enterprise BackupNot a Bug
(1754 days)
S33.7.0Linux (Ubuntu 11.10 64bit)innodb-log-files-in-group must be specified for copy-back (default not used)  
101212005-04-24
9:17
2006-01-04
10:13
MaxDBClosed
(4366 days)
S37.5, 7.6Microsoft Windows (w2k)DBPROC fails every second call Ulf Wendel
377692008-07-01
15:05
2008-07-18
16:21
TestsClosed
(3440 days)
S36.0-BK6.0Anymain.error_simulation fails randomly Alexander Nozdrin
546652010-06-21
12:07
2010-06-21
12:49
MySQL Workbench: SQL EditorNot a Bug
(2737 days)
S35.2.22 OSS RCMicrosoft Windows (Vista)Can't create view with query that can be executed in script-tab  
42342004-06-21
16:00
2004-06-21
19:03
MySQL Server: Command-line ClientsNot a Bug
(4928 days)
S24.0.18-ntMicrosoft Windows (XP, SP1)Error 1064 on "select [group function]" Dean Ellis
771942015-05-29
17:10
2015-06-19
12:58
MySQL Server: DMLDuplicate
(913 days)
S35.6.23Linux (CentOS 7)Assertion `param.sort_length != 0' failed in sql/filesort.cc:361  
800102016-01-15
19:27
2016-01-28
2:47
MySQL Fabric: High AvailabilityClosed
(690 days)
S31.6.3AnyError: 1871 when promoting an instance on H/A group (mysql 5.7.x) Nelson Goncalves
275302007-03-29
17:17
2007-04-24
17:19
MySQL ServerClosed
(3891 days)
S35.0.37-logAny (pc-linux-gnu x86_64)Incorrect calculation CRC32 value in GROUP BY requests Georgi Kodinov
326502007-11-23
10:37
2008-05-07
6:59
Tests: ServerCan't repeat
(3512 days)
S35.0.44, 5.1.19, 6.0.4 and up5.0+Other (AIX, i5os, Sol8/x86)SELECT with OUTER JOIN from I_S: "Out of memory" for "memory" and "MyISAM" Sergey Glukhov
167792006-01-25
13:23
2006-04-10
18:20
MySQL ServerCan't repeat
(4270 days)
S15.0Microsoft Windows (Windows)crash server UNION and SUM Godofredo Miguel Solorzano
80762005-01-21
19:05
2006-09-16
10:19
MySQL ServerWon't fix
(4111 days)
S4MySQL 4.1.9Microsoft Windows (Windows XP)inner from select column cannot be in outer select only in having part  
771972015-05-30
21:25
2015-12-09
17:38
MySQL Workbench: ModelingClosed
(740 days)
S36.3.3Microsoft WindowsValid stored procedure code labelled _SYNTAX_ERROR in Routine Group  
469892009-08-29
5:52
2017-01-09
6:33
MySQL Server: OptimizerVerified
(3033 days)
S35.1,5.4AnyNULL attribute gets lost when "CREATE TABLE AS SELECT ... GROUP BY WITH ROLLUP"  
272782007-03-19
23:47
2007-03-20
17:57
MySQL Server: DocumentationClosed
(3926 days)
S35.0Any (*)aggregate of outer query for subquery not documented Paul Dubois
311182007-09-20
19:33
2007-09-20
19:55
MySQL ServerNot a Bug
(3742 days)
S25.1.19-beta-log MySQL Community ServerSolarisMIN with Group by returns now row related data  
572302010-10-04
21:46
2011-02-16
23:44
MySQL Server: ReplicationWon't fix
(2628 days)
S35.1AnySTOP SLAVE hangs if executed in parallel with a group of events Daogang Qu
155042005-12-06
0:49
2006-06-28
15:17
MySQL AdministratorClosed
(4191 days)
S31.1.5/1.1.6Microsoft Windows (Windows XP SP2 Home Edition)Group ctl height incorrect in Resources tab of User Admin Mike Lischke
162722006-01-06
23:16
2006-02-21
22:32
MySQL ServerClosed
(4318 days)
S25.0.18Linux (Gentoo Linux)IF with floting point values does not work with GROUP BY Evgeny Potemkin
324002007-11-14
22:49
2008-01-14
19:24
MySQL Server: OptimizerClosed
(3626 days)
S25.0.41/5.0BK/5.1BKAnyComplex SELECT query returns correct result only on some occasions Georgi Kodinov
190892006-04-13
20:49
2006-06-05
21:14
MySQL Server: OptimizerClosed
(4214 days)
S35.0.20Any (any)CREATE TABLE ... SELECT * FROM a view with an ENUM column and GROUP BY fails Igor Babaev
531372010-04-24
0:14
2013-01-10
12:43
MySQL Server: OptimizerNot a Bug
(1803 days)
S25.0.90, 4.1, 5.0, 5.1, 5.6.99Any (FreeBSD 7.3/amd64, Linux)Optimizer may be confused by an index  
103872005-05-05
13:20
2005-07-22
7:53
MySQL ServerClosed
(4532 days)
S15.0.4 Beta-standardMicrosoft Windows (Windows XP) Mysql server crashes for Select statement for 'max',group by and with rollup.  
6602003-06-16
8:12
2003-06-16
10:50
MySQLCCCan't repeat
(5299 days)
S24.1 alphaMicrosoft Windows (windows)[test_data] ERROR 2003: Can't connect to MySQL server on 'xxxx' (10061)  
705482013-10-07
22:37
2013-10-08
18:06
MySQL ServerNot a Bug
(1532 days)
S2 5.5.9-logAnytimestamp column being set to current time  
19412003-11-24
21:26
2003-11-27
4:57
MySQL ServerNot a Bug
(5135 days)
S4allAny (all)Allow aliases in WHERE clauses for queries without GROUP BY  
434132009-03-05
13:23
2011-02-16
23:43
MySQL Cluster: Cluster (NDB) storage engineClosed
(3201 days)
S3mysql-5.1-telco-6.4SolarisNode group not removed after "drop nodegroup" Jonas Oreland
57822004-09-28
8:22
2004-10-01
20:19
MySQL Cluster: Cluster (NDB) storage engineClosed
(4826 days)
S24.1.6-gamma-nightly-20040927Linux (Linux)Unknown error when using LIMIT with ndb table. Tomas Ulin
103902005-05-05
14:56
2012-05-18
20:19
MySQL ServerNo Feedback
(4564 days)
S2MySQL Server 4.1Microsoft Windows (Window XP)SELECT MAX(a_datetime_field) returns a String rather than a Timestamp Assigned Account
267742007-03-01
22:16
2007-10-29
16:41
MySQL ServerNo Feedback
(3703 days)
S35.0.32, 5.0.37Linux (Debian GNU/Linux etch)Crash on ARM platform even after REPAIR TABLE  
103912005-05-05
14:56
2005-05-05
15:03
Connector / JDuplicate
(4610 days)
S2MySQL Server 4.1Microsoft Windows (Window XP)SELECT MAX(a_datetime_field) returns a String rather than a Timestamp  
853992017-03-10
8:57
2017-09-01
21:22
MySQL ServerCan't repeat
(108 days)
S2mysql5.7.17LinuxMysql5.7 Group replication node recovering OOM kill mysql server Bogdan Kecman
167922006-01-25
22:27
2006-09-25
17:44
MySQL Server: OptimizerClosed
(4102 days)
S25.0.19-nightly-20060115Linux (linux)query with subselect, join, and group not returning proper values Georgi Kodinov
825842016-08-15
12:40
2016-12-12
10:35
MySQL Server: Group ReplicationClosed
(371 days)
S15.7.14CentOS (7)task_write: Assertion `con->fd >= 0' failed with group replication  
249842006-12-11
23:42
2009-02-12
14:03
MySQL AdministratorClosed
(3231 days)
S3allAny (all)Administrator provides no way to debug problems with scheduled backups  
265202007-02-21
11:58
2014-03-13
13:35
MySQL Enterprise Monitor: WebWon't fix
(3776 days)
S41.1.0.4785Anyoffer sending a test mail to a notification group on SAVE and UPDATE Assigned Account
1542003-03-15
5:44
2003-03-15
23:28
MySQL Server: InnoDB storage engineClosed
(5392 days)
S2All Wrong group by or distinct on Innodb table indexed column with NULLs Heikki Tuuri
34822004-04-16
1:59
2004-04-28
10:47
MySQL ServerCan't repeat
(4982 days)
S14.1.1a-alphaMicrosoft Windows (Windows NT 4.0 SP6a)MySQL returns empty set when using index  
162832006-01-08
13:24
2006-01-16
20:12
MySQL Server: ViewsCan't repeat
(4354 days)
S25.0.17/18-ntMicrosoft Windows (Windows)View returns wrong result  
270352007-03-11
16:53
2008-01-03
15:21
MySQL Server: PackagingClosed
(3637 days)
S35.0.37 binariesLinux (Linux, Mac OS X)information_schema test fails on MySQL 5.0.37 Horst Hunger
303632007-08-10
17:58
2011-02-16
23:43
MySQL ServerClosed
(2585 days)
S55.2.46.0-rcAnyTPC-D complex query slower by 2.6x to 6x times in 5.2 then in 5.1 Sergey Petrunya
321552007-11-06
22:31
2011-02-16
23:43
MySQL Enterprise Monitor: WebClosed
(3097 days)
S32.0Anytranslate the Replication group names Eric Herman
288292007-06-01
10:01
2012-05-18
20:19
MySQL Server: ReplicationDuplicate
(3841 days)
S24.1.21,5.0.44Anyreplication breaks due to binlogs events written in wrong order Georgi Kodinov
682542013-02-02
10:31
2015-01-09
16:42
MySQL Server: OptimizerNot a Bug
(1074 days)
S25.6.10Anysubquery optimize to wrong semi-join with extensions syntax to group by Guilhem Bichot
257582007-01-22
18:01
2007-02-14
19:09
MySQL ServerCan't repeat
(3960 days)
S25.0.25+, 4.1.19+Any (all)quoted string in ORDER BY causes GROUP BY  
191032006-04-14
13:04
2007-10-09
18:03
MySQL Server: DocumentationClosed
(3723 days)
S35.0Any--defaults-group-suffix not documented  
265282007-02-21
15:02
2007-02-22
16:21
MySQL Server: OptimizerNot a Bug
(3952 days)
S35.0.34, 5.0.27Microsoft Windows (Windows)Optimizer produces inefficient execution plan on 5.0.x compared to 4.1.21 Igor Babaev
303682007-08-11
2:26
2012-05-18
20:19
MySQL ServerDuplicate
(3764 days)
S34.1/5.0/5.1AnyGROUP BY primary_key query's output is not ordered when the PK is not ordered Assigned Account
756812015-01-29
13:10
2015-02-19
14:13
MySQL ServerCan't repeat
(1033 days)
S25.6.21-1~dotdeb.1Linuxusing index for group-by not behaving as intended  
720982014-03-21
20:47
2014-03-22
6:48
MySQL Server: DMLVerified
(1367 days)
S35.5, 5.5.38Anyselect * from (subquery) get different result with subquery.  
418902009-01-05
22:53
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3161 days)
S36.0.9-release5.4+AnyFalcon: New execution plans with MRR cause slowdown for group of queries Sergey Petrunya
96352005-04-05
5:34
2005-04-05
5:39
MySQL ServerCan't repeat
(4640 days)
S15.0.3Linux (linux)select/round/group by query crashes server  
139872005-10-12
22:40
2007-11-21
9:49
MySQL Cluster: Cluster (NDB) storage engineClosed
(3680 days)
S25.0.15, 5.0.19Linux (Linux)Cluster: Loss of data nodes can cause high CPU usage from ndb_mgmd Stewart Smith
866912017-06-14
7:38
2017-07-29
1:00
MySQL ServerNo Feedback
(143 days)
S35.7.18CentOSall threads are hanged in group replication Bogdan Kecman
398442008-10-03
19:36
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3304 days)
S15.0+5.0.72+Any (MS Windows SP2 - XP 5.1.2600, Linux)Query Crash Mysql Server 5.0.67 Gleb Shchepa
603252011-03-03
21:29
2011-03-12
10:39
MySQL Server: PartitionsVerified
(2473 days)
S35.5, 5.1.57, 5.6.3Anypartition optimization  
17032003-10-29
10:12
2016-01-03
20:45
MySQL Server: InnoDB storage engineNo Feedback
(4797 days)
S34.0.12Linux (Slackware linux)SELECT DISTINCT not showing a distinct row Assigned Account
872072017-07-26
13:56
2017-11-09
6:38
MySQL Server: OptimizerClosed
(82 days)
S15.7.18Anyselect distinct with secondary key for 'Using index for group-by' bad results  
877192017-09-10
13:12
2017-09-11
20:46
MySQL ServerNot a Bug
(98 days)
S35.7.18Anycant't change master info for group replication Bogdan Kecman
360072008-04-11
22:39
2016-02-25
12:24
MySQL Enterprise Monitor: WebClosed
(3097 days)
S41.3.02.0AnyDisplay which notification group(s) are subscribed to which advisors Josh Sled
677522012-11-29
8:16
2012-11-29
17:13
MySQL Server: Stored RoutinesDuplicate
(1845 days)
S25.6.8rcLinuxaggregate functions return NULL in GROUP BY within stored procedure cursor  
188562006-04-06
17:05
2007-08-21
19:50
MySQL Cluster: Cluster (NDB) storage engineClosed
(3772 days)
S25.15.1.22Linux (Linux)Table remains locked after SELECT * INTO OUTFILE statment. Jonathan Miller
75932004-12-30
18:43
2004-12-31
9:50
MySQL Cluster: Cluster (NDB) storage engineClosed
(4735 days)
S14.1.8 (Max)Linux (Linux Fedora Core 1)Cannot Create A Large NDB Data Warehouse Mikael Ronström
500892010-01-05
14:57
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2583 days)
S26.0AnySecond call of procedure with view in subselect crashes server Roy Lyseng
657062012-06-22
7:42
2013-01-10
12:16
MySQL Server: DMLCan't repeat
(1803 days)
S15.5.24, 5.5.27, 5.1.65, 5.0.97Linux (Ubuntu 12.04)SELECT statement used to create a view works, selecting from the view -> ER 1356  
65702004-11-11
8:17
2005-01-14
12:00
MySQL ServerNo Feedback
(4721 days)
S24.1.7Microsoft Windows (MS Windows)Subquery not connected to query in select statement  
700592013-08-16
13:57
2013-11-06
0:13
MySQL Workbench: ModelingClosed
(1503 days)
S26.0.6.11184Microsoft Windows (Windows 7 64-bit)EER modelling - can't update Routine Groups  
785082015-09-22
3:20
2015-09-22
12:19
MySQL Server: DMLNot a Bug
(818 days)
S35.6.22AnySubquery result with aggregate function() in outer table is not understandable  
293572007-06-26
11:34
2007-08-06
7:39
MySQL Server: OptimizerNot a Bug
(3787 days)
S2 5.1.19-beta-log MySQL, 5.0 BKAnyFiltering on view with group don't works. Igor Babaev
380612008-07-11
21:16
2008-07-14
2:35
MySQL Server: ViewsNot a Bug
(3444 days)
S25.0.51aAnyselect from view w/group by ignores view order  
470222009-08-31
14:50
2011-02-16
23:44
MySQL Server: Performance SchemaDuplicate
(3030 days)
S16.0Linux (SMP 2009-05-27 10:35:34 +0200 i686 i686 i386 GNU/Linux)Got a crash in ha_perfschema when running the test "selects" (join). Marc Alff
196312006-05-09
10:18
2006-05-10
11:46
MySQL ServerDuplicate
(4240 days)
S15.0.21FreeBSD (FreeBSD)count(distinct COL) yields wrong results when group-by key contains a cast  
1762003-03-21
11:32
2003-03-24
12:57
MySQL ServerClosed
(5383 days)
S3all Mixing aliases and aggregate functions in GROUP BY results in empty set Sinisa Milivojevic
14562003-10-01
8:23
2003-12-11
12:03
MySQL ServerClosed
(5121 days)
S34.1.1 cast with union and group by with rollup displays incorrect results Sinisa Milivojevic
785122015-09-22
8:49
2016-05-25
15:00
MySQL Server: PackagingClosed
(577 days)
S35.7.9Any/var/log/mysqld.log has incorrect permissions after installing server from repo  
227042006-09-26
17:06
2007-07-05
21:10
MySQL Cluster: Disk DataCan't repeat
(3819 days)
S15.1.12-mainLinux (Linux 32 Bit OS)Cluster Crashes during NR while DD schema operations are being handled Tomas Ulin
188652006-04-06
19:29
2012-05-18
20:19
MySQL Cluster: Cluster (NDB) storage engineVerified
(4010 days)
S3mysql-4.1Linux (Linux)Table definitions "stay" even after a ndbd --initial Assigned Account
262892007-02-12
15:05
2007-02-13
10:18
MySQL Server: Information schemaNot a Bug
(3961 days)
S35.0.32Linux (Linux)GROUP BY groups `TEST` and `test` in I_S  
283372007-05-09
16:58
2007-05-27
18:19
MySQL ServerClosed
(3858 days)
S25.0.40AnyNOT EXISTS with GROUP BY behaves different in 5.0.40 (regression) Igor Babaev
659702012-07-20
21:50
2012-07-23
10:02
MySQL Server: DMLVerified
(1976 days)
S35.5.19, 5.5.26AnyAVG group function when dealing with maximum number give wrong results  
45302004-07-13
1:17
2012-05-18
20:19
MySQL ServerNo Feedback
(4875 days)
S34.0.20 and 4.0.18Linux (linux)a query using sum() reports wrong total Assigned Account
639222012-01-04
15:05
2013-04-10
1:41
MySQL Server: DocumentationWon't fix
(1713 days)
S114.14 Distrib 5.5.16, for Linux (x86_64)Linux (3.1.1)Order by null dosn't change sorting of grouped result Paul Dubois
764682015-03-24
0:06
2015-03-25
5:09
MySQL Server: DMLDuplicate
(999 days)
S15.6.22, 5.5.44, 5.6.23, 5.6.25Anyvoid Item_row::illegal_method_call(const char*): Assertion `0' failed.  
311572007-09-23
14:12
2007-11-09
21:13
MySQL Server: Data TypesClosed
(3692 days)
S25.1.23-debugLinux (suse 9.3 x86)crash when select+order by the avg of some field within the group by Georgi Kodinov
140062005-10-13
14:46
2005-10-19
7:42
MySQL Server: OptimizerNot a Bug
(4443 days)
S35.0Linux (Linux)GROUP BY doesn't work Alexey Botchkov
803102016-02-09
3:55
2016-12-12
1:30
MySQL Server: OptimizerClosed
(371 days)
S25.7, 5.6.29, 5.7.11AnyRegression for a grouping query with DISTINCT  
211742006-07-20
6:17
2007-04-12
21:24
MySQL Server: OptimizerClosed
(3903 days)
S25.0.18, 5.1bkLinux (linux)Index degrades sort performance and optimizer does not honor IGNORE INDEX Georgi Kodinov
383262008-07-24
2:50
2012-05-18
20:19
MySQL WorkbenchVerified
(3311 days)
S45.0.23WB70Anycontribution from a member of Japanese MySQL User Group about translation  
595742011-01-18
7:00
2011-02-16
23:44
MySQL Server: DocumentationClosed
(2517 days)
S35.1.51FreeBSD (Server version: 5.1.51 FreeBSD port: mysql-server-5.1.51_1)Assignment operator with group functions Paul Dubois
45352004-07-13
9:27
2004-08-12
10:45
MySQL ServerClosed
(4876 days)
S34.1.3Linux (linux)"group_concat AND order by " can't work correctly Vasily Kishkin
721192014-03-24
23:45
2014-05-23
4:29
MySQL FabricClosed
(1305 days)
S31.4.0Any"group add" hangs with server as localhost:32274 Alfranio Correia
252712006-12-25
15:18
2006-12-26
12:32
MySQL Server: Stored RoutinesCan't repeat
(4010 days)
S25.0.27Microsoft Windows (Windows XP SP2)Caching JOIN in stored procedure  
541992010-06-03
12:10
2011-02-16
23:44
MySQL Cluster: Disk DataClosed
(2589 days)
S3mysql-5.1-telco-7.1LinuxCluster+DiskData, Querying INFORMATION_SCHEMA.FILES slow when data node is down Maitrayi Sabaratnam
831282016-09-23
11:04
2017-01-24
14:35
MySQL Server: DocumentationClosed
(328 days)
S30.9.0-labsLinuxGroup Replication depends on resolvable hostnames without domain David Moss
6992003-06-23
6:56
2003-06-25
7:00
MySQL Server: Command-line ClientsClosed
(5290 days)
S24.1.0-alpha-max-ntMicrosoft Windows (Win XP)SUBSELECTION AND IN-KEYWORD Oleksandr Byelkin
769882015-05-08
15:49
2015-12-14
21:01
MySQL ServerCan't repeat
(948 days)
S25.6.16, 5.6.24Microsoft WindowsOrder By affecting a Query with column alias, group by, and having  
257882007-01-23
15:30
2007-01-29
18:05
MySQL Query BrowserClosed
(3976 days)
S31.1.20Microsoft Windows (WinXP Pro SP2)Query Browser does not like indented queries  
71012004-12-08
12:19
2004-12-10
11:29
MySQL ServerClosed
(4756 days)
S14.1Any (all)Usage of LEFT() function in GROUP BY crashes a server Sinisa Milivojevic
9582003-07-30
8:46
2003-08-06
6:54
MySQL ServerClosed
(5248 days)
S34.1, 5.0Linux (SuSE Linux 8.2)a big table without indices and select with group by doesnt work Konstantin Osipov
693102013-05-23
11:47
2013-05-23
12:44
MySQL Server: DMLVerified
(1670 days)
S35.6, 5.0.97, 5.1.70, 5.5.32, 5.6.12, 5.7.2AnyValid SQL statement rejected in ONLY_FULL_GROUP_BY  
53102004-08-31
3:11
2004-08-31
4:01
MySQL ServerClosed
(4857 days)
S24.1.3betaMicrosoft Windows (Windows 2000)subselect returns wrong results  
283502007-05-10
11:29
2007-06-22
11:44
MySQL Server: Row Based Replication ( RBR )Can't repeat
(3832 days)
S25.1.18Linux (x86_64)Different number of rows reported by "explain" Alexey Botchkov
434542009-03-06
13:38
2009-03-06
15:09
MySQL Server: ParserNot a Bug
(3209 days)
S25.1.30LinuxGROUP BY makes columns unrecognized when doing INSERT SELECT ... ON DUPLICATE K  
659832012-07-23
10:41
2012-08-24
1:00
MySQL Server: DMLNo Feedback
(1943 days)
S25.1.40Linuxa executing subquery , never stop  
554872010-07-22
16:22
2013-07-13
23:09
MySQL Workbench: ModelingClosed
(1619 days)
S25.2.25wb52Any (Linux, Mac OS X)Edit|Preferences|Model|Column Defaults: Types lack flag support (and validation)  
698242013-07-23
12:42
2017-08-16
13:24
MySQL Server: PackagingWon't fix
(124 days)
S45.6.12AnyAdd support for group  
790402015-10-30
21:49
2017-05-31
8:42
MySQL Server: OptimizerVerified
(774 days)
S45.7Anyplease merge more temptables  
611202011-05-11
0:31
2011-06-28
16:31
MySQL Workbench: ModelingWon't fix
(2365 days)
S45.2.33b - all AnyAbility to create real sub-folders within DB folders  
163222006-01-10
0:04
2006-01-10
7:44
MySQL Cluster: Cluster (NDB) storage engineClosed
(4360 days)
S25.1.5-alphaLinux (Linux)DD: drop tablespace before alter tablespace drop leaves cluster unstable Jonas Oreland
846742017-01-25
22:05
2017-02-16
10:59
MySQL Server: Group ReplicationClosed
(305 days)
S35.7.latestAnyHaving an unresolvable hostname in group_repl should not block group replication Tiago Jorge
565142010-09-02
18:00
2011-02-16
23:44
MySQL Server: DMLNo Feedback
(2632 days)
S35.5.5 m3FreeBSD (7.2)Mixing utf8, group by, IF and Datefield cause a truncate problem (Only in views)  
869792017-07-07
7:11
2017-07-14
10:37
MySQL Server: Group ReplicationVerified
(157 days)
S3mysql5.7.18Ubuntu group replicat master automatically quit  
370592008-05-29
9:34
2008-08-08
16:25
MySQL WorkbenchClosed
(3419 days)
S35.0.22Microsoft Windows (XP SP2)Errors during "Forward Engineer Schema" for Inserts date for TIMESTAMP columns Vladimir Kolesnikov
460192009-07-07
19:21
2011-02-16
23:44
MySQL Server: ViewsClosed
(2920 days)
S35.1.35, 5.0, 5.1, 5.4 bzr5.0+Linux (Fedora Core 11)ERROR 1356 When selecting from within another view that has Group By Martin Hansson
608672011-04-14
9:54
2011-05-14
23:00
MySQL ServerNo Feedback
(2410 days)
S26.0.5-alpha-communityAnyQUERY ERROR - "WHERE" IS OMMITED  
193962006-04-27
9:15
2006-06-02
13:20
MySQL ServerClosed
(4217 days)
S15.0BK/5.1BKMicrosoft Windows (Windows XP/Linux)LEFT JOINS on two views kills MySQL server (using MyODBC) Igor Babaev
429482009-02-17
23:02
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3212 days)
S55.0.67-0ubuntu6, 6.0.11Linux (Ubuntu 8.10)MySQL Optimizer does not properly use Indexes on Views with "Group By"  
534442010-05-05
16:43
2011-02-16
23:44
MySQL Workbench: ModelingNo Feedback
(2753 days)
S25.2.19Microsoft Windows (XP SP2)Created a Routine Group, populated, attempt to open failed  
880052017-10-06
4:39
2017-10-06
6:36
MySQL Server: DocumentationVerified
(73 days)
S35.7AnyFigure 17.13 seems incorrect in group replication document  
462772009-07-17
21:33
2011-02-16
23:44
MySQL Server: OptimizerVerifiedS35.0, 5.1, 5.4, 6.0Anydiffering results for equivalent queries using VAR_POP() & AVG() with DISTINCT  
114622005-06-20
16:13
2005-06-23
8:12
MySQL ServerNot a Bug
(4561 days)
S34.1.12Microsoft Windows (Windows XP)Problem with ROUND() function  
739272014-09-16
10:12
2015-03-24
21:34
MySQL Server: OptimizerClosed
(1043 days)
S35.7AnySELECT DISTINCT SUM() RETURNS DUPLICATE ROWS  
324552007-11-16
18:29
2007-11-16
22:40
MySQL Server: InnoDB storage engineCan't repeat
(3685 days)
S35.0.45-logFreeBSDProblem in innodb with a HAVING xxx IS NULL While using a GROUP BY  
40402004-06-07
15:54
2004-06-08
15:37
MySQL ServerNot a Bug
(4941 days)
S24.1.1a-alpha-ntMicrosoft Windows (Windows 2003 Server)Extremely Slow "Where in (Select... )" Subqueries GROUP BY / HAVING related Oleksandr Byelkin
96722005-04-06
11:11
2005-05-05
15:47
MySQL ServerCan't repeat
(4610 days)
S1 5.0.4-beta-nightly-20050328Linux (linux)mysql_stmt_attr_set CURSOR_TYPE_READ_ONLY query containing GROUP BY Konstantin Osipov
114642005-06-20
16:41
2005-06-20
22:54
MySQL ServerClosed
(4564 days)
S24.1.12a-nt-logMicrosoft Windows (Win XP)MySQL server crashes on simple aggregate (500 rows)  
145362005-11-01
7:37
2005-11-12
22:51
MySQL ServerClosed
(4419 days)
S25.0 ./mysql-test-run --ps-protocol user_var fails Michael Widenius
401362008-10-19
4:33
2011-02-16
23:43
MySQL Server: OptimizerClosed
(2583 days)
S36.0-BKAAnyGroup by is ignored when join buffer is used for an outer join Sergey Petrunya
675292012-11-09
0:20
2017-01-09
18:55
MySQL Server: DMLVerified
(1865 days)
S35.1.41, 5.1.67, 5.5.29, 5.7.0AnyGROUP BY treats +0 and -0 as different values  
793052015-11-17
7:29
2016-01-11
13:59
MySQL ServerClosed
(707 days)
S35.7.9, for linux-glibc2.5 (x86_64)Linux (linux)mysql_secure_installation isn't working with prompt in the [mysql] group  
826332016-08-18
12:09
2017-02-16
17:48
MySQL WorkbenchVerified
(486 days)
S36.3.7 build 1210 CE (64-bits)Fedora (24 (GNOME Shell 3.20.3))"Forward Engineering" button group hidden  
217052006-08-17
22:50
2012-05-18
20:19
MySQL Server: OptimizerDuplicate
(4120 days)
S24.1.21/4.1/5.0/5.1BKLinux (Linux)COUNT(DISTINCT field) with GROUP BY forces incorrect behaviour of LIMIT Georgi Kodinov
306652007-08-28
8:03
2007-11-13
18:59
MySQL Server: OptimizerClosed
(3688 days)
S35.1.17AnyInconsistent optimization of IGNORE INDEX FOR {ORDER BY|GROUP BY} Martin Hansson
383452008-07-24
12:31
2008-07-25
18:13
MySQL Server: GeneralCan't repeat
(3433 days)
S35.0.44-log mysql-5.0.44 Linux (Gentoo Linux)Result in first column depends on last field in select statments  
608732011-04-14
17:58
2011-04-15
12:42
MySQL Server: OptimizerClosed
(2439 days)
S25.1.49-3Linux (Debian x64)select query using function on index column does not use index  
286182007-05-23
12:30
2009-12-07
14:00
MySQL Server: ReplicationClosed
(3673 days)
S25.15.1.23AnySkipping into the middle of a group with SQL_SLAVE_SKIP_COUNTER is possible Mats Kindahl
322022007-11-08
22:30
2007-11-19
4:31
MySQL Server: GeneralClosed
(3682 days)
S25.0.505.0.52,5.1.23AnyORDER BY not working with GROUP BY Alexey Kopytov
60912004-10-14
11:14
2004-11-03
16:13
MySQL Query BrowserClosed
(4793 days)
S21.0.8 betaMicrosoft Windows (Win2K SP4)Incorrect GROUP BY/ORDER BY order causes crash Victor Vagin
112112005-06-09
16:10
2005-06-23
5:07
MySQL Server: OptimizerClosed
(4561 days)
S15.0.6Microsoft Windows (Windows XP)GROUP BY doesn't work correctly Timour Katchaounov
795642015-12-09
6:59
2016-09-16
11:47
MySQL Server: Group ReplicationNot a Bug
(458 days)
S30.6, 0.8AnyMySQL Group Replication stop replicate on conflict operations Nuno Carvalho
299002007-07-19
14:39
2013-03-03
20:45
MySQL Server: Information schemaVerified
(2876 days)
S35.1.21-23AnyMySQL does not return an error to the client if INFORMAT SCHEMA fill table fails  
370682008-05-29
12:12
2008-05-31
23:19
MySQL Server: C API (client library)Not a Bug
(3488 days)
S35.1.23 5.1.24Other (OPENBSD)use the c api call the procedure Error!!  
86532005-02-21
16:33
2005-04-06
15:09
MySQL ServerClosed
(4639 days)
S1 5.0.3 leaves an InnoDB trx open after connection ends; InnoDB shutdown hangs Jan Lindström
483332009-10-26
22:40
2011-02-16
23:44
MySQL Enterprise Monitor: WebClosed
(2973 days)
S32.2 alphaAnygroup/server nav tree styling regression Josh Sled
808462016-03-24
10:32
2016-04-26
5:54
MySQL Cluster: Cluster (NDB) storage engineClosed
(628 days)
S37.5.1AnySpecific partitioned tables always place first partition on node group 0  
176142006-02-21
14:06
2011-02-16
23:43
MySQL Cluster: Cluster (NDB) storage engineClosed
(3224 days)
S25.1.8Linux (Linux 64 bit OS)DD: SR fails when having logfilegroups wo/ undofiles Jonas Oreland
316942007-10-18
15:59
2008-01-31
14:08
MySQL ServerCan't repeat
(3609 days)
S25.1-bk (5.1.23-beta-debug)AnySIGSEGV in Field_string::type (this=0x80372c660) at field.h:1200 Tatiana Azundris Nuernberg
731682014-07-02
4:14
2015-02-25
10:51
MySQL Server: InnoDB storage engineVerified
(1265 days)
S55.6/5.7Anylocking/unlocking overhead for THD::LOCK_thd_data  
311842007-09-25
13:25
2007-10-29
17:43
MySQL Server: MyISAM storage engineNo Feedback
(3703 days)
S15.0.48 enterpriseMicrosoft Windows (server 2003)sort aborted  
823852016-07-30
0:32
2016-07-31
3:14
MySQL Server: Group ReplicationClosed
(505 days)
S2MySQL 5.7.14Linux (CentOS 6.5)Group Replication Plugin failing when plugin_load  
196672006-05-10
8:57
2006-06-23
5:06
MySQL ServerClosed
(4196 days)
S15.0.21FreeBSD (FreeBSD)group by a decimal expression yields wrong result Sergey Glukhov
652362012-05-08
8:15
2012-05-11
21:01
MySQL Cluster: Cluster (NDB) storage engineVerified
(2047 days)
S2NDB 7.2.5, MySQL 5.5.20Linux (Ubuntu 11.10 x64)Can't set/get data with 2-part key.  
186452006-03-30
10:30
2006-03-30
12:04
Connector / JDuplicate
(4281 days)
S3MySQL 4.1.13 + Connector 3.1.12Linux (RedHat Linux)ResultSet.getString() returns a byte array for GROUP_CONCAT()  
368212008-05-20
16:25
2013-06-18
9:40
MySQL Server: GeneralCan't repeat
(1644 days)
S35.0.51a/5.1/6.0Linux (Redhat Linux Enterprise 4ES X86_64)HAVING clause returning different result Guilhem Bichot
711262013-12-11
11:04
2014-05-29
7:39
MySQL FabricClosed
(1466 days)
S21.4.0Microsoft WindowsCommand "mysqlfabric" not recognized on Windows platform  
168542006-01-27
20:27
2012-05-18
20:19
MySQL ServerDuplicate
(4149 days)
S1MySQL 5.0.18 tinyint(1) are not treated as booleans in group by Georgi Kodinov
457822009-06-26
10:10
2011-02-16
23:44
MySQL Server: OptimizerDuplicate
(3097 days)
S25.1AnyQuery with nested JOIN + GROUP BY sporadically returns bad results  
703592013-09-16
23:02
2013-09-17
7:10
MySQL Server: OptimizerVerified
(1553 days)
S35.1, 5.5, 5.6, 5.7AnyWrong result (missing rows) with group by, multi-part key, equality conditions  
311912007-09-25
19:03
2007-09-26
19:23
MySQL ServerDuplicate
(3736 days)
S15.0.50, 5.1.22LinuxJOIN in combination with stored function crashes the server  
445032009-04-27
21:13
2011-02-16
23:43
MySQL WorkbenchClosed
(3115 days)
S35.1.12WB51Mac OS X (10.5.6)Renaming a routine group does not update EER diagram Alfredo Kojima
480872009-10-15
14:53
2016-11-27
20:45
MySQL Cluster: Cluster (NDB) storage engineDuplicate
(2910 days)
S1mysql-5.1-telco-7.0Linux (SuSE EL SP2 x86_64)ndbd crash with error 2341 Assigned Account
613992011-06-03
15:03
2011-06-03
15:54
MySQL Server: OptimizerVerified
(2390 days)
S35.5/5.0/5.1AnyWrong result with GROUP BY and indexes  
71282004-12-09
11:20
2004-12-09
13:36
MySQL ServerNot a Bug
(4757 days)
S34.0.14Mac OS X (MAC OS X)SELECT COUNT with GROUP BY bug  
217202006-08-18
12:33
2012-05-18
20:19
MySQL ServerDuplicate
(4113 days)
S25.0.24Microsoft Windows (WinXP sp2)SELECT <group func> INTO @var .. GROUP BY gives wrong result Assigned Account
288882007-06-05
1:25
2007-06-05
10:21
MySQL Server: Data TypesCan't repeat
(3849 days)
S34.0.25AnyCAST on TEXT field returns BLOB when ORDERED BY  
503942010-01-17
4:55
2011-02-16
23:44
MySQL Server: OptimizerClosed
(2583 days)
S25.1.41, 5.1, 5.5.99 bzr5.1+AnyRegression in EXPLAIN with index scan, LIMIT, GROUP BY and ORDER BY computed col Martin Hansson
782992015-09-01
13:31
2015-10-15
20:50
MySQL Workbench: ModelingClosed
(795 days)
S26.3.4Linux (Ubuntu 14.04.3 LTS)Adding Routines to Routines Group is not Working  
230032006-10-05
7:36
2006-10-26
2:37
MySQL Workbench PreviewWon't fix
(4071 days)
S11.1.4 alphaMicrosoft Windows (Windows XP SP2)Can't edit routine group object  
547472010-06-23
16:06
2011-02-16
23:44
MySQL Server: LockingClosed
(2656 days)
S35.5.3-m3, 5.5.5-m35.5+AnyDeadlock between REORGANIZE PARTITION and SELECT is not detected Mattias Jonsson
480922009-10-15
17:38
2009-10-15
18:49
MySQL Server: OptimizerNot a Bug
(2986 days)
S35.1, 6.0AnyAddition of DISTINCT clause results in incorrect exclusions from result set  
401572008-10-19
20:01
2012-05-18
20:19
Tests: ClusterVerifiedS25.1, 6.0Anyndb_dd_alter fails sporadically on pushbuild Assigned Account
  Showing 1-1000 of 2262 (Edit, Save, CSV, Feed) Show Next 1000 Entries »