Showing 1–1000 of 3114
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 33506 | 2007-12-25 10:04 | 2018-09-25 21:47 | Tests: Server | Duplicate (6753 days) | S7 | 6.0.5 | Linux (Debian x86_64) | Any | crash on stack overrun |
| 98782 | 2020-02-28 18:57 | 2020-07-20 8:31 | MySQL Server: InnoDB storage engine | Can't repeat (2298 days) | S5 | 8.0.19 | Any | Any | Using TempTable engine for GROUP BY is slower than using MEMORY engine |
| 91057 | 2018-05-29 10:31 | 2018-11-06 17:00 | MySQL Server: Group Replication | Closed (2981 days) | S3 | 5.7.23 | Any | Any | GR recovery can retry infinitely if count is modified to lower value on the fly |
| 94115 | 2019-01-29 14:18 | 2025-12-07 20:45 | MySQL Server | Duplicate (2829 days) | S3 | 8.0.14 | Linux | Any | mysql 8.0.14 dba.createCluster fail |
| 33266 | 2007-12-16 7:33 | 2018-09-25 21:47 | MySQL Server: Tests | Closed (6790 days) | S7 | 5.0.54,5.1.23, 5.1.24-BK, 6.0-BK | Any | Any | regression test subselect fails |
| 56470 | 2010-09-01 19:28 | 2016-10-16 20:45 | MySQL Server: Row Based Replication ( RBR ) | No Feedback (5869 days) | S1 | 5.6.99-m5 | Any | Any | Stop slave at middle of the transaction can cause fatal error |
| 118858 | 2025-08-20 8:51 | 2025-09-23 4:03 | MySQL Server: Optimizer | Verified (407 days) | S2 | 9.2.0 | Linux | Any | Inconsistency between the results returned by MySQL and other vendors' database systems was found during differentiation |
| 17590 | 2006-02-20 17:44 | 2006-02-23 9:32 | MySQL Server: Optimizer | Can't repeat (7559 days) | S2 | 5.1.7-beta | Any (All) | Any | Different key-len and # rows reported on all platforms |
| 49843 | 2009-12-21 9:59 | 2015-01-09 14:42 | MySQL Cluster: NDB API | Won't fix (4317 days) | S3 | mysql-cluster-7.0.6 | Linux | Any | ndb_mgm_get_status() returning invalid node_group information for starting node |
| 22020 | 2006-09-05 13:50 | 2013-10-06 20:45 | MySQL Cluster: Disk Data | Duplicate (7365 days) | S1 | 5.1 | Linux (Linux) | Any | ndb_dd_<various> tests fail, amd64 Linux |
| 29058 | 2007-06-12 19:14 | 2007-06-13 12:14 | MySQL Server: Tests | Can't repeat (7084 days) | S3 | 5.0.41 | IBM AIX (5.3) | Any | type_float test fails on AIX 5.3 using vac |
| 74095 | 2014-09-26 8:04 | 2014-10-27 14:04 | MySQL Server: Documentation | Closed (4391 days) | S3 | mysql 5.7.5m15 | Any | Any | "MySQL Extensions to GROUP BY" documentation needs update |
| 55453 | 2010-07-21 18:01 | 2011-02-16 23:44 | MySQL Enterprise Monitor: Agent | Closed (5923 days) | S1 | 2.2.2.1729 | Any | Any | Agent resends the same example query over and over every 2 minutes |
| 80660 | 2016-03-08 16:38 | 2016-03-08 16:52 | MySQL Server: Optimizer | Open | S4 | 5.7 | Any | Any | MySQL could detect functional dependency on group expressions |
| 121141 | 2026-08-20 1:50 | 2026-08-20 5:26 | MySQL Server: Optimizer | Verified (76 days) | S1 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | group skip scan for deduplication collapses each group to one row before a semijoin/antijoin condition on a later index |
| 121142 | 2026-08-20 1:50 | 2026-08-20 5:21 | MySQL Server: Optimizer | Duplicate (76 days) | S1 | 8.0.41, 8.4.11, 9.4.0, 9.7.1 | Any | Any | group skip scan for deduplication collapses each group to one row before a semijoin/antijoin condition on a later index |
| 78749 | 2015-10-08 6:25 | 2015-12-03 14:05 | MySQL Server: Group Replication | Closed (3989 days) | S1 | 0.5.0-dmr | Ubuntu (14.04) | Any | Assertion `!flags.finalized' failed with group replication plugin |
| 121314 | 2026-09-18 10:03 | 2026-09-30 14:48 | MySQL Server: Replication | Documenting (44 days) | S2 | 8.0.40/5.7.44 | Any | Any | MTS recovery silently skips transactions, leaving holes in gtid_executed |
| 72931 | 2014-06-10 9:18 | 2014-09-10 0:35 | MySQL Fabric | Closed (4438 days) | S3 | 1.4.3 | Linux (CentOS 6.5) | Any | mysqlfabric group destroy --force does not work, Error in _destroy_group. |
| 108118 | 2022-08-11 12:22 | 2022-08-22 16:47 | MySQL Server: Group Replication | Verified (1546 days) | S4 | 8.0.30 | Any | Any | group replication reconfiguration should not require destroying the group |
| 116532 | 2024-11-03 3:07 | 2024-11-28 14:36 | MySQL Server: Group Replication | Verified (706 days) | S1 | 8.0.40 | Ubuntu (24.04) | x86 (x86-64) | Group Replication cluster deployed across a regional GCP regularly got stuck |
| 7042 | 2004-12-06 16:29 | 2004-12-15 13:05 | MySQL Administrator | Closed (7994 days) | S3 | 1.0.16 | Windows (Win XP) | Any | MySQL Administrator writes mysqladmin_options.xml on exit |
| 15562 | 2005-12-07 21:22 | 2006-02-14 3:29 | MySQL Server | Closed (7568 days) | S3 | 5.0.16 | Solaris (Solaris 10 / SPARC) | Any | Package for Solaris 10 has invalid unix group 'wheel' reference |
| 25834 | 2007-01-24 16:52 | 2018-09-25 21:44 | MySQL Server: Tests | Closed (7176 days) | S7 | 5.0-current | Linux (Linux) | Any | Test failure in "func_group" |
| 35174 | 2008-03-10 0:00 | 2008-05-28 15:09 | MySQL Server | No Feedback (6734 days) | S1 | 5.0.37 | Linux (Redhat) | Any | Query w/ Many Subqueries and Views Causes Crash |
| 71199 | 2013-12-21 18:16 | 2014-01-28 17:45 | MySQL Server: Optimizer | Verified (4699 days) | S3 | 5.6.14, 5.6.15, 5.5.35 | Any | Any | Optimizer's estimated number of rows is 2 times wrong for (loose?) index scans |
| 81388 | 2016-05-12 6:32 | 2016-05-13 15:32 | MySQL Server: Optimizer | Not a Bug (3827 days) | S3 | 5.6.29 | Any | Any | min/max optimization ignores group by |
| 85725 | 2017-03-31 6:17 | 2017-04-07 23:00 | Tests: Group Replication | Not a Bug (3498 days) | S3 | 5.7.17 | Windows | Any | mysql group replication |
| 98770 | 2020-02-28 4:02 | 2020-03-03 15:05 | MySQL Server: Optimizer | Verified (2437 days) | S5 | 8.0.19 | Any | Any | Non-covering full index scan is always preferred over table scan for GROUP BY |
| 106032 | 2022-01-04 14:17 | 2022-01-21 6:47 | MySQL Server: Group Replication | Verified (1749 days) | S3 | 8.0.27 Community Server | Debian (11.2) | x86 (HyperV) | MySQL uses up ram/swap after short member disconnect within innodb cluster |
| 114638 | 2024-04-12 16:33 | 2024-08-06 9:58 | MySQL Server: DML | Closed (821 days) | S4 | 8.0 | Any | Any | ROLLUP misses a summary NULL |
| 71512 | 2014-01-29 15:34 | 2014-02-28 8:05 | MySQL Fabric | Closed (4632 days) | S3 | 1.4.0 | Any | Any | Servers in the same group should use a single user/password |
| 74093 | 2014-09-26 7:18 | 2014-09-30 17:54 | MySQL Server: Documentation | Closed (4418 days) | S3 | 5.7.5m15 | Any | Any | ONLY_FULL_GROUP_BY documentation not up to date |
| 80554 | 2016-02-29 9:43 | 2016-04-26 5:53 | MySQL Cluster: Cluster (NDB) storage engine | Closed (3871 days) | S3 | 7.4.11 | Any | Any | Binlog schema distribution timeout and fails when another mysql node start |
| 90601 | 2018-04-24 10:47 | 2021-11-30 13:19 | MySQL Server: Replication | Closed (2759 days) | S3 | 8.0.11 | Oracle Linux (Offical Docker image) | Any | REPORT_HOST OPTION HAS A LIMIT OF 60 CHARACTERS |
| 103378 | 2021-04-20 3:34 | 2021-04-20 9:08 | MySQL Server: Optimizer | Not a Bug (2024 days) | S3 | 8.0.23 | Any | Any | sql_mode=only_full_group_by error 1055 is not appear for DELETE and UPDATE |
| 120732 | 2026-06-20 13:22 | 2026-06-22 6:37 | MySQL Server: Optimizer | Verified (135 days) | S3 | MySQL 9.6 | Any (Storage Engine: InnoDB) | Any | Derived Table Merging Causes Incorrect Duplicate Removal with DISTINCT + GROUP BY + SUM(DISTINCT EXISTS(subquery)) |
| 30477 | 2007-08-17 15:12 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (7016 days) | S4 | all, or asap | Any | Any | Allow returning unordered result from GROUP BY |
| 62053 | 2011-08-02 4:14 | 2011-08-02 4:22 | MySQL Server: DML | Not a Bug (5573 days) | S1 | 5.5 | Any | Any | columns in SELECT clause not affected by group fn must be declared in GROUP BY |
| 70203 | 2013-08-30 16:38 | 2013-08-31 12:32 | MySQL Server: Documentation | Not a Bug (4813 days) | S3 | 5.5.32 | Any | Any | GROUP BY is consistent with ORDER BY in subquery |
| 71097 | 2013-12-05 18:26 | 2014-08-01 15:55 | MySQL Server: Optimizer | Closed (4534 days) | S2 | 5.1.70, 5.5.33, 5.5.35, 5.6.14, 5.6.15 | Any | Any | Wrong results for a simple query with GROUP BY |
| 71495 | 2014-01-27 20:34 | 2016-10-27 8:30 | MySQL Server: Replication | Verified (4355 days) | S3 | 5.6.14 | Any | Any | Logging of MTS breakage is insufficient. |
| 78183 | 2015-08-24 9:01 | 2015-09-01 8:37 | MySQL Server: DML | Not a Bug (4082 days) | S3 | 5.6.22 | Any | Any | Similar query with aggregate functions returns inconsistent result |
| 85221 | 2017-02-28 8:51 | 2017-07-11 11:44 | MySQL Server: Packaging | Closed (3403 days) | S3 | 5.7.17 | Red Hat | Any | Group Replication : Error while adding instance in group. |
| 90494 | 2018-04-18 12:04 | 2018-11-06 16:57 | MySQL Server: Group Replication | Closed (3008 days) | S3 | 8.0.12 | Any | Any | gr_exit_state_action=ABORT_SERVER is not considered on compatibility checks |
| 92981 | 2018-10-29 4:33 | 2019-10-14 11:15 | MySQL Server: Group Replication | Not a Bug (2578 days) | S2 | 5.7.22 | Oracle Linux | Any | Potential connection leak in group replication |
| 97207 | 2019-10-14 1:18 | 2019-10-14 10:21 | MySQL Server: Replication | Verified (2578 days) | S3 | 5.7.26, 5.7.27 | Any | Any | MySQL Group Replication Old incarnation |
| 106312 | 2022-01-27 18:14 | 2022-02-09 13:20 | MySQL Server: Optimizer | Verified (1741 days) | S3 | 5.7 | Any (Ubuntu 20.04.3 LTS) | Any (Intel(R) Core(TM) i7-10700 CPU @ 2.90GHz) | Huge value in GROUP BY clause cause unexpected output |
| 106526 | 2022-02-21 14:12 | 2023-12-01 6:54 | MySQL Server: Group Replication | Verified (1715 days) | S3 | 8.0.27 | Any | Any | Having a group member rejoining a group stalls writes to the group |
| 118027 | 2025-04-22 6:43 | 2025-04-22 11:37 | MySQL Server: Data Types | Verified (561 days) | S4 | 10.x (Future Planning / Major Architectu | Any | Any | Transform MySQL into a Structure-Aware, Flexible, AI-Compatible Engine with Infinite Grouping, Symbolic Linking, and Loc |
| 118602 | 2025-07-08 10:26 | 2025-08-19 0:07 | MySQL Server: Replication | Can't repeat (442 days) | S2 | 8.0.42 | Ubuntu (8.0.42-0ubuntu0.24.04.1) | x86 | SQL Thread cannot be stopped when last error was 1755 |
| 394 | 2003-05-07 20:59 | 2003-05-09 13:23 | MySQL Server: MyISAM storage engine | Closed (8580 days) | S2 | 4.0.12 | Windows (Win 2000/ 98) | Any | Creating table |
| 618 | 2003-06-06 22:46 | 2003-07-03 5:51 | MySQL Server | Closed (8525 days) | S2 | 4.0.12 | Windows (Windows NT) | Any | UNION clause does not work properly. |
| 16341 | 2006-01-10 14:23 | 2006-06-28 5:49 | MySQL Cluster: Disk Data | Closed (7434 days) | S3 | 5.1.5-alpha | Linux (Linux) | Any | DD: Failed CREATE LOGFILE GROUP/TABLESPACE should back out all changes |
| 22316 | 2006-09-13 15:49 | 2006-10-26 17:22 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (7314 days) | S1 | 5.0.24a | Linux (CentOS 4.4 x86_64) | Any | Four-node cluster loses Node Group 1 |
| 30393 | 2007-08-13 16:27 | 2007-10-09 0:53 | MySQL Server: Optimizer | Closed (6966 days) | S3 | IBM AIX (5.2, only 32 bit) | Any | Test "group_by" fails with a difference in "row count" and strategy (explain) | |
| 30732 | 2007-08-30 19:03 | 2007-09-30 19:09 | MySQL Server: Compiling | No Feedback (6975 days) | S2 | 5.0.32 | Windows (XP Professional) | Any | Really long query can't handle use of GROUP function |
| 57815 | 2010-10-28 14:52 | 2018-12-09 20:45 | MySQL Enterprise Monitor: Web | Verified (5851 days) | S3 | 2.3.0.2036 | Any | Any | There was a problem generating the Support Report for Group "". |
| 68568 | 2013-03-05 3:17 | 2021-09-15 20:49 | MySQL Server: Replication | Verified (4738 days) | S3 | 5.6.10 | Linux (CentOS 5.8 X64) | Any | Stop Slave statement will timeout not waiting the event group complete |
| 75287 | 2014-12-22 13:44 | 2015-03-30 15:58 | Connector / Python | Closed (4271 days) | S1 | 2.0 | Any | Any | Python does not work with HASH sahrding in MySQL Fabric |
| 86957 | 2017-07-05 12:49 | 2019-01-22 14:20 | MySQL Server: Group Replication | Closed (3045 days) | S3 | 5.7.20 | Any | Any | SETTING gr_force_members HITS ERROR1231 SOMETIMES WHILE UNBLOCKING THE GROUP |
| 87834 | 2017-09-22 8:00 | 2019-01-22 14:17 | MySQL Server: Group Replication | Closed (3178 days) | S3 | 5.7.21 | Any | Any | node joins group even though it is not whitelisted on one of the group member |
| 88304 | 2017-10-31 11:16 | 2018-02-01 14:03 | MySQL Server: Group Replication | Closed (3219 days) | S3 | 8.0.3 | Any | Any | SOMETIMES MEMBERS ENTER IN ERROR STATE AFTER LONG RECOVERY |
| 89195 | 2018-01-11 19:15 | 2019-07-25 14:45 | MySQL Server: Group Replication | Closed (2659 days) | S2 | 5.7.20, 8.0.3 | Any | Any | Total ordering of transactions is not respected in Group Replication. |
| 99436 | 2020-05-04 11:51 | 2020-09-28 14:46 | MySQL Cluster: Cluster (NDB) storage engine | Not a Bug (2228 days) | S3 | 8.0.20 | Red Hat (8) | Any | NDB fully replicated tables only in node group 0, not in node group 1 |
| 99659 | 2020-05-21 14:49 | 2020-05-28 15:15 | MySQL Server: Group Replication | Not a Bug (2351 days) | S2 | mysql80-server-8.0.19_2 | FreeBSD ( FreeBSD 12.1-RELEASE r354233 GENERIC amd64) | x86 | Group Replication going to ERROR after Regular operation is restored |
| 100381 | 2020-07-30 15:07 | 2020-10-14 17:19 | MySQL Server: Group Replication | Can't repeat (2212 days) | S2 | 8.0.21 | CentOS (CentOS Linux release 7.7.1908 (Core)) | x86 ( Intel(R) Xeon(R) CPU E5-2640 0 @ 2.50GHz) | Group replication primary got stuck after attempting to rejoin a group member |
| 103869 | 2021-05-31 14:29 | 2021-06-03 10:21 | MySQL Server: Optimizer | Verified (1981 days) | S5 | 8.0.24, 8.0.25 | Any | Any | Duplicate computation of aggregate function when referred in HAVING clause |
| 107821 | 2022-07-08 18:02 | 2022-07-20 6:36 | MySQL Server: Optimizer | Verified (1577 days) | S3 | 8.0, 8.0.29 | Any | Any | Result error : SQL with group by with rollup and const field |
| 121313 | 2026-09-18 5:38 | 2026-09-18 7:59 | MySQL Server: Optimizer | Verified (47 days) | S3 | 9.7.2 | Any | Any | REPLACE() Produces Different Results Depending on Whether GROUP BY Is Applied |
| 2085 | 2003-12-10 14:00 | 2003-12-11 14:24 | MySQL Server | Can't repeat (8364 days) | S2 | 4.1.1 | Windows (Windows 2000 sp6) | Any | InnoDB MySQL crashes when doing certain nested subqueries |
| 33655 | 2008-01-03 16:06 | 2008-07-31 17:19 | MySQL Server: Documentation | Closed (6670 days) | S3 | Any | Any | UDF documentation is unclear on pre-5.0 and 5.0 differences | |
| 34659 | 2008-02-19 10:36 | 2008-03-11 12:01 | MySQL Server: Errors | Not a Bug (6812 days) | S3 | 5.0+ | Any | Any | Unexpected error & wrong msg.: 1054: Unknown column '...' in 'having clause' |
| 36798 | 2008-05-19 13:05 | 2008-06-12 15:33 | MySQL Server: Documentation | Closed (6719 days) | S2 | 5.1.23/5.1.24 | Any | Any | aggregate functions with columns and aggregate functions works (shouldn't?) |
| 49432 | 2009-12-03 22:25 | 2011-02-16 23:44 | MySQL Workbench: Modeling | Closed (6042 days) | S2 | 5.2.10 Beta | Linux (mysql-workbench-oss-5.2.10-1ubu804-amd64.deb) | Any | Routines SQL not updated if new Routine Group opened in editor |
| 57833 | 2010-10-29 8:05 | 2018-04-17 13:01 | MySQL Enterprise Monitor: Web | Closed (3123 days) | S3 | 2.3.0.2036 | Any | Any | MEM Dashboard: You must log in to access the requested resource... |
| 78534 | 2015-09-23 17:29 | 2015-09-23 20:44 | MySQL Server: DML | Can't repeat (4060 days) | S3 | Any | Any | Different results are coming when ran a same Query in two different applications | |
| 83136 | 2016-09-24 15:47 | 2018-10-21 20:45 | MySQL Server: C API (client library) | No Feedback (3639 days) | S3 | 5.7.15 | Any | Any | for libmysql the [client] group may be read twice |
| 87474 | 2017-08-18 11:07 | 2018-05-31 14:47 | MySQL Server: Group Replication | Closed (3173 days) | S3 | 5.7.20 | Any | Any | Slave channels start before group replication starts preventing joins |
| 89042 | 2017-12-23 6:47 | 2018-05-31 14:53 | MySQL Server: Group Replication | Closed (3177 days) | S2 | 8.0.5 | Any | Any | START GR HANGS AND WITH THAT NO NEW CONNECTION IS ALLOWED ON THAT SERVER |
| 90986 | 2018-05-23 9:40 | 2018-11-06 16:58 | MySQL Server: Group Replication | Closed (2981 days) | S3 | 5.7.23 | Any | Any | Config issue makes server skips own details in ER_GRP_RPL_MEMBER_CHANGE msg |
| 91163 | 2018-06-07 1:10 | 2018-06-22 15:31 | MySQL Server: Group Replication | Can't repeat (3057 days) | S1 | 8.0.11 | CentOS (7.4) | Any | MGR member cannnot be joined, which has more executed transactions than present |
| 99838 | 2020-06-10 8:57 | 2020-07-13 12:42 | MySQL Server: Parser | Not a Bug (2305 days) | S3 | 8.0.20 | Any | Any | FULL GROUP BY violation insides a subquery |
| 111813 | 2023-07-19 10:36 | 2023-09-05 15:05 | Shell Upgrade Checker | Closed (1156 days) | S3 | 8.0.32, 8.0.34 | CentOS (CentOS Linux release 7.5.1804 (Core)) | x86 (Intel(R) Xeon(R) CPU E5-4620 v2 @ 2.60GHz) | mysqlshell upgrade checker checkTableOutput stage mark view Corrupt |
| 120281 | 2026-04-17 9:21 | 2026-04-17 11:32 | MySQL Server: Replication | Open (201 days) | S2 | 8.0.42 | Linux (any) | Any | replica_preserve_commit_order causes infinite deadlock in group commit pipeline, blocking all application writes |
| 120461 | 2026-05-12 19:56 | 2026-05-27 15:44 | MySQL Server | Open | S4 | 10.x | Any | Any | InnoDB Batch Commit for Faster Source and Replica Execution |
| 120786 | 2026-06-26 4:51 | 2026-06-26 8:50 | MySQL Server: Optimizer | Duplicate (131 days) | S1 | MySQL 9.6 | Any | Any | Derived Table Materialization with Pushed-Down IN Condition Causes Empty Result Instead of NULL for Aggregate |
| 4907 | 2004-08-05 9:23 | 2004-08-08 1:03 | MySQL Server | Closed (8123 days) | S4 | any | Any (any) | Any | feature request - SQL extensions |
| 7718 | 2005-01-06 21:59 | 2014-03-13 13:33 | MySQL Cluster: Cluster (NDB) storage engine | Won't fix (7968 days) | S3 | 4.1.9 | Linux (Fedora Core 1) | Any | NDB Fails On Loading Complex Data Warehouse |
| 16738 | 2006-01-24 1:46 | 2006-01-26 0:45 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7587 days) | S1 | 5.1.6-alpha | Linux (Linux) | Any | DD: Cluster does not handle running out of space in disk data file |
| 19141 | 2006-04-17 15:43 | 2006-04-23 1:15 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7500 days) | S2 | 5.1.10 | Linux (Linux 32 Bit OS) | Any | DD: CREATE LFG during DROP of a NDB table cause DN failure and corruption |
| 28691 | 2007-05-25 20:16 | 2007-08-23 16:42 | MySQL Server: Optimizer | Not a Bug (7013 days) | S3 | 5.1.18 | Any | Any | GROUP BY optimization ignores functional dependency on unique/primary key |
| 28977 | 2007-06-08 14:35 | 2007-06-08 14:46 | MySQL Server: General | Not a Bug (7089 days) | S2 | 5.0.37, 5.0.22 | Any | Any | cannot change the group mysqld runs as |
| 42094 | 2009-01-13 23:01 | 2020-04-11 2:07 | MySQL Server: Optimizer | Closed (2398 days) | S3 | 5.1 | Any | Any | Optimizer chooses a wrong index when group by, order by and limit is present |
| 54515 | 2010-06-15 14:14 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5828 days) | S1 | 5.5.5-m3-Celosia, 5.6.99-Dahlia, 6.0.14 | Any | Any | Crash in opt_range.cc::get_best_group_min_max on SELECT from VIEW with GROUP BY |
| 55188 | 2010-07-12 21:01 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5864 days) | S2 | 5.1.46sp1 | Any | Any | GROUP BY, GROUP_CONCAT and TEXT - inconsistent results |
| 56690 | 2010-09-09 13:30 | 2011-03-24 22:51 | MySQL Server: Optimizer | Closed (5704 days) | S3 | 5.0, 5.1, 5.5 | Any | Any | Wrong results with subquery with GROUP BY inside < ANY clause |
| 62372 | 2011-09-07 11:48 | 2018-02-11 14:17 | MySQL Server: DML | Closed (3188 days) | S3 | 5.5.15, 5.5.17 | Any | Any | Wrong query results with SQL_CALC_FOUND_ROWS, GROUP BY, LIMIT and Using index |
| 64454 | 2012-02-25 20:49 | 2026-10-23 2:32 | MySQL Workbench: Modeling | Won't fix (12 days) | S4 | 5.2.37, 5.2.38 | Any | Any | Routine Groups Can Not Be Resized |
| 71191 | 2013-12-20 15:30 | 2013-12-20 20:20 | MySQL Server: Optimizer | Verified (4702 days) | S3 | 5.5.33 | Any | Any | Loose index scan is used even though full table scan/tight index scan is faster |
| 72871 | 2014-06-04 12:08 | 2014-06-16 9:42 | MySQL Fabric | Not a Bug (4524 days) | S4 | 1.4.3 | Linux (CentOS 6.5) | Any | mysqlfabric changes slave connection to master and breaks replication. |
| 77508 | 2015-06-26 14:12 | 2016-04-27 15:05 | MySQL Server: Replication | Closed (4145 days) | S3 | 5.7.8 | Any | Any | Update new rpl tests to work with Group Replication |
| 84587 | 2017-01-20 13:43 | 2017-06-01 16:21 | MySQL Server: Optimizer | Closed (3452 days) | S2 | 8.0 | Any | Any | WL#9236: including or excluding columns from SELECT list makes results wrong |
| 89058 | 2017-12-26 12:15 | 2017-12-29 11:25 | MySQL Server: Group Replication | Not a Bug (3232 days) | S3 | 5.7.20 | Linux | Any | Group Replication(MGR) ERROR while executing concurrent DDL and DML |
| 89870 | 2018-03-01 14:21 | 2020-10-02 14:27 | MySQL Server: Partitions | Not a Bug (2224 days) | S4 | 5.7.18 | Any | Any | Group by optimization not used with partitioned tables |
| 89954 | 2018-03-08 6:01 | 2018-04-13 3:09 | MySQL Server: Group Replication | Closed (3127 days) | S2 | mysql-community-server-minimal-5.7.20-1. | Oracle Linux (3.10.0-693.11.6.el7.x86_64) | x86 | InnoDB cluster status inconsistent with group replication |
| 93578 | 2018-12-12 16:15 | 2019-02-05 10:10 | MySQL Server: Group Replication | Closed (2829 days) | S3 | 8.0.13 | Windows (Windows Server 2008 R2 Std) | x86 (64-bit AMD Opteron 6380) | group_replication fatal error, mysqld dies |
| 96244 | 2019-07-18 7:25 | 2025-12-07 20:45 | MySQL Server: Group Replication | No Feedback (2592 days) | S3 | 8.0.16 | Ubuntu (Ubuntu 18.04 in Digital Ocean) | Any | [GCS] The member was unable to join the group. Local port: 33061 |
| 96579 | 2019-08-18 19:59 | 2019-08-19 22:27 | MySQL Server: Errors | Not a Bug (2634 days) | S3 | 5.6/5.7/8.0 | Any | Any | Unexpected error message when using an outer reference in HAVING |
| 97293 | 2019-10-18 16:51 | 2019-11-20 16:46 | MySQL Server: Group Replication | Not a Bug (2541 days) | S2 | at least 8.0.16, 8.0.17 & 8.0.18 | Ubuntu (Ubuntu 18.04.2 LTS) | x86 (GNU/Linux 4.15.0 x86_64) | group replication plugin memory leak |
| 99274 | 2020-04-16 6:33 | 2020-05-05 12:41 | MySQL Server: Optimizer | Verified (2380 days) | S4 | 8.0.19 | Linux | Any | Resource Groups are not usable inside Container with CPU limited |
| 102433 | 2021-02-01 8:49 | 2025-01-31 16:08 | MySQL Server: Group Replication | Verified (2102 days) | S4 | 8.0 | Any | Any | Lightweigth group replication consensus member without the full database |
| 104117 | 2021-06-26 2:36 | 2021-06-26 2:39 | MySQL Server: Group Replication | Closed (1957 days) | S2 | mysql8.0.23 mysql8.0.24 | Any | Any | MGR all second node abnormal stop |
| 104118 | 2021-06-26 2:42 | 2022-08-23 8:45 | MySQL Server: Security: Privileges | Verified (1954 days) | S2 | 8.0.24 | Any | Any | MGR all second node abnormal stop |
| 107559 | 2022-06-14 8:45 | 2022-06-14 12:23 | MySQL Server: Optimizer | Not a Bug (1604 days) | S3 | Any | Any | Why Switch_ref_item_slice in TemptableAggregateIterator::Init | |
| 113404 | 2023-12-13 10:19 | 2023-12-13 11:47 | MySQL Server: Optimizer | Can't repeat (1057 days) | S4 | 8.0.22 | Any | Any | Loose Index Scan limitations |
| 113974 | 2024-02-13 9:05 | 2024-02-13 9:26 | MySQL Server: Group Replication | Verified (995 days) | S4 | 8.0 | Any | Any | improve GR error reporting |
| 118544 | 2025-06-27 14:18 | 2025-09-23 4:03 | MySQL Server: Optimizer | Verified (407 days) | S2 | 9.2.0 , 9.3.0 | Linux | Any | A potential join operator bug |
| 120908 | 2026-07-13 10:50 | 2026-07-20 11:16 | MySQL Server: Optimizer | Verified (113 days) | S1 | 9.1 | Any | Any | DISTINCTROW with GROUP BY in Derived Table Loses Rows Due to Incomplete Duplicate Removal Key |
| 3587 | 2004-04-28 12:30 | 2004-05-02 18:14 | MySQL Server | Closed (8221 days) | S2 | 5.0.0alpha | Windows (WinXP) | Any | Server crushes after executing query with connecting two subquery on two fields |
| 3686 | 2004-05-07 12:24 | 2004-05-12 16:18 | MySQL Server | Closed (8211 days) | S3 | 4.1.2 | Any | prepared statement, union + group by, inconsistent behaviour during prepare | |
| 4885 | 2004-08-04 2:16 | 2011-02-16 23:42 | MySQL Server: Optimizer | No Feedback (6484 days) | S4 | 4.1.3 | Windows (windows) | Any | combining subqueries with group by |
| 7733 | 2005-01-07 16:36 | 2005-01-07 23:09 | MySQL Cluster: Cluster (NDB) storage engine | Not a Bug (7971 days) | S3 | 4.1.9 | Linux (Fedora Core 1) | Any | [mysql_cluster] section connect-string confusion |
| 9210 | 2005-03-15 22:14 | 2005-04-20 1:44 | MySQL Server: Optimizer | Closed (7868 days) | S3 | 5.0 | Linux (SuSE Linux 9.1) | Any | Server crash with a simple query with GROUP BY |
| 9401 | 2005-03-25 9:04 | 2005-04-07 2:05 | MySQL Server | Closed (7881 days) | S3 | 4.1 | Linux (linux) | Any | type_timestamp segfaults mysqld |
| 10815 | 2005-05-24 7:36 | 2012-03-26 19:34 | MySQL Server: Optimizer | Closed (5336 days) | S2 | 4.1.12 | Linux (Linux) | Any | Sub-queries failure when using GROUP BY |
| 11704 | 2005-07-02 18:52 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5981 days) | S2 | 5.0.9, 4.1 | Linux (Linux/x86) | Any | Found locks from different threads in write -> crash with OPTIMIZE table? |
| 12885 | 2005-08-30 16:05 | 2005-09-15 19:12 | MySQL Server: Optimizer | Closed (7720 days) | S3 | 4.1.14, 5.0.11 | FreeBSD (freebsd, Windows) | Any | rollup / subquery and creat table, causes incorrect cannot be null |
| 15198 | 2005-11-23 19:58 | 2006-03-24 7:52 | MySQL Server: Optimizer | Not a Bug (7530 days) | S3 | 5.0.16-nt | Windows (Windows 2000) | Any | Dropping then adding an index changes group by optimization behaviour |
| 15643 | 2005-12-09 18:42 | 2006-09-06 19:12 | MySQL Server: Documentation | Closed (7364 days) | S2 | 5.0.15/5.0.18 BK/5.0.22 | Any (All) | Any | Can't group on calculated field aliased as other field |
| 17157 | 2006-02-06 14:53 | 2006-03-08 2:22 | MySQL Server: Installing | Closed (7546 days) | S3 | 5.0.17a-cert | Solaris (Solaris10) | Any | pkg install on Solaris doesn't reject a user 'mysql' in group 'mysql2' |
| 19136 | 2006-04-17 9:23 | 2006-05-13 4:45 | MySQL Server: Replication | Closed (7480 days) | S2 | 4.1.18,5.0.19, 5.0.20, 5.0-bk | Linux (RHEL4, Windows) | Any | Crashing log-bin and uninitialized user variables in a derived table |
| 19883 | 2006-05-17 13:58 | 2006-08-16 8:49 | MySQL Cluster: Disk Data | Can't repeat (7385 days) | S1 | 5.1 | Linux (Linux) | Any | ndbd seg fault with gcc 4.0.2 |
| 20052 | 2006-05-24 19:15 | 2012-05-18 20:19 | MySQL Cluster: Disk Data | Duplicate (7461 days) | S3 | 5.1.12 | Linux (Linux 32 Bit OS) | Any | Failure of CREATE TABLE SPACE should rollback TS name from cluster db |
| 22228 | 2006-09-11 5:23 | 2006-09-14 12:28 | MySQL Server | Can't repeat (7356 days) | S1 | 5.0.x | Linux (Linux) | Any | Group by with join, view and concat gives wrong answer |
| 23462 | 2006-10-19 13:42 | 2007-06-14 14:21 | MySQL Server | Not a Bug (7083 days) | S3 | mysql 5.0 | Any | Any | Group BY and MAX not selecting MAX result |
| 27885 | 2007-04-17 15:13 | 2025-12-07 20:45 | MySQL Server: Command-line Clients | Verified (6909 days) | S3 | 5.0.38 | Any | Any | command line clients puke on 'init-command' in my.cnf |
| 31798 | 2007-10-23 19:47 | 2007-10-23 20:49 | MySQL Server: Optimizer | Not a Bug (6952 days) | S3 | 5.0.45 | Linux (Debian) | Any | LEFT JOIN query with COUNT() and GROUP BY produces wrong result |
| 34751 | 2008-02-21 22:19 | 2018-02-08 22:42 | MySQL Server: DML | Closed (3191 days) | S3 | 5.0+ | Any | Any | Inside HAVING clause subqueries with aggregates and without GROUP BY rise error |
| 40094 | 2008-10-16 22:59 | 2009-02-04 10:29 | MySQL Server: DDL | Not a Bug (6482 days) | S4 | 5.1 | Linux | Any | Allow group read/write/execute at filesystem on database create |
| 42116 | 2009-01-14 15:35 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (6165 days) | S1 | 5.0.68 entreprise/5.1 | Linux (RHEL 5 x86_64) | Any | Mysql crash on specific query |
| 42322 | 2009-01-24 15:46 | 2009-01-24 15:56 | MySQL Server | Not a Bug (6493 days) | S2 | 5.1.30 | Windows (SP3) | Any | 5.1.30-community allows mixing of group and no group columns without group by |
| 45267 | 2009-06-02 13:01 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5826 days) | S3 | 5.4 | Any | Any | GROUP BY does not group NULLs on certain JOINs |
| 45809 | 2009-06-28 15:18 | 2011-02-16 23:44 | MySQL Server: Documentation | Closed (6283 days) | S3 | 5.1.35-community,5.1.36-community | Windows (XP Pro) | Any | Use "COUNT()" without "GROUP BY" has no error message |
| 48703 | 2009-11-11 21:58 | 2022-09-04 20:45 | MySQL Server: Optimizer | In progress (5994 days) | S3 | 5.0+ | Any | Any | nontrivial ORDER/GROUP BY expressions: ambiguous statements not detected |
| 49111 | 2009-11-25 20:11 | 2012-08-30 14:32 | MySQL Server: Optimizer | Closed (5179 days) | S3 | 5.5.0-beta, 5.1 | Any | Any | Change in execution plan for count_distinct_group_on_key causes peformance drop |
| 51017 | 2010-02-09 9:07 | 2010-02-13 19:12 | MySQL Server: Optimizer | Not a Bug (6108 days) | S3 | 6.0-codebase-bugfixing | Any | Any | Batched key access gives wrong results for SELECT with LEFT JOIN, GROUP BY |
| 54481 | 2010-06-14 11:10 | 2012-10-15 13:43 | MySQL Server: Optimizer | Closed (5133 days) | S2 | 5.1-bzr, 5.6.99-m4, mysql-next-mr-opt-backporting | Any | Any | GROUP BY loses effect with JOIN + ORDER BY + LIMIT and join caching |
| 58782 | 2010-12-07 10:46 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5774 days) | S3 | bzr_WL1393 | Any | Any | Missing rows with SELECT .. WHERE .. IN subquery with full GROUP BY and no aggr |
| 78349 | 2015-09-06 12:12 | 2015-12-03 14:22 | MySQL Server: DML | Closed (3989 days) | S3 | 5.6.22, 5.6.26 | Any | Any | w/ ONLY_FULL_GROUP_BY, having/order by + column alias have different results |
| 78402 | 2015-09-11 2:23 | 2015-09-11 4:15 | MySQL Server: Parser | Duplicate (4072 days) | S3 | 5.6.22 | Any | Any | GROUP BY with expression fails (should succeed) |
| 78424 | 2015-09-14 2:29 | 2015-09-14 10:50 | MySQL Server: DML | Can't repeat (4069 days) | S3 | 5.7.7 | Any | Any | w/ c1&&c2 appears in select list, group by clause and order by clause, SQL fails |
| 78785 | 2015-10-09 12:54 | 2017-10-24 14:32 | MySQL Server: Optimizer | Closed (3423 days) | S3 | 5.7.9 | Any | Any | Grouping on aggregated results not always rejected |
| 79875 | 2016-01-08 2:05 | 2016-02-20 1:00 | MySQL Enterprise Monitor | No Feedback (3911 days) | S3 | 3.1.1.7806 | CentOS | Any | one random server missing from group while assigning assets in event handler |
| 80726 | 2016-03-14 10:49 | 2016-11-19 16:27 | MySQL Server: Optimizer | Closed (3640 days) | S3 | 5.7 | Any | Any | GROUP BY on derived table, expression of aggregate and group column: error |
| 81760 | 2016-06-07 20:27 | 2016-08-09 14:52 | MySQL Cluster: Cluster (NDB) storage engine | Closed (3796 days) | S3 | 7.5.2 | Any | Any | Rename RealFragment to Partition in Ndb kernel code. |
| 87300 | 2017-08-03 10:18 | 2017-11-09 11:24 | Shell General / Core Client | Closed (3282 days) | S2 | mysqlsh Ver 1.0.10 for Linux on x86_64 | Any | Any | mysql-shell dba.checkInstanceConfiguration() |
| 87670 | 2017-09-05 9:32 | 2017-09-06 7:54 | MySQL Server: Optimizer | Verified (3346 days) | S3 | 5.7.18, 5.6.37, 5.7.19 | Any | Any | Force index for group by is not always honored |
| 89147 | 2018-01-08 22:18 | 2018-01-11 9:52 | MySQL Server: Group Replication | Verified (3219 days) | S4 | 5.7.20,8.0.3 | Any | Any | The field end_log_pos in Group Replication error messages is ambiguous. |
| 91870 | 2018-08-02 11:33 | 2019-01-22 14:00 | MySQL Server: Group Replication | Closed (2884 days) | S3 | 8.0.13 | Any | Any | ALL MEMBERS ARE EXITED FROM GR WHEN 1/4 NODE TRIED TO REJOIN AFTER network drop |
| 99592 | 2020-05-15 15:23 | 2020-05-18 4:37 | MySQL Server: DML | Duplicate (2361 days) | S3 | 8.0.20 | Ubuntu | Any | GROUP BY includes wrong data |
| 99778 | 2020-06-04 12:27 | 2020-07-02 14:12 | MySQL Server: Group Replication | Closed (2316 days) | S2 | 8.0.18 | Any | Any | Error when processing certification information in the incremental recovery proc |
| 100107 | 2020-07-03 16:57 | 2021-03-16 18:03 | MySQL Server: DML | Closed (2303 days) | S3 | 8.0.20 | MacOS | Any | MySQL 8.0.20 Bug? Groups duplicated when using GROUP BY and COUNT(DISTINCT ) |
| 100881 | 2020-09-17 18:08 | 2020-09-18 10:44 | MySQL Server: Group Replication | Can't repeat (2238 days) | S2 | 8.0.17 | SUSE (15 SP01) | x86 (x86_64) | [ERROR] [MY-010584] [Repl] Error executing row event: Error_code: MY-001146 |
| 101391 | 2020-10-30 3:04 | 2020-11-19 16:59 | MySQL Server: Performance Schema | Verified (2176 days) | S5 | 8.0, 8.0.22 | Any | Any | Performance Schema storage engine doesn't use index optimizations on group by |
| 102945 | 2021-03-12 8:04 | 2021-09-06 6:58 | MySQL Server: Replication | Verified (2046 days) | S3 | mysql.5.7 | Any | Any | MTS fail due to ignore stop event when logical timestamp reset on new binary fil |
| 103251 | 2021-04-08 14:09 | 2021-04-13 20:04 | MySQL Server: Clone Plugin | Verified (2036 days) | S4 | 8.0.22 | Ubuntu (18.04.5 LTS) | ARM (aarch64) | Allow cross-platform clone |
| 103766 | 2021-05-21 11:35 | 2022-03-16 11:36 | MySQL Server: Documentation | Verified (1993 days) | S4 | 8.0 | Any | Any | please document external (network) protocol used by group replication |
| 108417 | 2022-09-07 15:27 | 2022-09-20 11:26 | MySQL Server: Group Replication | Not a Bug (1506 days) | S3 | 8.0.30 | Any | Any | Innodb cluster failed after primary removed |
| 110888 | 2023-05-02 18:51 | 2023-07-31 15:35 | MySQL Server: Documentation | Closed (1192 days) | S3 | 8.0.31 | Any | Any | checkInstanceConfiguration and docs disagree on binlog_transaction_dependency_tr |
| 112193 | 2023-08-28 3:07 | 2023-10-10 11:02 | MySQL Cluster: plugin | Can't repeat (1121 days) | S3 | 5.7 | Any | Any | All nodes elected as PRIMARY |
| 113236 | 2023-11-27 17:22 | 2024-02-03 15:05 | MySQL Server: Row Based Replication ( RBR ) | Verified (1072 days) | S3 | 8.0.35-0ubuntu0.22.04.1 | Ubuntu (22.04.3 LTS 5.15.0-88-generic) | x86 (.) | conflicting replica_parallel_workers spec causes parallel_mode misconfig |
| 114248 | 2024-03-06 16:22 | 2024-03-07 14:05 | MySQL Server: InnoDB storage engine | Verified (972 days) | S3 | 8.0.36, 5.7.44 | Any | Any | Incomplete query results when backward scan and concurrent page merge |
| 115087 | 2024-05-23 3:10 | 2024-05-24 10:54 | MySQL Server: Group Replication | Verified (895 days) | S3 | 8.0.36 | Any | Any | SSL connection server_capabilities has overflow |
| 116245 | 2024-09-26 15:23 | 2025-12-07 20:45 | MySQL Server: Group Replication | No Feedback (735 days) | S2 | 8.0.36 | Red Hat ( 4.18.0-553.8.1.el8_10.x86_64) | x86 | innodb cluster / GR error after import w/ has_generated_invisible_primary_key=0 |
| 118704 | 2025-07-23 7:32 | 2025-08-06 5:43 | MySQL Server: Group Replication | Can't repeat (455 days) | S3 | 8.0.43 | Oracle Linux (redhat7.x) | x86 | When a network anomaly occurs, the MGR (MySQL Group Replication) cluster remains in the UNREACHABLE state for an extende |
| 120785 | 2026-06-26 4:17 | 2026-06-26 9:20 | MySQL Server: Optimizer | Duplicate (131 days) | S1 | MySQL 9.6 | Any | Any | Temporary Table Deduplication Uses Binary Comparison for FLOAT -0 and +0, Incorrectly Treating Them as Distinct Values |
| 1739 | 2003-11-03 2:18 | 2003-11-18 3:22 | MySQL Server | Won't fix (8387 days) | S3 | 4.0.16 | FreeBSD (FreeBSD 4.8) | Any | Strange results when using @vars with GROUP BY |
| 2713 | 2004-02-11 13:33 | 2004-02-23 7:05 | MySQL Server | Can't repeat (8290 days) | S2 | 4.1.1 | Solaris (Solaris 2.8) | Any | SELECT on derived table with no outer GROUP BY causes sig11 |
| 4460 | 2004-07-08 13:41 | 2020-01-14 20:31 | MySQL Server: Optimizer | Closed (2486 days) | S4 | 4.1.3 Beta | Windows (Win2k/linux/AIX) | Any | Query having subqueries (having group by clause) take too much of time |
| 5478 | 2004-09-08 16:07 | 2004-11-24 18:15 | MySQL Server | Not a Bug (8015 days) | S3 | 4.1.3 beta | Linux (Linux (2.4.x) (Mandrake 9.2)) | Any | order by sum(xxx) fails but order by N on selected sum(xxx) works |
| 7596 | 2004-12-30 21:51 | 2004-12-31 1:47 | MySQL Server: MyISAM storage engine | Not a Bug (7978 days) | S1 | 4.1.8nt | Windows (Win2k) | Any | group by function returning diverse column values for a row in a group |
| 10722 | 2005-05-18 22:05 | 2007-02-19 23:07 | MySQL Server: Optimizer | Closed (7198 days) | S5 | 4.1.11 | Linux (linux) | Any | SELECT .. MAX(t1.b) .. GROUP BY t2.a .. ORDER BY t1.b should not use filesort |
| 10984 | 2005-05-31 14:11 | 2005-07-19 12:37 | MySQL Server: Installing | Closed (7778 days) | S3 | 4.0.20-0 | Linux (CentOS 3.4) | Any | install fails if group mysql exists but not user |
| 20293 | 2006-06-06 13:12 | 2007-03-15 3:10 | MySQL Server | Closed (7174 days) | S2 | 4.1-BK, 5.0-BK, 4.1.20 and 5.0.22 | Any (*) | Any | group by cuts off value from time_format |
| 22881 | 2006-10-02 8:43 | 2006-10-24 9:05 | MySQL Cluster: Disk Data | Not a Bug (7316 days) | S3 | 5.1.11 | Linux (ubuntu dapper drake linux) | Any | CREATE LOGFILE GROUP ADD UNDOFILE incompatible with local datanodes |
| 23417 | 2006-10-18 10:04 | 2007-02-13 19:03 | MySQL Server | Closed (7204 days) | S3 | 5.0.27-BK, 5.0.24a | Linux (Linux, opensuse 10.0) | Any | (ONLY_FULL_GROUP_BY) function of aggregate is still an aggregate [S3/S2] |
| 24156 | 2006-11-09 21:59 | 2006-12-14 4:26 | MySQL Server: Optimizer | Closed (7265 days) | S5 | 5.0.30-BK, 5.0.28 | Linux (Linux, Mac OS X) | Any | Loose index scan not used with CREATE TABLE ...SELECT and similar statements |
| 24838 | 2006-12-05 20:59 | 2006-12-05 21:27 | MySQL Server | Not a Bug (7274 days) | S3 | 5.0.22-standard | Linux (linux) | Any | group by compares strings case-insensitively |
| 24860 | 2006-12-06 18:17 | 2007-11-28 19:03 | MySQL Server: Replication | Closed (6916 days) | S3 | 5.1.12 | Any | Any | Incorrect SLAVE_TRANSACTION_RETRIES code can result in slave stuck |
| 28449 | 2007-05-15 15:50 | 2007-06-14 19:26 | MySQL Server: General | Closed (7083 days) | S2 | 5.0, 5.1.19 | Any | Any | Server crashes on closing a temporary table after SELECT ... GROUP BY |
| 29360 | 2007-06-26 13:49 | 2007-07-27 4:52 | MySQL Server | Closed (7040 days) | S3 | 4.1, 5.0, 5.1 | Any | Any | SELECT aggregate function GROUP BY enum returns incorrect result |
| 29421 | 2007-06-28 13:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (7069 days) | S2 | 5.1.14-beta/5.0 | Any | Any | MySQL allows mixing of GROUP columns with no GROUP columns in complex terms |
| 30039 | 2007-07-25 13:35 | 2011-02-16 23:43 | MySQL Server: DML | Verified (7042 days) | S4 | Any | Any | Add "Using group-by" to Extra column in EXPLAIN output | |
| 30612 | 2007-08-24 0:42 | 2008-07-24 12:54 | MySQL Enterprise Monitor: Web | Closed (6677 days) | S3 | 1.2.0.7214 | Any | Any | Rename "remove all from group" to "delete group" |
| 30953 | 2007-09-11 13:05 | 2007-10-29 12:10 | MySQL Server: Data Types | Not a Bug (6946 days) | S3 | 6.0.2-alpha, 5.0.48 | Windows (XP 64-bit) | Any | suspicious results from LOG(B,X) functions |
| 31559 | 2007-10-12 9:23 | 2018-09-25 21:45 | MySQL Server: Tests | Closed (6963 days) | S7 | 5.0.50 | Any | Any | "group by" changed the implicit ordering |
| 33170 | 2007-12-12 15:45 | 2008-07-30 13:14 | MySQL Server: Documentation | Closed (6671 days) | S3 | 6.0.5 | Any | Any | New CREATE TABLESPACE behavoir with Falcon |
| 33391 | 2007-12-20 5:38 | 2008-01-20 11:38 | MySQL Server: Parser | No Feedback (6863 days) | S2 | Mysql 5.0.45 | Linux | Any | INSERT into table SELECT fields from table2 giving inconsistent/corrupt data |
| 33417 | 2007-12-20 19:38 | 2011-02-16 23:43 | MySQL Server: General | No Feedback (6205 days) | S3 | 5.0.46, 5.0.52 | Windows | Any | group by 3 columns with MAX() produces incorrect results |
| 33555 | 2007-12-28 15:00 | 2008-10-10 13:09 | MySQL Server: Partitions | Closed (6599 days) | S2 | 5.1.26RC | Linux (CENTOS5.2) | Any | Group By Query does not correctly aggregate partitions |
| 34102 | 2008-01-28 12:53 | 2011-02-16 23:43 | MySQL Cluster: Disk Data | Closed (6467 days) | S3 | 5.1.23 ndb 6.3.7; ndb 6.3.13 | Linux | Any | Creating LOGFILE group crashes cluster |
| 35628 | 2008-03-28 1:41 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (6575 days) | S3 | 5.0.52 | Any | Any | 5.0.52+ undocumented incompatible change in default GROUP BY behavior |
| 37344 | 2008-06-11 13:59 | 2008-09-30 20:08 | MySQL Server: Falcon storage engine | Closed (6609 days) | S1 | 6.0-falcon | Any | Any | Crash in IndexWalker::rebalanceDelete |
| 37362 | 2008-06-12 11:30 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (6302 days) | S1 | 6.0-falcon, 5.0, 5.1, 6.0 bzr | Any | Any | Crash in do_field_eq |
| 45504 | 2009-06-15 15:11 | 2016-01-20 15:47 | MySQL Enterprise Monitor: Web | Closed (3941 days) | S4 | 2.1.0.1060 | Any | Any | Support batch add-to-group on Manager servers' tab |
| 45940 | 2009-07-03 14:58 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (6309 days) | S3 | 5.1+ | Any | Any | issues around rli->last_event_start_time |
| 46328 | 2009-07-21 20:54 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5826 days) | S3 | 6.0 | Any | Any | Use of aggregate function without GROUP BY clause returns many rows (vs. one ) |
| 48089 | 2009-10-15 15:41 | 2021-05-02 20:45 | MySQL Cluster: Disk Data | In progress (6083 days) | S3 | mysql-5.1-telco-7.0 | Any | Any | Can't change UNDO_BUFFER_SIZE with ALTER LOGFILE GROUP ... |
| 48472 | 2009-11-02 13:39 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (6081 days) | S3 | 5.0.88, 5.1.41 | Any | Any | Loose index scan inappropriately chosen for some WHERE conditions |
| 58218 | 2010-11-16 7:23 | 2011-02-16 23:44 | Connector / NET | Duplicate (5832 days) | S1 | 6.3.4 | Any | Any | "Key" groupped by cannot be used in linq2e, group by subquery cannot be executed |
| 60315 | 2011-03-03 14:03 | 2013-01-15 14:40 | MySQL Server: Optimizer | Not a Bug (5041 days) | S5 | 5.1.51, 5.5.8 | Linux | Any | Slow ORDER BY function() if using GROUP BY |
| 64855 | 2012-04-03 14:53 | 2012-05-16 13:20 | MySQL Server: Stored Routines | Verified (5285 days) | S2 | 5.5.21, 5.6.5-m8, 5.1.64, 5.6.6, 5.5.25, 5.5.20-ndb-7.2.5 | Any | Any | Stored Procedure with GROUP/ORDER BY return unpredicatable results with CASE/IF |
| 65798 | 2012-07-03 15:16 | 2012-11-14 20:54 | MySQL Server: DML | Closed (5103 days) | S3 | 5.5.26 | Any | Any | ONLY_FULL_GROUP_BY documentation doesn't mention implicit group by |
| 66045 | 2012-07-27 10:28 | 2012-08-28 1:00 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (5182 days) | S2 | 5.5.22-ndb-7.2.6 | Other (debian 5 (2.6.26-2-amd64)) | Any | 5.5.22-ndb-7.2.6 CREATE LOGFILE GROUP failed |
| 67821 | 2012-12-05 22:37 | 2013-01-07 1:00 | MySQL Server: DML | No Feedback (5050 days) | S3 | 5.5.28 | Windows (7 Ultimate 64bit) | Any | GROUP BY not working in stored procedure |
| 68079 | 2013-01-14 12:01 | 2014-02-28 6:40 | MySQL Server: InnoDB storage engine | Closed (4675 days) | S2 | 5.5.29, 5.6.9-rc | Linux (x86_64) | Any | InnoDB does not scale well on 12 core system for specific all in memory SELECT |
| 71125 | 2013-12-11 8:38 | 2013-12-13 1:54 | MySQL Fabric | Closed (4709 days) | S3 | 1.4.0 | Any | Any | A server must belong to a single group |
| 71149 | 2013-12-16 9:37 | 2014-08-06 17:44 | MySQL Server: Optimizer | Closed (4544 days) | S3 | 5.6.15, 5.7.3-m13 | Any | Any | Assertion `((Item_result_field*)item)->result_field' fails in create_tmp_field |
| 71762 | 2014-02-18 15:51 | 2014-02-26 9:49 | MySQL Enterprise Monitor: Installing | Verified (4634 days) | S4 | 3.0.6 | Any | Any | Allow the agent installer to hint at the replication group name |
| 71891 | 2014-02-28 20:27 | 2014-03-05 20:37 | MySQL Server: Optimizer | Not a Bug (4627 days) | S3 | 5.6.15 | Any | Any | GROUP BY performance differs wildly for tautologically equal columns |
| 72003 | 2014-03-11 7:55 | 2014-03-11 11:04 | MySQL Server | Can't repeat (4621 days) | S1 | 5.6.12 | Linux (openSuse 13.1) | Any | Query fails JOIN in case of use of GROUP BY |
| 74646 | 2014-10-31 9:51 | 2014-10-31 10:27 | MySQL Server: DML | Verified (4387 days) | S3 | 5.6.20-debug, 5.6.22, 5.7.6 | Linux (CentOS 7) | Any | Assertion `((Item_result_field*)item)->result_field' failed in create_tmp_field |
| 74695 | 2014-11-05 5:25 | 2017-08-14 1:50 | MySQL Server: DML | Closed (4175 days) | S3 | 5.6.20-debug, 5.6.22, 5.7.6 | Linux (CentOS 7) | Any | Asser tion `args[0]->fixed' failed | sig 6 abort in sql/item_strfunc.h:882 |
| 75188 | 2014-12-12 2:47 | 2017-07-06 19:19 | MySQL Fabric | Won't fix (4342 days) | S3 | 1.5.3 | Linux (3.10.0-123.el7.x86_64) | Any | MySQLFabric doesn't work properly with Application User that has SUPER privilege |
| 76319 | 2015-03-13 19:36 | 2017-07-06 19:19 | MySQL Fabric | Won't fix (4251 days) | S4 | 1.5 | Any | Any | MySQL Fabric Service - Monitoring from external monitoring software |
| 78600 | 2015-09-28 9:44 | 2015-12-11 15:22 | MySQL Server: Group Replication | No Feedback (3981 days) | S1 | 0.5.0-dmr | Ubuntu (14.04) | Any | Compiling group replication plugin will fail because of boost_1_58_0 package |
| 80241 | 2016-02-02 19:35 | 2016-08-02 19:31 | MySQL Server: Group Replication | Closed (3746 days) | S3 | 0.7.0-labs | CentOS (el7-x86-64bit) | Any | Starting group replication causes MySQL to crash with sig 6 with selinux |
| 81494 | 2016-05-19 3:22 | 2019-05-16 16:45 | MySQL Server: mysqldump Command-line Client | Closed (2729 days) | S4 | 5.7.10, 5.7.17 | Any | Any | mysqldump can't get all databases backup with Group Replication |
| 83142 | 2016-09-25 18:38 | 2017-02-11 14:38 | MySQL Server: Documentation | Closed (3553 days) | S3 | 5.7.15 | Any | Any | Documentation clarifications about how default option files are used |
| 83239 | 2016-10-02 4:16 | 2016-10-06 21:28 | MySQL Server: Optimizer | Not a Bug (3681 days) | S3 | 5.7.15-0ubuntu0.16.04.1 | Ubuntu (16.04) | Any | Inconsistent nonaggregated field in SELECT not in GROUP BY |
| 84008 | 2016-11-29 18:24 | 2017-11-08 10:21 | MySQL Server: Group Replication | Closed (3505 days) | S3 | 8.0.1 | Any | Any | GR+MTS: ER1755 can be improved for MTS LC -> MTS DATABASE |
| 85164 | 2017-02-24 9:31 | 2017-11-08 10:22 | MySQL Server: Group Replication | Closed (3334 days) | S3 | 5.7.18 | Any | Any | GR SHOULD BLOCK OPERATIONS ON NON-COMPLAINT TABLES IN GR+ASYNC SETUP |
| 86475 | 2017-05-26 10:51 | 2017-08-16 18:12 | MySQL Server: Optimizer | Verified (3445 days) | S4 | 5.7.18 | Any | Any | Error with functions and group by with ONLY_FULL_GROUP_BY |
| 86956 | 2017-07-05 12:04 | 2017-08-25 10:48 | MySQL Server: Group Replication | Verified (3408 days) | S3 | 5.7.18 | Any | Any | Joining group timeout on permissions error |
| 88717 | 2017-11-30 14:10 | 2019-02-15 15:08 | MySQL Server: Documentation | Closed (2819 days) | S3 | 5.7.19 | Any | Any | MySQL Group Replication Large Transactions Limit |
| 89141 | 2018-01-08 22:07 | 2018-04-11 16:23 | MySQL Server: Group Replication | Duplicate (3129 days) | S2 | 5.7.20,8.0.3 | Any | Any | Error in Group Replication caused by bad Write Set tracking. |
| 89148 | 2018-01-08 22:23 | 2019-06-04 1:24 | MySQL Server: Group Replication | Verified (3187 days) | S4 | 5.7.20 and 8.0.3 | Any | Any | The timestamp of the GITD events in the GR relay log look wrong. |
| 89404 | 2018-01-25 11:51 | 2021-06-23 19:40 | MySQL Server: Group Replication | Verified (3204 days) | S4 | 8.0.4 | Any | Any | inconsistent support of CIDR or subnet notation |
| 90217 | 2018-03-26 15:07 | 2019-01-08 15:13 | MySQL Server: Group Replication | Closed (2857 days) | S1 | 8.0 | Any | Any | Add IPv6 support for Group Replication |
| 90534 | 2018-04-20 13:58 | 2023-09-12 10:45 | MySQL Server: Group Replication | Can't repeat (1149 days) | S1 | 8.0.11, 8.0.12 | MacOS (10.12.6) | x86 | InnoDB Cluster members stop by failed start of Group Replication |
| 91096 | 2018-05-31 20:35 | 2018-07-02 1:00 | MySQL Server | No Feedback (3048 days) | S2 | 5.7.15 | CentOS (CentOS Linux release 7.4.1708 (Core)) | Any | Binlog dump blocking thread pool group |
| 94004 | 2019-01-22 15:37 | 2019-02-19 12:17 | MySQL Server: Group Replication | Closed (2837 days) | S2 | 8.0.14 | Debian (Stretch) | x86 (amd64) | Cannot setup replication without ipv6 since 8.0.14 |
| 94429 | 2019-02-21 18:00 | 2019-07-25 8:36 | MySQL Server: Group Replication | Closed (2794 days) | S3 | 5.7.26 | Any | Any | MySQL 5.7 lowest member version join check should be with group lowest |
| 95068 | 2019-04-20 4:22 | 2019-06-26 15:04 | MySQL Server: Group Replication | Closed (2688 days) | S4 | 8.0.15 | Any | Any | Group Replication does not support SSL wildcard certificates |
| 97476 | 2019-11-04 17:06 | 2020-01-19 20:27 | MySQL Server: Optimizer | Closed (2481 days) | S3 | 8.0.16, 8.0.17, 8.0.18 | MacOS (Catalina 10.15) | x86 | Range optimizer skips rows |
| 98524 | 2020-02-09 2:47 | 2023-09-12 10:51 | MySQL Server: Group Replication | Can't repeat (1149 days) | S3 | 8.0.19 | CentOS | x86 | ERROR 3096 (HY000): The START GROUP_REPLICATION command failed as there was an e |
| 100333 | 2020-07-27 13:57 | 2022-11-14 19:45 | MySQL Server: Pluggable Authentication | Closed (1451 days) | S3 | 8.0.21 | Linux (n.a.) | x86 (n.a.) | LDAP plugin error message confusing |
| 100764 | 2020-09-08 8:50 | 2025-09-28 20:45 | MySQL Server: Optimizer | No Feedback (2211 days) | S1 | 8.0 | Any | Any | Rename Table causes other SQL execution plans to change. |
| 100925 | 2020-09-23 9:02 | 2020-09-24 17:49 | MySQL Server: Group Replication | Closed (2232 days) | S2 | 8.0.20, 8.0.21 | Ubuntu | Any | The Mgr parameter does not match the description in the official MySQL document |
| 102075 | 2020-12-26 9:25 | 2020-12-28 15:01 | MySQL Server: Group Replication | Duplicate (2137 days) | S2 | 5.7.29 | CentOS (CentOS Linux release 7.5.1804 (Core) ) | x86 (Intel(R) Xeon(R) CPU E5-2640 v4 @ 2.40GHz) | network and server is ok, but GR node been unreachable |
| 102706 | 2021-02-23 15:02 | 2021-03-13 23:18 | MySQL Server: Documentation | Closed (2062 days) | S3 | 8.0.21, 8.0.23 | Any | Any | Update group replication docs replication configuration requirements |
| 103039 | 2021-03-18 14:49 | 2021-03-26 11:34 | MySQL Server: Optimizer | Verified (2049 days) | S5 | 8.0.23, 5.7.33 | CentOS (8.2.2004) | Any | Query with group by not showing that it is using the index for the group by |
| 104646 | 2021-08-17 15:24 | 2025-12-07 20:45 | MySQL Server: Group Replication | No Feedback (1861 days) | S2 | 8.0.26 | Debian (10.10) | x86 | InnoDB group replication stalled on large transaction and high network bandwidth |
| 104677 | 2021-08-20 12:04 | 2025-12-07 20:45 | MySQL Server: Group Replication | No Feedback (1868 days) | S3 | 8.0.23 | Debian | Any | Old joiner blocked for a long time in the failure recovery(Local recovery phase) |
| 106430 | 2022-02-10 8:41 | 2022-02-17 14:31 | MySQL Server: Group Replication | Can't repeat (1721 days) | S3 | Any (OKD) | x86 | Timeout on wait for view after joining group | |
| 107460 | 2022-06-02 8:07 | 2023-08-29 9:41 | MySQL Server: Optimizer | Closed (1163 days) | S2 | 8.0 | Any | Any | SKIP SCAN result wrong |
| 107635 | 2022-06-22 14:47 | 2022-07-20 15:43 | MySQL Server: Group Replication | Closed (1573 days) | S1 | 8.0.* | Any | Any | event scheduler cause error on group replication |
| 109034 | 2022-11-09 4:15 | 2026-06-10 19:48 | MySQL Server: Logging | Verified (1451 days) | S4 | 8.0 | Any | Any | Slow log Rows_examined value is inaccurate |
| 109580 | 2023-01-11 8:02 | 2023-01-11 15:23 | MySQL Server: Group Replication | Not a Bug (1393 days) | S3 | 5.7.40 | Any | Any | Timeout on wait for view after joining group |
| 109615 | 2023-01-13 7:14 | 2023-01-17 19:05 | MySQL Server: Group Replication | Not a Bug (1387 days) | S3 | 5.7.40 | Any | Any | Timeout on wait for view after joining group |
| 110092 | 2023-02-16 6:43 | 2023-02-23 13:17 | MySQL Server | Not a Bug (1350 days) | S3 | 5.7.34-log | CentOS (CentOS Linux release 7.6.1810 (Core)) | Any | unique key has duplicate data. |
| 110175 | 2023-02-23 3:48 | 2023-02-23 14:23 | MySQL Server | Duplicate (1350 days) | S3 | 5.7.34-log | CentOS (CentOS (CentOS Linux release 7.6.1810 (Core))) | Any | unique key has duplicate data for mysqludmp |
| 110773 | 2023-04-23 7:56 | 2026-09-18 9:55 | MySQL Server: Group Replication | Closed (47 days) | S3 | mysql 8.0.32 | Any | Any | group_replication start faild use different ips and same port on same server |
| 112368 | 2023-09-17 14:39 | 2023-09-21 2:29 | MySQL Server: Group Replication | Can't repeat (1140 days) | S1 | 5.7.36 | Debian (Debian GNU/Linux 10 (buster)) | Any | Mismatched SQL for the same GTID transaction across primary and secondary |
| 112967 | 2023-11-06 1:07 | 2025-12-07 20:45 | MySQL Server: Group Replication | No Feedback (1064 days) | S2 | 8.0.28 | Debian (Debian GNU/Linux 10 (buster)) | x86 | Crash when a member is immediately reconnected after disconnection |
| 115033 | 2024-05-16 9:12 | 2024-07-19 14:43 | Shell Dump & Load | Closed (838 days) | S3 | 8.0.37 | Red Hat (4.18.0-513.24.1.el8_9.x86_64) | x86 | Running util.debug.collectDiagnostics w/ schemaStats:true get MySQL Error 1242 |
| 115679 | 2024-07-24 9:04 | 2024-07-24 9:46 | MySQL Server: Optimizer | Verified (833 days) | S5 | 8.0.37 | Any | Any | Block Nested-Loops Join can sometimes slow down the query |
| 117927 | 2025-04-10 6:25 | 2025-04-10 7:35 | MySQL Server: JSON | Verified (573 days) | S2 | 8.0.41, 8.4 | Any | Any | duplicate key in table while using tmp table for group by a json data |
| 119584 | 2025-12-22 16:09 | 2026-11-04 6:10 | MySQL Server: Optimizer | Verified (317 days) | S3 | 8.0.44 | Any | Any | The HAVING clause cannot recognize alias columns defined by Boolean expressions in derived tables |
| 119674 | 2026-01-14 5:25 | 2026-01-14 8:45 | MySQL Server: Group Replication | Open (294 days) | S3 | 9.2 | Any | Any | Doc: Group Replication “write set” definition is unclear/misleading (group-replication-summary) |
| 120215 | 2026-04-04 16:59 | 2026-04-06 5:38 | MySQL Server: Optimizer | Verified (212 days) | S3 | 9.6.0 | Ubuntu (22.04) | Any | Inconsistent window aggregate results with GROUP BY ... WITH ROLLUP |
| 120909 | 2026-07-13 11:05 | 2026-07-21 15:16 | MySQL Server: Optimizer | Verified (113 days) | S1 | 8.0.46, 8.4.10, 9.7.1 | Any | Any | ROLLUP Incorrectly Sets Base Group Row to NULL for Constant Folded Expression |
| 120970 | 2026-07-21 6:38 | 2026-07-21 17:36 | MySQL Server: Optimizer | Duplicate (106 days) | S1 | 9.7.1 | Any | Any | TempTable Engine Incorrectly Treats XOR Result Value 1 as NULL in GROUP BY, Merging Groups |
| 121028 | 2026-07-29 6:09 | 2026-07-31 11:49 | MySQL Server: Optimizer | Verified (96 days) | S2 | 9.7.1 | MacOS | ARM | Cardinality Check Granularity Error in subquery_to_derived |
| 121392 | 2026-09-29 8:00 | 2026-09-30 6:35 | MySQL Server: Optimizer | Verified (35 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Linux | Any | SELECT DISTINCT with a COLLATE-qualified WHERE predicate incorrectly drops matching rows when the optimizer uses an inde |
| 121612 | 2026-10-26 12:38 | 2026-10-27 7:27 | MySQL Server: Optimizer | Verified (8 days) | S2 | 8.0.46, 8.4.13, 9.7.4, 26.10 | Any (Docker container (mysql_dev), Linux x86_64) | Any | DISTINCT / GROUP BY over-evaluate NOT DETERMINISTIC side-effecting functions (N+1 / 2N+1 / 2N) |
| 121645 | 2026-11-01 8:12 | 2026-11-03 5:04 | MySQL Server: Optimizer | Verified (1 day) | S2 | 8.0.46, 8.4.13, 9.7.4, 26.10.0 | Any | Any | Wrong correlated COUNT result with a window function and redundant GROUP BY |
| 714 | 2003-06-24 14:11 | 2003-08-26 9:49 | MySQL Server | Closed (8471 days) | S2 | 4.1.1 | Linux (Linux) | Any | WITH ROLLUP crashes server |
| 1458 | 2003-10-01 13:47 | 2005-05-09 11:52 | MySQL Server | Won't fix (7849 days) | S4 | 4.0.13 | Any | configure options outside [group] works in 3.23.x but not 4.0.13 | |
| 2467 | 2004-01-21 1:56 | 2012-05-18 20:19 | MySQL Server | No Feedback (7667 days) | S4 | 4.0.17 | Any (All) | Any | Use of an alias in a 'group by function'? |
| 2968 | 2004-02-26 3:18 | 2004-02-26 8:59 | MySQLCC | Not a Bug (8287 days) | S3 | 4.0.17 | Windows (Windows XP) | Any | The use of the word "group" as a field name, seems to cause insert errors. |
| 4184 | 2004-06-17 13:51 | 2004-09-01 16:26 | MySQL Server | Closed (8099 days) | S2 | 4.1.2 | HP/UX (HP-UX 11) | Any | mysql_stmt_fetch() fetches wrong MSQL_TIME values |
| 4402 | 2004-07-04 8:21 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6606 days) | S4 | 4.1, 5.1.28, 6.0.6 | Any (all) | Any | Equivalence is not considered in group by and order by |
| 4463 | 2004-07-08 15:01 | 2007-05-04 12:13 | MySQL Server: Replication | Not a Bug (7124 days) | S4 | <4.1 | Any (doesn't matter) | Any | GROUP takes the first-found values |
| 4550 | 2004-07-14 20:10 | 2004-07-16 18:00 | MySQL Query Browser | Closed (8146 days) | S1 | 1.0.2 Alpha | Windows (Win2k) | Any | count(*) query causes invalid 'must group by' error |
| 5029 | 2004-08-13 11:49 | 2013-06-27 15:39 | MySQL Server: Command-line Clients | Closed (4878 days) | S4 | all | Any (all) | Any | mysql command to be able to use different configuration groups |
| 8086 | 2005-01-22 6:38 | 2005-02-26 21:25 | MySQL Server | No Feedback (7921 days) | S2 | 4.1.8 | Linux (Linux) | Any | Mysterious very poor performance w/ IN (select...) vs. =(correlated subquery) |
| 8614 | 2005-02-19 0:53 | 2005-06-22 2:29 | MySQL Server: Optimizer | Closed (7805 days) | S3 | 4.1.10 | Any (*) | Any | distinct sometimes ignored with group by "CONST" |
| 9720 | 2005-04-07 14:23 | 2013-05-30 12:40 | Connector / ODBC | Closed (4906 days) | S3 | 3.51.11 | Windows (Windows 2000) | Any | Problems with sum() and group by with Magic Development |
| 10005 | 2005-04-19 17:40 | 2006-01-09 14:46 | Eventum | Closed (7604 days) | S3 | current | Any (All) | Any | RFE - security patch, to prevent plaintext passwords in config files from leaki |
| 12803 | 2005-08-25 13:24 | 2013-06-17 14:31 | MySQL Server | Closed (4888 days) | S4 | next | Any (all) | Any | selecting a consistent row of aggrigate data during a group |
| 12823 | 2005-08-26 7:29 | 2005-10-19 15:00 | MySQL Server | Closed (7686 days) | S3 | MySQL-server-4.1.14-0.i386.rpm | Linux (SuSE 8.1 (2.4.21-273-default)) | Any | RPM Installation does not change group of existing mysql user during upgrade |
| 13160 | 2005-09-14 0:40 | 2005-09-14 5:23 | MySQL Server | Not a Bug (7721 days) | S2 | 4.1.14 | Linux (Linux Fedora Core 4) | Any | Incorrect result with MIN and GROUP BY after DELETE and re-INSERT of same data |
| 13595 | 2005-09-29 6:23 | 2005-09-29 12:19 | MySQL Server | Closed (7706 days) | S1 | 5.0.13 | Windows (WIN-NT2003) | Any | MySQL server crashes when querying view with group by.. having clause |
| 14343 | 2005-10-26 18:25 | 2005-12-10 11:45 | MySQL Server | Closed (7634 days) | S2 | mysql 4.1.14, php 5.0.4 | Linux (Linux RH4) | Any | mysqli php-extension |
| 14927 | 2005-11-14 16:30 | 2006-05-10 16:28 | MySQL Server | Closed (7483 days) | S1 | 4.1.12a | Windows (Windows XP) | Any | HAVING ignores conditions |
| 15131 | 2005-11-22 11:44 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (6427 days) | S4 | 4.1,5.0 | Any | Any | On-disk temporary tables created for GROUP BY should use indexes |
| 16154 | 2006-01-03 14:52 | 2006-02-13 17:42 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7569 days) | S3 | 5.1 | Linux (Linux) | Any | DD: Duplicate LOGFILE GROUP creates results in error unkown by perror |
| 16158 | 2006-01-03 17:11 | 2006-02-13 20:24 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7569 days) | S2 | 5.1 | Linux (Linux) | Any | DD: ALTER TABLESPACE fails if Duplicate CREATE TABLESPACE done before |
| 16193 | 2006-01-04 16:21 | 2006-01-20 16:05 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7593 days) | S1 | 5.1 | Linux (Linux) | Any | DD: drop logfile group corrupts NDB File system and cause NDBD crash |
| 16471 | 2006-01-13 1:28 | 2013-10-06 20:45 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (7555 days) | S2 | 5.1.6-alpha | Linux (Linux) | Any | DD: Maximum path for undofile in CREATE LOGFILE GROUP is 167 bytes |
| 17276 | 2006-02-09 14:51 | 2006-03-23 17:13 | MySQL Server | Won't fix (7531 days) | S4 | Any | Unwanted behaviour WITH ROLLUP | ||
| 17355 | 2006-02-13 23:37 | 2006-03-21 13:31 | MySQL Server | No Feedback (7533 days) | S1 | 5.0.18-linux-x86_64-glibc23 | Linux (Red Hat Enterprise AS 4 Update 2) | Any | Combination of "Group By" query crashes server |
| 17563 | 2006-02-19 22:56 | 2006-02-20 5:49 | Eventum | Duplicate (7562 days) | S3 | 1.7 | Windows (XP) | Any | Getting this missmatch error |
| 17844 | 2006-03-01 22:19 | 2006-03-08 14:05 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7546 days) | S2 | 5.1.8 | Linux (Linux 32 Bit OS) | Any | DD: INFORMATION_SCHEMA.FILES not showing correct free space information |
| 18131 | 2006-03-10 11:03 | 2006-03-28 17:26 | MySQL Server: Documentation | Not a Bug (7526 days) | S1 | MySQL 5.0.18 | Windows (Windows XP & Linux Fedora core 4) | Any | GROUP BY doesn't always work |
| 18797 | 2006-04-05 12:55 | 2006-04-12 23:02 | MySQL Server: Installing | Closed (7511 days) | S3 | 5.0.17a-cert | Other (SCO OpenServer 6.0) | Any | Adding of default user/group for VOLS packages is not explicitly described |
| 19419 | 2006-04-28 9:53 | 2006-09-25 20:02 | MySQL Server: Replication | Closed (7345 days) | S2 | 5.0.20/5.0BK/5.1BK | Windows (windows xp & linux) | Any | VIEW: View that the column name is different by master and slave is made |
| 19463 | 2006-05-01 18:48 | 2006-05-01 19:58 | MySQL Server | Not a Bug (7492 days) | S2 | 5.x | Windows (windows) | Any | Bug in executing SQL scripts that has a key named Group |
| 19544 | 2006-05-04 19:29 | 2006-06-21 5:01 | MySQL Server: Backup | Closed (7441 days) | S2 | 5.1 | Linux (Linux) | Any | mysqldump does not backup TS and LG information correctly. |
| 20536 | 2006-06-19 13:36 | 2006-09-25 15:00 | MySQL Server: Charsets | Closed (7345 days) | S3 | 5.0.23BK, 4.1 | Any (*) | Any | md5() with GROUP BY and UCS2 return different results on myisam/innodb |
| 21271 | 2006-07-25 11:07 | 2006-09-01 15:11 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7369 days) | S1 | 5.1.11 | Linux (RHEL-ES4 (Nahant)) | Any | 2 Node cluster can't recover from bringing one node down |
| 21648 | 2006-08-15 6:12 | 2006-09-01 8:09 | MySQL Server: Tests | Closed (7369 days) | S3 | 5.1.12bk | Any | information_schema test fails --with-ndbcluster | |
| 21828 | 2006-08-25 8:50 | 2024-09-15 20:45 | MySQL Server | No Feedback (7345 days) | S1 | 5.0.16 | Linux (redhat ) | Any | Wrong results when select using "into variable" with group by in stored procedur |
| 21957 | 2006-08-31 22:18 | 2006-10-01 9:02 | MySQL Server | No Feedback (7339 days) | S2 | 5.0.15 | Linux (Linux) | Any | Replication fails with "Error 'Invalid use of group function' on query." |
| 22342 | 2006-09-14 12:37 | 2006-10-26 3:14 | MySQL Server | Closed (7314 days) | S2 | 5.0.22-pro-nt-log | Any | No results returned for query using max and group by | |
| 22431 | 2006-09-18 6:05 | 2006-10-27 14:59 | MySQL Administrator | Closed (7313 days) | S2 | 1.2.4 rc, 1.2.3 rc | Windows (Windows XP SP2) | Any | MySQL Administrator improperly updates my.ini when modifying logging information |
| 23171 | 2006-10-11 10:09 | 2007-04-12 16:04 | MySQL Server: Replication | Closed (7146 days) | S3 | 5.1 | Any | Any | Illegal slave restart (group) position |
| 24516 | 2006-11-22 18:44 | 2021-05-02 20:45 | MySQL Cluster: NDB API | Verified (7147 days) | S4 | mysql-5.1 | Linux (Linux) | Any | MGMAPI reports bad data for down datanodes |
| 24886 | 2006-12-07 13:41 | 2011-02-16 23:43 | MySQL Server: Data Types | Closed (5928 days) | S2 | 5.0.27 | Linux (Linux) | Any | Wrong data type in the resultset if using GROUP BY and CONCAT |
| 27079 | 2007-03-13 12:16 | 2007-04-04 5:38 | MySQL Server: Charsets | Closed (7154 days) | S2 | 4.1.22/5.0/5.1BK | Linux (Linux) | Any | Crash while grouping empty ucs2 strings |
| 27219 | 2007-03-16 15:48 | 2008-04-07 17:24 | MySQL Server | Closed (6785 days) | S3 | 5.0.38 | Linux (Linux) | Any | count(*) in order by |
| 28950 | 2007-06-07 15:22 | 2007-06-07 18:11 | MySQL Server: Optimizer | Can't repeat (7090 days) | S3 | 5.0.40, 5.0.41 | Linux (x86, x86-64) | Any | Using EXISTS and a GROUP BY incorrectly yields no results |
| 29017 | 2007-06-11 11:43 | 2007-06-26 8:04 | MySQL Server | Can't repeat (7071 days) | S2 | 5.0.41 | Any | Any | Problem with subqueries and GROUP BY |
| 29209 | 2007-06-19 12:54 | 2007-08-01 12:21 | MySQL Server: Optimizer | Not a Bug (7035 days) | S3 | 5.0.44/5.1BK | Any | Any | Loose index scan is not used if key parts are in different order in the GROUP BY |
| 29285 | 2007-06-21 20:32 | 2008-08-25 10:01 | MySQL Server | Not a Bug (6645 days) | S1 | 5.0.36, 5.0.37, 5.0.60 | Any ((Linux, Windows)) | Any | --log-slow-queries + --log-queries-not-using-indexes works incorrect |
| 29630 | 2007-07-08 19:27 | 2007-07-09 13:07 | MySQL Server | Closed (7058 days) | S2 | 5.0.41-community-nt | Windows | Any | "group by" doesnt work with subselects |
| 30219 | 2007-08-03 3:40 | 2007-08-25 16:19 | MySQL Server: MyISAM storage engine | Closed (7011 days) | S2 | 5.0 (all) | Any | Any | GROUP BY with DISTINCT broken with BIT type in MyISAM in many cases |
| 30596 | 2007-08-23 14:07 | 2007-10-23 15:59 | MySQL Server: Optimizer | Closed (6952 days) | S2 | Any | Any | GROUP BY optimization gives wrong result order | |
| 33193 | 2007-12-13 2:15 | 2007-12-20 8:17 | MySQL Enterprise Monitor: Web | Closed (6894 days) | S2 | 1.3.0.8528 | Any | Any | group name is not displayed |
| 34201 | 2008-01-31 17:59 | 2008-04-02 19:31 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6790 days) | S2 | 5.0, 5.1 | Linux | Any | Unable stop a node when a node in a different group is in "not started" state |
| 34551 | 2008-02-14 15:43 | 2008-03-15 15:59 | MySQL Server: Stored Routines | No Feedback (6808 days) | S1 | 5.0.51a | Linux (el5) | Any | *** glibc detected *** mysqld: corrupted double-linked list: 0x0b4ae810 *** |
| 34620 | 2008-02-16 17:16 | 2008-03-15 8:41 | MySQL Server: DML | Closed (6808 days) | S3 | 5.0+, 5.0.58-BK | Any | Any | item_row.cc:50: Item_row::illegal_method_call(const char*): Assertion `0' failed |
| 37851 | 2008-07-03 20:20 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5828 days) | S1 | 6.0 | Any | Any | Crash in test_if_skip_sort_order tab->select is zero |
| 37868 | 2008-07-04 11:42 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6212 days) | S1 | 6.0 | Any | Any | Crash in test_if_skip_sort_order, bad value for used_key_parts |
| 37905 | 2008-07-06 16:19 | 2008-07-07 18:02 | MySQL Server | Unsupported (6694 days) | S3 | 5.0.51a | MacOS (part of XAMPP 0.7.2) | Any | SELECT COUNT with GROUP BY bug (see #7128) |
| 37977 | 2008-07-08 20:38 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5832 days) | S1 | 6.0 | Any | Any | Wrong result returned on GROUP BY + OR + Innodb |
| 38862 | 2008-08-18 15:34 | 2012-05-18 20:19 | MySQL Workbench | Verified (6639 days) | S4 | 5.0.24 | Any | Any | Usability: Drag/Drop options for routines - routine groups |
| 39455 | 2008-09-15 15:01 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (6482 days) | S4 | 5.0.51a-3ubuntu5.1 | Any | Any | Would be useful to ORDER BY arithmetic expressions on GROUP BY columns |
| 39905 | 2008-10-07 10:43 | 2008-10-07 11:31 | MySQL Server: InnoDB storage engine | Not a Bug (6602 days) | S3 | 5.0 | Any | Any | Incorrect result with HAVING and no GROUP BY |
| 42567 | 2009-02-03 12:39 | 2011-02-16 23:43 | MySQL Server: General | Closed (6440 days) | S2 | 5.1.30-community-log | Windows (2003) | Any | Invalid GROUP BY error |
| 43092 | 2009-02-22 21:09 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (6459 days) | S3 | 5.0.67-0ubuntu6 | Linux (Ubuntu 8.10) | Any | Group by still optimizing out extra nulls |
| 43342 | 2009-03-03 21:54 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6455 days) | S2 | 5.1, 6.0 | Any | Any | FORCE INDEX hint does not differentiate between ORDER BY and GROUP BY |
| 45224 | 2009-05-31 22:34 | 2009-06-01 10:28 | MySQL Server: Optimizer | Not a Bug (6365 days) | S3 | 5.4 | Any | Any | SELECT col_1 WHERE column(s) IN (subquery) AND condition GROUP BY col_n fails |
| 45226 | 2009-05-31 22:42 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (6220 days) | S3 | 5.4 | Any | Any | extra rows returned for queries using IN,GROUP BY and HAVING clauses |
| 45228 | 2009-05-31 22:56 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (6220 days) | S3 | 5.4 | Any | Any | Queries with WHERE <col_1> AND <condition> GROUP BY <col_2> produce bad results |
| 45738 | 2009-06-25 8:41 | 2011-02-16 23:44 | MySQL Workbench | Won't fix (6340 days) | S3 | 5.1.14 | Any | Any | routine object is deleted when its code is removed from routine-groups code |
| 46567 | 2009-08-05 14:24 | 2011-02-16 23:44 | MySQL Server: Documentation | Closed (6298 days) | S3 | 5.0, 5.1, 5.4/6.0 | Any | Any | Aggregate function documentation needs clarification for non-GROUP BY behavior |
| 47652 | 2009-09-25 17:39 | 2009-09-25 17:49 | MySQL Server | Not a Bug (6249 days) | S3 | 5.1 comunity server | Linux | Any | sub query and grouping results |
| 48118 | 2009-10-16 14:22 | 2022-09-04 20:45 | MySQL Server: Optimizer | Duplicate (6092 days) | S3 | 5.1, 6.0 | Any | Any | Server processing HAVING clauses incorrectly without a LIMIT clause |
| 49630 | 2009-12-11 16:30 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5825 days) | S3 | 6.0 | Any | Any | Segfault in select_describe() with double nested subquery and materialization |
| 50916 | 2010-02-04 15:14 | 2011-02-16 23:44 | MySQL Enterprise Monitor: Server | Closed (6064 days) | S3 | 2.1.1.1138 | Any | Any | Trying to remove a server that has QUAN inventory, but purged data, fails |
| 52081 | 2010-03-16 8:38 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5927 days) | S3 | 5.1.41, 5.1.44, 5.6.99 | Any | Any | Index hint/forcing for GROUP BY / ORDER BY is broken |
| 52592 | 2010-04-05 8:45 | 2011-02-16 23:44 | MySQL Server | No Feedback (6027 days) | S3 | 5.1.42-community | Windows (7 ) | Any | wrong warning in KEY_COLUMN_USAGE |
| 53161 | 2010-04-26 13:12 | 2013-01-18 1:51 | MySQL Server: Optimizer | Closed (5038 days) | S1 | 5.1.37, 5.1.46, 5.1.47 | Any | Any | Left join optimized into join leads to incorrect results |
| 53712 | 2010-05-17 16:13 | 2011-02-16 23:44 | MySQL Server: General | No Feedback (5983 days) | S2 | 5.1.46 | Solaris | Any | ORDER BY causes incorrect query result |
| 59557 | 2011-01-17 15:26 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5770 days) | S2 | 5.1, 5.5 | Any | Any | MySQL uses order of fields in GROUP BY when ORDER BY NULL is specified |
| 59831 | 2011-01-31 6:06 | 2011-02-16 23:44 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5754 days) | S3 | 7.1.6 | Any | Any | ndbinfo - counters not increasing after first query |
| 60808 | 2011-04-08 15:06 | 2011-04-08 16:35 | MySQL Server: General | Duplicate (5689 days) | S2 | 5.5.11, 5.1.54, 5.1.41 | Any (win7 64bit, ubuntu 10.04 64 bit) | Any | Duplicate entry for key 'group_key'; Can't write, duplicate key in table |
| 61666 | 2011-06-28 8:44 | 2011-06-28 9:01 | MySQL Server | Not a Bug (5608 days) | S3 | mysql Ver 14.12 Distrib 5.0.45 | Linux (Red Hat Enterprise Linux Server release 5.3 (Tikanga)) | Any | #1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns |
| 62314 | 2011-09-01 2:00 | 2011-09-01 6:41 | MySQL Workbench | Duplicate (5543 days) | S3 | 5.2.34 CE (7780) | Windows (7 Home Premium, 64 bit) | Any | Workbench flags GROUP BY modifier WITH ROLLUP as bad. |
| 62712 | 2011-10-13 0:54 | 2018-09-25 21:51 | Tools: MTR / mysql-test-run | Closed (5441 days) | S7 | 5.5.17 | Any | Any | RPM-based install of the test suite is useless for non-root users. |
| 62858 | 2011-10-21 9:59 | 2014-04-07 9:05 | MySQL Cluster: Disk Data | Closed (4594 days) | S3 | 5.5.15-ndb-7.2.1 | Linux | Any | CREATE LOGFILE GROUP / CREATE TABLESPACE accept only bytes as unit |
| 63609 | 2011-12-05 17:18 | 2011-12-12 18:25 | MySQL Server: General | Duplicate (5441 days) | S3 | Distrib 5.5.17, for FreeBSD7.4 (amd64) | FreeBSD (not tested on other OS) | Any | Query with GROUP by , ORDER BY and LIMIT return one row , not expected count |
| 67978 | 2012-12-27 6:13 | 2026-10-26 21:48 | MySQL Server: Memory storage engine | Documenting (5058 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Signed zero is handled incorrectly by HASH indexes and GROUP BY |
| 69268 | 2013-05-17 14:51 | 2013-06-24 8:29 | MySQL Server: Optimizer | Duplicate (4881 days) | S2 | 5.6 | Any | Any | LEFT JOIN plus GROUP BY incorrectly returns NULL |
| 71844 | 2014-02-26 13:31 | 2014-07-24 23:40 | MySQL Fabric | Closed (4486 days) | S4 | 1.4.1 | Any | Any | option to join FAULTY MySQL instance back into group |
| 72016 | 2014-03-12 4:15 | 2014-03-26 4:12 | MySQL Fabric | Closed (4606 days) | S2 | Linux | Any | Automatic Failover is not happening when global group master is failed | |
| 72018 | 2014-03-12 11:02 | 2014-08-01 16:35 | MySQL Server: Command-line Clients | Closed (4485 days) | S3 | 5.5.33-cll-lve, 5.6.16 | Linux (RHEL 6.4) | Any | SHOW CREATE VIEW output inccorrect |
| 72191 | 2014-04-01 17:54 | 2014-04-01 22:09 | MySQL Fabric | Can't repeat (4600 days) | S3 | 1.4.1-1 | Linux | Any | mysqlfabric help does not work as documented |
| 72281 | 2014-04-09 0:02 | 2017-07-06 19:19 | MySQL Fabric | Won't fix (4587 days) | S3 | Any | Any | mysqlfabric group promote may break replication | |
| 72417 | 2014-04-22 7:04 | 2014-04-24 11:03 | MySQL Server | Open | S4 | Linux | Any | execute semi join get incorrect result. | |
| 72474 | 2014-04-28 17:42 | 2014-04-29 14:00 | MySQL Server | Not a Bug (4572 days) | S2 | 5.5.35 | Linux (Debian 5.5.35-0+wheezy1-log) | Any | Query crash when selecting fixed value column on group by |
| 73066 | 2014-06-20 15:45 | 2023-01-12 18:36 | MySQL Server: Replication | Closed (2917 days) | S2 | 5.6.17 | Any | Any | Replication stall with multi-threaded replication |
| 73582 | 2014-08-14 12:18 | 2014-09-29 16:48 | MySQL Server: Documentation | Closed (4419 days) | S3 | 5.6 5.7 | Any | Any | Documentation says group commit for the binary log works only if sync_binlog=0 |
| 74415 | 2014-10-16 7:34 | 2015-04-14 12:04 | MySQL Enterprise Monitor: Advisors/Rules | Can't repeat (4237 days) | S3 | 3.0.14 | Any | Any | Advisor doesn't use the correct thresholds |
| 74859 | 2014-11-14 9:50 | 2018-10-01 16:17 | MySQL Server: DML | Closed (4293 days) | S6 | 5.6.20, 5.6.23, 5.7.6 | Any | Any | Assertion `scale >= 0 && precision > 0 && scale <= precision' failed |
| 75939 | 2015-02-17 21:24 | 2015-09-05 1:00 | MySQL Server: Group Replication | No Feedback (4079 days) | S1 | 5.7.5-labs-group-replication | Linux (ubuntu 14.04) | Any | mysql 5.7.5 group replication failed |
| 76501 | 2015-03-27 6:50 | 2015-03-27 15:11 | MySQL Server: Optimizer | Verified (4240 days) | S3 | 5.6.22 | Any | Any | "select + distinct + group by " works incorrectly |
| 77006 | 2015-05-11 21:03 | 2015-12-22 10:40 | MySQL Server: Optimizer | Not a Bug (3970 days) | S2 | 5.6.24, 5.6.26, 5.6.10, 5.7.8 | Any | Any | 5.6 incompatible change in DELETE/SELECT ... WHERE NOT IN (subquery) |
| 77742 | 2015-07-15 22:02 | 2018-10-21 20:45 | MySQL Server | No Feedback (4073 days) | S2 | 5.7.7 | Any | Any | join query returns in-correct result |
| 78417 | 2015-09-12 9:48 | 2015-09-14 11:44 | MySQL Server: Optimizer | Won't fix (4069 days) | S3 | 5.6.22 | Any | Any | Valid select with expression in group by under "only_full_group_by" fails |
| 78627 | 2015-09-29 16:45 | 2015-10-08 4:50 | MySQL Server: Group Replication | Not a Bug (4045 days) | S1 | 0.5.0-dmr | CentOS (6.4) | Any | Segmentation fault after running START GROUP_REPLICATION on Oracle Linux 6 |
| 79100 | 2015-11-03 17:01 | 2015-11-17 18:52 | MySQL Server: Documentation | Closed (4005 days) | S3 | any, 5.5, 5.6, 5.7 | Any | Any | MySQL Manual does not explain when ORDER BY NULL does NOT prevent filesort |
| 80186 | 2016-01-28 13:15 | 2016-01-28 13:54 | MySQL Server: DML | Not a Bug (3933 days) | S3 | 5.5.38-log | Windows | Any | the group by colunm is trimed when do group by |
| 80604 | 2016-03-03 12:36 | 2017-07-06 19:20 | MySQL Fabric: Command-line | Won't fix | S4 | 1.5.6 | Any | Any | The command line doesn't show the full status of a group |
| 80682 | 2016-03-10 8:44 | 2016-03-10 11:50 | MySQL Server: DML | Verified (3891 days) | S3 | 5.7.8, 5.7.11 | Any | Any | Inconsistent behavior with GROUP BY alias, w/ different sequence in select list |
| 81910 | 2016-06-17 16:35 | 2016-11-02 13:34 | MySQL Server: Replication | Closed (3722 days) | S3 | 5.7.14 | Any | Any | WRITE SET HASHES SHOULD HAVE A 64BITS OPTION TO REDUCE WRITE CONFLICTS |
| 82544 | 2016-08-11 14:36 | 2016-08-17 14:57 | MySQL Server: Documentation | Closed (3731 days) | S3 | 5.7.14 | Any | Any | Duplicate entry '' for key '<group_key>' while doing group by |
| 82764 | 2016-08-28 14:02 | 2017-11-24 14:48 | MySQL Server | Can't repeat (3267 days) | S2 | 5.17 | FreeBSD | Any | [Regression] MySQL server corrupts install if mysql user exists in FreeBSD |
| 84337 | 2016-12-26 8:50 | 2017-07-11 11:52 | MySQL Server: Group Replication | Closed (3403 days) | S2 | mysql 5.7.17 | Any | Any | Configure mgr with out root user encounter an error |
| 84631 | 2017-01-24 1:38 | 2019-01-03 11:45 | MySQL Server: Documentation | Closed (2862 days) | S3 | 5.7 | Any | Any | Group Replication Installation Documentation |
| 85026 | 2017-02-16 17:43 | 2019-01-22 14:23 | MySQL Server: Group Replication | Closed (3348 days) | S3 | 8.0.1 | Any | Any | GROUP MEMBERS BECOMES 'UNREACHABLE' WHEN SERVER WITH LOWER VERSION TRIES TO JOIN |
| 85047 | 2017-02-17 11:03 | 2017-07-17 12:30 | MySQL Server: Group Replication | Closed (3432 days) | S2 | 5.7.18 | Any | Any | Secondaries allows transactions through ASYNC setup into the group |
| 85977 | 2017-04-18 2:02 | 2024-10-23 16:38 | MySQL Server: Documentation | Verified (742 days) | S3 | 5.7 and 8.0 | Any | Any | The doc. of slave-parallel-type=LOGICAL_CLOCK wrongly reference Group Commit. |
| 86047 | 2017-04-23 7:58 | 2017-05-02 17:23 | MySQL Server: Query Cache | Closed (3473 days) | S2 | 5.6,5.7,8.0, 5.6.36 | Any | Any | FROM sub query with 'group by' is cached by mistake |
| 86359 | 2017-05-17 14:53 | 2017-11-08 10:27 | MySQL Server: Group Replication | Closed (3337 days) | S3 | 5.7.18 | Any | Any | Avoid setting group_replication_force_members in a partition that holds majority |
| 89194 | 2018-01-11 19:14 | 2018-04-11 16:23 | MySQL Server: Group Replication | Duplicate (3129 days) | S2 | 5.7.20, 8.0.3 | Any | Any | Wrong certification lead to data inconsistency and GR breakage. |
| 90488 | 2018-04-18 7:02 | 2018-07-11 1:00 | MySQL Server: Group Replication | Can't repeat (3038 days) | S2 | 5.7.21 MySQL Communinity Edition | Ubuntu (16.04) | x86 | mysqld crash on "start group_replication" with bootstrap |
| 90553 | 2018-04-21 10:46 | 2019-07-11 7:55 | MySQL Server: Documentation | Closed (2673 days) | S3 | 8.0.11 | Any | Any | group replication installation docs lead to errors in the logs |
| 91151 | 2018-06-05 17:12 | 2019-05-06 3:33 | MySQL Server: Group Replication | Verified (3073 days) | S3 | 8.0.11 | Any | Any | Add a Learner/Observer role to leverage it in WAN setup |
| 91254 | 2018-06-14 11:49 | 2018-06-24 7:54 | MySQL Server: mysqlpump Command-line Client | Duplicate (3055 days) | S3 | 8.0.11 | Any | Any | mysqlpump doesn't read "mysqlpump" group from option files |
| 91386 | 2018-06-24 0:30 | 2018-06-29 12:33 | MySQL Server: Optimizer | Verified (3050 days) | S4 | 5.7.18 | Any | Any | Index for group-by is not used with primary key for SELECT COUNT(DISTINCT a) |
| 91433 | 2018-06-27 8:12 | 2019-01-22 14:14 | MySQL Server: Group Replication | Closed (2981 days) | S3 | 8.0.13-wl11570 | Any | Any | when a member goes to ERROR, other members see it UNREACHABLE |
| 92210 | 2018-08-28 12:01 | 2018-09-09 19:12 | MySQL Server: Replication | Can't repeat (2978 days) | S2 | 5.7.23 | Any | Any | Mysql initilize replication component failed |
| 92454 | 2018-09-17 7:16 | 2018-11-02 14:34 | MySQL Server: Group Replication | Closed (2924 days) | S3 | 8.0.11-commercial | CentOS | Any | [GCS] Error pushing message into group communication engine |
| 92875 | 2018-10-21 19:37 | 2018-11-25 1:00 | MySQL Server: Group Replication | No Feedback (2902 days) | S2 | 8.0.11 | Debian (9) | Any | Crash after member tries to recover |
| 93254 | 2018-11-20 3:33 | 2019-04-17 22:22 | MySQL Server: JSON | Closed (2758 days) | S3 | 5.7.24, 8.0.13 | Ubuntu | Other (x64) | MAX treating Numbers as Strings when used in group by and JSON_UNQUOTE |
| 93347 | 2018-11-26 14:56 | 2019-07-25 8:30 | MySQL Server: Group Replication | Closed (2808 days) | S3 | 5.7 | Any | Any | VIEW_CHANGE_LOG_EVENT may not be logged on a overloaded primary |
| 94754 | 2019-03-22 15:11 | 2020-08-31 1:00 | Connector / J | No Feedback (2257 days) | S3 | 8.0.15 | Any | Any | Error getting group, by name, in native pattern class |
| 98533 | 2020-02-10 12:26 | 2020-04-15 12:15 | Shell AdminAPI InnoDB Cluster / ReplicaSet | Closed (2394 days) | S3 | 8.0.19 | Any | Any | createCluster and addInstance result in group_replication plugin errors in log |
| 99931 | 2020-06-18 19:41 | 2020-06-19 6:56 | MySQL Server: DML | Closed (2329 days) | S2 | 8.0.12, 8.0.18 | Any | Any | Aggregate group by returns incorrect result when loose index scan is used |
| 100395 | 2020-07-31 6:41 | 2020-09-01 13:18 | MySQL Server: Optimizer | Not a Bug (2255 days) | S3 | 8.0.13, 8.0.18, 8.0.21, 5.7.31 | Any | Any | No error reports on aggregates without group-by with ONLY_FULL_GROUP_BY sql_mode |
| 100734 | 2020-09-03 17:19 | 2020-10-04 1:00 | MySQL Server: DML | No Feedback (2223 days) | S3 | 8.021 | Any (Tried on windows, mac, centos) | x86 | Select with group by returns different results |
| 100791 | 2020-09-10 0:55 | 2020-10-01 14:18 | MySQL Server: Optimizer | Closed (2225 days) | S1 | 8.0.21 | Debian (Buster 10) | x86 | Data type changed in a GROUP BY WITH ROLLUP |
| 100985 | 2020-09-29 7:42 | 2020-09-29 9:18 | MySQL Server: Optimizer | Verified (2227 days) | S3 | 8.0.21, 5.7.31, 5.6.48 | Any | Any | Stored value for 0.001 is inconsistent, and casted to decimal is also different |
| 101178 | 2020-10-15 6:55 | 2025-12-07 20:45 | MySQL Server: Group Replication | No Feedback (1833 days) | S4 | 8.0.21 | CentOS (7.5.1804) | x86 (Intel(R) Core(TM) i5-8300H CPU @ 2.30GHz) | The variable group_replication_force_members is better to be case insensitive |
| 101179 | 2020-10-15 6:55 | 2020-10-20 7:53 | MySQL Server: Group Replication | Duplicate (2206 days) | S4 | 8.0.21 | CentOS (7.5.1804) | x86 (Intel(R) Core(TM) i5-8300H CPU @ 2.30GHz) | The variable group_replication_force_members is better to be case insensitive |
| 102040 | 2020-12-21 13:55 | 2021-01-25 13:03 | MySQL Server: Optimizer | Not a Bug (2144 days) | S3 | 8.0.18 | Linux | x86 | Different results of equivalent SQL querys |
| 102515 | 2021-02-07 11:03 | 2021-03-09 7:36 | MySQL Server: Group Replication | Verified (2094 days) | S2 | 8.0.23 | Any | Any | Group replication member remains ONLINE even when it gets (far) behind |
| 103808 | 2021-05-26 4:09 | 2025-12-07 20:45 | MySQL Server: Group Replication | No Feedback (1953 days) | S3 | 8.0.22 | CentOS (CentOS Linux release 7.8.2003 (Core)) | x86 | group repl MY-013328: Certification information is too large for transmission |
| 103930 | 2021-06-07 18:06 | 2021-06-08 13:55 | MySQL Server: DML | Verified (1975 days) | S2 | 5.7.34 | Any | Any | Result mismatch when unicode collation with special data |
| 107535 | 2022-06-09 22:56 | 2023-08-03 19:35 | MySQL Server: Optimizer | Verified (1189 days) | S3 | 8.0.29, 5.7.38 | Any | Any | Group by does not use loose scan unless full prefix is given |
| 107700 | 2022-06-29 11:18 | 2024-06-13 20:13 | MySQL Server: InnoDB storage engine | Closed (874 days) | S5 | 8.0.29 | Any | Any | Performance of Temptable is worse than Memory in GROUP BY scenario |
| 108150 | 2022-08-16 13:19 | 2023-01-27 16:19 | MySQL Server: Optimizer | Verified (1377 days) | S3 | 8.0.30 | Ubuntu (22.04.1) | x86 (x86_x64) | ALL query with UNION and ROLLUP wrong result |
| 108411 | 2022-09-07 12:26 | 2022-09-08 13:15 | Shell AdminAPI InnoDB Cluster / ReplicaSet | Can't repeat (1518 days) | S3 | Any | Any | cluster instance status reports clone information during distributed recovery | |
| 108573 | 2022-09-21 17:08 | 2023-03-02 15:47 | Shell AdminAPI InnoDB Cluster / ReplicaSet | Can't repeat (1343 days) | S3 | 8.0.30 | Any | Any | using 'manualStartOnBoot': true in create_replica_cluster causes issues |
| 108821 | 2022-10-19 10:01 | 2022-11-16 13:46 | MySQL Server: Documentation | Closed (1449 days) | S3 | 8.0.31 | Any | Any | DOC issue with group_replication_communication_debug_options description |
| 109105 | 2022-11-16 3:17 | 2022-11-16 9:24 | MySQL Server: Connection Handling | Verified (1449 days) | S4 | 8.0.28 | Linux | Any | Specify a default resource group for a user |
| 110245 | 2023-03-01 3:56 | 2023-03-02 9:59 | MySQL Server: Optimizer | Not a Bug (1343 days) | S3 | 8.0.32 | Any | Any | Issue with NOT IN |
| 111414 | 2023-06-14 9:26 | 2023-06-16 9:32 | MySQL Server: Optimizer | Can't repeat (1237 days) | S3 | 8.0.33 | Any | Any | HASH JOIN results in wrong query results |
| 111435 | 2023-06-15 11:14 | 2023-06-15 13:16 | MySQL Server: Optimizer | Duplicate (1238 days) | S3 | 8.0.32 | Any | Any | Hash join results in incorrect query results |
| 112280 | 2023-09-06 20:38 | 2023-09-07 4:27 | MySQL Server: Optimizer | Verified (1154 days) | S3 | 8.0.34 | Any | Any | Incorrect costing of group by loose index scans |
| 112499 | 2023-09-26 11:37 | 2023-09-26 11:48 | MySQL Server: DML | Verified (1135 days) | S6 | 8.0.34 | Ubuntu (20.04) | Any | Assertion Failure in /mysql-8.0.34/sql/sql_tmp_table.cc:485 |
| 112514 | 2023-09-26 12:23 | 2023-09-26 12:28 | MySQL Server: DML | Verified (1135 days) | S6 | 8.0.34 | Ubuntu (20.04) | Any | Assertion Failure in /mysql-8.0.34/sql/sql_lex.cc:2288 |
| 112881 | 2023-10-30 9:17 | 2023-10-30 9:36 | MySQL Server: Security: Privileges | Verified (1101 days) | S4 | 8.2 | Any | Any | Allow forcing a specific resource group for MySQL users for limiting CPU usage |
| 112929 | 2023-11-01 17:10 | 2023-11-10 19:13 | Shell AdminAPI InnoDB Cluster / ReplicaSet | Can't repeat (1090 days) | S3 | 8.0.30, 8.0.32 | CentOS | Any | InnoDB ClusterSet Replica Cluster creation fails due to account creation failure |
| 112982 | 2023-11-07 8:08 | 2023-11-14 19:46 | MySQL Server: DML | Closed (1086 days) | S6 | 8.0.34, 8.0.35 | Ubuntu (20.04) | Any | Assertion Failure in /mysql-8.0.34/sql/sql_derived.cc:558 |
| 113337 | 2023-12-05 10:29 | 2024-01-17 14:26 | MySQL Operator | Verified (1025 days) | S4 | 8.2.0-2.1.1 | Linux (Amazon Linux 2) | x86 (x86_64) | Cluster View Inconsistent - New Primary Unable to be Promoted |
| 113338 | 2023-12-05 11:16 | 2023-12-07 8:11 | MySQL Server: Partitions | Verified (1063 days) | S3 | 8.0.34, 8.0.35 | Linux | Any | return error result with a qubquery |
| 114703 | 2024-04-19 14:08 | 2024-04-25 14:14 | MySQL Server | Not a Bug (923 days) | S3 | 8.0.28 | CentOS (7.9) | x86 (x86_64) | The different use of in and = before subquery leads to the change of SQL result |
| 114771 | 2024-04-25 3:20 | 2024-05-07 7:41 | MySQL Server | Not a Bug (911 days) | S3 | 8.3.0 | Linux (7.9.2009 (Core)) | x86 (Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz) | Mysql 8.3.0 group replication causes the cluster to crash during large transacti |
| 116231 | 2024-09-25 15:01 | 2025-01-08 16:39 | Shell AdminAPI InnoDB Cluster / ReplicaSet | Closed (665 days) | S3 | 8.4.1 | Red Hat (8.9) | x86 | Router reports: Ignoring unsupported instance <host:port>, type: 'group-member' |
| 117992 | 2025-04-15 18:04 | 2025-04-24 0:31 | MySQL Server: Installing | Verified (560 days) | S4 | mysql-community-server-8.4.5-1.el8.x86_6 | Red Hat (RHEL 8.10) | x86 | Warn user when mysql already in LDAP user and/or group causing mysqld not to start at system init |
| 118585 | 2025-07-03 16:35 | 2025-07-04 6:42 | MySQL Server: Optimizer | Verified (488 days) | S5 | 8.0.39, 8.0.42, 8.4.5, 9.3.0 | Ubuntu (Ubuntu 20.04.2) | Any | system variable "range_alloc_block_size" arouse different execution plan |
| 118849 | 2025-08-18 12:14 | 2025-08-18 23:50 | MySQL Server: Optimizer | Verified (443 days) | S3 | 8.0.41 | Any | Any | after add HINT:JOIN_ORDER, the result is wrong. |
| 119011 | 2025-09-15 16:04 | 2025-09-25 16:08 | MySQL Server: Group Replication | Verified (407 days) | S3 | 9.4.0 | Any | Any | Execute some acl statements to a cluster without quorum in group replication makes login stuck |
| 119031 | 2025-09-18 6:12 | 2025-09-23 5:39 | MySQL Server: Parser | Not a Bug (407 days) | S3 | 8.4.6 | MacOS | Any | HAVING clause fails with "Unknown column" for a subquery alias that is valid in GROUP BY |
| 119174 | 2025-10-16 13:18 | 2026-01-13 20:33 | MySQL Server | Not a Bug (295 days) | S3 | 9.4.0 | Any | Any | unexpected value after changing Max to Min |
| 119305 | 2025-11-05 4:02 | 2025-12-16 13:55 | MySQL Server: Optimizer | Verified (323 days) | S3 | 8.0.41 | Linux | x86 | The query results of enabling and disabling materialization are inconsistent. |
| 119669 | 2026-01-13 13:27 | 2026-01-13 14:53 | MySQL Server: Optimizer | Verified (295 days) | S1 | 8.0.44 | Any | Any | Inconsistent behaviour between normal query and prepared statement |
| 119714 | 2026-01-18 12:26 | 2026-01-19 9:01 | MySQL Server: Optimizer | Verified (289 days) | S3 | 8.0.44 | Any | Any | after changing ASIN(hpg31.c1) in group clause,the col_1’s value unexpectedly change. |
| 119724 | 2026-01-20 5:55 | 2026-01-20 8:08 | MySQL Server: Optimizer | Verified (288 days) | S3 | 8.0.44 | Any | Any | after changing asin function in group clause,column's value unexpectedly change |
| 120043 | 2026-03-12 21:19 | 2026-07-28 10:58 | Shell Upgrade Checker | Closed (99 days) | S3 | 8.4.8 | Any | Any | mysql shell server upgrade checks ignoring cross database foreign key references in foreignKeyReferences check |
| 120145 | 2026-03-25 6:05 | 2026-03-25 19:22 | MySQL Server: Optimizer | Verified (224 days) | S2 | 8.0.45 | Linux (ubuntu 20.04) | x86 | Incorrect empty result after relocating a HAVING predicate into a derived-table boolean column with WHERE ref1 |
| 120733 | 2026-06-20 13:38 | 2026-06-22 9:29 | MySQL Server: Optimizer | Verified (135 days) | S1 | MySQL 9.6 | Any | Any | DISTINCTROW with ROW_NUMBER() Derived Table and GROUP BY Causes Duplicate Removal Key to Miss a Non‑Aggregate Column, Me |
| 120834 | 2026-07-02 10:38 | 2026-07-21 16:25 | MySQL Server: Optimizer | Verified (125 days) | S1 | 8.0.46, 8.4.10, 9.7.1 | Any | Any | AVG on Large DOUBLE Values Returns Inconsistent Results Across Execution Paths (Index Scan vs. Temporary Table) |
| 120864 | 2026-07-04 9:34 | 2026-07-04 13:47 | MySQL Server: Optimizer | Duplicate (123 days) | S1 | MySQL 9.7.1 | Any | Any | AGGREGATE_THEN_MERGE Causes Incorrect Column Mapping for GROUP BY Expression, Returning NULL Instead of Actual Value |
| 120903 | 2026-07-13 9:57 | 2026-07-21 15:45 | MySQL Server: Optimizer | Verified (113 days) | S1 | 8.0.46, 8.4.10, 9.7.1 | Any | Any | WITH ROLLUP in Derived Table Incorrectly Evaluates IFNULL Expression Due to Partial NULL Propagation |
| 121063 | 2026-08-07 1:37 | 2026-09-29 14:48 | MySQL Server: Group Replication | Documenting (62 days) | S1 | MySQL 8.4.8 - 8.4.11 | Any | Any | Members of one Group Replication group assign different GNOs to the same transaction |
| 121113 | 2026-08-18 9:22 | 2026-08-19 14:23 | MySQL Server: Optimizer | Verified (77 days) | S3 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | `JSON_QUOTE()` metadata overflow truncates valid output |
| 121389 | 2026-09-29 1:05 | 2026-09-29 5:28 | MySQL Server: Optimizer | Verified (36 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Any | Any | COUNT(DISTINCT) returns a wrong (too small) result on a partitioned table when loose index scan is chosen |
| 121526 | 2026-10-15 21:22 | 2026-10-27 16:59 | Shell Upgrade Checker | Verified (8 days) | S3 | 9.7.1, 26.7.0 | Any | Any | util.checkForServerUpgrade routine syntax check falsely rejects GROUP BY ... WITH ROLLUP in stored routines |
| 121644 | 2026-11-01 7:45 | 2026-11-03 5:29 | MySQL Server: Optimizer | Verified (1 day) | S2 | 8.0.46, 8.4.13, 9.7.4, 26.10.0 | Any | Any | Incorrect ERROR 1054 for a qualified GROUP BY column referenced in HAVING |
| 387 | 2003-05-07 6:02 | 2003-05-13 9:16 | MySQL Server | Closed (8576 days) | S3 | 4.0.12 | pc-linux (i686) | Any | ERROR 1055: 'NULL' isn't in GROUP BY -- in ANSI mode |
| 603 | 2003-06-06 4:35 | 2003-06-06 7:21 | MySQL Server | Not a Bug (8552 days) | S3 | Linux (Linux) | Any | strange behaviour with MAX without GROUP BY | |
| 807 | 2003-07-07 19:10 | 2003-07-09 6:22 | MySQL Server | Closed (8519 days) | S2 | 4.0.12 | pc-linux (i686) | Any | Crash using CASE INTERVAL(...) ... GROUP BY |
| 821 | 2003-07-09 15:59 | 2003-07-16 2:52 | MySQL Server | Closed (8512 days) | S2 | 4.1.0-alpha | Linux (Linux (Redhat 6.1) 2.2.12-20) | Any | Aggregate function or group by in derived table causes disconnect from server |
| 904 | 2003-07-23 20:53 | 2003-08-07 22:21 | MySQL Server: MyISAM storage engine | Not a Bug (8490 days) | S1 | 4.0.14 | Linux (debian linux) | Any | query jumped from 4 seconds to several minutes, join order changed in explain |
| 1981 | 2003-11-28 14:42 | 2003-12-11 10:31 | MySQL Server: MyISAM storage engine | Not a Bug (8364 days) | S3 | 4.0.16 | MacOS (Mac OS X) | Any | Unneccessary use of filesort and temporary table when using GROUP BY |
| 1991 | 2003-12-01 12:26 | 2003-12-01 12:59 | MySQL Server | Closed (8374 days) | S3 | 4.1.0 | Linux (Debian3.0) | Any | Maybe an error in count syntax with GROUP BY |
| 2007 | 2003-12-03 18:58 | 2004-06-01 0:32 | MySQLCC | Closed (8191 days) | S3 | 0.9.3 | Any (all) | Any | mysqlcc doesn't read [client] group |
| 2249 | 2004-01-01 13:33 | 2004-01-02 6:39 | MySQL Server: InnoDB storage engine | Can't repeat (8342 days) | S1 | 4.1.0-alpha | Linux (Linux Redhat 8.0) | Any | Signal 11 Running Join Query |
| 2661 | 2004-02-06 2:59 | 2004-02-24 14:35 | MySQL Server | Can't repeat (8289 days) | S2 | 4.0.15 | Solaris (Solaris 8 SPARC) | Any | Using same key on distinct and group by seems to create a busy-loop in mysql |
| 2898 | 2004-02-20 0:21 | 2004-02-20 12:11 | MySQL Server | Not a Bug (8293 days) | S3 | 4.1.1-alpha | FreeBSD (FreeBSD 4.9-STABLE) | Any | Unexpected result: max() with group by |
| 3845 | 2004-05-21 11:24 | 2004-05-28 13:52 | MySQL Server | Closed (8195 days) | S1 | 4.0.18-standard | Linux (Suse Linux 9.0/WinXP) | Any | wrong FOUND_ROWS result |
| 4623 | 2004-07-19 10:43 | 2004-07-22 15:40 | MySQL Server | Not a Bug (8140 days) | S3 | 4.0.0.18 | Windows (Win 2000 Prof) | Any | bad optimization "group by" clause |
| 5326 | 2004-08-31 21:25 | 2004-09-16 16:11 | MySQL Server | Closed (8084 days) | S2 | 4.1.4gamma | Windows (Windows 2000/Slackware Linux) | Any | subselect with group by causes incorrect ERROR 1054 (42S22): Unknown column |
| 5555 | 2004-09-14 0:23 | 2004-10-05 11:52 | MySQL Server | Closed (8065 days) | S1 | 4.1.4-gamma-standard-log | Linux (Linux 2.6) | Any | "GROUP BY enum_field" returns incorrect results |
| 5754 | 2004-09-26 20:38 | 2008-10-03 16:23 | MySQL Server: Security: Privileges | Not a Bug (6606 days) | S4 | 5.0 | Linux (Linux & Windows) | Any | Please: SCHEMA & GROUP support |
| 5814 | 2004-09-29 21:52 | 2004-10-04 13:26 | MySQL Server | Closed (8066 days) | S1 | 4.1.5-gamma-standard | Linux (Fedora Core 1) | Any | Sub-Select with Group by would return a wrong result |
| 6071 | 2004-10-13 18:43 | 2004-10-13 20:08 | MySQL Server | Not a Bug (8057 days) | S3 | 4.0.21 | Linux (Fedora Core 1) | Any | ORDER BY does not work correctly when combined with GROUP BY and LEFT JOIN |
| 7269 | 2004-12-14 14:36 | 2005-01-14 18:45 | MySQL Server | Closed (7964 days) | S3 | 5.0.3-pre | Linux (Linux / Athlon) | Any | Test failure: 'having' (using '--ps-protocol'), server process crash |
| 7541 | 2004-12-27 10:35 | 2005-01-23 15:34 | MySQL Server | Can't repeat (7955 days) | S1 | 5.0.3-pre | Linux (Linux 2.4 / Athlon) | Any | Test failure: Hang in 'having' (using '--ps-protocol') |
| 8093 | 2005-01-22 20:08 | 2005-01-24 17:19 | MySQL Server: MyISAM storage engine | Closed (7954 days) | S3 | 4.1.8 | Any (*) | Any | GROUP BY can alter some values of a grouped by column |
| 9090 | 2005-03-10 10:30 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5936 days) | S3 | 4.1.x, 5.x | Any | Any | Optimization Problem with a subquery in an IN Operation |
| 9430 | 2005-03-28 7:39 | 2005-04-28 13:51 | MySQL Server | No Feedback (7860 days) | S3 | 5.0.3-beta | Windows (windows 2000 server) | Any | can't group by view fields |
| 9703 | 2005-04-07 2:26 | 2005-05-12 20:17 | MySQL Server: Optimizer | Closed (7846 days) | S2 | 4.1.11 | Linux (RedHat EL3) | Any | Error 1032 with GROUP BY query and large tables |
| 10661 | 2005-05-16 11:05 | 2005-05-17 5:50 | Connector / ODBC | Not a Bug (7841 days) | S1 | 1 | Windows (Windows xp) | Any | Connection poblem B/w PHP 4.3, apache 2 and Mysql 4.1.11 |
| 10982 | 2005-05-31 12:02 | 2005-06-01 3:49 | MySQL Server | Closed (7826 days) | S2 | 5.0 | Any (all) | Any | A query from olap.test returns a wrong result set |
| 11071 | 2005-06-03 12:59 | 2005-06-27 13:27 | MySQL Server: Optimizer | Not a Bug (7800 days) | S1 | 4.1 bk tree | Linux (linux) | Any | SELECT crashes MySQL server |
| 11414 | 2005-06-17 13:05 | 2005-07-25 20:04 | MySQL Server: Optimizer | Closed (7772 days) | S1 | 4.1.13 | Windows (Windows NT) | Any | Crash on Windows with a simple group by query |
| 12556 | 2005-08-12 18:04 | 2005-09-09 0:44 | MySQL Server | Can't repeat (7726 days) | S2 | 4.0.25 | Linux (Linux FC3) | Any | upgrading to 4.0.25 removed mysql user and stops server |
| 13024 | 2005-09-06 23:04 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (7728 days) | S4 | 4.1.14, 5.0.11 | Any | Any | optimizer does not use index when where has (field1,field2,..)=(value1,value2,. |
| 13161 | 2005-09-14 5:30 | 2005-11-04 4:04 | Eventum | Closed (7670 days) | S2 | 1.6.1 | Windows (XP and IE) | Any | Cannot See the Created Issue |
| 13432 | 2005-09-23 16:05 | 2005-10-13 18:37 | MySQL Server | Closed (7692 days) | S4 | ANY | Any (ANY) | Any | C API: sending a group of rows at a time |
| 13461 | 2005-09-24 15:22 | 2005-10-14 8:28 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7691 days) | S2 | 5.1 4.1? 5.0? | Linux (Linux) | Any | Slave Cluster crashed on restart of two data nodes in seperate groups |
| 13863 | 2005-10-08 14:02 | 2006-01-25 20:03 | MySQL Server: Documentation | Closed (7588 days) | S3 | 5.0.13 | Windows (Win XP Professional SP2) | Any | Alternative INTO OUTFILE syntax not documented |
| 13953 | 2005-10-12 8:16 | 2005-10-12 9:44 | MySQL Server | Not a Bug (7693 days) | S3 | 5.0.x | Linux (Linux) | Any | CREATE TABLE with field list and SELECT makes more columns than expected |
| 14019 | 2005-10-13 22:45 | 2006-10-26 3:17 | MySQL Server: Optimizer | Closed (7314 days) | S3 | 4.1.14 / 5.1.13 | Any (*) | Any | group by converts literal string to column name |
| 15201 | 2005-11-23 20:34 | 2006-01-27 15:32 | MySQL Server | No Feedback (7586 days) | S2 | 5.0.15 | Linux (Linux) | Any | Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COE |
| 15917 | 2005-12-21 21:43 | 2006-04-14 14:36 | MySQL Server | Closed (7509 days) | S2 | 5.0.17 | Windows (Windows 2003, Windows XP, OXS) | Any | wrong result in NIST test on Windows for nested SELECT with GROUP BY |
| 16351 | 2006-01-10 19:34 | 2006-01-11 7:19 | MySQL Cluster: Cluster (NDB) storage engine | Can't repeat (7602 days) | S2 | 5.1.5-alpha | Linux (Linux) | Any | DD: Invaild Table Space locked in memory |
| 16386 | 2006-01-11 20:40 | 2006-03-14 10:34 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7540 days) | S2 | 5.1.6-alpha | Linux (Linux) | Any | DD: Cluster fails to create more then 5 logfile groups in extended dll testing |
| 16472 | 2006-01-13 1:54 | 2006-01-26 2:30 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7587 days) | S2 | 5.1 | Linux (Linux) | Any | DD: Maximum path for datafile in CREATE TABLESPACE cannot be more than 167 bytes |
| 16545 | 2006-01-16 18:32 | 2013-10-06 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Duplicate (7594 days) | S2 | 5.1 | Linux (Linux) | Any | DD: NDB engine does not support long file names (up to 256 bytes) |
| 16657 | 2006-01-20 0:16 | 2006-03-14 8:22 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7540 days) | S3 | 5.1 | Linux (Linux) | Any | DD: The max. value for UNDO_BUFFER_SIZE is 17M only. |
| 16721 | 2006-01-23 10:15 | 2006-01-24 15:12 | MySQL Server | Can't repeat (7589 days) | S1 | 5.0.16-Debian_1-log | Linux (Linux debian 2.6.15 sarge) | Any | ERROR 1062 (23000): Duplicate entry in a view (GROUP BY) |
| 16842 | 2006-01-27 14:12 | 2006-01-28 14:02 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7585 days) | S3 | 5.1.6 | Any | DD : Crash on drop logfile group after SR | |
| 17537 | 2006-02-17 23:44 | 2006-03-27 17:17 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (7527 days) | S2 | 5.1.8 | Linux (Linux 64 bit OS) | Any | DD: Drop Tables seemed to be locked into cluster cache |
| 18348 | 2006-03-20 6:36 | 2006-03-23 17:07 | MySQL Server | Won't fix (7531 days) | S4 | Any | AGGREGATE BY clause as alternative to GROUP BY | ||
| 18492 | 2006-03-24 15:53 | 2006-05-02 22:35 | MySQL Server: Prepared statements | Closed (7491 days) | S3 | 5.1.8, 5.0.21, 4.1.19 | Any | mysqld reports ER_ILLEGAL_REFERENCE in --ps-protocol | |
| 18603 | 2006-03-29 4:01 | 2006-04-26 10:35 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7497 days) | S1 | 5.1.9-BK, 5.1.7 | Linux (Linux) | Any | Invalid CREATE LOGFILE GROUP or CREATE TABLESPACE crashes server |
| 18604 | 2006-03-29 5:29 | 2006-04-26 10:50 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7497 days) | S3 | 5.1.9-BK, 5.1.7 | Linux (Linux) | Any | Illegal values permitted for ENGINE in CREATE LOGFILE GROUP |
| 18709 | 2006-04-01 17:23 | 2006-04-04 14:48 | MySQL Server | Can't repeat (7519 days) | S2 | 5.0.19 | Windows (Win32) | Any | group by doesn't work |
| 18710 | 2006-04-01 17:25 | 2006-04-01 17:58 | MySQL Server | Duplicate (7522 days) | S2 | 5.0.19 | Windows (Win32) | Any | group by doesn't work |
| 18813 | 2006-04-05 14:57 | 2020-05-03 20:45 | MySQL Server | Duplicate (7511 days) | S3 | 5.0.21-BK, 5.0.19 | Linux (Linux) | Any | WITH ROLLUP displays empty string instead of NULL if string columns grouped |
| 19201 | 2006-04-19 17:08 | 2006-05-13 14:46 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7480 days) | S2 | 4.1 -> | Linux (Linux) | Any | TRUNCATE table with blobs fails with 1205 |
| 19206 | 2006-04-19 22:02 | 2006-05-02 21:59 | MySQL Server: Documentation | Closed (7491 days) | S2 | 5.1 | Linux (Linux) | Any | Engine hangs trying to read from table that was locked for writing |
| 19452 | 2006-04-30 23:49 | 2006-09-02 1:55 | MySQL Server: Installing | Closed (7368 days) | S3 | 5.0, 5.1 | Any | mysql_upgrade: reads [client] group, but doesn't understand host option | |
| 20128 | 2006-05-29 15:55 | 2006-06-30 11:14 | MySQL Server: Optimizer | Not a Bug (7432 days) | S2 | 5.0 | Any | outer JOIN + GROUP BY: wrong result | |
| 20344 | 2006-06-08 15:46 | 2019-10-29 21:03 | MySQL Server: DML | Closed (2563 days) | S4 | 5.0.21-max | MacOS (OS X) | Any | Order BY requires column presence in SELECT |
| 20621 | 2006-06-22 8:09 | 2006-06-22 9:07 | MySQL Server | Can't repeat (7440 days) | S2 | 5.021 | Linux (Linux fedora core 4) | Any | query with adddate in group by makes server crash |
| 20672 | 2006-06-23 22:51 | 2006-08-16 8:40 | MySQL Cluster: Cluster (NDB) storage engine | Can't repeat (7385 days) | S2 | 5.1 | Linux (Linux) | Any | NDB regression fails if mysql-5.1 compiled with gcc4 |
| 21037 | 2006-07-13 14:09 | 2006-08-13 18:52 | MySQL Server: Views | No Feedback (7388 days) | S1 | 5.0.17 | Windows (XP) | Any | View With group by -- sql-mode : Only_Full_Group_By |
| 21172 | 2006-07-20 3:47 | 2006-09-01 13:29 | MySQL Cluster: Disk Data | Closed (7369 days) | S2 | 5.1.11 | Linux (Debian Sarge 3.1) | Any | Cluster will not restart, configuration error |
| 22292 | 2006-09-13 2:18 | 2006-09-23 11:40 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7347 days) | S2 | 5.0.24a | Linux (CentOS 4.4 x86_64) | Any | Cluster node dies while loading large dump file |
| 23182 | 2006-10-11 16:18 | 2006-12-15 22:24 | MySQL Server | Can't repeat (7264 days) | S1 | 5.0.27-BK, 5.0.24a | Linux (Linux app 2.6.18 ) | Any | Got an error when using aliases in a view, thought the select works |
| 23205 | 2006-10-12 9:36 | 2006-10-12 14:00 | MySQL Server | Can't repeat (7328 days) | S3 | 4.1.20 | Linux (Linux) | Any | Incorrect SUBSTRING result if using negative lenghts with InnoDB and GROUP BY |
| 23370 | 2006-10-17 13:32 | 2006-10-20 9:11 | MySQL Server | Duplicate (7320 days) | S1 | mysql-5.1.11-beta-win32 and 5.1.26 | Linux (Linux and Win) | Any | Bad nested group by performance |
| 23639 | 2006-10-25 17:35 | 2006-10-31 4:41 | MySQL Enterprise Monitor: Web | Closed (7309 days) | S2 | mysqlnetwork-0.6.33 | Linux (Fedora Core 3 (i386)) | Any | Filter events by rule group |
| 24114 | 2006-11-08 23:43 | 2007-05-10 13:08 | MySQL Enterprise Monitor: Web | Closed (7118 days) | S4 | 1.0.0 | Any (all) | Any | selecting no notifcations and a notification group results in an error |
| 24352 | 2006-11-16 6:11 | 2007-11-20 9:12 | MySQL Server | Can't repeat (6924 days) | S2 | 4.1.22, 4.1.9-nt-max-log | Windows (Windows XP) | Any | "=" operator failed rather than "LIKE" operator in GROUP BY statement |
| 24560 | 2006-11-23 21:48 | 2007-04-30 9:30 | MySQL Cluster: Disk Data | Closed (7128 days) | S2 | 5.1.14-bk | Linux (Linux FC4) | Any | UNDO_BUFFER_SIZE <= 64K in CREATE LOGFILE GROUP -> data node failure |
| 24714 | 2006-11-30 7:30 | 2007-08-20 15:40 | MySQL Server: Optimizer | Won't fix (7016 days) | S1 | 4.1.22, 4.1 BK | Linux (Linux, FreeBSD) | Any | Mathematical SELECT queries no longer return consistent results |
| 25373 | 2007-01-02 19:48 | 2007-03-15 15:32 | MySQL Server | Closed (7174 days) | S2 | 5.0.30, 5.1bk | Linux (linux) | Any | rollup grand total not have NULL for group by field basd on stored function |
| 25428 | 2007-01-05 7:06 | 2012-05-18 20:19 | MySQL Cluster: Disk Data | Duplicate (7243 days) | S2 | MySQL 5.1.14 | Linux (RHEL 4) | Any | The Text column, not being indexed, although it is still stored in memory |
| 25777 | 2007-01-23 11:44 | 2012-05-18 20:19 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (7083 days) | S2 | 5.0.37 | FreeBSD (FreeBSD 6.2) | Any | mysqld segfaults when used in NDB cluster |
| 26209 | 2007-02-09 6:47 | 2007-02-26 20:54 | MySQL Server: Views | Closed (7191 days) | S2 | 5.0.36-BK, 5.0.27 | Linux (Linux, winXP) | Any | wrong result using COUNT(DISTINCT ?) querying a VIEW with GROUP BY and ORDER BY |
| 26516 | 2007-02-21 4:21 | 2007-02-21 15:15 | MySQL Enterprise Monitor: Configuration | Closed (7196 days) | S1 | 1.1.0.4789 | Linux (linux) | Any | server inst - group # syntax error in httpd.conf |
| 26830 | 2007-03-04 5:43 | 2007-03-15 3:00 | MySQL Server: General | Closed (7174 days) | S1 | 5.0.38BK, 5.1.17BK | Any (*) | Any | subquery, group by .. with rollup crashes server |
| 26943 | 2007-03-07 23:57 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (6192 days) | S2 | 5.0.27, 5.0.22, 5.0.68 | Linux (linux(centos 4.4 server)) | Any | 64bit mysql 5 hangs on removing duplicate after query distinct,group by,order by |
| 27229 | 2007-03-16 21:25 | 2007-04-11 1:59 | MySQL Server | Closed (7147 days) | S3 | 5.0.38/5.1BK | FreeBSD (freebsd) | Any | crash/incorrect result in subquery with aggregate(outer_column) (debug server) |
| 27721 | 2007-04-09 20:12 | 2012-05-30 7:05 | MySQL Server: Stored Routines | Verified (5272 days) | S4 | 5.1 | Any | Any | In current Event Scheduler you cannot relate one temporal event to another one |
| 28601 | 2007-05-22 16:49 | 2007-05-23 9:04 | MySQL Server: Parser | Can't repeat (7105 days) | S3 | 5.0.41 | Any | Any | Incoherent results when using GROUP BY (regression) |
| 29438 | 2007-06-29 3:36 | 2007-07-29 8:21 | MySQL Server: General | No Feedback (7038 days) | S3 | 5.0.41 | Any | Any | rollup with multiple "group by" column repeats last grouping column final rollup |
| 29530 | 2007-07-03 20:15 | 2007-07-27 12:59 | MySQL Server: Documentation | Closed (7040 days) | S3 | 5.1 | Any | Any | undocumented options in 'create logfile group' & 'create tablespace' statements |
| 29606 | 2007-07-06 18:57 | 2009-07-20 9:44 | MySQL Server: General | Not a Bug (6316 days) | S4 | 5.1 | Any | Any | LAST ENTRY of a GROUP BY sql statement |
| 29796 | 2007-07-13 20:39 | 2007-08-13 21:49 | MySQL Server | No Feedback (7023 days) | S3 | 5.0.41 | Windows (XP Professional 5.1.2600) | Any | Correlated subquery return zero rows when Group By included in the outer query |
| 29845 | 2007-07-17 13:10 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (6931 days) | S4 | 6.0.0-alpha | Any | Any | GROUP BY does not make best use of indicies when evaluating SUM aggregates |
| 29975 | 2007-07-23 9:51 | 2007-07-23 10:52 | MySQL Server: General | Not a Bug (7044 days) | S3 | 5.0.37 | Linux (Fedora 7.9 (dev)) | Any | TIME_TO_SEC does never return more than 3020399 (838:59:59) |
| 30075 | 2007-07-26 15:33 | 2014-03-13 13:36 | MySQL Enterprise Monitor: Web | Won't fix (7019 days) | S4 | 1.2.0 | Any | Any | Allow reordering of servers within a group |
| 30089 | 2007-07-27 3:33 | 2007-07-27 18:17 | MySQL Server: User-defined functions ( UDF ) | Can't repeat (7040 days) | S2 | 5.1.20 | Linux (SuSE Enterprise 9.0, OpenSuSE 10.2) | Any | UDF aggregate functions crash when included in order by clause |
| 30109 | 2007-07-27 23:29 | 2007-07-30 14:37 | MySQL Server: General | Not a Bug (7037 days) | S2 | 4.1.20,4.1.23 - 5.0 | Linux | Any | Ambiguous ORDER BY behavior change |
| 30760 | 2007-09-02 3:30 | 2008-02-10 5:28 | MySQL Server | No Feedback (6842 days) | S5 | 5.0.45 | Linux | Any | mysql 5.0.45 is slower than 5.0.41 and more than 5.0.33 |
| 31714 | 2007-10-19 11:35 | 2021-05-02 20:45 | MySQL Cluster: Disk Data | Verified (6949 days) | S3 | mysql-5.1 | Linux | Any | No usefull feedback when trying to create tablespace with nonexistant log group |
| 31772 | 2007-10-23 2:33 | 2011-02-16 23:43 | MySQL Cluster: Disk Data | Closed (6467 days) | S3 | 5.1.22 | Any | Any | Select statement got warning after add a long name log/data file |
| 31782 | 2007-10-23 10:58 | 2011-02-16 23:43 | MySQL Cluster: Disk Data | Closed (6110 days) | S3 | mysql-5.1 | Linux | Any | No way to detect empty tablespaces using SQL |
| 31825 | 2007-10-24 20:35 | 2007-10-25 17:13 | MySQL Server: General | Can't repeat (6950 days) | S2 | 5.0.41 | Windows (Not tested on other OS'es) | Any | GROUP BY problem |
| 32482 | 2007-11-18 17:45 | 2008-01-14 19:09 | MySQL Server: DML | Closed (6869 days) | S2 | 5.1.22-rc-log | Linux | Any | crash with GROUP BY alias_of_user_variable WITH ROLLUP |
| 32931 | 2007-12-03 14:38 | 2008-02-06 16:03 | MySQL Workbench | Closed (6846 days) | S3 | 5.0.10 | Windows | Any | Routines Group Editor does not handle dragging routines correctly |
| 33049 | 2007-12-06 21:52 | 2008-03-15 9:14 | MySQL Server: Views | Closed (6808 days) | S3 | 5.0.56-debug, 5.1.24-rc-debug, 6.0.4-debug, 6.0.5pre-DEBUG | Any | Any | Assert while running test-as3ap test(mysql-bench suite) |
| 33808 | 2008-01-10 20:52 | 2008-03-14 18:43 | Connector / ODBC | Closed (6809 days) | S2 | 5.1.1 | Windows (xp2 sp2) | Any | MyODBC 51/Access ODBC CONVERT() causes error |
| 34203 | 2008-01-31 19:31 | 2008-03-01 8:38 | MySQL Workbench | No Feedback (6822 days) | S2 | 5.0.12 | Any | Any | Stops responding |
| 34347 | 2008-02-06 12:29 | 2008-02-06 13:27 | MySQL Server: General | Can't repeat (6846 days) | S2 | 5.0.51 | Linux (Debian AMD64) | Any | ORDER BY fails if result is grouped with GROUP BY |
| 34763 | 2008-02-22 19:20 | 2008-04-14 19:22 | MySQL Server: Optimizer | Closed (6778 days) | S3 | 5.0+ | Any | Any | item_subselect.cc:1235:Item_in_subselect::row_value_transformer:Assertion failed |
| 35002 | 2008-03-03 14:17 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6819 days) | S2 | 5.1.23-rc/5.1BK/5.0/6.0 | Linux (2.6.22.9-61.fc6) | Any | Wrong results returned when using derived table and group by |
| 35038 | 2008-03-04 15:40 | 2010-05-26 18:00 | MySQL Server: Falcon storage engine | Unsupported (6006 days) | S3 | 6.0-falcon-team | Any | Any | Falcon crash on I_S query in RecordVersion::fetchVersion line 98 |
| 36314 | 2008-04-24 11:16 | 2008-04-24 11:47 | MySQL Server: Documentation | Not a Bug (6768 days) | S3 | all | Any | Any | GRANT is missing in SQL documentation |
| 36511 | 2008-05-05 16:09 | 2008-05-05 16:41 | MySQL Server: General | Not a Bug (6757 days) | S2 | 5.0.51 | Any | Any | MySQL allows fields in SELECT list that are not in the GROUP BY statement |
| 36772 | 2008-05-16 23:04 | 2011-02-16 23:43 | MySQL Server: Charsets | Closed (6540 days) | S2 | 5.0BK/5.1BK/6.0BK | Any (Ubuntu (5.0.38-Ubuntu_0ubuntu1.4-log) and WinXP (5.0.45-community-nt)) | Any | When using UTF8, CONVERT with GROUP BY returns truncated results |
| 37870 | 2008-07-04 13:00 | 2008-11-11 21:35 | MySQL Server: Optimizer | Closed (6567 days) | S1 | 5.0 -r2646, 5.1 - r2673 , 6.0 - r2764 | Any | Any | Assertion in convert_constant_item: result = 0 |
| 37954 | 2008-07-08 2:22 | 2011-02-16 23:43 | MySQL Enterprise Monitor | Closed (6680 days) | S3 | 1.3.2.9126 | Any | Any | java.lang.NullPointerException when creating server group |
| 38217 | 2008-07-17 21:35 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6204 days) | S3 | 5.0.60, 5.0.64, 5.1.28 | Any | Any | GROUP BY with subquery fails. |
| 38297 | 2008-07-22 20:04 | 2014-12-21 3:15 | MySQL Server: User-defined functions ( UDF ) | Verified (6678 days) | S3 | 5.0, 5.1 | Windows (Vista Ultimat) | Any | aggregate UDF xxx_init / deinit only called once for aggregation with rollup |
| 38858 | 2008-08-18 13:56 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (6651 days) | S4 | Any | Any | ORDERGROUP BY construct | |
| 38859 | 2008-08-18 14:17 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (6651 days) | S4 | 6.0 | Any | Any | limiting a group - LIMITGROUP |
| 39168 | 2008-09-01 19:54 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5865 days) | S2 | any | Any | Any | ERROR: the age of the last checkpoint ... exceeds the log group capacity |
| 39169 | 2008-09-01 22:17 | 2008-10-10 8:06 | MySQL Server: DML | No Feedback (6599 days) | S1 | 6.0.4alpha, 6.0.6alpha | Windows (Windows XP Home) | Any | Unexpected behaviour when using GROUP BY and/or WHERE clauses |
| 40037 | 2008-10-15 9:34 | 2011-10-20 3:46 | MySQL Server: Optimizer | Closed (5494 days) | S3 | 5.x, 6.x | Any | Any | Incorrect result from MIN/MAX when no GROUP, and independent subquery predicate |
| 40195 | 2008-10-21 8:35 | 2008-10-21 17:46 | MySQL Server: InnoDB storage engine | Not a Bug (6588 days) | S5 | 5.1.28 | Linux (SLES10) | Any | Slowdown queries by the use of groupby in Innodb |
| 40884 | 2008-11-20 13:16 | 2011-02-16 23:43 | Tests: Server | Closed (6496 days) | S3 | 6.0-TRUNK | Solaris (Solaris 10) | Any | main.group_min_max crashes regularly on some Solaris 10 boxes |
| 41036 | 2008-11-25 22:23 | 2021-05-02 20:45 | MySQL Cluster: Disk Data | Verified | S4 | mysql-5.1-telco-7.0 | Any | Any | Easier Configuration Change On Cluster Disk Objects |
| 41074 | 2008-11-27 15:55 | 2011-02-16 23:43 | MySQL Server: Packaging | Closed (6494 days) | S3 | 5.1.30, 5.0.70, 6.0.8 | Solaris | Any | Grammatical error in error message from install/request in Solaris package |
| 41266 | 2008-12-05 15:36 | 2011-02-16 23:43 | MySQL Enterprise Monitor: Web | Closed (6503 days) | S3 | 2.0.0.7119 | Any | Any | rename group fails if the new name differs only in case from existing name |
| 41274 | 2008-12-06 2:50 | 2021-05-02 20:45 | MySQL Cluster: Disk Data | Verified (6542 days) | S3 | mysql-5.1-telco-6.3 | Linux | Any | error 1504 'Out of logbuffer memory' message is too vague |
| 41533 | 2008-12-17 9:50 | 2011-02-16 23:43 | MySQL Server | No Feedback (6500 days) | S2 | 5.1.24 | Linux | Any | Duplicated rows |
| 42236 | 2009-01-21 11:02 | 2009-01-23 9:18 | MySQL Server: Views | Not a Bug (6494 days) | S3 | 5.1.30-community | Windows | Any | ORDER BY and/or GROUP BY behaves badly together with views. |
| 42480 | 2009-01-30 14:13 | 2021-05-02 20:45 | MySQL Cluster: Disk Data | Verified (6487 days) | S3 | mysql-5.1-telco-6.3 | Linux | Any | Low setting for SharedGlobalMemory gives erroneous error 707 msg |
| 42955 | 2009-02-18 4:07 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5826 days) | S2 | 6.0-bzr | Any | Any | Wrong results returned by join queries with group by/order by when BKA is used |
| 43241 | 2009-02-26 17:54 | 2021-05-02 20:45 | MySQL Cluster: Disk Data | Verified | S3 | mysql-5.1-telco-6.3 | Any | Any | Inconsistancy in warnings on create table / create tablespace with unknown engin |
| 43474 | 2009-03-07 16:55 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (6413 days) | S1 | 6.0-falcon-team | Any | Any | Invalid page number referenced from IndexRootPage::findLeaf() |
| 43669 | 2009-03-16 9:16 | 2013-11-19 18:19 | MySQL Server: Data Types | Unsupported (4733 days) | S3 | 6.0.11 | Any | Any | Falcon returns diff. no of digits than other engines with MIN() for YEAR values |
| 43815 | 2009-03-24 0:47 | 2011-02-16 23:43 | MySQL Enterprise Monitor: Server | Closed (6375 days) | S2 | 2.0.5.7153 | Any | Any | New topology is not discovered after previous replication group is renamed |
| 43912 | 2009-03-27 13:56 | 2012-10-16 5:00 | MySQL Server: DML | Won't fix (5132 days) | S3 | 5.0.91 | Any | Any | 'Column * cannot be null' when derived table has count() with no results |
| 44775 | 2009-05-11 7:47 | 2018-09-25 21:50 | Tools: MTR / mysql-test-run | Closed (6348 days) | S7 | Windows | Any | MTR fails to bootstrap mysqld on Windows in Pushbuild 2 | |
| 45261 | 2009-06-02 10:47 | 2011-02-16 23:44 | MySQL Server: Stored Routines | Closed (6081 days) | S3 | 5.1,5.4 | Any | Any | Crash, stored procedure + decimal |
| 45361 | 2009-06-07 21:58 | 2009-06-11 19:19 | MySQL Server: Parser | Not a Bug (6355 days) | S3 | any | Any | Any | parser behaves too primitive here! |
| 45373 | 2009-06-08 13:14 | 2022-09-04 20:45 | MySQL Server: Optimizer | Verified (6347 days) | S3 | 5.1.35-community, 5.1.36-bzr | Any | Any | INDEX FOR GROUP BY is not used if there is a LIMIT clause in the query |
| 45386 | 2009-06-09 3:52 | 2011-02-16 23:44 | MySQL Server: DML | Closed (6245 days) | S3 | 5.0.81, 5.0, 5.1, 6.0 bzr | Solaris | Any | Wrong query result with MIN function in field list, WHERE and GROUP BY clause |
| 45632 | 2009-06-20 7:49 | 2018-09-07 11:55 | MySQL Server: Query Cache | Won't fix (2980 days) | S3 | 5.1 bzr | Linux (x86) | Any | query_cache_debug.test fails |
| 45897 | 2009-07-02 5:51 | 2013-02-05 15:15 | MySQL Workbench | Can't repeat (5020 days) | S2 | 5.1.16 | Any | Any | Do not add the name of the stored procedure in the routine group |
| 45963 | 2009-07-06 8:48 | 2009-07-06 10:41 | MySQL Server: DML | Not a Bug (6330 days) | S4 | 5.0.75-0ubuntu10.2 (Ubuntu) | Any | Any | DWIM: Allow group functions in WHERE clause, by doing GROUP BY first |
| 46004 | 2009-07-07 12:33 | 2012-05-18 20:19 | MySQL Server: InnoDB storage engine | Duplicate (5882 days) | S2 | 5.1 | Any | Any | Crash in row_sel_field_store_in_mysql_format on a SELECT + LIMIT |
| 46038 | 2009-07-08 11:12 | 2011-02-16 23:44 | MySQL Enterprise Monitor: Server | Closed (6315 days) | S3 | 2.1.0.1074 | Any | Any | MEM Admin setting does not save when creating a notification group |
| 46211 | 2009-07-15 18:16 | 2020-12-08 17:41 | MySQL Server: Parser | Not a Bug (2157 days) | S3 | Any | Any | SQL_BIG_RESULT, SQL_SMALL_RESULT, SQL_BUFFER_RESULT should be mutually exclusive | |
| 46344 | 2009-07-23 8:08 | 2015-01-09 10:37 | MySQL Enterprise Monitor: Web | Closed (4317 days) | S4 | Any | Any | [graphs]: Show hint with instance name which caused maximum contribution | |
| 46742 | 2009-08-15 13:30 | 2011-06-09 20:49 | Connector / NET | Closed (5627 days) | S3 | 6.0.4, 6.3.6 | Windows (windows 7) | Any | use " group by" statement in ado.net enetiy framework |
| 46923 | 2009-08-25 18:07 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (6078 days) | S2 | 5.1.37, 5.1.39, 5.4.x | Any | Any | select count(*) from partitioned table fails with ONLY_FULL_GROUP_BY |
| 46986 | 2009-08-28 22:08 | 2012-05-18 20:19 | MySQL Enterprise Monitor: Web | Verified (6165 days) | S3 | 2.0.6.7159 | Any | Any | SQL formatter fails for SELECT ... WHERE .. NOT IN ( SELECT ... ) GROUP BY |
| 47106 | 2009-09-03 16:44 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (6165 days) | S3 | 5.1, 5.4/6.0 | Any | Any | Crash / segfault on adding EXPLAIN to a non-crashing query |
| 47649 | 2009-09-25 13:25 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (6081 days) | S3 | 5.1,6.0.14 | Any | Any | crash during CALL procedure |
| 47650 | 2009-09-25 16:53 | 2011-02-16 23:44 | MySQL Server: DML | Closed (6081 days) | S3 | 5.0.X, 5.1.39, next-mr | Any (Mac OS X Snow leopard, Linux) | Any | using group by with rollup without indexes returns incorrect results with where |
| 48475 | 2009-11-02 14:06 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (6081 days) | S3 | 5.0.88, 5.1.41 | Any | Any | DISTINCT is ignored with GROUP BY WITH ROLLUP and only const tables |
| 49326 | 2009-12-02 5:22 | 2012-07-04 14:49 | MySQL Server: Replication | Closed (5236 days) | S4 | 5.0,5.1 | Any | Any | Support group commit for the binlog |
| 49360 | 2009-12-02 17:53 | 2013-02-03 19:22 | MySQL Server: Optimizer | No Feedback (5694 days) | S3 | 5.0.66 , 5.0.84 , 5.0.84 , 5.1.41, 5.1.43 | Any | Any | In some circumstances, GROUP BY WITH ROLLUP is faster then GROUP BY |
| 49431 | 2009-12-03 22:05 | 2018-06-24 20:45 | MySQL Workbench: Modeling | No Feedback (6069 days) | S2 | 5.2.10 r4680 | Any (XP) | Any | Routine groups seems busted |
| 49846 | 2009-12-21 12:42 | 2018-02-07 22:16 | MySQL Server: Optimizer | Closed (3192 days) | S3 | 5.0.90, 5.1.34-log, 5.1.41 | Any | Any | Valid dependent views result with ERROR 1055 (42000): 'xxx' isn't in GROUP BY |
| 50843 | 2010-02-02 18:12 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5981 days) | S2 | 5.1.42 | Any | Any | Optimizer ignores clustered index for GROUP BY even when it improves performance |
| 50910 | 2010-02-04 12:05 | 2011-02-16 23:44 | MySQL Server: Documentation | Closed (6117 days) | S3 | 5.1+ | Any | Any | confusing docs lines about replication group termination wth stop slave |
| 51111 | 2010-02-11 16:21 | 2011-02-16 23:44 | MySQL Cluster: Disk Data | Closed (6088 days) | S3 | mysql-5.1-telco-6.3 | Any | Any | ALTER LOGFILE GROUP missing error message |
| 51318 | 2010-02-19 10:48 | 2025-12-07 20:45 | MySQL Server: DDL | Verified | S4 | 5.1 | Any | Any | implement "if exists" for DROP LOGFILE GROUP, DROP TABLESPACE commands |
| 51439 | 2010-02-24 1:43 | 2011-02-16 23:44 | MySQL Proxy: Documentation | Closed (6095 days) | S3 | 0.8.0 | Any | Any | doc refers to [proxy] group in config file instead of [mysql-proxy] |
| 52029 | 2010-03-13 12:26 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6071 days) | S5 | 5.1.44 | Any | Any | GROUP BY results in much slower query |
| 52156 | 2010-03-17 19:09 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified (6008 days) | S3 | mysql-5.1-telco-6.3 | Any | Any | Incomplete log message shows wrong log group |
| 53144 | 2010-04-25 17:09 | 2010-04-25 17:29 | MySQL Server: General | Not a Bug (6037 days) | S3 | 5.0.88 | Any | Any | GROUP BY with ROLLUP includes previous data in rollup |
| 53544 | 2010-05-10 16:50 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5826 days) | S2 | 5.1.47, 5.6.99-m4 Dahlia, bzr_mysql-6.0-codebase-bugfixing | Any | Any | Server hangs during JOIN query in stored procedure called twice in a row |
| 55602 | 2010-07-28 13:35 | 2011-02-16 23:44 | MySQL Server | No Feedback (5912 days) | S2 | 5.1.46 | Solaris (10, 64 bit) | Any | select count(*) + order by desc + limit + partitioning delivers not all results |
| 56118 | 2010-08-19 13:12 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5833 days) | S3 | 5.1.49, 5.5.6-m3, 5.6.99 | Any | Any | STOP SLAVE does not wait till trx with CREATE TMP TABLE ends, replication aborts |
| 57334 | 2010-10-08 4:58 | 2011-02-16 23:44 | MySQL Server | Can't repeat (5871 days) | S3 | 5.1.45 | Any | Any | FULL OUTER JOIN is not working |
| 57813 | 2010-10-28 14:40 | 2018-12-09 20:45 | MySQL Enterprise Monitor: Web | Verified (5851 days) | S3 | 2.3.0.2036 | Any | Any | MEM Dashboard: could not insert: [com.mysql.etools.monitor.pom.hib.HibNamed |
| 58775 | 2010-12-07 0:55 | 2010-12-07 4:19 | MySQL Server: Errors | Not a Bug (5811 days) | S3 | 5.1.52 | Any | Any | Table Field Name - Group |
| 58838 | 2010-12-09 12:05 | 2011-03-03 2:27 | MySQL Server: Optimizer | Closed (5725 days) | S3 | 5.6.1-m5 | Any | Any | Wrong results with HAVING + LIMIT without GROUP BY when ICP is enabled |
| 59502 | 2011-01-14 13:13 | 2011-02-16 23:44 | MySQL Cluster: Disk Data | Closed (5761 days) | S3 | Any | Any | race condition in drop logfile group | |
| 60023 | 2011-02-08 21:45 | 2014-05-22 12:13 | MySQL Server: Optimizer | Verified | S5 | 5.5.8 , 5.1.51 | Any | Any | No Loose Index Scan for GROUP BY / DISTINCT on InnoDB partitioned table |
| 60589 | 2011-03-22 15:06 | 2011-03-22 17:12 | Connector / NET | Duplicate (5706 days) | S1 | 6.3.6 | Any | Any | LINQ Group By Generating Broken Query |
| 60702 | 2011-03-30 23:25 | 2011-04-05 14:55 | MySQL Server: Optimizer | Verified (5697 days) | S5 | 5.1.57 | Any | Any | GROUP BY orders when used inside a UNION query, though it should not |
| 61943 | 2011-07-21 13:16 | 2012-07-11 9:38 | MySQL Server: DML | Verified (5233 days) | S4 | 5.5.12 | Any | Any | Syntax to specify a field from select_expr for Group By |
| 62496 | 2011-09-22 1:09 | 2012-07-27 8:37 | MySQL Workbench: Modeling | Closed (5213 days) | S3 | 5.2.34 CE | Windows (Win7 Pro, 64 bit) | Any | Synchronization issue in data modeling when adding routine in a routine group. |
| 64001 | 2012-01-11 18:35 | 2012-12-13 18:23 | MySQL Workbench: Administration | Duplicate (5074 days) | S3 | 5.2.37 | Linux (Ubuntu 10.10, 11.10) | Any | Moving a connection to a group makes it dissappear |
| 64002 | 2012-01-11 20:01 | 2012-01-19 11:52 | MySQL Server: Optimizer | Verified (5410 days) | S1 | 5.5.19 | Any (Debian, Windows XP) | Any | Aggregate queries with multiple columns and no GROUP BY produce bogus results |
| 64988 | 2012-04-15 22:10 | 2012-04-24 19:06 | MySQL Server | Closed (5307 days) | S3 | 5.5.23 | Linux | Any | FLUSH LOGS failed when large_pages is on |
| 66967 | 2012-09-26 8:17 | 2012-09-27 11:37 | MySQL Server: Optimizer | Duplicate (5151 days) | S2 | 5.5.27 | Linux | Any | Index is not used for MyISAM table with SELECT+GROUP BY |
| 67089 | 2012-10-04 18:50 | 2014-11-19 7:51 | MySQL Server: Logging | Verified (4368 days) | S4 | 5.1.54, 5.6.21 | Any | Any | Mysql error log group owned by root. |
| 68086 | 2013-01-15 8:41 | 2013-01-15 19:28 | MySQL Server: Memory storage engine | Verified (5041 days) | S3 | 5.5.29, 5.5.30, 5.7.1 | Any | Any | Heap tables don't use index for group by |
| 68640 | 2013-03-11 20:01 | 2013-03-14 13:44 | MySQL Server: Optimizer | Not a Bug (4983 days) | S3 | 5.5.29 | Linux (RHEL 6.3) | Any | Optimizer does not handle group by properly in insert...select |
| 69470 | 2013-06-14 9:33 | 2013-06-14 13:08 | MySQL Server: DML | Duplicate (4891 days) | S3 | 5.6.10 | Linux | Any | Use "group by", but no aggregate function, get weird result |
| 69590 | 2013-06-26 15:59 | 2018-03-14 20:53 | MySQL Server: DML | Closed (3157 days) | S3 | 5.5.32 | Any | Any | Problem using between with group by functions |
| 69684 | 2013-07-07 10:44 | 2014-06-02 14:33 | MySQL Server: DML | Closed (4551 days) | S2 | 5.5, 5.6 | Any | Any | The update and select behave differently under the same conditions. |
| 70880 | 2013-11-11 14:31 | 2013-12-13 1:00 | MySQL Server | No Feedback (4710 days) | S2 | 5.5.24-log | Any | Any | GROUP BY function produces truncated columns in combination with CONV() or BIN() |
| 71206 | 2013-12-22 17:13 | 2013-12-31 20:00 | MySQL Server: Optimizer | Verified (4699 days) | S1 | 5.5.32-0ubuntu0.12.04.1-log, 5.6.15, 5.1.72, 5.5.35, 5.7.3 | Linux (ubuntu 12.04) | Any | GROUP_CONCAT changes GROUP BY behavior |
| 71766 | 2014-02-19 0:06 | 2014-03-11 6:39 | MySQL Fabric | Closed (4621 days) | S2 | 1.4.0 | Linux (2.6.39-200.24.1.el6uek.x86_64) | Any | mysqlfabric group destroy command failure |
| 71942 | 2014-03-05 15:21 | 2014-03-05 15:53 | MySQL Server | Not a Bug (4627 days) | S5 | Any | Any | Select * -- does it have to be "indeterminate" when using ORDER BY and GROUP BY | |
| 72357 | 2014-04-16 13:22 | 2014-08-26 18:14 | MySQL Workbench: Modeling | Can't repeat (4453 days) | S3 | 6.1.4 | Windows (7 64bit) | Any | Crash-prone Routine Groups. |
| 72553 | 2014-05-06 15:00 | 2014-05-23 3:50 | MySQL Fabric | Closed (4548 days) | S3 | 1.4.0 | Any | Any | Concurrency control is not locking the right objects |
| 72814 | 2014-05-30 9:31 | 2014-07-18 18:56 | MySQL Server: Optimizer | Verified (4538 days) | S3 | 5.6.17 | Any | Any | Assertion `!(ordered_index_usage == ordered_index_void && ... fails |
| 72988 | 2014-06-12 15:36 | 2015-03-24 18:04 | MySQL Server: Replication | Closed (4346 days) | S2 | 5.7 | Any | Any | Slave thread fails with MTS + GTID + replicate_same_server_id |
| 73873 | 2014-09-10 9:44 | 2014-09-30 19:15 | MySQL Fabric | Closed (4418 days) | S2 | Any | Any | Locking error in the failure detector | |
| 74505 | 2014-10-22 12:22 | 2019-11-20 21:46 | MySQL Server: DML | Can't repeat (2541 days) | S3 | 5.6.20-debug | Linux (CentOS 7) | Any | Assertion tab->select->quick->index==(uint)best_key' in test_if_skip_sort_order |
| 74763 | 2014-11-10 12:39 | 2015-02-03 3:14 | MySQL Workbench | Closed (4292 days) | S2 | 6.2.3.12312 build 2280, 64bit | Windows (8.1) | Any | Can't see all connections in a group |
| 75668 | 2015-01-28 16:21 | 2015-01-28 20:10 | MySQL Server: Optimizer | Verified (4298 days) | S2 | 5.6.22/5.7 | FreeBSD (FreeBSD 8.4) | Any | Use of Distinct, Group_concat, and Group by together produces 1 NULL row result. |
| 76099 | 2015-03-02 14:20 | 2015-04-07 22:57 | MySQL Server: Replication | Closed (4251 days) | S3 | 5.7.7 | Any | Any | Make rpl.rpl_sp_privileges test work with Group Replication |
| 76283 | 2015-03-12 9:50 | 2017-10-24 14:22 | MySQL Server: Optimizer | Closed (3362 days) | S3 | 5.7 | Any | Any | Incorrect result for DISTINCT SELECT |
| 77392 | 2015-06-17 16:22 | 2016-04-27 15:05 | MySQL Server: Replication | Closed (4076 days) | S3 | 5.7.7 | Any | Any | Slave group event parser does not recognize XA ROLLBACK as a boundary |
| 77996 | 2015-08-08 23:55 | 2017-07-06 19:20 | MySQL Fabric: Executor | Won't fix (4089 days) | S3 | 1.5.3 | Ubuntu (14.04LTS) | Any | Fabric does not stop replication when server is removed from active group. |
| 79044 | 2015-10-31 19:28 | 2021-03-31 11:39 | MySQL Server: Optimizer | Verified (2044 days) | S4 | 5.7, 8.0 | Any | Any | group by WITH CUBE |
| 79149 | 2015-11-06 5:54 | 2015-12-17 8:30 | Connector / NET | Can't repeat (3975 days) | S1 | MySQL 5.7 | Windows | Any | Connecting MySQL Fabric through Connector/NET 6.9.8 |
| 80131 | 2016-01-24 21:05 | 2016-02-01 15:43 | MySQL Server: Optimizer | Not a Bug (3929 days) | S1 | 5.7.10 | Windows (i) | Any | The 'group' statement has changed it's behaviour in 5.7.10 |
| 80224 | 2016-02-01 19:13 | 2016-02-15 9:00 | MySQL Server: Optimizer | Verified (3915 days) | S3 | 5.5.46, 5.6.28, 5.7.11 | Any | Any | CONCAT_WS duplication of arguments when used in conjunction with HAVING |
| 80244 | 2016-02-02 23:30 | 2020-08-16 17:35 | MySQL Server: Optimizer | Closed (3830 days) | S2 | 5.7.10, but at least as far back as 5.6 | Any | Any | "Using index for group-by" queries can return no data with LE/LEQ and rounding |
| 80952 | 2016-04-04 21:31 | 2021-03-01 15:46 | Connector / NET | Duplicate (3865 days) | S1 | 6.9.8 | Windows (7 64 bits) | Any | linq generate wring query with group by: Unknown column 'GroupBy1.K1' in 'field |
| 81188 | 2016-04-24 11:16 | 2016-04-25 7:38 | Connector / J | Duplicate (3845 days) | S3 | 5.1.37 | Any | Any | select json type get garbled reason |
| 81984 | 2016-06-23 9:21 | 2016-07-05 12:44 | MySQL Fabric | Not a Bug (3774 days) | S2 | 1.5.6 | Debian (8.5) | Any | FABRIC Picks the wrong master and fails to failover |
| 82171 | 2016-07-08 19:24 | 2016-07-27 2:20 | MySQL Server: Documentation | Closed (3752 days) | S3 | Any | Any | GROUP BY Optimization clarification | |
| 82317 | 2016-07-22 7:42 | 2018-07-18 8:55 | MySQL Server: Parser | Verified (3757 days) | S3 | 5.5.49 | Any (v14.04.1) | Any | Unrelevant error message: Unknown column in 'having' clause |
| 82581 | 2016-08-15 10:21 | 2021-11-03 0:08 | MySQL Server: Group Replication | Verified (3586 days) | S1 | 5.7.14 | CentOS (7) | Any | altering table engine from innodb to memory will break group replication |
| 82604 | 2016-08-17 3:41 | 2021-03-01 15:47 | Connector / NET | Duplicate (3731 days) | S3 | 6.9.9 | Windows | Any | LINQ conditional Group By column excluded from select list |
| 83005 | 2016-09-15 6:56 | 2017-05-03 3:47 | MySQL Server: Optimizer | Closed (3586 days) | S1 | 5.6.10, 5.6.33, 5.7.15, 5.5.52 | Any | Any | When the Optimiser is using index for group-by it often gives wrong results |
| 83144 | 2016-09-26 6:48 | 2020-02-25 19:09 | MySQL Server: mysqlpump Command-line Client | Closed (2444 days) | S3 | 5.7.15, 5.7.21, 8.0.0, 8.0.4, 8.0.18 | Any | Any | mysqlpump reads mysql_dump group, not mysqlpump in config-group |
| 84281 | 2016-12-20 15:44 | 2018-09-25 21:52 | Tests: Group Replication | Not a Bug (3585 days) | S7 | mysql-5.7.17 | CentOS (6.6) | Any | group replication can not work |
| 84371 | 2016-12-29 19:14 | 2020-02-05 15:52 | MySQL Server: Documentation | Won't fix (2464 days) | S3 | 5.7.17 | Any | Any | Missing documentation for backup/recover when using MySQL Group Replication |
| 84537 | 2017-01-17 14:11 | 2017-10-24 14:31 | MySQL Server: Optimizer | Closed (3347 days) | S3 | 8.0.1 | Any | Any | GROUP BY DESC gives wrong result when groups on DECIMAL and sees a NULL |
| 84731 | 2017-01-31 8:56 | 2017-09-18 10:30 | MySQL Server: Group Replication | Closed (3334 days) | S3 | 5.7.17 | Any | Any | Group Replication: mysql client connections hang during group replication start |
| 85119 | 2017-02-22 3:08 | 2022-03-15 15:38 | MySQL Server: InnoDB storage engine | Unsupported (1695 days) | S4 | 5.6 5.7 | Any | Any | Innodb needs an instant checksum. |
| 85998 | 2017-04-19 9:02 | 2018-06-06 8:41 | MySQL Server: Documentation | Closed (3073 days) | S3 | 5.7 | Any | Any | SELECT ... FOR UPDATE not listed as possibe limitation with Group Replication |
| 86858 | 2017-06-29 3:19 | 2017-11-08 10:32 | MySQL Server: Group Replication | Closed (3344 days) | S2 | 5.7.18 | Any | Any | Confusing GR error message: check credentials, but issue is hostnanme resolving |
| 86993 | 2017-07-09 18:28 | 2017-07-18 20:04 | MySQL Server: Documentation | Closed (3396 days) | S3 | 5.6, 5.7 | Any | Any | Incorrect statement about InnoDB group commit in the manual |
| 87190 | 2017-07-26 3:07 | 2018-02-01 5:10 | Tests: Server | Verified (3198 days) | S3 | 8.0.2,8.0.4 | Any | Any | Test main.group_by is unstable |
| 87208 | 2017-07-26 14:05 | 2017-07-31 12:24 | MySQL Server: Group Replication | Not a Bug (3383 days) | S3 | 5.7.18 | Any | Any | Flow control mechanism does not prevent nodes from lagging further behind |
| 87631 | 2017-08-31 16:06 | 2018-02-01 14:01 | MySQL Server: Group Replication | Closed (3221 days) | S2 | 8.0.3 | Any | Any | LOAD DELAYS SWITCHING A GR NODE FROM RECOVERING TO ONLINE |
| 87998 | 2017-10-05 16:42 | 2017-10-10 15:07 | MySQL Server: Optimizer | Not a Bug (3312 days) | S3 | 5.7 | Any | Any | MySQL Group By slow even when indexed |
| 88228 | 2017-10-25 19:22 | 2017-11-15 21:52 | MySQL Server: Documentation | Closed (3276 days) | S3 | 8.0 | Any | Any | "ORDER BY Optimization" doc contradiction re: GROUP BY |
| 88452 | 2017-11-13 1:15 | 2018-02-01 14:03 | MySQL Server: Group Replication | Closed (3248 days) | S2 | 5.7.19 | Any | Any | No Check for duplicatio @@server_uuid when joining group |
| 88509 | 2017-11-16 1:53 | 2025-07-26 21:59 | Connector / NET | Can't repeat (466 days) | S4 | 6.10.4 | Windows | Any | ExecuteScalar, ExecuteNonQuery and ExecuteReader suspended |
| 88749 | 2017-12-05 2:41 | 2018-09-25 22:07 | MySQL Server: DML | Verified (3256 days) | S6 | 5.5.58 | Any | Any | Assertion `item->type() == Item::FIELD_ITEM || (item->type() == Item::REF_ITEM & |
| 88841 | 2017-12-09 15:07 | 2018-05-31 14:52 | MySQL Server: Group Replication | Closed (3207 days) | S3 | 8.0.4 | Any | Any | Typos in 'Initialized group communication with configuration' message |
| 89059 | 2017-12-26 18:54 | 2018-05-31 14:58 | MySQL Server: Group Replication | Closed (3176 days) | S3 | 8.0.11 | Any | Any | LAST_CONFLICT_FREE_TRANSACTION shows different values in group (empty on joiner) |
| 89142 | 2018-01-08 22:09 | 2019-04-30 15:41 | MySQL Server: Group Replication | Closed (2745 days) | S4 | 5.7.20, 8.0.3 | Any | Any | Make FLUSH RELAY LOGS work for Group Replication. |
| 89143 | 2018-01-08 22:10 | 2018-07-02 14:06 | MySQL Server: Replication | Closed (3114 days) | S2 | 5.7.20 | Any | Any | Commit order deadlock + retry logic is not considering trx error cases |
| 89145 | 2018-01-08 22:15 | 2018-01-11 9:47 | MySQL Server: Group Replication | Verified (3219 days) | S4 | 5.7.20,8.0.3 | Any | Any | Provide relay log details in case of Group Replication applier failure. |
| 89381 | 2018-01-24 12:53 | 2018-03-08 1:00 | MySQL Server: Group Replication | No Feedback (3164 days) | S2 | 8.0.4 | Debian (9.3) | Any | Rolling upgrading Group Replication using packages |
| 89686 | 2018-02-16 7:47 | 2019-04-30 11:04 | MySQL Server: Documentation | Closed (2745 days) | S3 | 5.7, 8.0 | Any | Any | Need to add "offset is provided by server_id and increment is 7" to GR manual. |
| 89688 | 2018-02-16 8:49 | 2018-06-09 6:49 | MySQL Server: Compiling | Verified (3070 days) | S4 | 5.7.21, 8.0.3, 8.0.4 | Any (linux and macos) | Any | server crash when group replication starts with mysqld-debug |
| 90951 | 2018-05-21 16:18 | 2020-03-09 12:17 | MySQL Server: Optimizer | Closed (2563 days) | S3 | 5.6.35 | Any | Any | Contribution by Facebook: Enhance group-by loose index scan |
| 91150 | 2018-06-05 16:02 | 2018-08-01 0:17 | MySQL Server: Group Replication | Verified (3017 days) | S4 | 8.0.11 | Any | Any | Force primary to stop accept writes on low number of members in the group |
| 91793 | 2018-07-25 16:25 | 2019-01-22 14:02 | MySQL Server: Group Replication | Closed (2856 days) | S4 | 8.0.12 | Any | Any | Use the new shutdown service when gr_exit_state_action=ABORT_SERVER |
| 91933 | 2018-08-08 9:22 | 2025-12-07 20:45 | MySQL Server: Group Replication | No Feedback (2795 days) | S1 | 8.0.11 | CentOS | Any | MySQL Group Replication - Transaction hangs in COMMIT state at primary |
| 92110 | 2018-08-21 18:02 | 2019-07-25 8:27 | MySQL Server: Group Replication | Closed (2795 days) | S3 | 8.0.13 | Any | Any | Errors when joining on start may lead to a stale view of the group |
| 92293 | 2018-09-05 8:32 | 2018-11-19 16:03 | MySQL Server: Group Replication | Verified (2909 days) | S4 | 5.7, 8.0 | Any | Any | MySQL InnoDB Cluster/Group Replication Server StartUp Sequence Request |
| 92526 | 2018-09-21 10:29 | 2019-04-30 16:29 | MySQL Server: Replication | Closed (2780 days) | S3 | 8.0.14 | Any | Any | MAKE GR REPLICATION CHANNELS ROTATE RELAY LOG ON FLUSH LOGS |
| 92654 | 2018-10-03 11:16 | 2018-10-03 14:05 | MySQL Server: Optimizer | Verified (2954 days) | S3 | 8.0.12, 5.7.23 | Windows | x86 | GROUP BY fails for queries when a temporary table is involved |
| 94186 | 2019-02-04 8:23 | 2019-05-03 9:20 | MySQL Server: Documentation | Closed (2742 days) | S3 | 5.7 | Any | Any | replication_group_members table's document page is incomplete for server status |
| 94213 | 2019-02-06 10:31 | 2019-07-25 8:35 | MySQL Server: Group Replication | Closed (2780 days) | S3 | 8.0.14 | Any | Any | group_replication_consistency=AFTER does not include BEFORE_ON_PRIMARY_FAILOVER |
| 94433 | 2019-02-22 1:15 | 2019-02-22 6:59 | MySQL Server: Optimizer | Not a Bug (2812 days) | S3 | 8.0.15 | CentOS (CentOS 7.5) | x86 (x86_64) | In mysql 8.0, result set of "group by" query is not sorted |
| 95932 | 2019-06-23 14:37 | 2019-06-25 8:51 | MySQL Server: InnoDB storage engine | Can't repeat (2689 days) | S2 | 5.5 | Linux (own os based on linux 64bit) | x86 | mysqld got signal 11 |
| 96071 | 2019-07-02 10:43 | 2022-07-19 13:12 | MySQL Server: InnoDB storage engine | Verified (2338 days) | S3 | 8.0.16 | Any | Any | TempTable engine uses much more memory than MEMORY engine for temporary table |
| 96217 | 2019-07-16 9:25 | 2019-07-30 10:50 | MySQL Server: Connection Handling | Can't repeat (2654 days) | S3 | 8.0 | Any | Any | Confliction of resource group and thread pool plugin, invalid memory access |
| 96318 | 2019-07-25 2:58 | 2019-07-26 12:28 | MySQL Server: Prepared statements | Closed (2658 days) | S3 | 5.7.17 | Windows | Any | distinct group by There are discrepancies in statistical data |
| 96479 | 2019-08-08 20:50 | 2019-11-07 2:56 | MySQL Server: Japanese Documentation | Verified (2644 days) | S3 | 5.6 | Any | Any | JapaneseDocumentBug |
| 96549 | 2019-08-15 10:59 | 2019-08-28 12:23 | MySQL Server: Optimizer | Not a Bug (2625 days) | S3 | 5.6,5.7,8.0, 5.6.45, 5.7.27, 8.0.17 | Any | Any | MySQL query optimizer rewrites query and gets different results than MySQL5.5 |
| 97060 | 2019-09-30 4:58 | 2019-09-30 10:38 | Shell AdminAPI InnoDB Cluster / ReplicaSet | Verified (2592 days) | S2 | 8.0.17 | CentOS (7.3) | x86 | dba.createCluster('myCluster', {adoptFromGR: true}) failed |
| 97417 | 2019-10-29 13:33 | 2019-11-05 14:50 | MySQL Server: Documentation | Closed (2556 days) | S3 | 8.0 5.7 | Any | Any | Typo in Group Replication Settings docs |
| 97707 | 2019-11-20 12:39 | 2023-09-12 10:49 | MySQL Server: Group Replication | Can't repeat (1149 days) | S1 | all version with MGR | Any | Any | group replication lost transaction when init by ansible |
| 97836 | 2019-11-30 12:54 | 2026-10-06 11:51 | MySQL Server: Group Replication | Documenting (29 days) | S2 | 8.0.18 | Linux (CentOS Linux release 7.6.1810) | Any (Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz) | In group replication foreign key will break slave aplier |
| 98630 | 2020-02-17 9:36 | 2020-02-18 13:33 | MySQL Server | Not a Bug (2451 days) | S3 | Any | Any | The same expression in GROUP BY and in output is not distinguished | |
| 99100 | 2020-03-27 13:22 | 2021-11-12 14:28 | MySQL Server: InnoDB storage engine | Closed (1904 days) | S2 | 8.0 | Any | Any | GROUP BY will throw table is full when temptable memory allocation exceed limit |
| 99459 | 2020-05-06 8:17 | 2020-05-08 13:41 | MySQL Server: Optimizer | Verified (2371 days) | S3 | 5.6,5.7,8.0 | Any | Any | SQL run with GROUP_MIN_MAX may infinite loop and never return |
| 99481 | 2020-05-08 6:30 | 2020-05-08 10:15 | MySQL Server: DML | Can't repeat (2371 days) | S3 | 5.7 | Windows | Any | Query with group by and sum works 99% of the times but fails occasionally |
| 99913 | 2020-06-17 11:00 | 2020-06-19 12:37 | MySQL Server: Optimizer | Duplicate (2329 days) | S2 | 8.0.20 | Windows | Any | Group by corrupts data |
| 100221 | 2020-07-14 21:13 | 2020-08-13 1:32 | MySQL Server: Group Replication | Not a Bug (2274 days) | S2 | 8.0 | Ubuntu | x86 | MySQL Group Replication between hosts running containers not working |
| 100378 | 2020-07-30 8:57 | 2020-08-03 11:58 | MySQL Server: Replication | Can't repeat (2284 days) | S3 | 8.0.21 | Any | Any | GROUP_REPLICATION member cannot join |
| 100398 | 2020-07-31 8:33 | 2020-07-31 9:50 | MySQL Server: Optimizer | Verified (2287 days) | S3 | 8.0.19, 5.7.31, 8.0.21 | Any | Any | The results of aggregation operations are inconsistent in different partitions |
| 100597 | 2020-08-21 7:10 | 2024-04-18 10:19 | MySQL Server: Optimizer | Closed (932 days) | S3 | 8.0 | Any | Any | INDEX hint does not affect count(*) execution |
| 100723 | 2020-09-03 7:30 | 2020-09-08 19:33 | MySQL Server: Replication | Verified (2249 days) | S5 | 8.0 | Any | Any | slow MTS recovery in startup |
| 101228 | 2020-10-19 15:55 | 2020-11-03 23:40 | MySQL Server: DML | Not a Bug (2192 days) | S2 | 8.0.22 | Any | Any | date group and sort groups similar dates in different groups |
| 101609 | 2020-11-13 20:45 | 2025-12-07 20:45 | MySQL Server | No Feedback (2109 days) | S2 | 8.0.22 | Linux (Debian 10) | x86 (VPS) | MySQL server process ram/swap usage keeps increasing on a innodb cluster |
| 101838 | 2020-12-02 19:17 | 2021-07-21 11:34 | MySQL Server: Optimizer | Closed (1933 days) | S2 | 8.0 | Any | Any | Adding GROUP BY slows down a query. |
| 102524 | 2021-02-08 9:07 | 2021-02-08 14:07 | MySQL Server: DML | Not a Bug (2095 days) | S2 | 8.0.18 | CentOS | Any | Wrong result when order by a function expression. |
| 102556 | 2021-02-10 15:48 | 2021-04-06 12:18 | MySQL Server: Group Replication | Verified (2038 days) | S2 | 8.0.21 | CentOS (Release: 7.7.1908) | x86 (Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz) | Apparent deadlock involving group replication applier threads |
| 102742 | 2021-02-25 18:27 | 2021-05-25 16:05 | MySQL Server: Group Replication | Closed (1989 days) | S3 | 8.0.23 | Windows (Windows Server 2019) | x86 | Distributed recovery fails if performed while many rows are being inserted |
| 102942 | 2021-03-12 6:53 | 2021-03-15 9:34 | MySQL Server: Prepared statements | Not a Bug (2060 days) | S1 | 8.0.23 | Any | Any | prepare execute result is different from a query execute directly |
| 103938 | 2021-06-08 8:02 | 2021-06-11 6:43 | MySQL Server: Storage Engines | Not a Bug (1972 days) | S3 | 8.0 | Linux | x86 | TempTable use more space when overflow to InnoDB on-disk interna temporary table |
| 105748 | 2021-11-30 11:47 | 2025-12-07 20:45 | MySQL Server: Group Replication | Duplicate (1787 days) | S2 | Any | Any | Why is group_replication_consistency = AFTER crashing a Group Replication cluste | |
| 106814 | 2022-03-24 5:05 | 2022-03-24 14:43 | MySQL Server: Optimizer | Not a Bug (1686 days) | S3 | 8.0.18 | Any | Any | The type varchar can't use <auto_key0> if optimizer don't do derived_merge |
| 106815 | 2022-03-24 8:45 | 2024-01-18 7:21 | MySQL Server: Group Replication | Verified (1021 days) | S4 | 8.0.28 | Any | Any | improve instrumentation of group replication group changes |
| 107599 | 2022-06-20 6:26 | 2022-06-20 7:10 | MySQL Server: Documentation | Verified (1598 days) | S4 | 8.0 | Any | Any | Improve GR server throttling documentation to provide more details |
| 107930 | 2022-07-21 5:58 | 2022-07-26 10:38 | MySQL Workbench | Can't repeat (1562 days) | S3 | 8.0.29 | MacOS (macOS 12.x Monterey x86_64) | Any | Facing error in the MySQL Workbench |
| 108792 | 2022-10-16 2:34 | 2022-10-18 8:57 | MySQL Server: Clone Plugin | Not a Bug (1478 days) | S3 | 8.0.21 | Any | Any | Clone plugin is not supported btw commercial and community version |
| 109548 | 2023-01-09 7:55 | 2023-12-20 12:33 | MySQL Server: DML | Closed (1050 days) | S5 | 8.0.13,8.0.31 | Any | Any | Poor performance when using HASH field to check unique |
| 110011 | 2023-02-09 15:20 | 2023-02-13 13:40 | MySQL Server: DML | Not a Bug (1360 days) | S3 | 8.0.32 | Windows | Any | inconsistent behavior with group by and order by |
| 110122 | 2023-02-17 14:22 | 2023-02-28 14:25 | MySQL Server: mysqldump Command-line Client | Unsupported (1346 days) | S3 | 8.0.32 | Red Hat (Alma 8.7 (Valeri Polyakov)) | x86 | Start MySQL 8.0.32 second instance with temporary data directory |
| 110447 | 2023-03-21 4:45 | 2025-12-07 20:45 | MySQL Operator | No Feedback (1293 days) | S2 | 8.0.32-2.0.8 | Any | Any | Not able to create innodb cluster |
| 110537 | 2023-03-29 4:02 | 2023-03-31 0:37 | MySQL Server: Group Replication | Can't repeat (1314 days) | S1 | 5.7.40 | Any | Any | MySQL cluster fail to auto recover |
| 111189 | 2023-05-29 15:04 | 2023-08-09 12:50 | MySQL Server: Optimizer | Closed (1183 days) | S3 | 8.0 | Any | Any | Scalar correlated subquery with group by clause mistakenly transformed |
| 111379 | 2023-06-13 2:48 | 2023-07-04 0:18 | MySQL Server: Optimizer | Verified (1219 days) | S6 | 8.0.33 | Ubuntu (20.04 LTS) | x86 (Intel(R) Core(TM) i7-10700 CPU) | Assertion `context->query_block == thd->lex->current_query_block()' failed |
| 111441 | 2023-06-15 18:53 | 2023-06-22 17:57 | MySQL Server: DML | Closed (1231 days) | S6 | 8.0.33 | Ubuntu (20.04 LTS) | x86 (Intel(R) Core(TM) i7-10700 CPU) | bool Sql_cmd_dml::prepare(THD*): Assertion `thd->is_error()' failed. |
| 112356 | 2023-09-15 10:13 | 2023-10-20 1:00 | MySQL Server: DML | No Feedback (1112 days) | S2 | 8.0.25 | Linux | Any | SQL returns unexpected results |
| 112401 | 2023-09-20 18:44 | 2023-09-22 23:47 | MySQL Cluster: Cluster (NDB) storage engine | Verified (1139 days) | S3 | 8.0.34 | Any | Any | Node group assumed to start from 0 |
| 112498 | 2023-09-26 11:35 | 2024-01-03 17:34 | MySQL Server: DML | Closed (1036 days) | S6 | 8.0.34 | Ubuntu (20.04) | Any | Assertion Failure in /mysql-8.0.34/sql/sql_resolver.cc:183 |
| 112502 | 2023-09-26 11:46 | 2023-09-26 11:49 | MySQL Server: DML | Verified (1135 days) | S6 | 8.0.34 | Ubuntu (20.04) | Any | Assertion Failure in /mysql-8.0.34/sql/item_sum.cc:1598 |
| 112512 | 2023-09-26 12:19 | 2023-09-26 12:23 | MySQL Server: DML | Verified (1135 days) | S6 | 8.0.34 | Ubuntu (20.04) | Any | Assertion Failure in /mysql-8.0.34/sql/sql_base.cc:9133 |
| 112888 | 2023-10-30 21:35 | 2023-10-31 1:42 | MySQL Server: Group Replication | Closed (1100 days) | S3 | 8.0.27 | Any | Any | View_change_log_event's in secondary cluster break cross-DC failovers |
| 113838 | 2024-01-31 19:24 | 2024-02-14 0:27 | MySQL Server: Group Replication | Closed (994 days) | S3 | 8.0+ | Any | Any | Async connection failover prevents failed Group Replication member rejoin |
| 114762 | 2024-04-24 10:05 | 2024-04-25 14:23 | MySQL Server: Optimizer | Verified (924 days) | S3 | 8.0 | Any | Any | invalid result set with join lateral and group by on a generated field |
| 114892 | 2024-05-06 7:30 | 2026-06-10 12:57 | Tests: Group Replication | Verified (147 days) | S7 | 8.0.46, 8.4.4 | MacOS (14.4.1) | ARM | Test XComControlTest.SuspectMemberFailedRemovalDueToMajorityLoss fails |
| 115040 | 2024-05-16 12:09 | 2024-10-29 10:09 | MySQL Server: Optimizer | Verified (902 days) | S3 | 8.0 | Any | Any | Incorrect result from lateral join with group by month/monthname function inside |
| 115671 | 2024-07-23 9:47 | 2024-07-23 13:49 | MySQL Server: Optimizer | Verified (834 days) | S5 | 8.0.37, 8.0.39 | Any | Any | The optimizer has chosen a poor execution plan. |
| 116309 | 2024-10-07 10:39 | 2024-10-22 11:32 | MySQL Server: Optimizer | Verified (743 days) | S5 | 596f0d23 (9.0.0), 9.1.0 | Ubuntu | Any | Performance of TPC-H Query |
| 116491 | 2024-10-28 11:45 | 2024-11-30 1:00 | MySQL Workbench: Modeling | No Feedback (705 days) | S1 | 8.0.38 build 4270039 CE | MacOS (14.7 (23H124)) | ARM (M1 Max) | SIGSEGV while synhronizing database to the model |
| 116534 | 2024-11-03 10:40 | 2024-11-06 12:58 | MySQL Server: Optimizer | Verified (728 days) | S5 | 596f0d23 (9.0.0) | Any | Any | Another Performance of TPC-H Query 16 |
| 116645 | 2024-11-13 14:18 | 2024-11-13 15:33 | MySQL Workbench | Verified (721 days) | S4 | 8.0 | Any (11) | Any | Improved search in Connections list |
| 116932 | 2024-12-11 1:45 | 2024-12-13 19:06 | MySQL Server: Replication | Verified (693 days) | S3 | MySQL8.0,5.7 | Any | Any | Not update the slave_relay_log_info table in time causes replication recovery failure |
| 117408 | 2025-02-07 4:26 | 2025-02-07 8:42 | MySQL Server: Optimizer | Verified (635 days) | S5 | 8.0.41 | Any | Any | Tight index scan not used when group by does not begin with first part of key, but where condition is list of constants |
| 117670 | 2025-03-12 3:46 | 2025-03-12 13:48 | MySQL Server: Optimizer | Not a Bug (602 days) | S3 | 8.0.34, 8.0.41 | Linux | Any | Unknown column '?' in 'group statement' |
| 118165 | 2025-05-12 8:39 | 2026-05-04 12:31 | MySQL Server: Replication | Closed (184 days) | S4 | 8.0+ | Any | Any | Ensure MySQL automatic connection failover handling can handle mixed MySQL "upstream" versions |
| 118592 | 2025-07-07 12:12 | 2025-07-10 6:53 | MySQL Server: Prepared statements | Duplicate (482 days) | S1 | 9.3.0 | Any | Any | Unexpected result of prepared statement |
| 118898 | 2025-08-26 12:35 | 2026-10-22 20:48 | MySQL Server: Group Replication | Patch pending (429 days) | S3 | 8.4.6 | Any | Any | Cluster endup having two primary nodes, also if group_replication_single_primary_mode is ON. |
| 119167 | 2025-10-16 8:28 | 2025-11-17 1:00 | MySQL Server: Optimizer | No Feedback (353 days) | S3 | 8.0.25 | Linux (ARM Kylin v10) | ARM (ARM Kylin v10) | SIGSEGV in calc_row_difference()/memcmp during GROUP BY + MAX(CONCAT(...)) (temporary table update path) |
| 119441 | 2025-11-21 20:09 | 2026-10-20 8:43 | MySQL Server: Group Replication | Duplicate (15 days) | S2 | 8.0.35 | Linux (Rocky Linux release 8.10) | x86 | Group replication binds to ipv6 wildcard address |
| 119605 | 2025-12-29 9:37 | 2025-12-29 13:00 | MySQL Server: Optimizer | Verified (310 days) | S3 | 8.0.27 | Any | Any | GROUP BY brings unnecessary order columns |
| 119761 | 2026-01-23 9:47 | 2026-01-23 10:25 | MySQL Server | Not a Bug (285 days) | S3 | 8.0 5.7 | Linux | Any | there is something wrong about join+group by suition,ONLY_FULL_GROUP_BY don't effect |
| 119808 | 2026-01-29 14:44 | 2026-07-08 12:18 | MySQL Server: DML | Verified (119 days) | S2 | Any | Any | Error 3569 with HIGH_PRIORITY + VIEW + GROUP BY + FOR UPDATE | |
| 120075 | 2026-03-16 14:26 | 2026-03-25 12:47 | MySQL Server: Optimizer | Verified (231 days) | S1 | 8.0.45 | Linux (ubuntu 20.04) | x86 | Silent Data Truncation of DOUBLE (DBL_MAX) in Subqueries/Temporary Tables |
| 120217 | 2026-04-05 12:27 | 2026-04-06 5:24 | MySQL Server: Optimizer | Verified (212 days) | S3 | 9.6.0 | Ubuntu (22.04) | Any | GROUPING() in ORDER BY of EXISTS/IN/ALL/ANY subquery: invalid arguments not rejected |
| 120488 | 2026-05-17 11:04 | 2026-05-18 7:14 | MySQL Server: Group Replication | Open | S2 | 8.4.9 | Linux (rocky linux 9.7) | x86 (9.7) | MySQL 8.4 Group Replication memory pools not released to OS srv_worker_thread 44,772x total/current ratio; xcom_cache ho |
| 120737 | 2026-06-22 8:28 | 2026-06-22 10:31 | MySQL Server: Optimizer | Verified (135 days) | S1 | 8.0.45 | Any | Any | Inconsistent CAST Handling of Out-of-Range TEXT Values in Single Table vs. View/Join Paths |
| 120832 | 2026-07-02 10:02 | 2026-07-20 11:08 | MySQL Server: Optimizer | Verified (125 days) | S1 | 9.1 | Any | Any | WITH ROLLUP Super‑Aggregate Row Missing in Zero Input Rows Short‑Circuit Path |
| 120837 | 2026-07-02 15:20 | 2026-07-02 19:44 | MySQL Server: Optimizer | Verified (125 days) | S2 | 9.6.0 | Any | Any | Wrong result with CTE, UNION ALL, GROUP BY/HAVING and LOCATE('', column) |
| 121011 | 2026-07-27 9:52 | 2026-07-27 14:18 | MySQL Server: Optimizer | Verified (100 days) | S3 | 8.0.46, 8.4.10, 9.7.1 | MacOS | ARM | subquery_to_derived causes wrong result with GROUP BY ... WITH ROLLUP |
| 121083 | 2026-08-12 20:39 | 2026-08-13 6:28 | MySQL Server: Optimizer | Verified (83 days) | S3 | 8.0.46,8.4.11, 9.7,2 | Linux | ARM | SELECT DISTINCT ... GROUP BY <same list> drops rows |
| 121179 | 2026-08-27 18:23 | 2026-10-30 15:48 | MySQL Server: Optimizer | Patch pending (68 days) | S2 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | Framed window functions return wrong results when windowing steps are skipped (const plan, implicit grouping) |
| 121272 | 2026-09-12 14:16 | 2026-09-14 11:39 | MySQL Server: Optimizer | Verified (51 days) | S3 | 8.0.45 | MacOS (MacOS 26.5.2, using Homebrew) | ARM | Incorrect ORDER BY when using GROUP BY, GROUP_CONCAT() and COUNT(id) OVER() |
| 121343 | 2026-09-21 14:37 | 2026-10-14 14:48 | MySQL Server: Replication | Documenting (23 days) | S2 | MySQL 8.4 branch, commit `99960bf74fa919 | Any | Any | Group Replication generates invalid Clone SQL from a valid TLS path containing an apostrophe |
| 121481 | 2026-10-11 15:45 | 2026-10-13 8:16 | MySQL Server: Optimizer | Duplicate (22 days) | S2 | 26.7.1 | Ubuntu (24.04) | x86 (x86_64) | Wrong result: INTERSECT/EXCEPT and DISTINCT/GROUP BY/UNION treat 0 and -0 as distinct although 0 = -0 |
| 121611 | 2026-10-26 12:36 | 2026-10-27 6:40 | MySQL Server: DML | Verified (8 days) | S3 | 9.7.4, 26.10 | Any (Docker container (mysql_dev), Linux x86_64) | Any | JSON Duality View update that deletes a parent group and reassigns its children is rejected with FK error 1451 |
| 154 | 2003-03-15 5:44 | 2003-03-15 23:28 | MySQL Server: InnoDB storage engine | Closed (8635 days) | S2 | All | Any | Wrong group by or distinct on Innodb table indexed column with NULLs | |
| 176 | 2003-03-21 11:32 | 2019-04-08 13:46 | MySQL Server | Closed (8626 days) | S3 | all | Any | Any | Mixing aliases and aggregate functions in GROUP BY results in empty set |
| 314 | 2003-04-22 17:01 | 2003-04-26 4:22 | MySQL Server | Closed (8593 days) | S3 | 4.0 | Any | GROUP BY forces functions to treat multy-byte charset values as single-byte | |
| 380 | 2003-05-06 10:14 | 2003-06-19 12:59 | MySQL Server | Closed (8539 days) | S2 | 4.1.0 | Any (any) | Any | MySQL crashes with InnoDB + group |
| 590 | 2003-06-05 3:02 | 2003-06-11 9:31 | MySQL Server | Not a Bug (8547 days) | S2 | 4.0.13 | Linux (Linux (Debian)) | Any | Different results with 4.0.13 and 3.23.51 versions |
| 621 | 2003-06-08 23:10 | 2003-08-09 6:41 | MySQL Server | Closed (8488 days) | S4 | 4.0.13 | Linux (RedHat Linux) | Any | Groups of users |
| 644 | 2003-06-12 14:56 | 2024-11-28 16:13 | MySQL Server | Can't repeat (8273 days) | S1 | 4.1 | Linux (linux 2.4) | Any | crash in add_key_field when using prepared statements |
| 660 | 2003-06-16 8:12 | 2003-06-16 10:50 | MySQLCC | Can't repeat (8542 days) | S2 | 4.1 alpha | Windows (windows) | Any | [test_data] ERROR 2003: Can't connect to MySQL server on 'xxxx' (10061) |
| 699 | 2003-06-23 6:56 | 2003-06-25 7:00 | MySQL Server: Command-line Clients | Closed (8533 days) | S2 | 4.1.0-alpha-max-nt | Windows (Win XP) | Any | SUBSELECTION AND IN-KEYWORD |
| 825 | 2003-07-10 2:34 | 2003-09-19 15:38 | MySQL Server | Can't repeat (8447 days) | S2 | 4.1-Alpha | Linux (Linux) | Any | GROUP_CONCAT returns weird sets of data |
| 958 | 2003-07-30 8:46 | 2003-08-06 6:54 | MySQL Server | Closed (8491 days) | S3 | 4.1, 5.0 | Linux (SuSE Linux 8.2) | Any | a big table without indices and select with group by doesnt work |
| 1301 | 2003-09-16 8:26 | 2004-03-12 6:16 | MySQL Server | Closed (8272 days) | S1 | 4.1 | Linux (Linux RH 7.3) | Any | func_gconcat test fails in valgrind-max build |
| 1335 | 2003-09-18 10:06 | 2003-12-09 14:21 | MySQL Server | Closed (8366 days) | S3 | 4.0.15 | Any | "Filesort" is missing in EXPLAIN | |
| 1346 | 2003-09-19 5:03 | 2003-09-19 7:45 | MySQL Server: Command-line Clients | Not a Bug (8447 days) | S3 | 4.0.12 | Windows (Windows 2000) | Any | Finding Duplicates with GROUP BY |
| 1363 | 2003-09-21 9:18 | 2008-09-27 9:17 | MySQL Server | Can't repeat (6612 days) | S3 | 4.0.15a | Linux (Linux 2.4.21-SMP-686 (Debian)) | Any | Not expected behaviour of CREATE TEMPORARY TABLE...SELECT |
| 1407 | 2003-09-26 3:26 | 2003-11-04 11:53 | MySQL Server | No Feedback (8401 days) | S3 | 4.1.0-alpha | Windows (Win2k) | Any | IF in WHERE-clause |
| 1456 | 2003-10-01 8:23 | 2003-12-11 12:03 | MySQL Server | Closed (8364 days) | S3 | 4.1.1 | Any | cast with union and group by with rollup displays incorrect results | |
| 1555 | 2003-10-15 3:44 | 2003-10-18 14:04 | MySQL Server | Closed (8418 days) | S1 | 4.1.0-alpha-max-nt | Windows (Windows 2000 Advanced Server SP4) | Any | SELECT statement with HAVING clause, but no GROUP BY clause crashes Service |
| 1586 | 2003-10-17 6:32 | 2003-10-19 15:00 | MySQL Server | Not a Bug (8417 days) | S3 | 3.23.49 | Linux (RH 7.3) | Any | group by not working with an aggregate function on date field |
| 1703 | 2003-10-29 10:12 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | No Feedback (8040 days) | S3 | 4.0.12 | Linux (Slackware linux) | Any | SELECT DISTINCT not showing a distinct row |
| 1790 | 2003-11-10 0:45 | 2003-12-10 4:45 | MySQL Server | Closed (8365 days) | S2 | 3.23,4.0,4.1 | Any (any) | Any | BIT_AND() result in GROUP BY different when SQL_BIG_RESULT used |
| 1941 | 2003-11-24 21:26 | 2025-12-29 11:50 | MySQL Server | Not a Bug (8378 days) | S4 | all | Any (all) | Any | Allow aliases in WHERE clauses for queries without GROUP BY |
| 2048 | 2003-12-08 12:12 | 2004-01-17 3:04 | MySQL Server | Closed (8327 days) | S2 | 4.1.2-alfa | Linux (Linux slackware 9.0) | Any | some subselect queries crashes mysqld in case of innodb tables |
| 2063 | 2003-12-09 12:45 | 2003-12-10 5:58 | MySQL Server | Won't fix (8365 days) | S3 | 4.0.17 | Any | Strange GROUP BY behavior with user variables | |
| 2069 | 2003-12-09 20:17 | 2003-12-10 13:52 | MySQL Server: User-defined functions ( UDF ) | Closed (8365 days) | S2 | 4.0.16 | Linux (Linux (Gentoo)) | Any | using an aggregate udf, the order by clause changes NULL to 0 |
| 2104 | 2003-12-12 6:02 | 2004-01-30 5:45 | MySQL Server: MyISAM storage engine | Can't repeat (8314 days) | S1 | 4.0.16 | Linux (RH 9, Apache 1.3.29) | Any | after deleting row index got fragmented |
| 2148 | 2003-12-18 1:26 | 2003-12-18 4:08 | MySQL Server: Command-line Clients | Not a Bug (8357 days) | S2 | MySQL 4.0.15 | Windows (Windows) | Any | Subqueries in the FROM clause |
| 2323 | 2004-01-08 9:20 | 2004-02-26 13:46 | MySQL Server | No Feedback (8287 days) | S1 | 4.0.15 | MacOS (OSX 10.3.2) | Any | Table caching problem? data doesn't update |
| 2394 | 2004-01-14 21:21 | 2004-01-14 22:16 | MySQL Server | Can't repeat (8330 days) | S3 | 5.0.0 | Windows (winxp) | Any | Crash MySQL |
| 2398 | 2004-01-15 7:02 | 2004-01-15 7:26 | MySQL Server: MyISAM storage engine | Can't repeat (8329 days) | S1 | 4.0.17 | Linux (Linux 2.6.0) | Any | MySQL crashes on boolean fulltext search |
| 2425 | 2004-01-16 6:40 | 2005-10-04 17:22 | MySQL Server | Duplicate (7701 days) | S4 | 4.0.17 | Linux (Linux) | Any | feat. requ. GROUP BY-Function FIRST |
| 2596 | 2004-01-31 11:17 | 2005-04-28 2:29 | MySQL Server | Closed (7860 days) | S3 | 5.0 alpha | Solaris (Solaris 9 sparc 64) | Any | MySQL Client Segmentation Fault on Solaris 9 |
| 2695 | 2004-02-09 22:28 | 2004-04-05 3:20 | MySQL Server | Closed (8248 days) | S2 | 4.1.1-alpha-nt | Windows (Windows XP) | Any | Strange behaviour with GROUP_CONCAT() using ORDER BY |
| 2927 | 2004-02-23 10:49 | 2005-08-10 17:28 | MySQL Server | Won't fix (7756 days) | S2 | 3.23.58 | Linux (Linux) | Any | EXTRACT() with GROUP BY produces wrong results |
| 3171 | 2004-03-15 1:27 | 2004-03-26 7:02 | MySQL Server: MyISAM storage engine | Not a Bug (8258 days) | S2 | 4.1.1-alpha | Windows (WinXP Professional) | Any | A bug in getting table name from result set (for given field) in PHP |
| 3405 | 2004-04-06 22:04 | 2004-04-07 7:15 | MySQL Server: Documentation | Closed (8246 days) | S3 | 5 | Any | No explanation of "formula" for Group By/Order By in Select | |
| 3482 | 2004-04-16 1:59 | 2004-04-28 10:47 | MySQL Server | Can't repeat (8225 days) | S1 | 4.1.1a-alpha | Windows (Windows NT 4.0 SP6a) | Any | MySQL returns empty set when using index |
| 3659 | 2004-05-05 10:34 | 2004-07-19 13:39 | MySQL Cluster: Cluster (NDB) storage engine | Closed (8143 days) | S1 | mysql-4.1.2-alpha bk | FermiLinux LTS 3.01 | Any | >1 concurrent update causes deadlock |
| 3874 | 2004-05-24 17:28 | 2005-10-13 14:42 | MySQL Server | Closed (7692 days) | S3 | 3.23.58 | FreeBSD (Free BSD) | Any | A Group By Field is not considered |
| 3934 | 2004-05-30 8:43 | 2004-06-08 12:37 | MySQL Server: User-defined functions ( UDF ) | Closed (8184 days) | S2 | 4.0.20a | Windows (XP) | Any | UDF on Windows crash the server |
| 4040 | 2004-06-07 15:54 | 2004-06-08 15:37 | MySQL Server | Not a Bug (8184 days) | S2 | 4.1.1a-alpha-nt | Windows (Windows 2003 Server) | Any | Extremely Slow "Where in (Select... )" Subqueries GROUP BY / HAVING related |
| 4064 | 2004-06-08 21:19 | 2004-06-09 0:33 | MySQL Server | Not a Bug (8183 days) | S2 | 4.1.2 | Linux (Linux) | Any | group by with having produces wrong results |
| 4065 | 2004-06-08 21:31 | 2020-01-31 13:38 | MySQL Server: DML | Won't fix (2469 days) | S4 | all | Any (all) | Any | remove the need to mention column name in select in order to use it in having |
| 4131 | 2004-06-14 20:12 | 2004-09-26 21:58 | MySQL Server | Closed (8074 days) | S2 | 4.0.20 | Linux (Linux) | Any | TIMESTAMP columns missing minutes and seconds when using GROUP BY |
| 4156 | 2004-06-16 0:26 | 2004-06-16 13:58 | MySQL Server | Not a Bug (8176 days) | S3 | 4.1.2 ALpha | Windows (Win XP Pro) | Any | Error 1250 Table from one of the SELECT's cannot be used in global ORDER clause |
| 4234 | 2004-06-21 16:00 | 2004-06-21 19:03 | MySQL Server: Command-line Clients | Not a Bug (8171 days) | S2 | 4.0.18-nt | Windows (XP, SP1) | Any | Error 1064 on "select [group function]" |
| 4323 | 2004-06-29 13:16 | 2004-06-30 22:54 | MySQL Server | Duplicate (8162 days) | S2 | 3.0.14 and below | Linux (Linux) | Any | getObject typing breaks in group by with timestamp and date manipulation |
| 4400 | 2004-07-03 20:52 | 2004-07-17 1:42 | MySQL Server | Closed (8145 days) | S3 | 4.1 | Any (all) | Any | incorrect error message about aggregate function in subquery |
| 4530 | 2004-07-13 1:17 | 2012-05-18 20:19 | MySQL Server | No Feedback (8118 days) | S3 | 4.0.20 and 4.0.18 | Linux (linux) | Any | a query using sum() reports wrong total |
| 4535 | 2004-07-13 9:27 | 2004-08-12 10:45 | MySQL Server | Closed (8119 days) | S3 | 4.1.3 | Linux (linux) | Any | "group_concat AND order by " can't work correctly |
| 4695 | 2004-07-22 13:29 | 2004-07-23 21:31 | MySQL Administrator | Not a Bug (8139 days) | S4 | 4.1 | Windows (Windows 2000 advance server) | Any | About creating user groups and assigning a user to his/her group |
| 4871 | 2004-08-03 14:45 | 2004-08-04 10:12 | MySQL Server | Not a Bug (8127 days) | S3 | 4.1.3 | Windows (Windows NT4) | Any | MAX(COUNT(*))...GROUP BY |
| 5310 | 2004-08-31 3:11 | 2004-08-31 4:01 | MySQL Server | Closed (8100 days) | S2 | 4.1.3beta | Windows (Windows 2000) | Any | subselect returns wrong results |
| 5615 | 2004-09-16 19:37 | 2005-03-02 21:18 | MySQL Server | Closed (7917 days) | S1 | 4.1.3 | Any (any) | Any | type of aggregate function column wrong when using group by |
| 5635 | 2004-09-17 19:55 | 2004-09-20 12:46 | MySQL Administrator | Closed (8080 days) | S3 | 1.0.12 | Windows (Windows XP SP2) | Any | 'Add a Group' option does nothing is variable tabs of health section |
| 5644 | 2004-09-18 20:01 | 2004-11-18 20:46 | MySQL Server: MyISAM storage engine | No Feedback (8021 days) | S2 | 4.1.4-gamma-nt | Windows (Windows XP Pro + all patches) | Any | LIKE brings a MySQL Server to hang with 100% cpu |
| 5782 | 2004-09-28 8:22 | 2004-10-01 20:19 | MySQL Cluster: Cluster (NDB) storage engine | Closed (8069 days) | S2 | 4.1.6-gamma-nightly-20040927 | Linux (Linux) | Any | Unknown error when using LIMIT with ndb table. |
| 6091 | 2004-10-14 11:14 | 2004-11-03 16:13 | MySQL Query Browser | Closed (8036 days) | S2 | 1.0.8 beta | Windows (Win2K SP4) | Any | Incorrect GROUP BY/ORDER BY order causes crash |
| 6184 | 2004-10-20 20:49 | 2004-10-21 13:58 | MySQL Server | Can't repeat (8049 days) | S2 | 4.0.20 | Linux (Gentoo Linux 2.6.8) | Any | FOUND_ROWS() returns the wrong value when GROUP BY and HAVING clauses are used |
| 6570 | 2004-11-11 8:17 | 2005-01-14 12:00 | MySQL Server | No Feedback (7964 days) | S2 | 4.1.7 | Windows (MS Windows) | Any | Subquery not connected to query in select statement |
| 6652 | 2004-11-16 2:16 | 2004-11-16 12:30 | MySQL Server: MyISAM storage engine | Not a Bug (8023 days) | S1 | 5.0.1-alpha | Linux (Fedora Core 2) | Any | SUM does not return correct values unless the field is aliased |
| 6931 | 2004-12-02 3:45 | 2005-02-04 13:26 | MySQL Server | Closed (7943 days) | S3 | 4.1.8 | Any (any) | Any | Date Type column problem when using UNION-Table. |
| 7013 | 2004-12-05 0:15 | 2005-02-18 17:57 | MySQL Server | Closed (7929 days) | S3 | 5.0.3-alpha-debug | Linux (SUSE 9.2) | Any | Stored procedure crash if group by ... with rollup |
| 7101 | 2004-12-08 12:19 | 2019-11-14 13:58 | MySQL Server | Closed (7999 days) | S1 | 4.1 | Any (all) | Any | Usage of LEFT() function in GROUP BY crashes a server |
| 7128 | 2004-12-09 11:20 | 2004-12-09 13:36 | MySQL Server | Not a Bug (8000 days) | S3 | 4.0.14 | MacOS (MAC OS X) | Any | SELECT COUNT with GROUP BY bug |
| 7204 | 2004-12-12 17:20 | 2004-12-13 7:50 | MySQL Server | Closed (7996 days) | S2 | 4.1.8-pre | IBM AIX (AIX 4.3.3) | Any | "func_str" fails on AIX 4.3 when using --ps-protocol |
| 7251 | 2004-12-14 7:27 | 2005-01-16 4:07 | MySQL Server | Can't repeat (7962 days) | S3 | 5.0.3-pre | Linux (Linux/PPC) | Any | "myisam" test fails in current 5.0 tree |
| 7270 | 2004-12-14 15:11 | 2005-01-14 18:48 | MySQL Server | Closed (7964 days) | S3 | 5.0.3-pre | Linux (Linux / Athlon) | Any | Test failure: 'select' (using '--ps-protocol': results re-ordered) |
| 7593 | 2004-12-30 18:43 | 2004-12-31 9:50 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7978 days) | S1 | 4.1.8 (Max) | Linux (Linux Fedora Core 1) | Any | Cannot Create A Large NDB Data Warehouse |
| 7960 | 2005-01-17 16:17 | 2005-01-19 19:26 | MySQL Server | Not a Bug (7959 days) | S3 | 5.0.0-alpha | Windows (Windows XP) | Any | Lost Connection during SQL Select |
| 8051 | 2005-01-20 16:40 | 2013-10-06 20:45 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (7904 days) | S3 | 4.1.8/4.1.9 | HP/UX (HP-UX 11i11 PARISC 64bit) | Any | Cannot restart ndbd with large table (20 000 000 rows) |
| 8076 | 2005-01-21 19:05 | 2006-09-16 10:19 | MySQL Server | Won't fix (7354 days) | S4 | MySQL 4.1.9 | Windows (Windows XP) | Any | inner from select column cannot be in outer select only in having part |
| 8292 | 2005-02-03 15:57 | 2006-01-27 15:42 | Connector / NET | Closed (7586 days) | S2 | 1.0.4 | Windows (Windows 2000) | Any | GROUP BY / WITH ROLLUP with DataSet causes System.Data.ConstraintException |
| 8653 | 2005-02-21 16:33 | 2005-04-06 15:09 | MySQL Server | Closed (7882 days) | S1 | Any | 5.0.3 leaves an InnoDB trx open after connection ends; InnoDB shutdown hangs | ||
| 8775 | 2005-02-24 11:15 | 2006-04-14 13:49 | MySQL Server | Closed (7509 days) | S2 | 4.1.10 | Windows (windows/linux) | Any | Using string literal with a name of a column makes query return too few rows |
| 8817 | 2005-02-26 0:26 | 2005-02-26 1:14 | MySQL Server | Closed (7921 days) | S2 | 5.0.2-alpha-max-log | Windows (WinXp Professional) | Any | coalesce() with max() or count() in stored proc. does not work next time |
| 8949 | 2005-03-04 17:08 | 2005-03-04 17:20 | MySQL Server | Duplicate (7915 days) | S2 | 4.1.9 | Linux (Debian Linux 3.3) | Any | MySQL doesn't recognize some UTF-8 chars |
| 9213 | 2005-03-16 2:34 | 2005-04-11 2:21 | MySQL Server: Optimizer | Closed (7877 days) | S2 | 4.1.11 | Any (any) | Any | GROUP BY query on utf-8 key returns wrong results (empty set) |
| 9635 | 2005-04-05 5:34 | 2005-04-05 5:39 | MySQL Server | Can't repeat (7883 days) | S1 | 5.0.3 | Linux (linux) | Any | select/round/group by query crashes server |
| 9672 | 2005-04-06 11:11 | 2005-05-05 15:47 | MySQL Server | Can't repeat (7853 days) | S1 | 5.0.4-beta-nightly-20050328 | Linux (linux) | Any | mysql_stmt_attr_set CURSOR_TYPE_READ_ONLY query containing GROUP BY |
| 9990 | 2005-04-19 5:24 | 2007-09-25 10:14 | MySQL Server: Command-line Clients | Not a Bug (6980 days) | S1 | 5.0.4 | Linux (Linux) | Any | CHANGE IN BEHAVIOR OF GROUP BY WORKING BY PARSER |
| 10021 | 2005-04-20 2:46 | 2005-06-01 18:31 | MySQL Server: Optimizer | Can't repeat (7826 days) | S3 | 5.0.4/5.0.5 BK | Windows (win2000) | Any | group by fields must on a index ? |
| 10121 | 2005-04-24 9:17 | 2006-01-04 10:13 | MaxDB | Closed (7609 days) | S3 | 7.5, 7.6 | Windows (w2k) | Any | DBPROC fails every second call |
| 10387 | 2005-05-05 13:20 | 2005-07-22 7:53 | MySQL Server | Closed (7775 days) | S1 | 5.0.4 Beta-standard | Windows (Windows XP) | Any | Mysql server crashes for Select statement for 'max',group by and with rollup. |
| 10390 | 2005-05-05 14:56 | 2012-05-18 20:19 | MySQL Server | No Feedback (7807 days) | S2 | MySQL Server 4.1 | Windows (Window XP) | Any | SELECT MAX(a_datetime_field) returns a String rather than a Timestamp |
| 10391 | 2005-05-05 14:56 | 2005-05-05 15:03 | Connector / J | Duplicate (7853 days) | S2 | MySQL Server 4.1 | Windows (Window XP) | Any | SELECT MAX(a_datetime_field) returns a String rather than a Timestamp |
| 10557 | 2005-05-11 14:44 | 2005-05-11 15:41 | MySQL Server: Optimizer | Not a Bug (7847 days) | S3 | 5.0.4-beta-debug | Linux (linux 2.6.8-24.14 smp) | Any | Too few results when "Using index for group-by" |
| 10886 | 2005-05-26 14:59 | 2005-06-22 2:36 | MySQL Server: Optimizer | Closed (7805 days) | S2 | 4.1.12 | Linux (Linux) | Any | INSERT ... SELECT ... ON DUPLICATE KEY UPDATE produces bad results |
| 11141 | 2005-06-07 16:03 | 2005-06-10 18:01 | MySQL Server | Not a Bug (7817 days) | S2 | 4.1.12 | FreeBSD (FreeBSD 4/5) | Any | Group quota for databases, Mysql hang up when quota exceed |
| 11211 | 2005-06-09 16:10 | 2005-06-23 5:07 | MySQL Server: Optimizer | Closed (7804 days) | S1 | 5.0.6 | Windows (Windows XP) | Any | GROUP BY doesn't work correctly |
| 11359 | 2005-06-15 19:36 | 2005-08-26 9:43 | MySQL Migration Toolkit | Closed (7740 days) | S1 | 1.0.10 | Windows (Windows2000) | Any | INFORMATION_SCHEMA.ROUTINES doesn't exist in source |
| 11376 | 2005-06-16 11:19 | 2005-08-16 19:19 | MySQL Server | Can't repeat (7750 days) | S2 | 5.0.7 | Windows (win2k) | Any | Problem with Group By |
| 11385 | 2005-06-16 14:28 | 2005-06-23 18:18 | MySQL Server | Closed (7804 days) | S3 | 5.0.7/4.1.11 | Linux (Linux/x86, Windows) | Any | crash in group by and DIV |
| 11462 | 2005-06-20 16:13 | 2005-06-23 8:12 | MySQL Server | Not a Bug (7804 days) | S3 | 4.1.12 | Windows (Windows XP) | Any | Problem with ROUND() function |
| 11464 | 2005-06-20 16:41 | 2005-06-20 22:54 | MySQL Server | Closed (7807 days) | S2 | 4.1.12a-nt-log | Windows (Win XP) | Any | MySQL server crashes on simple aggregate (500 rows) |
| 11543 | 2005-06-24 9:08 | 2005-07-25 20:38 | MySQL Server: Optimizer | Closed (7772 days) | S3 | 4.1.11-Debian_0.dotdeb.0-log | Linux (Linux - Debian) | Any | Error in GROUP BY .. WITH ROLLUP |
| 11571 | 2005-06-25 13:40 | 2005-06-25 14:02 | MySQL Server | Can't repeat (7802 days) | S1 | 5.0.4-beta | Windows (Windows XP) | Any | server-crash while performing subquery with "group by" and "where" |
| 11640 | 2005-06-29 13:29 | 2008-10-03 20:22 | MySQL Server: DDL | Won't fix (6606 days) | S4 | Any | Any | automatic key creation on CREATE TABLE ... SELECT | |
| 11869 | 2005-07-11 19:18 | 2005-08-08 15:49 | MySQL Server: Optimizer | Closed (7758 days) | S1 | 4.1.12-nt, 5.0.7-nt-beta/5.0.10 | Windows (Windows XP1/Linux) | Any | Server crashes making a union join query with fulltext search |
| 12072 | 2005-07-20 21:02 | 2005-07-21 0:38 | MySQL Server | Closed (7776 days) | S1 | 5.0.9 | Windows (WinXP) | Any | Incorrect results when using GROUP BY after applying an index |
| 12139 | 2005-07-24 14:32 | 2005-08-26 8:25 | MySQL Server | Can't repeat (7740 days) | S3 | 5.0.9-nt | Windows (winXP) | Any | MyISAM: DISTINCT/GROUP BY return duplicates |
| 12266 | 2005-07-29 12:12 | 2005-08-07 1:39 | MySQL Server: Optimizer | Closed (7759 days) | S3 | 4.1.12-nt, 4.1.13, 4.1.14 | Linux (Linux) | Any | GROUP BY expression on DATE column gives wrong results |
| 12275 | 2005-07-29 17:48 | 2005-07-29 18:06 | MySQL Server | Not a Bug (7768 days) | S3 | 4.1.10A | Linux (RedHat AS4 IA64) | Any | Incomplete results when performing outer join |
| 12348 | 2005-08-03 14:46 | 2005-08-08 16:20 | MySQL Server: Installing | Closed (7758 days) | S2 | 4.1.13 | Linux (CentOS 4.1) | Any | Installation RPM fails because of groupadd on CentOS Linux. |
| 12809 | 2005-08-25 15:41 | 2005-09-15 19:19 | MySQL Server | Closed (7720 days) | S1 | MySQL-server-standard-4.1.13-0.rhel3.i38 | Linux (RHAS-3) | Any | server RPM fails to start because of install script |
| 12859 | 2005-08-29 18:59 | 2005-09-06 15:52 | MySQL Server: Optimizer | Closed (7729 days) | S3 | 4.1.14, 5.0.11 | Windows (Windows, freebsd) | Any | group_concat in subquery cause incorrect not null |
| 12922 | 2005-09-01 1:57 | 2005-09-08 19:15 | MySQL Server: Optimizer | Closed (7727 days) | S2 | 5.0.11 | Linux (Linux) | Any | wrong results with GROUP BY on VIEW |
| 13356 | 2005-09-20 18:49 | 2005-09-30 17:10 | MySQL Server: Optimizer | Closed (7705 days) | S1 | 5.0.10-beta/5.0 BK source | Linux (linux) | Any | server crash |
| 13538 | 2005-09-27 20:02 | 2005-09-27 20:58 | MySQL Server | Can't repeat (7708 days) | S2 | 4.1.11a-4sarge1 | Linux (Debian Sarge) | Any | Query giving error if referred field is indexed |
| 13556 | 2005-09-28 9:23 | 2006-01-24 11:36 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7589 days) | S3 | 5.1-ndb-dd | Any | Incorrect parsing of create tablespace statement in 64-bit release | |
| 13669 | 2005-09-30 19:18 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (6293 days) | S4 | 5.0 | Any (all) | Any | Group commit is broken in 5.0 |
| 13831 | 2005-10-07 8:39 | 2005-10-07 9:00 | MySQL Server | Can't repeat (7698 days) | S3 | 4.1.12a | Windows (Windows XP) | Any | GROUP BY and AGGREGATE FUNCTION bug |
| 13857 | 2005-10-07 22:06 | 2005-10-21 10:55 | MySQL Server | Not a Bug (7684 days) | S2 | 5.0.13-rc-nt | Windows (Windows 2003) | Any | Comparison operator semantics changed, does not convert string date literals |
| 13987 | 2005-10-12 22:40 | 2007-11-21 9:49 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6923 days) | S2 | 5.0.15, 5.0.19 | Linux (Linux) | Any | Cluster: Loss of data nodes can cause high CPU usage from ndb_mgmd |
| 14006 | 2005-10-13 14:46 | 2005-10-19 7:42 | MySQL Server: Optimizer | Not a Bug (7686 days) | S3 | 5.0 | Linux (Linux) | Any | GROUP BY doesn't work |
| 14169 | 2005-10-20 9:18 | 2006-04-14 18:30 | MySQL Server | Closed (7509 days) | S3 | 5.0.13-rc, 5.0.15-BK, 5.0.16-nightly-20051017-debug | Linux (Linux, Windows) | Any | ORDER BY changes field type to BLOB for GROUP_CONCAT |
| 14445 | 2005-10-28 22:36 | 2005-11-01 12:21 | MySQL Server | Closed (7673 days) | S3 | 5.0 | Any | ANALYSE() computes wrong STD value for integer types | |
| 14536 | 2005-11-01 7:37 | 2005-11-12 22:51 | MySQL Server | Closed (7662 days) | S2 | 5.0 | Any | ./mysql-test-run --ps-protocol user_var fails | |
| 14607 | 2005-11-03 14:25 | 2006-11-02 7:02 | MySQL Server | Can't repeat (7307 days) | S3 | 5.1.7 | Linux (Linux, Windows) | Any | count(substring) cannot return value if we use rollup in group statement |
| 14666 | 2005-11-05 2:05 | 2005-11-05 4:31 | Connector / ODBC | Closed (7669 days) | S1 | 3.51 | Windows (Windows XP Pro) | Any | SELECT statement works in MySQL but not through ODBC |
| 14850 | 2005-11-10 23:13 | 2005-12-09 19:09 | MySQL Server: Views | Closed (7635 days) | S2 | 5.0.17-BK, 5.0.15 | Linux (Linux) | Any | ERROR 1062 when a quering a view using a Group By on a column that can be null. |
| 15130 | 2005-11-22 11:19 | 2007-07-27 16:23 | MySQL Server: Optimizer | Closed (7040 days) | S5 | 5.0.16, 4.1.15 | Linux (Linux) | Any | CREATE TABLE ... SELECT SQL_BIG_RESULT looses filesort optimization |
| 15135 | 2005-11-22 14:28 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (6437 days) | S5 | 4.1.14 | Any (NT) | Any | Dependent subquery performs very badly |
| 15343 | 2005-11-30 8:27 | 2006-01-02 17:37 | MaxDB | No Feedback (7611 days) | S2 | 7.5.00.30 | Linux (RedHat EE 4) | Any | Wrong SUM Calculation with Join and GROUP BY |
| 15352 | 2005-11-30 16:05 | 2005-11-30 16:48 | MySQL Server | Closed (7644 days) | S1 | 5.0.16-nt | Windows (Windows XP, 2000 Server) | Any | Crash: View within "Group by"-Statement |
| 15359 | 2005-11-30 17:27 | 2006-01-02 7:50 | MySQL Query Browser | No Feedback (7611 days) | S3 | 1.1.17 | Windows (Windows XP Pro, SP2) | Any | inet_ntoa output truncated when data is grouped |
| 15426 | 2005-12-02 9:34 | 2011-06-25 0:41 | MySQL Server: DML | Won't fix (5611 days) | S4 | 4.1,5.0 | Linux (Linux) | Any | SQL_CALC_FOUND_ROWS |
| 15504 | 2005-12-06 0:49 | 2006-06-28 15:17 | MySQL Administrator | Closed (7434 days) | S3 | 1.1.5/1.1.6 | Windows (Windows XP SP2 Home Edition) | Any | Group ctl height incorrect in Resources tab of User Admin |
| 15584 | 2005-12-08 12:25 | 2018-02-11 20:45 | MySQL Server | Analyzing (4887 days) | S4 | Any | Any | Server can not tell clients about generated keys | |
| 15706 | 2005-12-13 8:08 | 2006-02-28 0:55 | MySQL Server: Prepared statements | Closed (7554 days) | S3 | bk mysql-5.0 tree | Linux (Linux/x86) | Any | Test case 'subselect' fails in --ps-protocol mode |
| 16160 | 2006-01-03 17:57 | 2006-01-04 13:45 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7609 days) | S1 | 5.1 | Linux (Linux) | Any | DD: CREATE LOGFILE GROUP cause core |
| 16232 | 2006-01-05 17:11 | 2006-08-31 16:26 | MySQL Server: Views | Can't repeat (7370 days) | S3 | 5.0.17/5.0.19 BK | Linux (Linux 2.6) | Any | GROUP BY on a view with a WHERE restriction gives incorrect results |
| 16255 | 2006-01-06 16:07 | 2006-09-07 0:34 | MySQL Server: Optimizer | Closed (7363 days) | S3 | 4.1.16 | Windows (windows and linux) | Any | Subquery in where |
| 16272 | 2006-01-06 23:16 | 2006-02-21 22:32 | MySQL Server | Closed (7561 days) | S2 | 5.0.18 | Linux (Gentoo Linux) | Any | IF with floting point values does not work with GROUP BY |
| 16283 | 2006-01-08 13:24 | 2006-01-16 20:12 | MySQL Server: Views | Can't repeat (7597 days) | S2 | 5.0.17/18-nt | Windows (Windows) | Any | View returns wrong result |
| 16322 | 2006-01-10 0:04 | 2006-01-10 7:44 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7603 days) | S2 | 5.1.5-alpha | Linux (Linux) | Any | DD: drop tablespace before alter tablespace drop leaves cluster unstable |
| 16481 | 2006-01-13 14:07 | 2006-02-14 9:15 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7568 days) | S1 | 5.1.6-alpha | Linux (Linux) | Any | DD: Cluster fails during load of TPC-B tables |
| 16496 | 2006-01-13 21:04 | 2006-02-01 16:28 | MySQL Server | Can't repeat (7581 days) | S2 | 5.0.18-log | Linux (SUSE LINUX Enterprise Server 9) | Any | segfault when combining DISTINCT and GROUP BY in one query |
| 16705 | 2006-01-22 1:09 | 2006-06-01 12:06 | MySQL Server: Optimizer | Not a Bug (7461 days) | S2 | 5.0.19 | Linux (Linux) | Any | User variable in GROUP BY causes unpredictable results |
| 16753 | 2006-01-24 17:45 | 2006-02-02 12:37 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7580 days) | S2 | 5.1.6-alpha | Linux (Linux) | Any | DD: mysqldump does not support Cluster Disk Data backups |
| 16767 | 2006-01-25 3:23 | 2006-02-08 23:48 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7574 days) | S3 | 5.1 | Linux (Linux) | Any | DD: ALTER LG that does not exist returns wrong error code |
| 16779 | 2006-01-25 13:23 | 2006-04-10 18:20 | MySQL Server | Can't repeat (7513 days) | S1 | 5.0 | Windows (Windows) | Any | crash server UNION and SUM |
| 16792 | 2006-01-25 22:27 | 2006-09-25 17:44 | MySQL Server: Optimizer | Closed (7345 days) | S2 | 5.0.19-nightly-20060115 | Linux (linux) | Any | query with subselect, join, and group not returning proper values |
| 16854 | 2006-01-27 20:27 | 2025-12-07 20:45 | MySQL Server | Duplicate (7392 days) | S1 | MySQL 5.0.18 | Any | tinyint(1) are not treated as booleans in group by | |
| 16913 | 2006-01-30 18:48 | 2006-03-14 9:05 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7540 days) | S2 | 5.1 | Linux (Linux) | Any | DD: Cluster fails to create more then 9 table spaces. |
| 17007 | 2006-02-01 14:56 | 2006-02-03 13:58 | MySQL Server | Can't repeat (7579 days) | S1 | 5.0.18-nt | Windows (windows2003 web edition) | Any | sum crashes MySQL |
| 17253 | 2006-02-09 0:32 | 2006-03-16 15:03 | MySQL Server | No Feedback (7538 days) | S1 | 5.0.18, 5.0.15 | Linux (Linux 2.4.21-32) | Any | free(): invalid pointer, mysqld got signal 11 |
| 17487 | 2006-02-16 17:20 | 2006-02-19 9:25 | MySQL Server | Not a Bug (7563 days) | S4 | MySQL 5.0.18-nt | Windows (Windows XP Professional with SP2) | Any | CASE and IF() used in a group function (e.g. SUM ) results in error #1305 |
| 17499 | 2006-02-17 1:51 | 2006-02-28 19:37 | MySQL Server: Partitions | Closed (7554 days) | S1 | Any | Alter table of ndb partitioned tables causes mysqld to core | ||
| 17500 | 2006-02-17 2:28 | 2006-12-16 14:09 | MySQL Server: Optimizer | Can't repeat (7263 days) | S3 | 5.0.19-BK, 5.0.18-LOG | Linux (Linux, Freebsd 6.0) | Any | Format() + GROUP BY + PHP error |
| 17614 | 2006-02-21 14:06 | 2011-02-16 23:43 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6467 days) | S2 | 5.1.8 | Linux (Linux 64 bit OS) | Any | DD: SR fails when having logfilegroups wo/ undofiles |
| 17888 | 2006-03-03 6:38 | 2006-03-08 14:17 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7546 days) | S2 | 5.1 | Linux (Linux) | Any | DD: ADD INDEX causes error 756 'Index on disk column is not supported |
| 17974 | 2006-03-06 16:16 | 2006-03-21 10:08 | MySQL Server | Won't fix (7533 days) | S3 | 4.1.18 | Any (Any) | Any | INSERT ... SELECT with GROUP BY causes truncation of DECIMAL |
| 18006 | 2006-03-07 1:07 | 2006-03-07 1:34 | MySQL Server | Not a Bug (7547 days) | S2 | 5.0.16 | Windows (Windows 2003) | Any | GROUP BY can corrupt BIT values when multiple bits returned |
| 18144 | 2006-03-10 20:56 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5927 days) | S3 | 5.0.21-BK, 5.0.18 | Linux (Linux, FreeBSD) | Any | Cost with FORCE/USE index seems incorrect in some cases. |
| 18311 | 2006-03-17 15:42 | 2006-08-27 10:37 | MySQL Server | No Feedback (7374 days) | S1 | 5.0.21, 5.0.19 | Linux (Linux-2.6.12) | Any | MySQL Server crashes with "got signal 6" |
| 18490 | 2006-03-24 15:46 | 2006-04-05 4:41 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7518 days) | S2 | 5.1.8 bk src | Any | cluster: binlog events lost on remote mysqld (asynchronous) | |
| 18493 | 2006-03-24 17:01 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (7019 days) | S4 | 5.0.18 | Linux (Linux) | Any | "Using index for group-by" not used in subqueries |
| 18645 | 2006-03-30 10:30 | 2006-03-30 12:04 | Connector / J | Duplicate (7524 days) | S3 | MySQL 4.1.13 + Connector 3.1.12 | Linux (RedHat Linux) | Any | ResultSet.getString() returns a byte array for GROUP_CONCAT() |
| 18780 | 2006-04-04 19:47 | 2006-06-14 0:39 | MySQL Cluster: Disk Data | Closed (7448 days) | S1 | 5.1.9 | Linux (Linux) | Any | DD: DBT2 causes cluster failure using disk data in dbtup/DbtupDiskAlloc.cpp |
| 18856 | 2006-04-06 17:05 | 2007-08-21 19:50 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7015 days) | S2 | 5.1 | Linux (Linux) | Any | Table remains locked after SELECT * INTO OUTFILE statment. |
| 18865 | 2006-04-06 19:29 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified (7253 days) | S3 | mysql-4.1 | Linux (Linux) | Any | Table definitions "stay" even after a ndbd --initial |
| 19089 | 2006-04-13 20:49 | 2006-06-05 21:14 | MySQL Server: Optimizer | Closed (7457 days) | S3 | 5.0.20 | Any (any) | Any | CREATE TABLE ... SELECT * FROM a view with an ENUM column and GROUP BY fails |
| 19103 | 2006-04-14 13:04 | 2007-10-09 18:03 | MySQL Server: Documentation | Closed (6966 days) | S3 | 5.0 | Any | Any | --defaults-group-suffix not documented |
| 19320 | 2006-04-25 6:11 | 2013-10-06 20:45 | MySQL Server | No Feedback (7404 days) | S2 | 5.1.9 | Linux (RHEL4u2) | Any | Failing to create disk database |
| 19396 | 2006-04-27 9:15 | 2006-06-02 13:20 | MySQL Server | Closed (7460 days) | S1 | 5.0BK/5.1BK | Windows (Windows XP/Linux) | Any | LEFT JOINS on two views kills MySQL server (using MyODBC) |
| 19490 | 2006-05-02 20:17 | 2006-05-15 19:42 | MySQL Server | Closed (7478 days) | S1 | 5.0.21 and 5.1.10 | Linux (Linux) | Any | View on a date column with calculated INTERVAL crashes the server |
| 19631 | 2006-05-09 10:18 | 2006-05-10 11:46 | MySQL Server | Duplicate (7483 days) | S1 | 5.0.21 | FreeBSD (FreeBSD) | Any | count(distinct COL) yields wrong results when group-by key contains a cast |
| 19667 | 2006-05-10 8:57 | 2006-06-23 5:06 | MySQL Server | Closed (7439 days) | S1 | 5.0.21 | FreeBSD (FreeBSD) | Any | group by a decimal expression yields wrong result |
| 19703 | 2006-05-11 2:53 | 2006-05-12 17:22 | MySQL Server | Not a Bug (7481 days) | S4 | Linux (redhat9) | Any | group by with and? | |
| 20024 | 2006-05-23 16:36 | 2006-05-23 22:19 | MySQL Server | Not a Bug (7470 days) | S3 | 5.0.19 | Linux (RHEL4) | Any | Single Column Distict Query not performing as expected |
| 20053 | 2006-05-24 19:42 | 2006-07-03 16:53 | MySQL Cluster: Disk Data | Closed (7429 days) | S2 | 5.1.12 | Linux (Linux 32 Bit OS) | Any | TABLESPACE should only be allowed to drop files that are created for that TS |
| 20203 | 2006-06-01 13:45 | 2006-07-06 1:45 | MySQL Server: Views | Not a Bug (7426 days) | S3 | 5.0.22, 4.1.21-BK | Any (All) | Any | SEC_TO_TIME(SUM(TIME_TO_SEC( doesn't work correctly with a VIEW |
| 20284 | 2006-06-06 7:57 | 2006-07-27 2:47 | MySQL Server: Documentation | Closed (7405 days) | S4 | 5.0.20 | Any (All) | Any | There is no description of "copying to group table" |
| 20466 | 2006-06-14 18:02 | 2006-08-07 8:24 | MySQL Server | Closed (7394 days) | S3 | 5.0.22 | Linux (Linux 2.6.15 Debian Testing) | Any | SELECT with GROUP BY from view missing data when trigger defined on base table |
| 20709 | 2006-06-27 0:20 | 2006-08-10 15:47 | MySQL Server: MyISAM storage engine | Closed (7391 days) | S3 | 4.1 | Any (ALL) | Any | Collation not used in group by on 4.1 |
| 20805 | 2006-07-01 16:25 | 2006-07-05 13:55 | MySQL Server | Closed (7427 days) | S2 | 5.0.22 | Linux (linux) | Any | select with order by date_add crashes the server |
| 20825 | 2006-07-03 15:46 | 2006-10-25 19:24 | MySQL Server | Closed (7315 days) | S3 | 4.1.20 and 5.0.22, 5.0.24-BK | Linux (Linux, freebsd) | Any | rollup puts non-equal values together |
| 20868 | 2006-07-05 14:19 | 2006-08-02 19:08 | MySQL Server | Closed (7399 days) | S3 | 5.0.22/5.0BK/5.1BK | Linux (Fedora Core 5 (64-bit)) | Any | Client connection is broken on SQL query error |
| 21009 | 2006-07-12 17:38 | 2006-07-17 18:12 | MySQL Server | Can't repeat (7415 days) | S1 | 5.0.22 | FreeBSD (FreeBSD) | Any | mysql crashing on signal 11 |
| 21010 | 2006-07-12 17:38 | 2006-07-12 20:34 | MySQL Server | Duplicate (7420 days) | S3 | 4.0 4.1 5.0 5.1 | Any | GROUP BY clause resolves a string as an identifier | |
| 21174 | 2006-07-20 6:17 | 2007-04-12 21:24 | MySQL Server: Optimizer | Closed (7146 days) | S2 | 5.0.18, 5.1bk | Linux (linux) | Any | Index degrades sort performance and optimizer does not honor IGNORE INDEX |
| 21258 | 2006-07-24 19:38 | 2006-07-27 12:31 | MySQL Cluster: Cluster (NDB) storage engine | Not a Bug (7405 days) | S2 | 5.1 | Linux (Linux) | Any | Cluster will not start if new nodes added to the cluster with existing database. |
| 21316 | 2006-07-27 13:34 | 2006-07-27 15:39 | MySQL Server | Closed (7405 days) | S2 | 5.0.21 | Linux (Linux) | Any | a group by clause crash the server |
| 21361 | 2006-07-31 11:55 | 2006-09-05 13:39 | MySQL Server | Duplicate (7365 days) | S4 | 5.0.22 | Linux (Linux) | Any | Patch: create coredumps on linux when --user or --group is used |
| 21535 | 2006-08-09 10:58 | 2006-11-02 8:38 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7307 days) | S2 | MySQL cluster 5.0.22 | Linux (Redhat Linux 2.6.9-34.ELsmp #1 ) | Any | 3r: The failure handling of node 1 ends up in an infinite loop. |
| 21566 | 2006-08-10 12:25 | 2006-09-10 12:35 | MySQL Server | No Feedback (7360 days) | S1 | VERSION 5.1.17 | Linux (LINUX 2.4.20-8) | Any | Query Working With Windows XP is not Working in LINUX 2.4.20-8 |
| 21705 | 2006-08-17 22:50 | 2025-12-07 20:45 | MySQL Server: Optimizer | Duplicate (7363 days) | S2 | 4.1.21/4.1/5.0/5.1BK | Linux (Linux) | Any | COUNT(DISTINCT field) with GROUP BY forces incorrect behaviour of LIMIT |
| 21720 | 2006-08-18 12:33 | 2012-05-18 20:19 | MySQL Server | Duplicate (7356 days) | S2 | 5.0.24 | Windows (WinXP sp2) | Any | SELECT <group func> INTO @var .. GROUP BY gives wrong result |
| 21853 | 2006-08-27 20:36 | 2006-10-05 16:57 | MySQL Server: Optimizer | Closed (7335 days) | S2 | 5.0 | Linux (Linux) | Any | Query with "ALL" keyworkd doesnt return what's expected |
| 21892 | 2006-08-29 5:40 | 2013-10-06 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Duplicate (7371 days) | S1 | 5.1.11 | Linux (Debian 2.6.17 (32bit)) | Any | Cluster restart fails with disk tables |
| 22015 | 2006-09-05 12:24 | 2006-10-04 19:27 | MySQL Server | Closed (7336 days) | S1 | mysql-debug-5.0.24a-linux-i686-icc-glibc | Linux (Debian-GNU/Linux 2.6.16-2-k7) | Any | nested group_concat in subselect results in server crash |
| 22138 | 2006-09-09 3:13 | 2006-10-23 14:23 | MySQL Server: Optimizer | Closed (7317 days) | S3 | 5.0.24a,5.0BK,5.1BK | Any (*) | Any | Server crash on complex select |
| 22534 | 2006-09-21 0:18 | 2006-09-21 17:41 | MySQL Server | Can't repeat (7349 days) | S2 | any > 5 | Linux (linux) | Any | multiple aliases in a SELECT from a view with a GROUP BY clause has issues |
| 22704 | 2006-09-26 17:06 | 2007-07-05 21:10 | MySQL Cluster: Disk Data | Can't repeat (7062 days) | S1 | 5.1.12-main | Linux (Linux 32 Bit OS) | Any | Cluster Crashes during NR while DD schema operations are being handled |
| 22781 | 2006-09-28 14:51 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5981 days) | S2 | 5.0.24/5.0BK | Any | Any | SQL_BIG_RESULT fails to influence sort plan |
| 22874 | 2006-10-01 17:23 | 2006-10-05 9:24 | MySQL Server | Not a Bug (7335 days) | S3 | 5.0.24a | Linux (opensuse 10.0) | Any | ONLY_FULL_GROUP_BY conflicts with column alias |
| 22887 | 2006-10-02 11:55 | 2006-12-07 12:57 | MySQL Server: Information schema | No Feedback (7272 days) | S3 | 5.1.11 | Linux (ubuntu dapper drake linux) | Any | information_schema.FILES.TABLESPACE_NAME not null for UNDOFILEs |
| 23003 | 2006-10-05 7:36 | 2006-10-26 2:37 | MySQL Workbench Preview | Won't fix (7314 days) | S1 | 1.1.4 alpha | Windows (Windows XP SP2) | Any | Can't edit routine group object |
| 23135 | 2006-10-10 12:10 | 2006-10-10 13:39 | MySQL Server | Duplicate (7330 days) | S5 | 5.0.19 | Linux (Linux) | Any | Slow views performance |
| 23136 | 2006-10-10 12:17 | 2006-10-11 6:31 | MySQL Server: Views | Not a Bug (7329 days) | S1 | 5.0.19 | Linux (Linux) | Any | Views performance |
| 23539 | 2006-10-23 4:09 | 2006-10-27 5:40 | MySQL Enterprise Monitor: Server | Closed (7313 days) | S1 | Any | Expression evaluation stops after adding notification group to Heat Chart rule | ||
| 23610 | 2006-10-25 3:28 | 2006-11-03 18:52 | MySQL Enterprise Monitor: Installing | Closed (7306 days) | S1 | Linux (linux) | Any | Server - files in the /usr/sbin dir are being set to group 'mysql' (br 1787) | |
| 23800 | 2006-10-31 10:47 | 2007-03-06 19:30 | MySQL Server: Optimizer | Closed (7183 days) | S2 | 5.0.26-27/4.1BK/5.0BK/5.1BK | GNU/Linux (Archlinux) | Any | Correlated sub query returning incorrect results when operated upon |
Showing 1–1000 of 3114
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.130 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.