| Showing 1-1000 of 3030 (Edit, Save, CSV, Feed) | Show Next 1000 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 3686 | 2004-05-07 12:24 | 2004-05-12 16:18 | MySQL Server | Closed (8033 days) | S3 | 4.1.2 | Any | prepared statement, union + group by, inconsistent behaviour during prepare | |
| 1458 | 2003-10-01 13:47 | 2005-05-09 11:52 | MySQL Server | Won't fix (7671 days) | S4 | 4.0.13 | Any | configure options outside [group] works in 3.23.x but not 4.0.13 | |
| 17276 | 2006-02-09 14:51 | 2006-03-23 17:13 | MySQL Server | Won't fix (7353 days) | S4 | Any | Unwanted behaviour WITH ROLLUP | ||
| 21648 | 2006-08-15 6:12 | 2006-09-01 8:09 | MySQL Server: Tests | Closed (7191 days) | S3 | 5.1.12bk | Any | information_schema test fails --with-ndbcluster | |
| 22342 | 2006-09-14 12:37 | 2006-10-26 3:14 | MySQL Server | Closed (7136 days) | S2 | 5.0.22-pro-nt-log | Any | No results returned for query using max and group by | |
| 387 | 2003-05-07 6:02 | 2003-05-13 9:16 | MySQL Server | Closed (8398 days) | S3 | 4.0.12 | pc-linux (i686) | Any | ERROR 1055: 'NULL' isn't in GROUP BY -- in ANSI mode |
| 807 | 2003-07-07 19:10 | 2003-07-09 6:22 | MySQL Server | Closed (8341 days) | S2 | 4.0.12 | pc-linux (i686) | Any | Crash using CASE INTERVAL(...) ... GROUP BY |
| 16842 | 2006-01-27 14:12 | 2006-01-28 14:02 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7407 days) | S3 | 5.1.6 | Any | DD : Crash on drop logfile group after SR | |
| 18348 | 2006-03-20 6:36 | 2006-03-23 17:07 | MySQL Server | Won't fix (7353 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 (7313 days) | S3 | 5.1.8, 5.0.21, 4.1.19 | Any | mysqld reports ER_ILLEGAL_REFERENCE in --ps-protocol | |
| 19452 | 2006-04-30 23:49 | 2006-09-02 1:55 | MySQL Server: Installing | Closed (7190 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 (7254 days) | S2 | 5.0 | Any | outer JOIN + GROUP BY: wrong result | |
| 154 | 2003-03-15 5:44 | 2003-03-15 23:28 | MySQL Server: InnoDB storage engine | Closed (8457 days) | S2 | All | Any | Wrong group by or distinct on Innodb table indexed column with NULLs | |
| 314 | 2003-04-22 17:01 | 2003-04-26 4:22 | MySQL Server | Closed (8415 days) | S3 | 4.0 | Any | GROUP BY forces functions to treat multy-byte charset values as single-byte | |
| 1335 | 2003-09-18 10:06 | 2003-12-09 14:21 | MySQL Server | Closed (8188 days) | S3 | 4.0.15 | Any | "Filesort" is missing in EXPLAIN | |
| 1456 | 2003-10-01 8:23 | 2003-12-11 12:03 | MySQL Server | Closed (8186 days) | S3 | 4.1.1 | Any | cast with union and group by with rollup displays incorrect results | |
| 2063 | 2003-12-09 12:45 | 2003-12-10 5:58 | MySQL Server | Won't fix (8187 days) | S3 | 4.0.17 | Any | Strange GROUP BY behavior with user variables | |
| 3405 | 2004-04-06 22:04 | 2004-04-07 7:15 | MySQL Server: Documentation | Closed (8068 days) | S3 | 5 | Any | No explanation of "formula" for Group By/Order By in Select | |
| 3659 | 2004-05-05 10:34 | 2004-07-19 13:39 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7965 days) | S1 | mysql-4.1.2-alpha bk | FermiLinux LTS 3.01 | Any | >1 concurrent update causes deadlock |
| 8653 | 2005-02-21 16:33 | 2005-04-06 15:09 | MySQL Server | Closed (7704 days) | S1 | Any | 5.0.3 leaves an InnoDB trx open after connection ends; InnoDB shutdown hangs | ||
| 13556 | 2005-09-28 9:23 | 2006-01-24 11:36 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7411 days) | S3 | 5.1-ndb-dd | Any | Incorrect parsing of create tablespace statement in 64-bit release | |
| 14445 | 2005-10-28 22:36 | 2005-11-01 12:21 | MySQL Server | Closed (7495 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 (7484 days) | S2 | 5.0 | Any | ./mysql-test-run --ps-protocol user_var fails | |
| 16854 | 2006-01-27 20:27 | 2025-12-07 20:45 | MySQL Server | Duplicate (7214 days) | S1 | MySQL 5.0.18 | Any | tinyint(1) are not treated as booleans in group by | |
| 17499 | 2006-02-17 1:51 | 2006-02-28 19:37 | MySQL Server: Partitions | Closed (7376 days) | S1 | Any | Alter table of ndb partitioned tables causes mysqld to core | ||
| 18490 | 2006-03-24 15:46 | 2006-04-05 4:41 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7340 days) | S2 | 5.1.8 bk src | Any | cluster: binlog events lost on remote mysqld (asynchronous) | |
| 21010 | 2006-07-12 17:38 | 2006-07-12 20:34 | MySQL Server | Duplicate (7242 days) | S3 | 4.0 4.1 5.0 5.1 | Any | GROUP BY clause resolves a string as an identifier | |
| 23539 | 2006-10-23 4:09 | 2006-10-27 5:40 | MySQL Enterprise Monitor: Server | Closed (7135 days) | S1 | Any | Expression evaluation stops after adding notification group to Heat Chart rule | ||
| 23800 | 2006-10-31 10:47 | 2007-03-06 19:30 | MySQL Server: Optimizer | Closed (7005 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 |
| 24420 | 2006-11-18 22:49 | 2007-02-07 19:11 | MySQL Server: Optimizer | Closed (7032 days) | S2 | Any | (a,b) IN (SELECT a,min(b) FROM t GROUP BY a) can produce wrong results | ||
| 24915 | 2006-12-08 15:38 | 2006-12-11 21:48 | MySQL Server: Views | Closed (7090 days) | S3 | 5.0.16 | Any | using a view to retrieve a large number of entries | |
| 25696 | 2007-01-18 15:22 | 2007-03-05 19:54 | MySQL Server: Documentation | Closed (7006 days) | S4 | Any | Alternatives to rows with group-wise maximum | ||
| 25718 | 2007-01-19 12:32 | 2007-01-19 13:57 | MySQL Server | Can't repeat (7051 days) | S3 | 4.1.22 and 5.0.27 | Any | group by with alias in expression (follow up bug #11694) | |
| 26087 | 2007-02-05 15:27 | 2007-02-05 18:23 | MySQL Server | Closed (7034 days) | S3 | 5.0 | Unix | Any | Empty Result Set Returned When COUNT(), GROUP BY, and WHERE Are Used Together |
| 26613 | 2007-02-24 13:02 | 2007-02-24 13:09 | MySQL Server | Not a Bug (7015 days) | S2 | Any | convert not working on mysql can u give me the example | ||
| 14 | 2002-12-21 9:21 | 2002-12-27 20:46 | MySQL Server | Closed (8535 days) | S3 | 3.23.44 | Any | query results in a differnt number of rows depending if sql_big_tables | |
| 265 | 2003-04-09 18:04 | 2003-04-10 4:01 | MySQL Server: Documentation | Closed (8431 days) | S3 | Any | misspelling of SEPARATOR in documentation | ||
| 443 | 2003-05-17 11:39 | 2012-05-18 20:19 | MySQL Server | Duplicate (8392 days) | S1 | 4.1.1 | Any | Crash in query with ORDER BY, GROUP BY and subqueries | |
| 804 | 2003-07-07 13:25 | 2003-07-07 15:01 | MySQL Websites: MySQL.com | Duplicate (8343 days) | S2 | 08 JUL 2003 | N/A | Any | Missed Mensioning "Bug Fix" (Or Miss Fixing a Bug) |
| 805 | 2003-07-07 13:27 | 2003-07-14 14:04 | MySQL Websites: MySQL.com | Not a Bug (8336 days) | S2 | N/A | N/A | Any | Missed Mensioning "Bug Fix" (Or Miss Fixing a Bug) |
| 968 | 2003-07-31 12:19 | 2003-08-01 1:11 | MySQL Server: Installing | Closed (8318 days) | S3 | Any | script needs fixing | ||
| 1315 | 2003-09-16 19:39 | 2003-09-17 5:02 | MySQL Server: Command-line Clients | Not a Bug (8271 days) | S3 | Ver 11.15 Distrib 3.23.37 | sun-solaris2.7 (sparc) | Any | having clauses don't accept quotes around aliased column name |
| 1434 | 2003-09-29 13:24 | 2003-10-06 10:54 | MySQL Server | Closed (8252 days) | S1 | Any | MySQL crashes on CREATE TABLE IF NOT EXISTS ... SELECT ... | ||
| 1451 | 2003-09-30 16:24 | 2003-10-03 1:20 | MySQL Server: InnoDB storage engine | Closed (8255 days) | S2 | 4.0.13 | Any | Export Table Creation - Error with Foreign Key | |
| 1708 | 2003-10-30 0:56 | 2003-11-02 7:33 | MySQL Server: InnoDB storage engine | Closed (8225 days) | S2 | 4.1.1 (2003-10-30) | Any | InnoDB crash on a subquery | |
| 2001 | 2003-12-03 3:23 | 2003-12-03 6:32 | MySQL Server | Not a Bug (8194 days) | S3 | Any | Problems with table names | ||
| 2495 | 2004-01-23 11:51 | 2004-03-18 23:39 | MySQL Server | Closed (8088 days) | S3 | 5.0 | Any | Crash with default-character-set=tis620 | |
| 3190 | 2004-03-16 9:45 | 2005-02-28 19:29 | MySQL Server | Closed (7741 days) | S4 | Any | Standard Deviation STDDEV - 2 different calculations | ||
| 3626 | 2004-05-02 1:19 | 2004-06-02 19:57 | MySQL Administrator | Closed (8012 days) | S3 | 1.0.3 | Any | Unable to remove graphs and groups | |
| 4215 | 2004-06-18 23:30 | 2012-05-18 20:19 | MySQL Server: Installing | Duplicate (7933 days) | S2 | 4.1.2 | REL 3 | Any | Intel 4.1.2 mysql_install_db fails |
| 4253 | 2004-06-22 23:20 | 2005-12-13 16:36 | MySQL Server | Won't fix (7453 days) | S4 | Any | add a "herarchical data structure" - table type | ||
| 5269 | 2004-08-27 21:56 | 2004-10-30 1:01 | MySQL Server: MyISAM storage engine | Can't repeat (7862 days) | S2 | Any | Error 127 from query, check/repair report no problems | ||
| 6016 | 2004-10-11 11:38 | 2004-10-11 14:47 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7881 days) | S2 | Any | Strange crash with blobs + different DATABASES | ||
| 6818 | 2004-11-25 1:42 | 2004-11-26 7:35 | MySQL Server: Documentation | Closed (7835 days) | S3 | 4.1.7 | Any | undocumented change in alias behavior | |
| 7946 | 2005-01-16 19:20 | 2005-02-04 21:04 | MySQL Server | Closed (7765 days) | S3 | 4.1.9 | Any | distinct with subquery and group by | |
| 8616 | 2005-02-19 1:56 | 2005-03-21 20:04 | MySQL Server | Closed (7720 days) | S3 | 4.1.10 | Any | distinct with group by, suppresses rollup (and/or parts of result) | |
| 8638 | 2005-02-21 8:32 | 2005-02-24 13:19 | MySQL Server | Closed (7745 days) | S3 | 5.0.3-pre | Almost all Unix | Any | Test 'sp' fails: Stored Procedure often sends warning 1329 |
| 8640 | 2005-02-21 9:47 | 2005-02-24 13:53 | MySQL Server | Closed (7745 days) | S2 | 5.0.3-pre | some Unix 64-bit | Any | Server crash due to 'flush status' in various tests |
| 9618 | 2005-04-04 18:16 | 2005-04-06 9:55 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7704 days) | S2 | 4.1.11 | x86: Linux, OpenBSD, QNX, Sol 8 | Any | Test 'group_by' returns more rows than expected when NDB is included |
| 11314 | 2005-06-14 12:41 | 2005-06-14 15:16 | MySQL Server | Closed (7635 days) | S2 | 5.0 | Any | SELECT GROUP HAVING DEFAULT(a) hangs | |
| 11375 | 2005-06-16 10:57 | 2020-11-22 20:45 | MySQL Server: Documentation | No Feedback (7450 days) | S2 | Any | Unbalanced data for number of nodes not on the form 2 ** n | ||
| 11829 | 2005-07-09 2:19 | 2005-07-11 14:06 | MySQL Server: Documentation | Closed (7608 days) | S3 | Any | D.1.3. Changes in release 5.0.8 - bad example code | ||
| 12121 | 2005-07-22 18:57 | 2005-09-09 17:30 | MySQL Server: Documentation | Closed (7548 days) | S3 | Any | C-API: mysql_real_connect documentation is not exact | ||
| 13081 | 2005-09-09 7:36 | 2005-10-05 23:53 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7522 days) | S2 | 5.0.13 | Any | NDB gets incorrect result in test-ATIS | |
| 13088 | 2005-09-09 13:35 | 2005-09-09 17:17 | MySQL Server: Documentation | Closed (7548 days) | S3 | Any | Documentation Bug for the ENUM field | ||
| 13180 | 2005-09-14 13:50 | 2005-09-23 18:19 | MySQL Server: Optimizer | Closed (7534 days) | S3 | 4.1.14/5.0 BK source | * / freebsd/Suse 9.3 | Any | server accepts sometimes group in update's where condition |
| 13475 | 2005-09-26 8:40 | 2026-02-08 20:45 | MySQL Server | Duplicate (7514 days) | S3 | mips-sgi-irix6.5 | Any | yassl: octane2 server crash | |
| 14418 | 2005-10-28 9:02 | 2005-12-09 14:36 | MySQL Server: Replication | Closed (7457 days) | S2 | Any | RBR: Uncertain behaviour when stopping updates in the middle | ||
| 16109 | 2005-12-30 23:35 | 2006-01-05 15:45 | MySQL Server: Documentation | Closed (7430 days) | S3 | n/a | n/a | Any | doubled words in 5.0.17 manual |
| 17594 | 2006-02-20 19:41 | 2012-05-18 20:19 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (7331 days) | S1 | 5.1.7-beta | Various Unix | Any | Various NDB startup / restart problems |
| 18451 | 2006-03-23 8:46 | 2006-06-19 12:56 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7265 days) | S1 | 5.1 | Any | Restoring a backup changes fragement type | |
| 18742 | 2006-04-03 15:05 | 2006-05-25 17:23 | MySQL Server | Closed (7290 days) | S3 | 5.0.21-pre | Any | Test 'group_min_max' fails if "classic" configuration in 5.0 | |
| 18765 | 2006-04-04 5:00 | 2006-05-04 10:58 | MySQL Server | No Feedback (7311 days) | S2 | 5.0.19-nt | server 2003 or winXP | Any | query with subquery hangs server. |
| 19737 | 2006-05-11 18:36 | 2006-05-12 17:09 | MySQL Server: Installing | Closed (7303 days) | S3 | 4.0-BK, 4.1-BK, 5.0-BK | Unix | Any | Some file modes too restrictive for other-user "make install" |
| 21810 | 2006-08-24 12:29 | 2006-08-24 21:58 | MySQL Server | Duplicate (7199 days) | S3 | 5.0.22 | Any | parser bug perhaps? | |
| 21924 | 2006-08-30 15:05 | 2026-02-08 20:45 | MySQL Server: Tests | Duplicate (7192 days) | S3 | Any | func_group test fails in 5.1 | ||
| 21981 | 2006-09-03 9:31 | 2006-09-06 12:16 | MySQL Cluster: Disk Data | Closed (7186 days) | S3 | Any | ndbd crashes during CREATE LOGFILE GROUP if compiled with gcc4 (on some platform | ||
| 22965 | 2006-10-03 23:15 | 2006-10-04 12:33 | MySQL Server | Closed (7158 days) | S4 | Any | Feature request: WEIGHTED_AVG | ||
| 23340 | 2006-10-16 17:01 | 2014-02-20 8:22 | MySQL Server | Open | S4 | Any | Calculate Age Function (days,months and years of age) | ||
| 25375 | 2007-01-02 21:51 | 2007-01-08 18:03 | MySQL Enterprise Monitor: Documentation | Closed (7062 days) | S4 | 1.0.0 | Any | The log-level option for the [agent] group is not documented in the manual | |
| 26937 | 2007-03-07 21:46 | 2020-05-03 20:45 | MySQL Server | Duplicate (7002 days) | S1 | 4.1,5.0,5.1 | Any | Wrong results when using GROUP BY SUBSTRING(..) and LONGTEXT | |
| 26990 | 2007-03-09 9:14 | 2007-03-09 10:45 | MySQL Server: Documentation | Closed (7002 days) | S3 | Any | Typo in 5.1 Documentation Chapter 13.1.9. | ||
| 98782 | 2020-02-28 18:57 | 2020-07-20 8:31 | MySQL Server: InnoDB storage engine | Can't repeat (2120 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 (2803 days) | S3 | 5.7.23 | Any | Any | GR recovery can retry infinitely if count is modified to lower value on the fly |
| 33266 | 2007-12-16 7:33 | 2018-09-25 21:47 | MySQL Server: Tests | Closed (6612 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 (5691 days) | S1 | 5.6.99-m5 | Any | Any | Stop slave at middle of the transaction can cause fatal error |
| 17590 | 2006-02-20 17:44 | 2006-02-23 9:32 | MySQL Server: Optimizer | Can't repeat (7381 days) | S2 | 5.1.7-beta | Any (All) | Any | Different key-len and # rows reported on all platforms |
| 74095 | 2014-09-26 8:04 | 2014-10-27 14:04 | MySQL Server: Documentation | Closed (4213 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 (5745 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 |
| 108118 | 2022-08-11 12:22 | 2022-08-22 16:47 | MySQL Server: Group Replication | Verified (1368 days) | S4 | 8.0.30 | Any | Any | group replication reconfiguration should not require destroying the group |
| 71199 | 2013-12-21 18:16 | 2014-01-28 17:45 | MySQL Server: Optimizer | Verified (4521 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 (3649 days) | S3 | 5.6.29 | Any | Any | min/max optimization ignores group by |
| 98770 | 2020-02-28 4:02 | 2020-03-03 15:05 | MySQL Server: Optimizer | Verified (2259 days) | S5 | 8.0.19 | Any | Any | Non-covering full index scan is always preferred over table scan for GROUP BY |
| 114638 | 2024-04-12 16:33 | 2024-08-06 9:58 | MySQL Server: DML | Closed (643 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 (4454 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 (4240 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 (3693 days) | S3 | 7.4.11 | Any | Any | Binlog schema distribution timeout and fails when another mysql node start |
| 103378 | 2021-04-20 3:34 | 2021-04-20 9:08 | MySQL Server: Optimizer | Not a Bug (1846 days) | S3 | 8.0.23 | Any | Any | sql_mode=only_full_group_by error 1055 is not appear for DELETE and UPDATE |
| 30477 | 2007-08-17 15:12 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (6838 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 (5395 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 (4635 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 (4356 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 (4177 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 (3904 days) | S3 | 5.6.22 | Any | Any | Similar query with aggregate functions returns inconsistent result |
| 90494 | 2018-04-18 12:04 | 2018-11-06 16:57 | MySQL Server: Group Replication | Closed (2830 days) | S3 | 8.0.12 | Any | Any | gr_exit_state_action=ABORT_SERVER is not considered on compatibility checks |
| 97207 | 2019-10-14 1:18 | 2019-10-14 10:21 | MySQL Server: Replication | Verified (2400 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 (1563 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 (1537 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 (383 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 |
| 57815 | 2010-10-28 14:52 | 2018-12-09 20:45 | MySQL Enterprise Monitor: Web | Verified (5673 days) | S3 | 2.3.0.2036 | Any | Any | There was a problem generating the Support Report for Group "". |
| 75287 | 2014-12-22 13:44 | 2015-03-30 15:58 | Connector / Python | Closed (4093 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 (2867 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 (3000 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 (3041 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 (2481 days) | S2 | 5.7.20, 8.0.3 | Any | Any | Total ordering of transactions is not respected in Group Replication. |
| 103869 | 2021-05-31 14:29 | 2021-06-03 10:21 | MySQL Server: Optimizer | Verified (1803 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 (1399 days) | S3 | 8.0, 8.0.29 | Any | Any | Result error : SQL with group by with rollup and const field |
| 33655 | 2008-01-03 16:06 | 2008-07-31 17:19 | MySQL Server: Documentation | Closed (6492 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 (6634 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 (6541 days) | S2 | 5.1.23/5.1.24 | Any | Any | aggregate functions with columns and aggregate functions works (shouldn't?) |
| 57833 | 2010-10-29 8:05 | 2018-04-17 13:01 | MySQL Enterprise Monitor: Web | Closed (2945 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 (3882 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 (3461 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 (2995 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 (2999 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 (2803 days) | S3 | 5.7.23 | Any | Any | Config issue makes server skips own details in ER_GRP_RPL_MEMBER_CHANGE msg |
| 99838 | 2020-06-10 8:57 | 2020-07-13 12:42 | MySQL Server: Parser | Not a Bug (2127 days) | S3 | 8.0.20 | Any | Any | FULL GROUP BY violation insides a subquery |
| 4907 | 2004-08-05 9:23 | 2004-08-08 1:03 | MySQL Server | Closed (7945 days) | S4 | any | Any (any) | Any | feature request - SQL extensions |
| 28691 | 2007-05-25 20:16 | 2007-08-23 16:42 | MySQL Server: Optimizer | Not a Bug (6835 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 (6911 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 (2220 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 (5650 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 (5686 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 (5526 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 (3010 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 | 2012-02-28 10:12 | MySQL Workbench: Modeling | Verified (5186 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 (4524 days) | S3 | 5.5.33 | Any | Any | Loose index scan is used even though full table scan/tight index scan is faster |
| 77508 | 2015-06-26 14:12 | 2016-04-27 15:05 | MySQL Server: Replication | Closed (3967 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 (3274 days) | S2 | 8.0 | Any | Any | WL#9236: including or excluding columns from SELECT list makes results wrong |
| 89870 | 2018-03-01 14:21 | 2020-10-02 14:27 | MySQL Server: Partitions | Not a Bug (2046 days) | S4 | 5.7.18 | Any | Any | Group by optimization not used with partitioned tables |
| 96579 | 2019-08-18 19:59 | 2019-08-19 22:27 | MySQL Server: Errors | Not a Bug (2456 days) | S3 | 5.6/5.7/8.0 | Any | Any | Unexpected error message when using an outer reference in HAVING |
| 102433 | 2021-02-01 8:49 | 2025-01-31 16:08 | MySQL Server: Group Replication | Verified (1924 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 (1779 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 (1776 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 (1426 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 (879 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 (817 days) | S4 | 8.0 | Any | Any | improve GR error reporting |
| 15643 | 2005-12-09 18:42 | 2006-09-06 19:12 | MySQL Server: Documentation | Closed (7186 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 |
| 23462 | 2006-10-19 13:42 | 2007-06-14 14:21 | MySQL Server | Not a Bug (6905 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 (6731 days) | S3 | 5.0.38 | Any | Any | command line clients puke on 'init-command' in my.cnf |
| 34751 | 2008-02-21 22:19 | 2018-02-08 22:42 | MySQL Server: DML | Closed (3013 days) | S3 | 5.0+ | Any | Any | Inside HAVING clause subqueries with aggregates and without GROUP BY rise error |
| 45267 | 2009-06-02 13:01 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5648 days) | S3 | 5.4 | Any | Any | GROUP BY does not group NULLs on certain JOINs |
| 48703 | 2009-11-11 21:58 | 2022-09-04 20:45 | MySQL Server: Optimizer | In progress (5816 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 (5001 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 (5930 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 (4955 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 (5596 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 (3811 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 (3894 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 (3891 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 (3245 days) | S3 | 5.7.9 | Any | Any | Grouping on aggregated results not always rejected |
| 80726 | 2016-03-14 10:49 | 2016-11-19 16:27 | MySQL Server: Optimizer | Closed (3462 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 (3618 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 (3104 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 (3168 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 (3041 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 (2706 days) | S3 | 8.0.13 | Any | Any | ALL MEMBERS ARE EXITED FROM GR WHEN 1/4 NODE TRIED TO REJOIN AFTER network drop |
| 99778 | 2020-06-04 12:27 | 2020-07-02 14:12 | MySQL Server: Group Replication | Closed (2138 days) | S2 | 8.0.18 | Any | Any | Error when processing certification information in the incremental recovery proc |
| 101391 | 2020-10-30 3:04 | 2020-11-19 16:59 | MySQL Server: Performance Schema | Verified (1998 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 (1868 days) | S3 | mysql.5.7 | Any | Any | MTS fail due to ignore stop event when logical timestamp reset on new binary fil |
| 103766 | 2021-05-21 11:35 | 2022-03-16 11:36 | MySQL Server: Documentation | Verified (1815 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 (1328 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 (1014 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 (943 days) | S3 | 5.7 | Any | Any | All nodes elected as PRIMARY |
| 114248 | 2024-03-06 16:22 | 2024-03-07 14:05 | MySQL Server: InnoDB storage engine | Verified (794 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 (717 days) | S3 | 8.0.36 | Any | Any | SSL connection server_capabilities has overflow |
| 20293 | 2006-06-06 13:12 | 2007-03-15 3:10 | MySQL Server | Closed (6996 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 |
| 24860 | 2006-12-06 18:17 | 2007-11-28 19:03 | MySQL Server: Replication | Closed (6738 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 (6905 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 (6862 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 (6891 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 (6864 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 (6499 days) | S3 | 1.2.0.7214 | Any | Any | Rename "remove all from group" to "delete group" |
| 31559 | 2007-10-12 9:23 | 2018-09-25 21:45 | MySQL Server: Tests | Closed (6785 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 (6493 days) | S3 | 6.0.5 | Any | Any | New CREATE TABLESPACE behavoir with Falcon |
| 35628 | 2008-03-28 1:41 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (6397 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 (6431 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 (6124 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 (3763 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 (6131 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 (5648 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 (5905 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 (5903 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 (5654 days) | S1 | 6.3.4 | Any | Any | "Key" groupped by cannot be used in linq2e, group by subquery cannot be executed |
| 64855 | 2012-04-03 14:53 | 2012-05-16 13:20 | MySQL Server: Stored Routines | Verified (5107 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 (4925 days) | S3 | 5.5.26 | Any | Any | ONLY_FULL_GROUP_BY documentation doesn't mention implicit group by |
| 71125 | 2013-12-11 8:38 | 2013-12-13 1:54 | MySQL Fabric | Closed (4531 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 (4366 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 (4456 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 (4449 days) | S3 | 5.6.15 | Any | Any | GROUP BY performance differs wildly for tautologically equal columns |
| 76319 | 2015-03-13 19:36 | 2017-07-06 19:19 | MySQL Fabric | Won't fix (4073 days) | S4 | 1.5 | Any | Any | MySQL Fabric Service - Monitoring from external monitoring software |
| 81494 | 2016-05-19 3:22 | 2019-05-16 16:45 | MySQL Server: mysqldump Command-line Client | Closed (2551 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 (3375 days) | S3 | 5.7.15 | Any | Any | Documentation clarifications about how default option files are used |
| 84008 | 2016-11-29 18:24 | 2017-11-08 10:21 | MySQL Server: Group Replication | Closed (3327 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 (3156 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 (3267 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 (3230 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 (2641 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 (2951 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 (3009 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 (3026 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 (2679 days) | S1 | 8.0 | Any | Any | Add IPv6 support for Group Replication |
| 94429 | 2019-02-21 18:00 | 2019-07-25 8:36 | MySQL Server: Group Replication | Closed (2616 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 (2510 days) | S4 | 8.0.15 | Any | Any | Group Replication does not support SSL wildcard certificates |
| 100764 | 2020-09-08 8:50 | 2025-09-28 20:45 | MySQL Server: Optimizer | No Feedback (2033 days) | S1 | 8.0 | Any | Any | Rename Table causes other SQL execution plans to change. |
| 102706 | 2021-02-23 15:02 | 2021-03-13 23:18 | MySQL Server: Documentation | Closed (1884 days) | S3 | 8.0.21, 8.0.23 | Any | Any | Update group replication docs replication configuration requirements |
| 106430 | 2022-02-10 8:41 | 2022-02-17 14:31 | MySQL Server: Group Replication | Can't repeat (1543 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 (985 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 (1395 days) | S1 | 8.0.* | Any | Any | event scheduler cause error on group replication |
| 109034 | 2022-11-09 4:15 | 2022-11-14 14:45 | MySQL Server: Logging | Verified (1273 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 (1215 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 (1209 days) | S3 | 5.7.40 | Any | Any | Timeout on wait for view after joining group |
| 110773 | 2023-04-23 7:56 | 2023-11-28 21:08 | MySQL Server: Group Replication | Verified (899 days) | S3 | mysql 8.0.32 | Any | Any | group_replication start faild use different ips and same port on same server |
| 115679 | 2024-07-24 9:04 | 2024-07-24 9:46 | MySQL Server: Optimizer | Verified (655 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 (395 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 | 2025-12-22 19:42 | MySQL Server: Optimizer | Verified (139 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 (116 days) | S3 | 9.2 | Any | Any | Doc: Group Replication “write set” definition is unclear/misleading (group-replication-summary) |
| 2467 | 2004-01-21 1:56 | 2012-05-18 20:19 | MySQL Server | No Feedback (7489 days) | S4 | 4.0.17 | Any (All) | Any | Use of an alias in a 'group by function'? |
| 4402 | 2004-07-04 8:21 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6428 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 (6946 days) | S4 | <4.1 | Any (doesn't matter) | Any | GROUP takes the first-found values |
| 5029 | 2004-08-13 11:49 | 2013-06-27 15:39 | MySQL Server: Command-line Clients | Closed (4700 days) | S4 | all | Any (all) | Any | mysql command to be able to use different configuration groups |
| 8614 | 2005-02-19 0:53 | 2005-06-22 2:29 | MySQL Server: Optimizer | Closed (7627 days) | S3 | 4.1.10 | Any (*) | Any | distinct sometimes ignored with group by "CONST" |
| 10005 | 2005-04-19 17:40 | 2006-01-09 14:46 | Eventum | Closed (7426 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 (4710 days) | S4 | next | Any (all) | Any | selecting a consistent row of aggrigate data during a group |
| 15131 | 2005-11-22 11:44 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (6249 days) | S4 | 4.1,5.0 | Any | Any | On-disk temporary tables created for GROUP BY should use indexes |
| 20536 | 2006-06-19 13:36 | 2006-09-25 15:00 | MySQL Server: Charsets | Closed (7167 days) | S3 | 5.0.23BK, 4.1 | Any (*) | Any | md5() with GROUP BY and UCS2 return different results on myisam/innodb |
| 23171 | 2006-10-11 10:09 | 2007-04-12 16:04 | MySQL Server: Replication | Closed (6968 days) | S3 | 5.1 | Any | Any | Illegal slave restart (group) position |
| 29017 | 2007-06-11 11:43 | 2007-06-26 8:04 | MySQL Server | Can't repeat (6893 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 (6857 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 (6467 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 |
| 30219 | 2007-08-03 3:40 | 2007-08-25 16:19 | MySQL Server: MyISAM storage engine | Closed (6833 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 (6774 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 (6716 days) | S2 | 1.3.0.8528 | Any | Any | group name is not displayed |
| 34620 | 2008-02-16 17:16 | 2008-03-15 8:41 | MySQL Server: DML | Closed (6630 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 (5650 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 (6034 days) | S1 | 6.0 | Any | Any | Crash in test_if_skip_sort_order, bad value for used_key_parts |
| 37977 | 2008-07-08 20:38 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5654 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 (6461 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 (6304 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 (6424 days) | S3 | 5.0 | Any | Any | Incorrect result with HAVING and no GROUP BY |
| 43342 | 2009-03-03 21:54 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6277 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 (6187 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 (6042 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 (6042 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 (6162 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 (6120 days) | S3 | 5.0, 5.1, 5.4/6.0 | Any | Any | Aggregate function documentation needs clarification for non-GROUP BY behavior |
| 48118 | 2009-10-16 14:22 | 2022-09-04 20:45 | MySQL Server: Optimizer | Duplicate (5914 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 (5647 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 (5886 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 (5749 days) | S3 | 5.1.41, 5.1.44, 5.6.99 | Any | Any | Index hint/forcing for GROUP BY / ORDER BY is broken |
| 53161 | 2010-04-26 13:12 | 2013-01-18 1:51 | MySQL Server: Optimizer | Closed (4860 days) | S1 | 5.1.37, 5.1.46, 5.1.47 | Any | Any | Left join optimized into join leads to incorrect results |
| 59557 | 2011-01-17 15:26 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5592 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 (5576 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 (5511 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 |
| 62712 | 2011-10-13 0:54 | 2018-09-25 21:51 | Tools: MTR / mysql-test-run | Closed (5263 days) | S7 | 5.5.17 | Any | Any | RPM-based install of the test suite is useless for non-root users. |
| 67978 | 2012-12-27 6:13 | 2012-12-29 16:21 | MySQL Server: Memory storage engine | Verified (4880 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 (4703 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 (4308 days) | S4 | 1.4.1 | Any | Any | option to join FAULTY MySQL instance back into group |
| 72281 | 2014-04-09 0:02 | 2017-07-06 19:19 | MySQL Fabric | Won't fix (4409 days) | S3 | Any | Any | mysqlfabric group promote may break replication | |
| 73066 | 2014-06-20 15:45 | 2023-01-12 18:36 | MySQL Server: Replication | Closed (2739 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 (4241 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 (4059 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 (4115 days) | S6 | 5.6.20, 5.6.23, 5.7.6 | Any | Any | Assertion `scale >= 0 && precision > 0 && scale <= precision' failed |
| 76501 | 2015-03-27 6:50 | 2015-03-27 15:11 | MySQL Server: Optimizer | Verified (4062 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 (3792 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 (3895 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 (3891 days) | S3 | 5.6.22 | Any | Any | Valid select with expression in group by under "only_full_group_by" fails |
| 79100 | 2015-11-03 17:01 | 2015-11-17 18:52 | MySQL Server: Documentation | Closed (3827 days) | S3 | any, 5.5, 5.6, 5.7 | Any | Any | MySQL Manual does not explain when ORDER BY NULL does NOT prevent filesort |
| 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 (3713 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 (3544 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 (3553 days) | S3 | 5.7.14 | Any | Any | Duplicate entry '' for key '<group_key>' while doing group by |
| 84337 | 2016-12-26 8:50 | 2017-07-11 11:52 | MySQL Server: Group Replication | Closed (3225 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 (2684 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 (3170 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 (3254 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 (564 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 (3295 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 (3159 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 (2951 days) | S2 | 5.7.20, 8.0.3 | Any | Any | Wrong certification lead to data inconsistency and GR breakage. |
| 90553 | 2018-04-21 10:46 | 2019-07-11 7:55 | MySQL Server: Documentation | Closed (2495 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 (2895 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 (2877 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 (2872 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 (2803 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 (2800 days) | S2 | 5.7.23 | Any | Any | Mysql initilize replication component failed |
| 93347 | 2018-11-26 14:56 | 2019-07-25 8:30 | MySQL Server: Group Replication | Closed (2630 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 (2079 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 (2216 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 (2151 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 (2077 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 (2045 days) | S3 | 8.021 | Any (Tried on windows, mac, centos) | x86 | Select with group by returns different results |
| 100985 | 2020-09-29 7:42 | 2020-09-29 9:18 | MySQL Server: Optimizer | Verified (2049 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 |
| 102515 | 2021-02-07 11:03 | 2021-03-09 7:36 | MySQL Server: Group Replication | Verified (1916 days) | S2 | 8.0.23 | Any | Any | Group replication member remains ONLINE even when it gets (far) behind |
| 103930 | 2021-06-07 18:06 | 2021-06-08 13:55 | MySQL Server: DML | Verified (1797 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 (1011 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 (696 days) | S5 | 8.0.29 | Any | Any | Performance of Temptable is worse than Memory in GROUP BY scenario |
| 108411 | 2022-09-07 12:26 | 2022-09-08 13:15 | Shell AdminAPI InnoDB Cluster / ReplicaSet | Can't repeat (1340 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 (1165 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 (1271 days) | S3 | 8.0.31 | Any | Any | DOC issue with group_replication_communication_debug_options description |
| 110245 | 2023-03-01 3:56 | 2023-03-02 9:59 | MySQL Server: Optimizer | Not a Bug (1165 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 (1059 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 (1060 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 (976 days) | S3 | 8.0.34 | Any | Any | Incorrect costing of group by loose index scans |
| 112881 | 2023-10-30 9:17 | 2023-10-30 9:36 | MySQL Server: Security: Privileges | Verified (923 days) | S4 | 8.2 | Any | Any | Allow forcing a specific resource group for MySQL users for limiting CPU usage |
| 118849 | 2025-08-18 12:14 | 2025-08-18 23:50 | MySQL Server: Optimizer | Verified (265 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 (229 days) | S3 | 9.4.0 | Any | Any | Execute some acl statements to a cluster without quorum in group replication makes login stuck |
| 119174 | 2025-10-16 13:18 | 2026-01-13 20:33 | MySQL Server | Not a Bug (117 days) | S3 | 9.4.0 | Any | Any | unexpected value after changing Max to Min |
| 119669 | 2026-01-13 13:27 | 2026-01-13 14:53 | MySQL Server: Optimizer | Verified (117 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 (111 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 (110 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-03-26 15:51 | Shell Upgrade Checker | Verified (45 days) | S3 | 8.4.8 | Any | Any | mysql shell server upgrade checks ignoring cross database foreign key references in foreignKeyReferences check |
| 2007 | 2003-12-03 18:58 | 2004-06-01 0:32 | MySQLCC | Closed (8013 days) | S3 | 0.9.3 | Any (all) | Any | mysqlcc doesn't read [client] group |
| 8093 | 2005-01-22 20:08 | 2005-01-24 17:19 | MySQL Server: MyISAM storage engine | Closed (7776 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 (5758 days) | S3 | 4.1.x, 5.x | Any | Any | Optimization Problem with a subquery in an IN Operation |
| 10982 | 2005-05-31 12:02 | 2005-06-01 3:49 | MySQL Server | Closed (7648 days) | S2 | 5.0 | Any (all) | Any | A query from olap.test returns a wrong result set |
| 13024 | 2005-09-06 23:04 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (7550 days) | S4 | 4.1.14, 5.0.11 | Any | Any | optimizer does not use index when where has (field1,field2,..)=(value1,value2,. |
| 13432 | 2005-09-23 16:05 | 2005-10-13 18:37 | MySQL Server | Closed (7514 days) | S4 | ANY | Any (ANY) | Any | C API: sending a group of rows at a time |
| 14019 | 2005-10-13 22:45 | 2006-10-26 3:17 | MySQL Server: Optimizer | Closed (7136 days) | S3 | 4.1.14 / 5.1.13 | Any (*) | Any | group by converts literal string to column name |
| 24114 | 2006-11-08 23:43 | 2007-05-10 13:08 | MySQL Enterprise Monitor: Web | Closed (6940 days) | S4 | 1.0.0 | Any (all) | Any | selecting no notifcations and a notification group results in an error |
| 26830 | 2007-03-04 5:43 | 2007-03-15 3:00 | MySQL Server: General | Closed (6996 days) | S1 | 5.0.38BK, 5.1.17BK | Any (*) | Any | subquery, group by .. with rollup crashes server |
| 27721 | 2007-04-09 20:12 | 2012-05-30 7:05 | MySQL Server: Stored Routines | Verified (5094 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 (6927 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 (6860 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 (6862 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 (6138 days) | S4 | 5.1 | Any | Any | LAST ENTRY of a GROUP BY sql statement |
| 29845 | 2007-07-17 13:10 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (6753 days) | S4 | 6.0.0-alpha | Any | Any | GROUP BY does not make best use of indicies when evaluating SUM aggregates |
| 30075 | 2007-07-26 15:33 | 2014-03-13 13:36 | MySQL Enterprise Monitor: Web | Won't fix (6841 days) | S4 | 1.2.0 | Any | Any | Allow reordering of servers within a group |
| 31772 | 2007-10-23 2:33 | 2011-02-16 23:43 | MySQL Cluster: Disk Data | Closed (6289 days) | S3 | 5.1.22 | Any | Any | Select statement got warning after add a long name log/data file |
| 33049 | 2007-12-06 21:52 | 2008-03-15 9:14 | MySQL Server: Views | Closed (6630 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) |
| 34203 | 2008-01-31 19:31 | 2008-03-01 8:38 | MySQL Workbench | No Feedback (6644 days) | S2 | 5.0.12 | Any | Any | Stops responding |
| 34763 | 2008-02-22 19:20 | 2008-04-14 19:22 | MySQL Server: Optimizer | Closed (6600 days) | S3 | 5.0+ | Any | Any | item_subselect.cc:1235:Item_in_subselect::row_value_transformer:Assertion failed |
| 35038 | 2008-03-04 15:40 | 2010-05-26 18:00 | MySQL Server: Falcon storage engine | Unsupported (5828 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 (6590 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 (6579 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 (6362 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 (6389 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 (6502 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 (6026 days) | S3 | 5.0.60, 5.0.64, 5.1.28 | Any | Any | GROUP BY with subquery fails. |
| 38858 | 2008-08-18 13:56 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (6473 days) | S4 | Any | Any | ORDERGROUP BY construct | |
| 38859 | 2008-08-18 14:17 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (6473 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 (5687 days) | S2 | any | Any | Any | ERROR: the age of the last checkpoint ... exceeds the log group capacity |
| 40037 | 2008-10-15 9:34 | 2011-10-20 3:46 | MySQL Server: Optimizer | Closed (5316 days) | S3 | 5.x, 6.x | Any | Any | Incorrect result from MIN/MAX when no GROUP, and independent subquery predicate |
| 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 |
| 41266 | 2008-12-05 15:36 | 2011-02-16 23:43 | MySQL Enterprise Monitor: Web | Closed (6325 days) | S3 | 2.0.0.7119 | Any | Any | rename group fails if the new name differs only in case from existing name |
| 42955 | 2009-02-18 4:07 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5648 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 (6235 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 (4555 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 (6197 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 (4954 days) | S3 | 5.0.91 | Any | Any | 'Column * cannot be null' when derived table has count() with no results |
| 45261 | 2009-06-02 10:47 | 2011-02-16 23:44 | MySQL Server: Stored Routines | Closed (5903 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 (6177 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 (6169 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 |
| 45897 | 2009-07-02 5:51 | 2013-02-05 15:15 | MySQL Workbench | Can't repeat (4842 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 (6152 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 (5704 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 (6137 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 (1979 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 (4139 days) | S4 | Any | Any | [graphs]: Show hint with instance name which caused maximum contribution | |
| 46923 | 2009-08-25 18:07 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5900 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 (5987 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 (5987 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 (5903 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 (5903 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 (5903 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 (5058 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 (5516 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 (5891 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 (3014 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 (5803 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 (5939 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 (5910 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 (5917 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 (5893 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 (5830 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 (5859 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 (5648 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 |
| 56118 | 2010-08-19 13:12 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5655 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 (5693 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 (5673 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 (5633 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 (5547 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 (5583 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 (5528 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 (5519 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 (5055 days) | S4 | 5.5.12 | Any | Any | Syntax to specify a field from select_expr for Group By |
| 64002 | 2012-01-11 20:01 | 2012-01-19 11:52 | MySQL Server: Optimizer | Verified (5232 days) | S1 | 5.5.19 | Any (Debian, Windows XP) | Any | Aggregate queries with multiple columns and no GROUP BY produce bogus results |
| 67089 | 2012-10-04 18:50 | 2014-11-19 7:51 | MySQL Server: Logging | Verified (4190 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 (4863 days) | S3 | 5.5.29, 5.5.30, 5.7.1 | Any | Any | Heap tables don't use index for group by |
| 69590 | 2013-06-26 15:59 | 2018-03-14 20:53 | MySQL Server: DML | Closed (2979 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 (4373 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 (4532 days) | S2 | 5.5.24-log | Any | Any | GROUP BY function produces truncated columns in combination with CONV() or BIN() |
| 71942 | 2014-03-05 15:21 | 2014-03-05 15:53 | MySQL Server | Not a Bug (4449 days) | S5 | Any | Any | Select * -- does it have to be "indeterminate" when using ORDER BY and GROUP BY | |
| 72553 | 2014-05-06 15:00 | 2014-05-23 3:50 | MySQL Fabric | Closed (4370 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 (4360 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 (4168 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 (4240 days) | S2 | Any | Any | Locking error in the failure detector | |
| 76099 | 2015-03-02 14:20 | 2015-04-07 22:57 | MySQL Server: Replication | Closed (4073 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 (3184 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 (3898 days) | S3 | 5.7.7 | Any | Any | Slave group event parser does not recognize XA ROLLBACK as a boundary |
| 79044 | 2015-10-31 19:28 | 2021-03-31 11:39 | MySQL Server: Optimizer | Verified (1866 days) | S4 | 5.7, 8.0 | Any | Any | group by WITH CUBE |
| 80224 | 2016-02-01 19:13 | 2016-02-15 9:00 | MySQL Server: Optimizer | Verified (3737 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 (3652 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 |
| 81188 | 2016-04-24 11:16 | 2016-04-25 7:38 | Connector / J | Duplicate (3667 days) | S3 | 5.1.37 | Any | Any | select json type get garbled reason |
| 82171 | 2016-07-08 19:24 | 2016-07-27 2:20 | MySQL Server: Documentation | Closed (3574 days) | S3 | Any | Any | GROUP BY Optimization clarification | |
| 82317 | 2016-07-22 7:42 | 2018-07-18 8:55 | MySQL Server: Parser | Verified (3579 days) | S3 | 5.5.49 | Any (v14.04.1) | Any | Unrelevant error message: Unknown column in 'having' clause |
| 83005 | 2016-09-15 6:56 | 2017-05-03 3:47 | MySQL Server: Optimizer | Closed (3408 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 (2266 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 |
| 84371 | 2016-12-29 19:14 | 2020-02-05 15:52 | MySQL Server: Documentation | Won't fix (2286 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 (3169 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 (3156 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 (1517 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 (2895 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 (3166 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 (3218 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 (3020 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 (3205 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 (3043 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 (3134 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 (3098 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 (3070 days) | S2 | 5.7.19 | Any | Any | No Check for duplicatio @@server_uuid when joining group |
| 88749 | 2017-12-05 2:41 | 2018-09-25 22:07 | MySQL Server: DML | Verified (3078 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 (3029 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 (2998 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 (2567 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 (2936 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 (3041 days) | S4 | 5.7.20,8.0.3 | Any | Any | Provide relay log details in case of Group Replication applier failure. |
| 89686 | 2018-02-16 7:47 | 2019-04-30 11:04 | MySQL Server: Documentation | Closed (2567 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 (2892 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 (2385 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 (2839 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 (2678 days) | S4 | 8.0.12 | Any | Any | Use the new shutdown service when gr_exit_state_action=ABORT_SERVER |
| 92110 | 2018-08-21 18:02 | 2019-07-25 8:27 | MySQL Server: Group Replication | Closed (2617 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 (2731 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 (2602 days) | S3 | 8.0.14 | Any | Any | MAKE GR REPLICATION CHANNELS ROTATE RELAY LOG ON FLUSH LOGS |
| 94186 | 2019-02-04 8:23 | 2019-05-03 9:20 | MySQL Server: Documentation | Closed (2564 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 (2602 days) | S3 | 8.0.14 | Any | Any | group_replication_consistency=AFTER does not include BEFORE_ON_PRIMARY_FAILOVER |
| 96071 | 2019-07-02 10:43 | 2022-07-19 13:12 | MySQL Server: InnoDB storage engine | Verified (2160 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 (2476 days) | S3 | 8.0 | Any | Any | Confliction of resource group and thread pool plugin, invalid memory access |
| 96479 | 2019-08-08 20:50 | 2019-11-07 2:56 | MySQL Server: Japanese Documentation | Verified (2466 days) | S3 | 5.6 | Any | Any | JapaneseDocumentBug |
| 96549 | 2019-08-15 10:59 | 2019-08-28 12:23 | MySQL Server: Optimizer | Not a Bug (2447 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 |
| 97417 | 2019-10-29 13:33 | 2019-11-05 14:50 | MySQL Server: Documentation | Closed (2378 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 (971 days) | S1 | all version with MGR | Any | Any | group replication lost transaction when init by ansible |
| 98630 | 2020-02-17 9:36 | 2020-02-18 13:33 | MySQL Server | Not a Bug (2273 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 (1726 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 (2193 days) | S3 | 5.6,5.7,8.0 | Any | Any | SQL run with GROUP_MIN_MAX may infinite loop and never return |
| 100378 | 2020-07-30 8:57 | 2020-08-03 11:58 | MySQL Server: Replication | Can't repeat (2106 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 (2109 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 (754 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 (2071 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 (2014 days) | S2 | 8.0.22 | Any | Any | date group and sort groups similar dates in different groups |
| 101838 | 2020-12-02 19:17 | 2021-07-21 11:34 | MySQL Server: Optimizer | Closed (1755 days) | S2 | 8.0 | Any | Any | Adding GROUP BY slows down a query. |
| 102942 | 2021-03-12 6:53 | 2021-03-15 9:34 | MySQL Server: Prepared statements | Not a Bug (1882 days) | S1 | 8.0.23 | Any | Any | prepare execute result is different from a query execute directly |
| 105748 | 2021-11-30 11:47 | 2025-12-07 20:45 | MySQL Server: Group Replication | Duplicate (1609 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 (1508 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 (843 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 (1420 days) | S4 | 8.0 | Any | Any | Improve GR server throttling documentation to provide more details |
| 108792 | 2022-10-16 2:34 | 2022-10-18 8:57 | MySQL Server: Clone Plugin | Not a Bug (1300 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 (872 days) | S5 | 8.0.13,8.0.31 | Any | Any | Poor performance when using HASH field to check unique |
| 110447 | 2023-03-21 4:45 | 2025-12-07 20:45 | MySQL Operator | No Feedback (1115 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 (1136 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 (1005 days) | S3 | 8.0 | Any | Any | Scalar correlated subquery with group by clause mistakenly transformed |
| 112401 | 2023-09-20 18:44 | 2023-09-22 23:47 | MySQL Cluster: Cluster (NDB) storage engine | Verified (961 days) | S3 | 8.0.34 | Any | Any | Node group assumed to start from 0 |
| 112888 | 2023-10-30 21:35 | 2023-10-31 1:42 | MySQL Server: Group Replication | Closed (922 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 (816 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 (746 days) | S3 | 8.0 | Any | Any | invalid result set with join lateral and group by on a generated field |
| 115040 | 2024-05-16 12:09 | 2024-10-29 10:09 | MySQL Server: Optimizer | Verified (724 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 (656 days) | S5 | 8.0.37, 8.0.39 | Any | Any | The optimizer has chosen a poor execution plan. |
| 116534 | 2024-11-03 10:40 | 2024-11-06 12:58 | MySQL Server: Optimizer | Verified (550 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 (543 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 (515 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 (457 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 |
| 118165 | 2025-05-12 8:39 | 2026-05-04 12:31 | MySQL Server: Replication | Closed (6 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 (304 days) | S1 | 9.3.0 | Any | Any | Unexpected result of prepared statement |
| 118898 | 2025-08-26 12:35 | 2025-09-04 11:53 | MySQL Server: Group Replication | Verified (251 days) | S3 | 8.4.6 | Any | Any | Cluster endup having two primary nodes, also if group_replication_single_primary_mode is ON. |
| 119605 | 2025-12-29 9:37 | 2025-12-29 13:00 | MySQL Server: Optimizer | Verified (132 days) | S3 | 8.0.27 | Any | Any | GROUP BY brings unnecessary order columns |
| 119808 | 2026-01-29 14:44 | 2026-04-20 11:52 | MySQL Server: DML | Open (20 days) | S2 | Any | Any | Error 3569 with HIGH_PRIORITY + VIEW + GROUP BY + FOR UPDATE | |
| 176 | 2003-03-21 11:32 | 2019-04-08 13:46 | MySQL Server | Closed (8448 days) | S3 | all | Any | Any | Mixing aliases and aggregate functions in GROUP BY results in empty set |
| 380 | 2003-05-06 10:14 | 2003-06-19 12:59 | MySQL Server | Closed (8361 days) | S2 | 4.1.0 | Any (any) | Any | MySQL crashes with InnoDB + group |
| 1790 | 2003-11-10 0:45 | 2003-12-10 4:45 | MySQL Server | Closed (8187 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 (8200 days) | S4 | all | Any (all) | Any | Allow aliases in WHERE clauses for queries without GROUP BY |
| 4065 | 2004-06-08 21:31 | 2020-01-31 13:38 | MySQL Server: DML | Won't fix (2291 days) | S4 | all | Any (all) | Any | remove the need to mention column name in select in order to use it in having |
| 4400 | 2004-07-03 20:52 | 2004-07-17 1:42 | MySQL Server | Closed (7967 days) | S3 | 4.1 | Any (all) | Any | incorrect error message about aggregate function in subquery |
| 5615 | 2004-09-16 19:37 | 2005-03-02 21:18 | MySQL Server | Closed (7739 days) | S1 | 4.1.3 | Any (any) | Any | type of aggregate function column wrong when using group by |
| 6931 | 2004-12-02 3:45 | 2005-02-04 13:26 | MySQL Server | Closed (7765 days) | S3 | 4.1.8 | Any (any) | Any | Date Type column problem when using UNION-Table. |
| 7101 | 2004-12-08 12:19 | 2019-11-14 13:58 | MySQL Server | Closed (7821 days) | S1 | 4.1 | Any (all) | Any | Usage of LEFT() function in GROUP BY crashes a server |
| 9213 | 2005-03-16 2:34 | 2005-04-11 2:21 | MySQL Server: Optimizer | Closed (7699 days) | S2 | 4.1.11 | Any (any) | Any | GROUP BY query on utf-8 key returns wrong results (empty set) |
| 11640 | 2005-06-29 13:29 | 2008-10-03 20:22 | MySQL Server: DDL | Won't fix (6428 days) | S4 | Any | Any | automatic key creation on CREATE TABLE ... SELECT | |
| 13669 | 2005-09-30 19:18 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (6115 days) | S4 | 5.0 | Any (all) | Any | Group commit is broken in 5.0 |
| 15135 | 2005-11-22 14:28 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (6259 days) | S5 | 4.1.14 | Any (NT) | Any | Dependent subquery performs very badly |
| 15584 | 2005-12-08 12:25 | 2018-02-11 20:45 | MySQL Server | Analyzing (4709 days) | S4 | Any | Any | Server can not tell clients about generated keys | |
| 17974 | 2006-03-06 16:16 | 2006-03-21 10:08 | MySQL Server | Won't fix (7355 days) | S3 | 4.1.18 | Any (Any) | Any | INSERT ... SELECT with GROUP BY causes truncation of DECIMAL |
| 19089 | 2006-04-13 20:49 | 2006-06-05 21:14 | MySQL Server: Optimizer | Closed (7279 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 (6788 days) | S3 | 5.0 | Any | Any | --defaults-group-suffix not documented |
| 20203 | 2006-06-01 13:45 | 2006-07-06 1:45 | MySQL Server: Views | Not a Bug (7248 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 (7227 days) | S4 | 5.0.20 | Any (All) | Any | There is no description of "copying to group table" |
| 20709 | 2006-06-27 0:20 | 2006-08-10 15:47 | MySQL Server: MyISAM storage engine | Closed (7213 days) | S3 | 4.1 | Any (ALL) | Any | Collation not used in group by on 4.1 |
| 22138 | 2006-09-09 3:13 | 2006-10-23 14:23 | MySQL Server: Optimizer | Closed (7139 days) | S3 | 5.0.24a,5.0BK,5.1BK | Any (*) | Any | Server crash on complex select |
| 22781 | 2006-09-28 14:51 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5803 days) | S2 | 5.0.24/5.0BK | Any | Any | SQL_BIG_RESULT fails to influence sort plan |
| 24984 | 2006-12-11 23:42 | 2009-02-12 14:03 | MySQL Administrator | Closed (6296 days) | S3 | all | Any (all) | Any | Administrator provides no way to debug problems with scheduled backups |
| 25758 | 2007-01-22 18:01 | 2007-02-14 19:09 | MySQL Server | Can't repeat (7025 days) | S2 | 5.0.25+, 4.1.19+ | Any (all) | Any | quoted string in ORDER BY causes GROUP BY |
| 26183 | 2007-02-08 12:02 | 2014-01-05 20:45 | MySQL Websites: bugs.mysql.com | Verified (7031 days) | S2 | http://bugs.mysql.com/search.php | Any (www) | Any | Can't find a bug using up-level category |
| 26520 | 2007-02-21 11:58 | 2014-03-13 13:35 | MySQL Enterprise Monitor: Web | Won't fix (6841 days) | S4 | 1.1.0.4785 | Any | Any | offer sending a test mail to a notification group on SAVE and UPDATE |
| 27177 | 2007-03-15 15:14 | 2007-07-03 15:05 | MySQL Server: Documentation | Closed (6886 days) | S3 | All Versions | Any | Any | SHOW PROCESSLIST Syntax - add descriptions for state |
| 27278 | 2007-03-19 23:47 | 2007-03-20 17:57 | MySQL Server: Documentation | Closed (6991 days) | S3 | 5.0 | Any (*) | Any | aggregate of outer query for subquery not documented |
| 27530 | 2007-03-29 17:17 | 2007-04-24 17:19 | MySQL Server | Closed (6956 days) | S3 | 5.0.37-log | Any (pc-linux-gnu x86_64) | Any | Incorrect calculation CRC32 value in GROUP BY requests |
| 28337 | 2007-05-09 16:58 | 2007-05-27 18:19 | MySQL Server | Closed (6923 days) | S2 | 5.0.40 | Any | Any | NOT EXISTS with GROUP BY behaves different in 5.0.40 (regression) |
| 28526 | 2007-05-18 17:15 | 2012-05-18 20:19 | MySQL Server | Duplicate (6919 days) | S2 | 5.0.40, 5.0.41, 5.0.42-20070517 | Any | Any | Correlated subquery with GROUP BY on outer query returns no results in 5.0.40+ |
| 28618 | 2007-05-23 12:30 | 2009-12-07 14:00 | MySQL Server: Replication | Closed (6738 days) | S2 | 5.1 | Any | Any | Skipping into the middle of a group with SQL_SLAVE_SKIP_COUNTER is possible |
| 28829 | 2007-06-01 10:01 | 2025-12-07 20:45 | MySQL Server: Replication | Duplicate (6906 days) | S2 | 4.1.21,5.0.44 | Any | Any | replication breaks due to binlogs events written in wrong order |
| 28888 | 2007-06-05 1:25 | 2007-06-05 10:21 | MySQL Server: Data Types | Can't repeat (6914 days) | S3 | 4.0.25 | Any | Any | CAST on TEXT field returns BLOB when ORDERED BY |
| 29317 | 2007-06-23 13:42 | 2007-06-25 13:05 | MySQL Server: Documentation | Closed (6894 days) | S3 | 5.0 | Any | Any | COUNT() listed in other functions |
| 29357 | 2007-06-26 11:34 | 2007-08-06 7:39 | MySQL Server: Optimizer | Not a Bug (6852 days) | S2 | 5.1.19-beta-log MySQL, 5.0 BK | Any | Any | Filtering on view with group don't works. |
| 29900 | 2007-07-19 14:39 | 2013-03-03 20:45 | MySQL Server: Information schema | Verified (5941 days) | S3 | 5.1.21-23 | Any | Any | MySQL does not return an error to the client if INFORMAT SCHEMA fill table fails |
| 30245 | 2007-08-05 20:44 | 2007-09-14 15:17 | MySQL Server | Closed (6813 days) | S3 | 5.0/5.1 | Any | Any | BIT type gets cast to LONG when DISTINCT or GROUP BY is used |
| 30324 | 2007-08-08 23:31 | 2007-10-23 16:34 | MySQL Server: Optimizer | Closed (6774 days) | S2 | 5.0-bk, 5.1-bk | Any | Any | Grouping queries with COUNT(DISTINCT bit column) return wrong results |
| 30363 | 2007-08-10 17:58 | 2011-02-16 23:43 | MySQL Server | Closed (5650 days) | S5 | 5.2.4 | Any | Any | TPC-D complex query slower by 2.6x to 6x times in 5.2 then in 5.1 |
| 30368 | 2007-08-11 2:26 | 2012-05-18 20:19 | MySQL Server | Duplicate (6829 days) | S3 | 4.1/5.0/5.1 | Any | Any | GROUP BY primary_key query's output is not ordered when the PK is not ordered |
| 30559 | 2007-08-22 11:21 | 2007-08-23 13:35 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6835 days) | S3 | 5.1.21 | Any | Any | Some NDB space management commands do not fail as expected |
| 30587 | 2007-08-23 8:45 | 2007-11-05 3:13 | MySQL Server: Data Types | Closed (6761 days) | S2 | 4.1, 5.0, 5.1 | Any | Any | mysql crashes when trying to group by TIME div NUMBER |
| 30665 | 2007-08-28 8:03 | 2007-11-13 18:59 | MySQL Server: Optimizer | Closed (6753 days) | S3 | 5.1.17 | Any | Any | Inconsistent optimization of IGNORE INDEX FOR {ORDER BY|GROUP BY} |
| 30772 | 2007-09-03 16:34 | 2007-09-07 16:47 | MySQL Enterprise Monitor: Server | Closed (6820 days) | S3 | 1.2.0.7406 | Any | Any | Exceptions in catalina.out for support zip feature as replication info disabled |
| 31035 | 2007-09-14 20:47 | 2007-10-23 0:26 | MySQL Server: General | Closed (6774 days) | S1 | 5.0.50, 5.1.23 | Any | Any | select from function, group by result crasher |
| 31293 | 2007-09-29 16:57 | 2011-02-16 23:43 | MySQL Server: DDL | Closed (5688 days) | S3 | 5.1.22-ndb-6.3.2-telco-log | Any | Any | create logfile group/tablespace returns OK with warning when engine=myisam |
| 31694 | 2007-10-18 15:59 | 2008-01-31 14:08 | MySQL Server | Can't repeat (6674 days) | S2 | 5.1-bk (5.1.23-beta-debug) | Any | Any | SIGSEGV in Field_string::type (this=0x80372c660) at field.h:1200 |
| 31794 | 2007-10-23 18:03 | 2007-11-29 0:47 | MySQL Server: Optimizer | Closed (6737 days) | S3 | 5.1.20-beta | Any | Any | no syntax error on SELECT id FROM t HAVING count(*)>2; |
| 32155 | 2007-11-06 22:31 | 2011-02-16 23:43 | MySQL Enterprise Monitor: Web | Closed (6162 days) | S3 | 2.0 | Any | Any | translate the Replication group names |
| 32202 | 2007-11-08 22:30 | 2007-11-19 4:31 | MySQL Server: General | Closed (6747 days) | S2 | 5.0.50 | Any | Any | ORDER BY not working with GROUP BY |
| 32256 | 2007-11-10 11:56 | 2007-11-11 18:40 | MySQL Server | Not a Bug (6755 days) | S3 | 5.0.52-BK, 5.0.45 | Any | Any | malfunction of JOIN with 'GROUP BY ... HAVING ...' clause |
| 32400 | 2007-11-14 22:49 | 2008-01-14 19:24 | MySQL Server: Optimizer | Closed (6691 days) | S2 | 5.0.41/5.0BK/5.1BK | Any | Any | Complex SELECT query returns correct result only on some occasions |
| 32478 | 2007-11-18 12:44 | 2007-12-19 7:42 | MySQL Server: User-defined functions ( UDF ) | No Feedback (6717 days) | S3 | Any | Any | Udf HAVING problem | |
| 32481 | 2007-11-18 17:03 | 2007-12-18 17:49 | MySQL Server: User-defined functions ( UDF ) | No Feedback (6718 days) | S3 | Any | Any | Why different result? | |
| 32556 | 2007-11-21 5:11 | 2008-01-14 18:59 | MySQL Server: Optimizer | Closed (6691 days) | S1 | 5.0.50,5.1.23,6.0.3 | Any | Any | assert in "using index for group-by" : is_last_prefix <= 0, file .\opt_range.cc |
| 32558 | 2007-11-21 6:46 | 2007-12-12 19:43 | MySQL Server: General | Closed (6724 days) | S1 | 5.1.23 | Any | Any | group by null-returning expression with rollup causes crash |
| 33085 | 2007-12-08 13:22 | 2025-12-07 20:45 | MySQL Server: Stored Routines | Duplicate (6719 days) | S2 | 5.1-BK | Any | Any | Stored functions crash server when used in select list and group by |
| 33520 | 2007-12-27 0:29 | 2008-07-31 17:19 | MySQL Server: Documentation | Closed (6492 days) | S3 | 5.1.22 | Any | Any | Description for UDF aggregate function XXX_add not correct |
| 34666 | 2008-02-19 14:11 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (6586 days) | S3 | 5.0/5.1/6.0.4 | Any | Any | Incomplete metadata returned to client on view + group by + Innodb/Falcon |
| 34874 | 2008-02-27 9:47 | 2018-02-08 22:50 | MySQL Server: DML | Closed (3013 days) | S3 | 5.0+ | Any | Any | Wrong result with IN(SELECT aggregate FROM DUAL) |
| 35331 | 2008-03-17 11:18 | 2008-11-28 15:02 | MySQL Server: Views | Can't repeat (6372 days) | S3 | 6.0-falcon-team | Any | Any | Crash in Field::maybe_null on view updates |
| 35954 | 2008-04-10 6:12 | 2011-02-16 23:43 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6201 days) | S2 | 5.1.22-rc | Any | Any | cluster 5.1.22-rc rolling upgrade to 5.1.23-rc broken |
| 36007 | 2008-04-11 22:39 | 2016-02-25 12:24 | MySQL Enterprise Monitor: Web | Closed (6162 days) | S4 | 1.3.0 | Any | Any | Display which notification group(s) are subscribed to which advisors |
| 36084 | 2008-04-15 8:34 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (6599 days) | S3 | 5.0.58 | Any | Any | name_const with negative, subquery, group by causes crash |
| 36460 | 2008-05-02 0:14 | 2008-05-02 15:03 | MySQL Server | Closed (6582 days) | S2 | 5.1 | Any | Any | Subqueries eliminating duplicates needed by group by |
| 37343 | 2008-06-11 13:42 | 2008-09-30 19:49 | MySQL Server: Falcon storage engine | Closed (6431 days) | S1 | 6.0-falcon | Any | Any | Assertion in IndexNode::parseNode, ASSERT(key - (UCHAR*) indexNode < 14); |
| 37348 | 2008-06-11 15:30 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (6414 days) | S1 | 5.1/6.0-falcon | Any | Any | Crash in or immediately after JOIN::make_sum_func_list |
| 37463 | 2008-06-17 21:33 | 2008-06-17 21:55 | MySQL Server | Not a Bug (6536 days) | S3 | 5.0.51b | Any | Any | COLLATE possible in ORDER BY and GROUP BY, but not in both at same time |
| 37769 | 2008-07-01 15:05 | 2008-07-18 16:21 | Tests | Closed (6505 days) | S3 | 6.0-BK | Any | Any | main.error_simulation fails randomly |
| 37936 | 2008-07-07 16:07 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (6310 days) | S1 | 5.1.28-bzr, 6.0, 6.0.7-bzr | Any | Any | ASSERT_COLUMN_MARKED_FOR_WRITE in Field_datetime::store , Field_varstring::store |
| 38061 | 2008-07-11 21:16 | 2008-07-14 2:35 | MySQL Server: Views | Not a Bug (6509 days) | S2 | 5.0.51a | Any | Any | select from view w/group by ignores view order |
| 38326 | 2008-07-24 2:50 | 2012-05-18 20:19 | MySQL Workbench | Verified (6376 days) | S4 | 5.0.23 | Any | Any | contribution from a member of Japanese MySQL User Group about translation |
| 39472 | 2008-09-16 8:59 | 2015-01-09 10:03 | MySQL Enterprise Monitor: Web | Closed (4139 days) | S4 | 1.x, 2.0 | Any | Any | directly access a group or host |
| 39656 | 2008-09-26 2:15 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6362 days) | S1 | 5.0.67, 5.1.28 | Any (Windows XP, Fedora 9) | Any | Behaviour different for agg functions with & without where - ONLY_FULL_GROUP_BY |
| 39800 | 2008-10-02 3:51 | 2011-02-16 23:43 | MySQL Enterprise Monitor: Server | Can't repeat (6424 days) | S2 | Any | Any | Notification emails fail when using more than one address in the group | |
| 39844 | 2008-10-03 19:36 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (6369 days) | S1 | 5.0+ | Any (MS Windows SP2 - XP 5.1.2600, Linux) | Any | Query Crash Mysql Server 5.0.67 |
| 40002 | 2008-10-13 14:18 | 2008-10-22 9:30 | MySQL Server | Can't repeat (6409 days) | S1 | 5.0.18 | Any | Any | Wrong result using group by |
| 40136 | 2008-10-19 4:33 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5648 days) | S3 | 6.0-BKA | Any | Any | Group by is ignored when join buffer is used for an outer join |
| 40157 | 2008-10-19 20:01 | 2021-11-24 12:34 | Tests: Cluster | Won't fix (1628 days) | S7 | 5.1, 6.0 | Any | Any | ndb_dd_alter fails sporadically on pushbuild |
| 40775 | 2008-11-17 9:26 | 2012-05-18 20:19 | MySQL Enterprise Monitor: Server | Verified (6340 days) | S4 | 2.0.0.7088 | Any | Any | Provide rules to enable agents to be automatically added to server groups |
| 40781 | 2008-11-17 12:27 | 2009-02-24 7:20 | MySQL Enterprise Monitor: Web | Not a Bug (6284 days) | S3 | 2.0.0.7088 | Any | Any | Browser behaviour appears different on Safari when adding servers to group |
| 40823 | 2008-11-18 13:40 | 2011-02-16 23:43 | MySQL Enterprise Monitor: Web | Closed (5900 days) | S4 | 2.0.0 | Any | Any | Add number of servers affected in mouse over of heatchart icons on groups |
| 40999 | 2008-11-25 5:34 | 2021-05-02 20:45 | MySQL Cluster: Disk Data | Verified | S4 | mysql-5.1-telco-6.3 | Any | Any | Cluster cannot increase undo log buffer size. |
| 41223 | 2008-12-04 11:53 | 2011-02-16 23:43 | MySQL Enterprise Monitor: Web | Closed (6365 days) | S3 | 2.0.0.7105 | Any | Any | cannot remove server from self-created goup: Error U0002: You must log in to ... |
| 41890 | 2009-01-05 22:53 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (6226 days) | S3 | 6.0.9-release | Any | Any | Falcon: New execution plans with MRR cause slowdown for group of queries |
| 42294 | 2009-01-23 9:51 | 2011-02-16 23:43 | Eventum | Closed (6313 days) | S3 | 2.2 | Any | Any | errors in the upgrade process while converting the database to UTF-8 |
| 42319 | 2009-01-24 6:32 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (6314 days) | S3 | 5.1.30 / NDB 6.3.20 | Any | Any | ALTER LOGFILE GROUP is not in online help |
| 42341 | 2009-01-26 9:37 | 2009-05-15 16:15 | MySQL Server: Falcon storage engine | Closed (6204 days) | S1 | 6.0-falcon-team | Any | Any | Falcon assertion (key - (UCHAR*) indexNode < 14) in IndexNode::parseNode |
| 43027 | 2009-02-19 16:09 | 2012-05-18 20:19 | MySQL Enterprise Monitor: Advisors/Rules | Verified (6288 days) | S4 | 2.0 | Any | Any | Global changes of notifications and Advisors in Enterprise Dashboard |
| 43816 | 2009-03-24 0:57 | 2011-02-16 23:43 | MySQL Enterprise Monitor: Server | Closed (6197 days) | S3 | 2.0.5.7153 | Any | Any | Replication group is renamed back to default after new topology discovered |
| 43846 | 2009-03-24 23:04 | 2011-02-16 23:43 | MySQL Enterprise Monitor: Server | Closed (6197 days) | S3 | 2.0.5.7153 | Any | Any | Error when renaming replication group to a previous name |
| 44117 | 2009-04-06 19:22 | 2009-04-07 10:19 | MySQL Server: Parser | Not a Bug (6242 days) | S3 | 5.1.33 | Any | Any | ORDER BY does nor work for a GROUP BY alias |
| 44303 | 2009-04-16 1:55 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5650 days) | S1 | 6.0.10-debug, 6.0.12-debug, 5.4.4-alpha-debug | Any | Any | Assertion failures in Field_xxx::store_xxx for materialized InsideOut semijoins |
| 44511 | 2009-04-28 11:21 | 2011-02-16 23:43 | Tools: MTR / mysql-test-run | Closed (6190 days) | S4 | Any | Any | MTR2: add an option not to kill other servers when one from the group exits | |
| 45642 | 2009-06-21 20:35 | 2011-02-16 23:44 | MySQL Workbench | Closed (6163 days) | S2 | 5.1.14RC | Any | Any | Generated INSERT statements don't have database name |
| 45782 | 2009-06-26 10:10 | 2011-02-16 23:44 | MySQL Server: Optimizer | Duplicate (6162 days) | S2 | 5.1 | Any | Any | Query with nested JOIN + GROUP BY sporadically returns bad results |
| 46277 | 2009-07-17 21:33 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0, 5.1, 5.4, 6.0 | Any | Any | differing results for equivalent queries using VAR_POP() & AVG() with DISTINCT |
| 46356 | 2009-07-23 14:06 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6045 days) | S3 | 5.4, 6.0 | Any | Any | Certain queries aren't recognizing GROUP BY w/ join_cache_level = 1 |
| 46989 | 2009-08-29 5:52 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6098 days) | S3 | 5.1,5.4 | Any | Any | NULL attribute gets lost when "CREATE TABLE AS SELECT ... GROUP BY WITH ROLLUP" |
| 47150 | 2009-09-05 11:13 | 2014-09-10 6:59 | MySQL Server: Optimizer | Closed (5987 days) | S2 | 5.1,5.4 | Any | Any | Assertion in Field_long::val_int() on MERGE + TRIGGER + multi-table UPDATE |
| 47367 | 2009-09-16 12:00 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5647 days) | S3 | 6.0 | Any | Any | Crash in Name_resolution_context::process_error |
| 47744 | 2009-09-30 13:19 | 2011-02-16 23:44 | Tests: Engine | Closed (6066 days) | S3 | 5.4.5 (mysql-trunk) | Any | Any | innodb.innodb-timeout fails sporadically |
| 47746 | 2009-09-30 13:27 | 2011-02-16 23:44 | Tests: Engine | Closed (5987 days) | S3 | 5.1 | Any | Any | main.innodb_mysql fails sporadically |
| 48092 | 2009-10-15 17:38 | 2009-10-15 18:49 | MySQL Server: Optimizer | Not a Bug (6051 days) | S3 | 5.1, 6.0 | Any | Any | Addition of DISTINCT clause results in incorrect exclusions from result set |
| 48141 | 2009-10-19 8:55 | 2011-02-16 23:44 | MySQL Enterprise Monitor: Web | Closed (6008 days) | S3 | 2.2.0.1514 | Any | Any | UI: add servers to a group shows all servers and not only the selected ones |
| 48167 | 2009-10-19 18:54 | 2011-02-16 23:44 | MySQL Enterprise Monitor: Web | Closed (6043 days) | S3 | Any | Any | dashboard full-graph popup doesn't reflect group/server selection | |
| 48333 | 2009-10-26 22:40 | 2011-02-16 23:44 | MySQL Enterprise Monitor: Web | Closed (6038 days) | S3 | 2.2 alpha | Any | Any | group/server nav tree styling regression |
| 48736 | 2009-11-12 16:03 | 2011-02-16 23:44 | MySQL Cluster: Cluster (NDB) storage engine | Can't repeat (5981 days) | S3 | mysql-5.1-telco-6.3.26 | Any | Any | missing node group error sometimes causes Sig 11 instead |
| 48760 | 2009-11-13 13:36 | 2025-12-07 20:45 | MySQL Server: Stored Routines | Duplicate (5955 days) | S3 | 5.1 | Any | Any | assert in __cxa_pure_virtual called by Item_field::result_type |
| 49453 | 2009-12-04 10:31 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5647 days) | S3 | 6.0 | Any | Any | re-execution of prepared statement with view and semijoin crashes |
| 49632 | 2009-12-11 20:47 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (5959 days) | S3 | 6.0 | Any | Any | Crash in fix_semijoin_strategies_for_picked_join_order with semijoin=on (return) |
| 50089 | 2010-01-05 14:57 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5648 days) | S2 | 6.0 | Any | Any | Second call of procedure with view in subselect crashes server |
| 50394 | 2010-01-17 4:55 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5648 days) | S2 | 5.1.41, 5.1, 5.5.99 bzr | Any | Any | Regression in EXPLAIN with index scan, LIMIT, GROUP BY and ORDER BY computed col |
| 50539 | 2010-01-22 10:36 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5908 days) | S2 | 5.5.0, 5.5.2-m2, 6.0.14-bzr | Any (64bit) | Any | GROUP BY + COUNT(DISTINCT ) on an int column shows results off by one |
| 50930 | 2010-02-04 20:41 | 2011-02-16 23:44 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5917 days) | S3 | mysql-5.1-telco-6.2 | Any | Any | Cluster crash when node is restarted 255 times and encountering error 1204 |
| 50939 | 2010-02-05 9:10 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5687 days) | S5 | all | Any | Any | Loose Index Scan unduly relies on engine to remember range endpoints |
| 51055 | 2010-02-10 10:43 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5802 days) | S3 | mysql-5.1 | Any | Any | Replication failure on duplicate key + traditional SQL mode |
| 51745 | 2010-03-05 4:29 | 2010-03-05 4:34 | MySQL Server: General | Not a Bug (5910 days) | S2 | Community 5.1 | Any | Any | Lack of GROUP BY fails to stop query execution with non-aggregated column |
| 53103 | 2010-04-23 9:34 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5647 days) | S3 | 6.0.14 | Any | Any | MTR test ps crashes in optimize_cond() when running with --debug |
| 53137 | 2010-04-24 0:14 | 2013-01-10 12:43 | MySQL Server: Optimizer | Not a Bug (4868 days) | S2 | 5.0.90, 4.1, 5.0, 5.1, 5.6.99 | Any (FreeBSD 7.3/amd64, Linux) | Any | Optimizer may be confused by an index |
| 53534 | 2010-05-10 8:50 | 2011-12-06 1:05 | MySQL Server: Optimizer | Closed (5269 days) | S2 | 5.1.44, 5.1.47, 5.1.49, 5.0, 5.6.99 | Any | Any | Incorrect 'select SQL_BIG_RESULT...' with GROUP BY on subquery columns |
| 53587 | 2010-05-11 22:57 | 2016-08-17 14:51 | MySQL Server: Documentation | Closed (3553 days) | S3 | 5.0,5.1 | Any | Any | what are the semantics of the rand function |
| 54023 | 2010-05-27 9:54 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (5827 days) | S1 | 5.5.5_Celosia, 5.6.99_Dahlia, bzr_mysql-next-mr-opt-backporting | Any | Any | crash in fix_semijoin_strategies_for_picked_join_order with semijoin=off |
| 54056 | 2010-05-28 6:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5826 days) | S3 | 5.1.47, 5.1.48, 5.6.99 | Any | Any | Incorrect number format in output from SELECT |
| 54407 | 2010-06-10 19:45 | 2010-06-10 20:43 | MySQL Server: Errors | Not a Bug (5813 days) | S1 | Any | Any | My SQL frequent errors# 144, 2006 | |
| 54747 | 2010-06-23 16:06 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5721 days) | S3 | 5.5.3-m3, 5.5.5-m3 | Any | Any | Deadlock between REORGANIZE PARTITION and SELECT is not detected |
| 54812 | 2010-06-25 14:58 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5603 days) | S3 | 5.1, 5.5 | Any | Any | assert in Diagnostics_area::set_ok_status during EXPLAIN |
| 54859 | 2010-06-28 9:12 | 2011-02-16 23:44 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5795 days) | S3 | Any | Any | >2 replica: Hanging if 1 node can not be restored using REDO log during SR | |
| 55487 | 2010-07-22 16:22 | 2013-07-13 23:09 | MySQL Workbench: Modeling | Closed (4684 days) | S2 | 5.2.25 | Any (Linux, Mac OS X) | Any | Edit|Preferences|Model|Column Defaults: Types lack flag support (and validation) |
| 56165 | 2010-08-21 8:12 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5739 days) | S3 | 5.0.not_sure, 5.0, 5.1, 5.6.99 bzr | Any | Any | Bad Optimization |
| 56190 | 2010-08-23 14:23 | 2013-08-25 20:45 | MySQL Server: InnoDB storage engine | Verified | S4 | 5.1.50, 5.5.5 | Any | Any | improve error messages for 'the age of the last checkpoint ..which exceeds the ' |
| 56309 | 2010-08-26 19:31 | 2012-05-18 20:19 | MySQL Enterprise Monitor: Server | Verified | S4 | 2.2.0 | Any | Any | turn off auto-close notification |
| 57230 | 2010-10-04 21:46 | 2011-02-16 23:44 | MySQL Server: Replication | Won't fix (5693 days) | S3 | 5.1 | Any | Any | STOP SLAVE hangs if executed in parallel with a group of events |
| 58081 | 2010-11-09 12:29 | 2020-01-25 1:11 | MySQL Server: Optimizer | Closed (4176 days) | S3 | 5.1.52, 5.5.8 | Any | Any | Duplicate entry error when doing GROUP BY |
| 58655 | 2010-12-02 12:38 | 2011-06-13 12:54 | MySQL Server | Closed (5445 days) | S3 | 5.1.55-debug | Any | Any | Assertion failed, server crashes with mysqld got signal 6 |
| 60325 | 2011-03-03 21:29 | 2011-03-12 10:39 | MySQL Server: Partitions | Verified (5538 days) | S3 | 5.5, 5.1.57, 5.6.3 | Any | Any | partition optimization |
| 60867 | 2011-04-14 9:54 | 2011-05-14 23:00 | MySQL Server | No Feedback (5475 days) | S2 | 6.0.5-alpha-community | Any | Any | QUERY ERROR - "WHERE" IS OMMITED |
| 61120 | 2011-05-11 0:31 | 2011-06-28 16:31 | MySQL Workbench: Modeling | Won't fix (5430 days) | S4 | 5.2.33b - all | Any | Any | Ability to create real sub-folders within DB folders |
| 61399 | 2011-06-03 15:03 | 2018-02-06 23:11 | MySQL Server: Optimizer | Closed (3015 days) | S3 | 5.5/5.0/5.1 | Any | Any | Wrong result with GROUP BY and indexes |
| 61468 | 2011-06-09 21:54 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified (5448 days) | S4 | Any | Any | mysqldump values() group size | |
| 61551 | 2011-06-17 12:26 | 2011-06-18 8:34 | MySQL Server: Optimizer | Verified (5441 days) | S3 | 5.1.56 | Any | Any | Loose index scan is not used for select COUNT(distinct a) |
| 65970 | 2012-07-20 21:50 | 2012-07-23 10:02 | MySQL Server: DML | Verified (5041 days) | S3 | 5.5.19, 5.5.26 | Any | Any | AVG group function when dealing with maximum number give wrong results |
| 67196 | 2012-10-11 21:00 | 2012-10-12 12:22 | MySQL Server: InnoDB storage engine | Verified (4958 days) | S3 | 5.5, 5.6 | Any | Any | ENUM type not treated correctly in HAVING w/ MAX() |
| 67529 | 2012-11-09 0:20 | 2017-01-09 18:55 | MySQL Server: DML | Verified (4930 days) | S3 | 5.1.41, 5.1.67, 5.5.29, 5.7.0 | Any | Any | GROUP BY treats +0 and -0 as different values |
| 68254 | 2013-02-02 10:31 | 2015-01-09 16:42 | MySQL Server: Optimizer | Not a Bug (4139 days) | S2 | 5.6.10 | Any | Any | subquery optimize to wrong semi-join with extensions syntax to group by |
| 69168 | 2013-05-07 19:20 | 2013-09-18 6:38 | MySQL Server: InnoDB storage engine | Closed (4617 days) | S2 | 5.6.11, 5.6.12 | Any (FreeBSD, Linux) | Any | COUNT(*)...GROUP BY sometimes returns wrong results on partitioned InnoDB tables |
| 69310 | 2013-05-23 11:47 | 2018-03-14 20:45 | MySQL Server: DML | Verified (4735 days) | S3 | 5.6, 5.0.97, 5.1.70, 5.5.32, 5.6.12, 5.7.2 | Any | Any | Valid SQL statement rejected in ONLY_FULL_GROUP_BY |
| 69439 | 2013-06-11 9:00 | 2013-06-11 14:15 | MySQL Server: Documentation | Closed (4716 days) | S3 | 5.1.70, 5.5.32 | Any | Any | Documented minimal value of innodb_log_file_size is wrong in 5.1 and 5.5 |
| 69824 | 2013-07-23 12:42 | 2017-08-16 13:24 | MySQL Server: Packaging | Won't fix (3189 days) | S4 | 5.6.12 | Any | Any | Add support for group |
| 70002 | 2013-08-12 19:23 | 2013-08-19 7:38 | MySQL Server: Optimizer | Duplicate (4647 days) | S2 | 5.6.13, 5.5, 5.1 | Any | Any | very low performance join - eq_ref and ref access broken for compound indexes |
| 70162 | 2013-08-27 12:57 | 2013-08-28 2:12 | MySQL Server: Optimizer | Not a Bug (4638 days) | S2 | 5.1 5.5 5.6 | Any | Any | Wrong result for @i:=@i+1 in query while using group by and order by |
| 70173 | 2013-08-28 7:58 | 2013-11-15 18:08 | MySQL Server: Optimizer | Closed (4559 days) | S4 | 5.7.3 | Any | Any | please remove sort aborted errors from the error log |
| 70220 | 2013-09-03 6:14 | 2015-10-26 15:51 | MySQL Server: Optimizer | Closed (3849 days) | S2 | 5.1,5.5, 5.6, 5.7.2-m12 | Any | Any | Grouping with a view may report 'Invalid use of group function' |
| 70359 | 2013-09-16 23:02 | 2013-09-17 7:10 | MySQL Server: Optimizer | Verified (4618 days) | S3 | 5.1, 5.5, 5.6, 5.7 | Any | Any | Wrong result (missing rows) with group by, multi-part key, equality conditions |
| 70548 | 2013-10-07 22:37 | 2013-10-08 18:06 | MySQL Server | Not a Bug (4597 days) | S2 | 5.5.9-log | Any | Any | timestamp column being set to current time |
| 70894 | 2013-11-13 9:02 | 2013-11-13 11:41 | MySQL Server | Not a Bug (4561 days) | S2 | 5.5, 5.6 | Any | Any | GROUP BY HAVING with MAX returns not all results |
| 71140 | 2013-12-13 9:16 | 2015-07-31 8:59 | MySQL Server: Optimizer | Verified (3936 days) | S2 | 5.1, 5.5, 5.6.15, 5.7.7 | Any | Any | Optimizer does NOT use range checks in typical self-join for InnoDB tables |
| 71189 | 2013-12-20 14:56 | 2021-08-08 20:45 | MySQL Server: Documentation | Verified (4524 days) | S3 | 5.5, any | Any | Any | Manual does not provide enough details on how loose index scan really works |
| 71201 | 2013-12-21 20:01 | 2014-01-16 5:36 | MySQL Server: Performance Schema | Closed (4497 days) | S3 | 5.6.14, 5.6.15 | Any | Any | More than one stage named "stage/sql/init"? |
| 71204 | 2013-12-22 15:42 | 2014-01-06 13:43 | MySQL Server: Performance Schema | Verified (4520 days) | S3 | 5.6.14, 5.6.16 | Any | Any | Timing for stages in P_S is different from what SHOW PROFILE reports |
| 71244 | 2013-12-30 9:48 | 2014-03-29 8:31 | MySQL Server: DML | Closed (4450 days) | S2 | 5.6.15, 5.5.35, 5.1.72, 5.7.3 | Any | Any | Wrong result computation using ALL() and GROUP BY |
| 71804 | 2014-02-22 22:29 | 2020-09-13 20:45 | MySQL Server: Optimizer | Verified (4220 days) | S5 | 5.6.6 m9, 5.5.32, 5.1.61 | Any (sqlfiddle.com) | Any | Unnecessary filesort when joining on unique column using group by. |
| 72098 | 2014-03-21 20:47 | 2019-11-18 22:37 | MySQL Server: DML | Closed (2365 days) | S3 | 5.5, 5.5.38 | Any | Any | select * from (subquery) get different result with subquery. |
| 72119 | 2014-03-24 23:45 | 2014-05-23 4:29 | MySQL Fabric | Closed (4370 days) | S3 | 1.4.0 | Any | Any | "group add" hangs with server as localhost:32274 |
| 73018 | 2014-06-17 3:20 | 2015-06-22 10:02 | MySQL Server: Replication | Verified (3975 days) | S5 | 5.6 | Any | Any | improve performance when binlog_order_commits=0 and sync_binlog >1 |
| 73168 | 2014-07-02 4:14 | 2015-02-25 10:51 | MySQL Server: InnoDB storage engine | Verified (4330 days) | S5 | 5.6/5.7 | Any | Any | locking/unlocking overhead for THD::LOCK_thd_data |
| 73202 | 2014-07-05 0:31 | 2014-12-04 16:20 | MySQL Server: InnoDB storage engine | Closed (4185 days) | S3 | 5.6, 5.7.5 | Any | Any | write/sync redo log before flush thread cache to binlog |
| 73277 | 2014-07-11 13:23 | 2014-07-15 13:55 | MySQL Server: Parser | Verified (4317 days) | S3 | 5.537-35.1-log, 5.0.97, 5.1.74, 5.5.39, 5.6.21, 5.7.5 | Any | Any | REGEXP escape of - not escaped properly in character group |
| 73495 | 2014-08-07 8:27 | 2017-07-06 19:19 | MySQL Fabric | Won't fix (4293 days) | S3 | 1.4.4 | Any | Any | MySQL Fabric database permissions need to be more clearly documented |
| 73927 | 2014-09-16 10:12 | 2015-03-24 21:34 | MySQL Server: Optimizer | Closed (4108 days) | S3 | 5.7 | Any | Any | SELECT DISTINCT SUM() RETURNS DUPLICATE ROWS |
| 74221 | 2014-10-04 6:23 | 2018-10-01 16:17 | MySQL Server: Charsets | Closed (2951 days) | S6 | 5.6.20 | Any | Any | ctype-ucs2.c:1545: my_strnncollsp_utf16_bin: Assertion `(slen % 2) == 0' failed. |
| 74980 | 2014-11-24 13:01 | 2015-01-09 6:54 | MySQL Server: Optimizer | Not a Bug (4139 days) | S3 | 5.5, 5.6 | Any | Any | "where" condition after "group by" statement does not work/give any warnings |
| 75270 | 2014-12-19 1:33 | 2016-02-02 19:26 | MySQL Server: Optimizer | Closed (4048 days) | S3 | 5.6.16 | Any | Any | query results are different when opening or closing semijoin optimizer_switch |
| 75299 | 2014-12-23 15:45 | 2017-03-23 12:11 | MySQL Server: Replication | Duplicate (3391 days) | S3 | 5.6 | Any | Any | group commit with GTID enabled need more optimization |
| 75756 | 2015-02-03 23:36 | 2015-02-04 16:25 | MySQL Enterprise Monitor: Agent | Not a Bug (4113 days) | S4 | Any | Any | mysqlmonitoragent install add to group in MEM console | |
| 75851 | 2015-02-10 19:21 | 2015-08-04 9:43 | MySQL Server: DDL | Verified (3932 days) | S2 | 5.6.22, 5.6.25, 5.6.27 | Any | Any | SHOW CREATE VIEW should retain original view formatting and definition |
| 75890 | 2015-02-13 9:41 | 2019-11-29 8:14 | MySQL Server: Row Based Replication ( RBR ) | Open | S4 | 5.6.x | Any | Any | A new feature request of slave mts apply |
| 76468 | 2015-03-24 0:06 | 2015-03-25 5:09 | MySQL Server: DML | Duplicate (4064 days) | S1 | 5.6.22, 5.5.44, 5.6.23, 5.6.25 | Any | Any | void Item_row::illegal_method_call(const char*): Assertion `0' failed. |
| 76901 | 2015-04-30 9:42 | 2015-08-25 10:19 | MySQL Server: Options | Closed (3911 days) | S3 | 5.7.6 | Any | Any | binlog_max_flush_queue_time variable is not used in current MySQL 5.7 |
| 77345 | 2015-06-14 9:26 | 2015-06-14 9:26 | MySQL Server | Open | S4 | All | Any | Any | The aggregate functions of MySQL is too slow, too much CPU for type convertion |
| 77863 | 2015-07-28 19:00 | 2015-07-30 13:05 | MySQL Server: Performance Schema | Closed (3937 days) | S5 | 5.6.26 | Any | Any | slowdown caused by memset in sql_digest_storage.reset() |
| 78181 | 2015-08-24 6:59 | 2015-08-24 9:23 | MySQL Server: DML | Verified (3912 days) | S2 | 5.6.21, 5.6.26, 5.7.9 | Any | Any | Group by different behavior in mysql 5.6.21 |
| 78330 | 2015-09-05 0:12 | 2015-09-05 6:34 | MySQL Server: DML | Duplicate (3900 days) | S1 | 5.6.23 | Any | Any | handle_fatal_signal (sig=6) in Item_row::illegal_method_call on SELECT |
| 78360 | 2015-09-08 6:14 | 2015-09-08 12:29 | MySQL Server: DML | Verified (3897 days) | S3 | 5.6.22, 5.6.26 | Any | Any | More than 1 row is returned when using "having count(alias)" |
| 78380 | 2015-09-09 10:58 | 2016-04-27 15:07 | Tests: Replication | Closed (3896 days) | S3 | 5.7.9 | Any | Any | Update rpl suite tests to work on Group Replication |
| 78383 | 2015-09-09 14:51 | 2015-09-10 14:28 | MySQL Server: General | Not a Bug (3895 days) | S3 | 5.5 / 5.6 | Any | Any | Bug with group by & group_concat |
| 78508 | 2015-09-22 3:20 | 2015-09-22 12:19 | MySQL Server: DML | Not a Bug (3883 days) | S3 | 5.6.22 | Any | Any | Subquery result with aggregate function() in outer table is not understandable |
| 78512 | 2015-09-22 8:49 | 2016-05-25 15:00 | MySQL Server: Packaging | Closed (3642 days) | S3 | 5.7.9 | Any | Any | /var/log/mysqld.log has incorrect permissions after installing server from repo |
| 79040 | 2015-10-30 21:49 | 2017-05-31 8:42 | MySQL Server: Optimizer | Verified (3839 days) | S4 | 5.7 | Any | Any | please merge more temptables |
| 79403 | 2015-11-25 7:35 | 2019-10-25 10:41 | MySQL Router | Can't repeat (2389 days) | S1 | 2.0.2 | Any | Any | Switchover does not work with fabric plugin |
| 79564 | 2015-12-09 6:59 | 2016-09-16 11:47 | MySQL Server: Group Replication | Not a Bug (3523 days) | S3 | 0.6, 0.8 | Any | Any | MySQL Group Replication stop replicate on conflict operations |
| 79942 | 2016-01-13 0:57 | 2017-07-06 19:20 | MySQL Fabric: Installation and Configuration | Won't fix (3770 days) | S3 | 1.6.3 | Any | Any | MySQL Fabric log-bin or gtid requirement logic failure |
| 79994 | 2016-01-15 0:10 | 2017-07-06 19:20 | MySQL Fabric: Sharding | Won't fix (3765 days) | S3 | Any | Any | HASH sharding not true HASH; implemented as RANGE | |
| 80010 | 2016-01-15 19:27 | 2016-01-28 2:47 | MySQL Fabric: High Availability | Closed (3755 days) | S3 | 1.6.3 | Any | Any | Error: 1871 when promoting an instance on H/A group (mysql 5.7.x) |
| 80310 | 2016-02-09 3:55 | 2016-12-12 1:30 | MySQL Server: Optimizer | Closed (3436 days) | S2 | 5.7, 5.6.29, 5.7.11 | Any | Any | Regression for a grouping query with DISTINCT |
| 80653 | 2016-03-08 6:43 | 2016-03-15 10:10 | MySQL Server | Closed (3708 days) | S2 | 5.7.10 | Any | Any | COUNT DISTINCT GROUP BY ROLLUP return wrong number |
| 80846 | 2016-03-24 10:32 | 2016-04-26 5:54 | MySQL Cluster: Cluster (NDB) storage engine | Closed (3693 days) | S3 | 7.5.1 | Any | Any | Specific partitioned tables always place first partition on node group 0 |
| 80898 | 2016-03-30 5:00 | 2016-11-16 6:49 | MySQL Server: InnoDB storage engine | Closed (3691 days) | S3 | 5.7 | Any | Any | Replication stops after transaction is rolled back asynchronously in master |
| 81128 | 2016-04-18 13:41 | 2025-10-19 15:37 | Connector / J | Closed (203 days) | S3 | 5.1.38 | Any | Any | Master host list overwritten by slave list when loadBalanceConnectionGroup used |
| 81377 | 2016-05-11 8:50 | 2017-01-27 15:52 | MySQL Server: DDL | Closed (3447 days) | S3 | 5.7 | Any | Any | Specifying a name for view's column in CREATE VIEW makes SELECT fail |
| 81450 | 2016-05-17 5:28 | 2019-12-16 22:33 | MySQL Server: DML | Closed (2337 days) | S6 | 5.5.49 | Any | Any | void make_sortkey(SORTPARAM*, uchar*, uchar*): Assertion `0' failed make_sortkey |
| 81684 | 2016-06-02 6:05 | 2016-06-02 13:22 | MySQL Server: DML | Verified (3629 days) | S1 | 5.7.8, 5.6.30, 5.7.12 | Any | Any | select + where exists( select + group by + limit) works incorrectly |
| 81716 | 2016-06-03 16:19 | 2016-11-02 13:32 | MySQL Server: Replication | Closed (3560 days) | S3 | 5.7 | Any | Any | TX_ISOLATION INFORMATION SHOULD BE ADDED TO TRAN_CONTEXT_INFO (REQUIRED FOR GR) |
| 82481 | 2016-08-06 17:28 | 2016-12-02 13:01 | MySQL Server: Group Replication | Closed (3446 days) | S1 | 5.7.14 | Any | Any | MySQL Group Replication 0.8 is asynchronous |
| 82687 | 2016-08-23 1:59 | 2017-07-11 11:52 | MySQL Server: Group Replication | Closed (3225 days) | S3 | Any | Any | group replication should not require root@'%' to exist and have privileges | |
| 83246 | 2016-10-03 13:43 | 2018-04-04 17:47 | MySQL Server: Document Store: MySQL Shell | Won't fix (2958 days) | S4 | 5.7.15-labs-gr090 | Any | Any | Improve dba.validateInstance() error output to include my.cnf format |
| 84674 | 2017-01-25 22:05 | 2017-02-16 10:59 | MySQL Server: Group Replication | Closed (3370 days) | S3 | 5.7.latest | Any | Any | Having an unresolvable hostname in group_repl should not block group replication |
| 84710 | 2017-01-30 8:45 | 2017-11-21 10:21 | MySQL Server: Group Replication | Duplicate (3092 days) | S1 | 5.7.17 | Any | Any | group replication does not respect localhost IP |
| 84728 | 2017-01-31 8:22 | 2017-07-11 11:08 | MySQL Server: Group Replication | Closed (3225 days) | S2 | 5.7.17 | Any | Any | Not Possible To Avoid MySQL From Starting When GR Cannot Start |
| 84729 | 2017-01-31 8:39 | 2019-10-30 12:48 | MySQL Server: Group Replication | Closed (2384 days) | S4 | 5.7.17 | Any | Any | Group Replication: Block Reads On Partitioned Nodes |
| 84730 | 2017-01-31 8:43 | 2024-11-12 15:31 | MySQL Server: Group Replication | Verified (3383 days) | S4 | 5.7.17 | Any | Any | Feature: Troubleshoot Group Replication Transaction Rollbacks |
| 84733 | 2017-01-31 9:15 | 2017-06-21 11:32 | MySQL Server: Group Replication | Closed (3326 days) | S3 | 5.7.17 | Any | Any | Cannot Start GR with super_read_only=1 |
| 84784 | 2017-02-02 3:06 | 2019-07-07 6:39 | MySQL Server: Group Replication | Closed (2601 days) | S2 | 5.7.17, 8.0.4 | Any | Any | Group Replication nodes do not rejoin cluster after network connectivity issues |
| 84785 | 2017-02-02 3:38 | 2017-06-09 9:37 | MySQL Server: Group Replication | Closed (3257 days) | S2 | 5.7.17 | Any | Any | Prevent Large Transactions in Group Replication |
| 84798 | 2017-02-02 14:32 | 2017-09-22 15:41 | MySQL Server: Group Replication | Closed (3152 days) | S3 | 5.7.17 | Any | Any | Group Replication can use some verbosity in the error log |
| 86254 | 2017-05-10 4:39 | 2017-08-29 10:25 | MySQL Server: Optimizer | Closed (3176 days) | S1 | 5.7.17 | Any | Any | Assertion `0' failed in Item::tmp_table_field_from_field_type |
| 86515 | 2017-05-31 6:43 | 2017-06-19 6:34 | MySQL Server: Replication | Verified (3247 days) | S4 | 5.7 | Any | Any | Statstistics for binlog group commits |
| 86581 | 2017-06-05 4:48 | 2017-06-14 3:37 | MySQL Server: Group Replication | Verified (3252 days) | S4 | 5.7.18 | Any | Any | GCS timeout waiting for executing stop group_replication when loss majority |
| 86859 | 2017-06-29 4:23 | 2017-12-21 17:47 | MySQL Server: Group Replication | Closed (3062 days) | S2 | 5.7.18 | Any | Any | Group Replication does not honor skip-name-resolve |
| 87207 | 2017-07-26 13:56 | 2017-11-09 6:38 | MySQL Server: Optimizer | Closed (3147 days) | S1 | 5.7.18 | Any | Any | select distinct with secondary key for 'Using index for group-by' bad results |
| 87295 | 2017-08-03 8:16 | 2017-08-03 13:25 | Tests: Group Replication | Verified (3202 days) | S3 | 8.0.2 | Any | Any | Test group_replication.gr_single_primary_majority_loss_1 produces warnings |
| 87560 | 2017-08-28 9:14 | 2021-04-19 4:25 | MySQL Server: XA transactions | Verified (3070 days) | S2 | mysql-5.7.17 | Any | Any | XA PREPARE log order error in replication and binlog recovery |
| 87577 | 2017-08-29 10:23 | 2017-08-29 10:25 | MySQL Server: DML | Duplicate (3176 days) | S1 | 5.7.19 | Any | Any | Field* Item::tmp_table_field_from_field_type(TABLE*, bool):Assertion `0' failed |
| 87719 | 2017-09-10 13:12 | 2017-09-11 20:46 | MySQL Server | Not a Bug (3163 days) | S3 | 5.7.18 | Any | Any | cant't change master info for group replication |
| 87780 | 2017-09-15 21:25 | 2017-10-24 14:23 | MySQL Server: Optimizer | Closed (3139 days) | S3 | 8.0.3 | Any | Any | Unwarranted error indicating window name not defined |
| 88005 | 2017-10-06 4:39 | 2019-05-16 14:59 | MySQL Server: Documentation | Closed (2551 days) | S3 | 5.7 | Any | Any | Figure 17.13 seems incorrect in group replication document |
| 88053 | 2017-10-11 9:05 | 2017-10-12 5:08 | MySQL Server: Optimizer | Not a Bug (3132 days) | S3 | 5.7.19 | Any | Any | too few rows when query contains group_concat, left join, and no group by |
| 88120 | 2017-10-17 11:22 | 2018-04-16 13:40 | MySQL Server: Replication | Closed (2999 days) | S3 | 5.7.17 | Any | Any | Backport BUG#26277771 to 5.7 |
| 88668 | 2017-11-27 17:30 | 2018-05-31 14:49 | MySQL Server: Group Replication | Closed (2999 days) | S3 | 8.0.4 | Any | Any | UNISTALL Group Replication can deadlock with GR Start on server start |
| 88830 | 2017-12-08 9:55 | 2018-05-31 14:51 | MySQL Server: Group Replication | Closed (2951 days) | S3 | 9.0.0 | Any | Any | With plugin-load and typo debugger aborts with missing DBUG_RETURN in '?func' |
| 89196 | 2018-01-11 19:16 | 2018-01-19 9:50 | MySQL Server: Replication | Verified (3033 days) | S4 | 5.7.20, 8.0.3 | Any | Any | Please add GTID in applier error messages. |
| 89287 | 2018-01-17 15:49 | 2018-05-31 14:55 | MySQL Server: Group Replication | Closed (3000 days) | S3 | 5.7.21 | Any | Any | Enforce that all members do have the same lower_case_table_names value |
| 89743 | 2018-02-21 6:40 | 2018-04-18 12:39 | MySQL Server: Optimizer | Verified (2944 days) | S4 | 8.0 | Any | Any | Missing an efficient way of getting the last row in each group of an index |
| 89914 | 2018-03-05 14:12 | 2018-03-23 18:05 | MySQL Server: Optimizer | Closed (2970 days) | S3 | 8.0 | Any | Any | Debug assert when executing create resource group in stored function |
| 89918 | 2018-03-05 17:06 | 2018-03-07 10:55 | MySQL Server | Not a Bug (2986 days) | S3 | 5.5, 5.6, 5.7, 8 | Any | Any | Operation with user-defined variables depends on index |
| 90398 | 2018-04-12 4:16 | 2020-02-06 13:34 | MySQL Server: Optimizer | Closed (2558 days) | S2 | 5.7.17 EE, 5.7.22 | Any | Any | Duplicate entry for key '<group_key>' error |
| 90599 | 2018-04-24 9:41 | 2018-11-09 12:01 | MySQL Server: DML | Not a Bug (2739 days) | S3 | 8.0.11 | Any | Any | Window function with RAND() is not random with GROUP BY |
| 91876 | 2018-08-02 17:52 | 2018-10-10 18:34 | MySQL Server: Prepared statements | Closed (2769 days) | S3 | 8, 8.0.12 | Any | Any | PREPARED statement fails for SET RESOURCE GROUP |
| 92209 | 2018-08-28 11:08 | 2019-05-14 11:55 | MySQL Server: Optimizer | Closed (2721 days) | S2 | 8.0.12, 5.7.23, 5.6.41, 5.5.61 | Any | Any | AVG(YEAR(datetime_field)) makes an error result beacuse of overflow |
| 93212 | 2018-11-15 15:34 | 2020-01-20 9:46 | MySQL Server: Group Replication | Closed (2525 days) | S3 | 8.0.13 | Any | Any | Some threads are not registered in the global thread manager |
| 93586 | 2018-12-13 9:50 | 2019-04-20 23:10 | MySQL Server: Optimizer | Closed (2579 days) | S2 | 8.0, 8.0.13 | Any | Any | Query state "Removing duplicates" |
| 93599 | 2018-12-13 20:21 | 2018-12-18 14:01 | MySQL Server: Performance Schema | Verified (2704 days) | S4 | Any | Any | Columns not named in group by clause should increase warnings in P_S tables | |
| 93703 | 2018-12-20 12:30 | 2019-01-22 5:57 | MySQL Server: Tests | Verified (2665 days) | S7 | 8.0.13, 8.0.14 | Any | Any | EXPLAIN SELECT returns inconsistent number of ROWS in main.group_by |
| 93875 | 2019-01-10 13:25 | 2021-11-25 16:39 | MySQL Server: mysqldump Command-line Client | Closed (1627 days) | S3 | 5.7.24, 8.0.13 | Any | Any | mysqldump per-table dump is slow since 5.7 on instances with many tables |
| 94014 | 2019-01-23 9:11 | 2019-07-25 11:22 | MySQL Server: Documentation | Closed (2481 days) | S3 | 5.7 | Any | Any | Primary / Secondary role not shown in P_S.replication_group_members |
| 94224 | 2019-02-06 16:45 | 2019-11-17 10:39 | MySQL Server: Optimizer | Verified (2649 days) | S3 | 5.6, 5.6.43 | Any (any) | Any (any) | [5.6] Optimizer reconsiders index based on index definition order, not value |
| 95306 | 2019-05-08 17:20 | 2019-07-25 8:40 | MySQL Server: Group Replication | Closed (2547 days) | S3 | 8.0.17 | Any | Any | _get_communication_protocol() fails if one or more members are RECOVERING |
| 96447 | 2019-08-07 10:59 | 2020-01-20 9:56 | MySQL Server: Group Replication | Closed (2377 days) | S3 | 8.0.17 | Any | Any | Group Replication Clone process might conflict with recovery phase 0 |
| 97101 | 2019-10-04 4:53 | 2020-10-06 11:06 | MySQL Server: Group Replication | Closed (2042 days) | S4 | Any | Any | Allow CREATE TABLE ... SELECT ... to work with group replication | |
| 97149 | 2019-10-08 23:30 | 2019-10-09 12:13 | MySQL Server | Not a Bug (2405 days) | S3 | 5.7.18 | Any | Any | S.O.S order by in sub query not working |
| 97540 | 2019-11-07 17:59 | 2020-01-20 10:02 | MySQL Server: Group Replication | Closed (2371 days) | S3 | 8.0 | Any | Any | errors not showing on ps.replication_applier_status_by_worker on single applier |
| 98070 | 2019-12-25 12:33 | 2020-01-06 8:51 | MySQL Server: Replication | Verified (2327 days) | S5 | 8.0.18 | Any | Any | Optimize write performance when group commit |
| 98151 | 2020-01-08 1:03 | 2023-09-12 11:14 | MySQL Server: Group Replication | Can't repeat (971 days) | S3 | 8.0.18 | Any | Any | group replication with wrong member_state after server shutdown |
| 98473 | 2020-02-04 4:18 | 2020-03-02 10:18 | MySQL Server: Group Replication | Not a Bug (2260 days) | S3 | 8.0.18 | Any | Any | group replication will be block after lock table |
| 98663 | 2020-02-19 10:53 | 2020-04-02 12:22 | MySQL Server: DML | Closed (2230 days) | S3 | 8.0.16 | Any | Any | ROLLUP output is not reasonable when same fields exist in the group by syntax |
| 98682 | 2020-02-20 10:27 | 2020-05-29 10:07 | MySQL Server: Errors | Closed (2172 days) | S3 | 8.0.19 | Any | Any | Parameter names in error message are omitted "group_replciation" prefix |
| 99158 | 2020-04-02 10:35 | 2020-04-02 11:36 | MySQL Server: SYS Schema | Verified (2229 days) | S3 | 8.0, 8.0.19 | Any | Any | x$memory_global_by_current_bytes is not same as memory_global_by_current_bytes |
| 99679 | 2020-05-25 2:32 | 2020-05-26 9:14 | MySQL Server | Can't repeat (2175 days) | S3 | 8.0.18 | Any | Any | stop group_replication will assert |
| 100259 | 2020-07-20 4:41 | 2021-04-26 23:21 | MySQL Server: Optimizer | Closed (1850 days) | S2 | 8.0,5.6.48, 5.7.31, 8.0.21 | Any | Any | decimal returned function value overflow when group by |
| 100268 | 2020-07-20 17:13 | 2020-07-20 18:13 | MySQL Server: DML | Not a Bug (2120 days) | S2 | 8.0.20 | Any | Any | 8.0.20: LEFT JOIN w/ unique index does not work properly w/ non-strict GROUP BY |
| 100962 | 2020-09-26 5:17 | 2020-10-26 11:42 | MySQL Server: Performance Schema | Analyzing (2022 days) | S3 | 5.7 | Any | Any | memory_summary_%_by_event_name Have different values |
| 101111 | 2020-10-10 2:30 | 2021-03-02 13:05 | MySQL Server: Documentation | Closed (2035 days) | S3 | Any | Any | document bug | |
| 101274 | 2020-10-22 11:45 | 2025-12-07 20:45 | MySQL Server: Group Replication | No Feedback (1993 days) | S2 | 8.0.22 | Any | Any | Clone Operation succeed but node failing join GR when relay logs are present |
| 101514 | 2020-11-09 4:46 | 2020-11-13 16:30 | MySQL Server: Documentation | Closed (2004 days) | S3 | 5.7, 8.0 | Any | Any | The requirements of Group Replication is not complete. |
| 101515 | 2020-11-09 4:50 | 2021-04-08 12:38 | MySQL Server: Documentation | Closed (1858 days) | S3 | 5.7, 8.0 | Any | Any | The requirements of Group Replication are not complete. |
| 101521 | 2020-11-09 7:35 | 2020-11-10 17:36 | MySQL Server: Documentation | Not a Bug (2007 days) | S3 | 5.7 | Any | Any | The user/group permission should be specified about system variable 'datadir' |
| 101691 | 2020-11-20 7:25 | 2021-11-05 13:48 | MySQL Server: Optimizer | Verified (1997 days) | S3 | 8.0.22, 8.0.17, 8.0.18 | Any | Any | Use substring_index and rank() in a sql cause wrong result |
| 102169 | 2021-01-07 9:42 | 2021-01-07 10:07 | MySQL Server: DML | Verified (1949 days) | S2 | 8.0.18, 5.6.50, 5.7.32, 8.0.22 | Any | Any | tinyint DIV a small value expression return wrong |
| 102886 | 2021-03-09 13:21 | 2021-04-24 15:40 | MySQL Server: Japanese Documentation | Closed (1842 days) | S3 | 8.0.23 | Any | Any | 1.3 MySQL 8.0 の新機能(リソース管理~) |
| 103027 | 2021-03-18 3:21 | 2021-03-18 9:00 | MySQL Server: Prepared statements | Not a Bug (1879 days) | S2 | 8.0.23 | Any | Any | prepare execute result is different from a query execute directly |
| 103194 | 2021-04-02 8:02 | 2021-04-02 15:32 | MySQL Server: DML | Not a Bug (1864 days) | S2 | 8.0.23 | Any | Any | Prepare execution result is wrong |
| 103296 | 2021-04-13 5:35 | 2021-04-13 6:01 | MySQL Server: Optimizer | Verified (1853 days) | S3 | 8.0.22, 5.7.33, 8.0.23 | Any | Any | Aggregate function group by primary key/non-primary key has differnet result |
| 103316 | 2021-04-14 11:49 | 2021-04-14 15:55 | MySQL Server: Group Replication | Verified (1852 days) | S6 | 8.0.23 | Any | Any | Group replication assertion / memory corruption |
| 103317 | 2021-04-14 11:50 | 2021-04-15 5:22 | MySQL Server: InnoDB storage engine | Duplicate (1851 days) | S6 | 8.0.18/8.0.22/8.0.23 | Any | Any | Using temptable, query with many columns and group by clause alerts 1022 error |
| 103583 | 2021-05-05 8:21 | 2021-05-18 13:36 | MySQL Server: DDL | Closed (1818 days) | S1 | 8.0.24, 8.0.23, 8.0.21 | Any | Any | Dump/Restore fails with nested VIEWS having ROLLUP over DISTINCT groups |
| 103961 | 2021-06-09 14:01 | 2021-06-26 10:23 | MySQL Server | Not a Bug (1779 days) | S2 | 8.0.25 | Any | Any | Error: "Unknown column 'foo' in 'having clause'" when using function in HAVING |
| 104023 | 2021-06-15 9:15 | 2021-06-15 9:35 | MySQL Server: Japanese Documentation | Verified (1790 days) | S3 | 8.0 | Any | Any | Wrong translation in 8.2.1.1 WHERE 句の最適化 |
| 104523 | 2021-08-03 14:44 | 2021-11-22 16:14 | MySQL Server: Group Replication | Closed (1630 days) | S4 | 8.0.26 | Any | Any | Improve logging of GCS communication issues. |
| 104527 | 2021-08-04 1:42 | 2021-08-04 12:53 | MySQL Server: Optimizer | Not a Bug (1740 days) | S3 | 8.0 | Any (20.04) | Any (Dell Optiplex 990) | SELECT incorrectly shows NULL first time for user-defined variable |
| 105170 | 2021-10-08 9:03 | 2021-10-08 14:24 | MySQL Server: Data Types | Verified (1675 days) | S3 | 5.7 | Any (v10) | Any | wrong data returned grouping on substring and bit |
| 105289 | 2021-10-21 14:54 | 2021-10-25 12:20 | MySQL Server: Optimizer | Verified (1661 days) | S3 | 5.7 | Any | Any | Optimizer choose index scan but not index range for query with range condition |
| 105437 | 2021-11-03 7:53 | 2021-11-03 9:05 | MySQL Server: Optimizer | Can't repeat (1649 days) | S3 | 8.0.23 | Any | Any | Wrong answer when got multiple count(distinct) |
| 105526 | 2021-11-11 9:00 | 2021-11-17 8:03 | MySQL Server: Optimizer | Verified (1637 days) | S3 | 5.7 | Any | Any | Query result is incompatible with the SQL standard |
| 106463 | 2022-02-15 10:55 | 2022-08-08 9:39 | Shell AdminAPI InnoDB Cluster / ReplicaSet | Closed (1371 days) | S4 | 8.0.28 | Any | Any | Running DDL queries in a Multi-Primary Cluster |
| 106623 | 2022-03-02 22:01 | 2026-04-24 21:54 | MySQL Server: Documentation | Closed (1529 days) | S3 | 8.0 | Any | Any | Incorrect multi-index hint example |
| 106754 | 2022-03-17 7:06 | 2022-03-21 13:52 | MySQL Server: Optimizer | Verified (1515 days) | S5 | 5.7, 8.0, 5.7.37, 8.0.28 | Any | Any | Index-loose scan doesn't work for signle table partition Query |
| 107663 | 2022-06-26 14:56 | 2023-06-27 12:28 | MySQL Server: Optimizer | Verified (1414 days) | S6 | 8.0.29 | Any | Any | Assertion `keyparts > 0' failed in MySQL 8.0.29 |
| 108339 | 2022-08-30 18:16 | 2023-01-25 16:11 | Shell General / Core Client | Closed (1201 days) | S2 | 8.0.30 | Any | Any | dba.rebootClusterFromCompleteOutage() hanging |
| 108421 | 2022-09-07 21:52 | 2024-10-16 5:59 | MySQL Server: Group Replication | Not a Bug (571 days) | S2 | 8.0.29 | Any | Any | Events remain in SLAVESIDE_DISABLED after a node is promoted to PRIMARY in GR |
| 108582 | 2022-09-22 17:57 | 2022-09-23 14:54 | MySQL Server: mysqldump Command-line Client | Verified (1325 days) | S3 | 8.0 | Any | Any | mysqldump with --compatible=ANSI displays error |
| 108824 | 2022-10-19 10:21 | 2022-10-19 10:52 | MySQL Server: Group Replication | Verified (1299 days) | S3 | 8.0.31 | Any | Any | GCS_DEBUG_TRACE log not possible to rotate/archive without downtime |
| 109361 | 2022-12-13 12:06 | 2023-01-11 1:03 | MySQL Server: Optimizer | Closed (1215 days) | S2 | 8.0.29 | Any | Any | MySQL 8.0.29+ is slower than MySQL 8.0.28 with queries using JOINS |
| 109897 | 2023-02-02 10:08 | 2023-02-02 11:32 | MySQL Server: Optimizer | Verified (1193 days) | S3 | 8.0.31 | Any | Any | Field_double::val_str causes string truncation |
| 110155 | 2023-02-21 14:07 | 2023-02-21 14:22 | MySQL Server: Group Replication | Verified (1174 days) | S4 | 8.0.32 | Any | Any | Improve GR error MY-013780 reporting |
| 111057 | 2023-05-17 12:23 | 2023-05-18 12:35 | MySQL Server | Closed (1088 days) | S3 | 8.0.30 | Any | Any | group by or distinct clause result doesn't match collation expectation |
| 111095 | 2023-05-21 9:42 | 2023-05-22 12:43 | MySQL Server: Documentation | Unsupported (1084 days) | S3 | Any | Any | Enhance film_list view by GROUP_CONCATing category.name column values | |
| 111210 | 2023-05-31 6:40 | 2025-02-19 12:58 | MySQL Server: Group Replication | Verified (1075 days) | S4 | 8.0 | Any | Any | please add weight to replication_group_members |
| 111415 | 2023-06-14 9:39 | 2023-06-19 14:12 | MySQL Server: Optimizer | Verified (1056 days) | S3 | 8.0 | Any | Any | Correlated group query wrong result |
| 111706 | 2023-07-10 8:24 | 2025-03-17 9:33 | MySQL Server: Optimizer | Verified (1035 days) | S3 | 8.0.28, 8.0.33 | Any | Any | Incorrect result |
| 112001 | 2023-08-09 3:27 | 2023-08-11 16:14 | MySQL Server: Documentation | Closed (1003 days) | S3 | 8.0, 8.1 | Any | Any | Wrong Authorized User |
| 112011 | 2023-08-09 12:06 | 2023-08-17 12:21 | MySQL Server: Prepared statements | Verified (1004 days) | S3 | 8.0 | Any | Any | RESOURCE GROUP hint fails when used within a prepared statement |
| 112103 | 2023-08-18 2:02 | 2023-08-18 13:03 | MySQL Server: Data Types | Can't repeat (996 days) | S3 | Any | Any | The query takes too long to execute with no results | |
| 112212 | 2023-08-29 16:01 | 2023-08-30 7:42 | MySQL Server: Optimizer | Verified (984 days) | S3 | 8.0.34 | Any | Any | Subquery to derived result mismatch(HASH JOIN/BNL JOIN result mismatch) |
| 112293 | 2023-09-07 14:04 | 2023-09-08 6:54 | MySQL Server: DML | Verified (975 days) | S3 | 8.0, 8.0.34, 5.7.43 | Any | Any | Wrong result if non-breaking space is contained in varchar |
| 112390 | 2023-09-19 14:58 | 2023-09-21 12:00 | MySQL Server | Not a Bug (962 days) | S3 | MySQL 5.7 | Any | Any | The group by combined with GROUP_CONCAT will return undefined result |
| 112951 | 2023-11-03 10:05 | 2023-11-03 10:22 | MySQL Server: DDL | Verified (919 days) | S6 | 8.1.0, 8.0.35, 8.2.0 | Any | Any | Assertion `fixed' failed in MySQL 8.1.0 |
| 113211 | 2023-11-24 12:14 | 2023-11-24 12:34 | MySQL Server: Optimizer | Verified (898 days) | S2 | 8.0.35, 8.1.0, 8.2.0 | Any | Any | The latest version 8.0 returns abnormal results for complex queries |
| 113384 | 2023-12-09 8:05 | 2023-12-11 11:42 | MySQL Server: Data Types | Verified (881 days) | S3 | 8.0 | Any | Any | Queried with partitions,returned result is error |
| 113548 | 2024-01-04 7:38 | 2024-01-09 9:30 | MySQL Server: Group Replication | Duplicate (852 days) | S2 | 8.0.34-26 | Any | Any | Cloning failing in Mysql Group replication |
| 114186 | 2024-03-01 15:32 | 2024-03-01 16:02 | MySQL Server: DML | Verified (800 days) | S4 | 8.0 | Any | Any | Make ANY_VALUE standard compliant |
| 114282 | 2024-03-08 13:10 | 2024-03-08 13:13 | MySQL Server: DML | Verified (793 days) | S2 | 8.35, 8.0.36 | Any | Any | Inconsistent result may caused by group by NULL |
| 114312 | 2024-03-12 6:30 | 2024-03-19 2:26 | MySQL Server: DML | Verified (782 days) | S3 | 8.0 | Any | Any | Item_ref::used_tables wrong when ref to a rollup constant |
| 114358 | 2024-03-14 18:21 | 2024-03-15 20:28 | MySQL Operator | Not a Bug (786 days) | S1 | 2.1.1 | Any | Any | Access denied when SECONDARY connect to PRIMARY |
| 114666 | 2024-04-17 11:28 | 2024-04-18 13:47 | MySQL Server: FULLTEXT search | Verified (752 days) | S6 | 8.0 | Any | Any | Incorrect results for combination of left join, match & group by |
| 114725 | 2024-04-22 9:05 | 2024-05-07 7:33 | MySQL Operator | Can't repeat (733 days) | S2 | 8.3.0-2.1.2 | Any | Any | sometimes sidecar container will complain kopf._cogs.clients.errors.APIForbidden |
| 114884 | 2024-05-05 9:03 | 2024-05-06 6:22 | MySQL Server: Optimizer | Verified (734 days) | S2 | 8.2.0, 8.0.37 | Any | Any | Incorrect inner join with group by execution |
| 114885 | 2024-05-05 9:07 | 2026-04-24 4:44 | MySQL Server: Optimizer | Verified (734 days) | S1 | 8.2.0, 8.0.37 | Any | Any | Incorrect group by execution |
| 114886 | 2024-05-05 9:16 | 2024-05-06 6:30 | MySQL Server: Optimizer | Verified (734 days) | S1 | 8.2.0, 8.0.37 | Any | Any | Incorrect semi-join with group by execution |
| 114887 | 2024-05-05 9:20 | 2024-05-06 6:33 | MySQL Server: Optimizer | Verified (734 days) | S1 | 8.2.0, 8.0.37 | Any | Any | Incorrect Muti-table join with group by execution |
| 114934 | 2024-05-09 7:33 | 2024-06-05 2:06 | MySQL Server: Replication | Can't repeat (704 days) | S3 | 5.7.44 | Any | Any | In Heavy workload, it degenerates to use single thread replication in fact |
| 114982 | 2024-05-13 11:47 | 2024-05-13 12:40 | MySQL Server: Partitions | Verified (727 days) | S2 | 8.0 | Any | Any | Query result about list partition table is incorrect |
| 115132 | 2024-05-27 2:48 | 2024-05-31 7:13 | MySQL Server: Charsets | Can't repeat (709 days) | S3 | 8.0.32 | Any | Any | group by with COLLATE return unexpected result |
| 115351 | 2024-06-17 4:32 | 2024-07-15 13:49 | MySQL Server: InnoDB storage engine | Can't repeat (692 days) | S3 | mysql-8.0.32 | Any | Any | page tracking cannot find stop point |
| 115796 | 2024-08-08 10:18 | 2024-08-08 10:23 | MySQL Server: Optimizer | Verified (640 days) | S3 | 8.0.30,8.4.0 | Any | Any | derived_merge affect exists-subselect condition pushdown |
| 115983 | 2024-09-03 2:27 | 2025-06-05 14:24 | MySQL Server: InnoDB storage engine | Can't repeat (614 days) | S3 | 5.7.44 | Any | x86 | Implicit internal temp table reports ’The table '/tmp/#sql_XXX'‘ is full; |
| 116010 | 2024-09-05 10:27 | 2024-09-05 12:17 | Shell VSCode Extension | Verified (612 days) | S4 | 1.16.x | Any | Any | grouping connections |
| 116027 | 2024-09-06 11:37 | 2024-10-05 14:27 | MySQL Server: Group Replication | Verified (605 days) | S4 | Any | Any | The Problems with Paxos Variant Algorithms in Group Replication | |
| 116476 | 2024-10-25 4:50 | 2024-10-25 11:54 | MySQL Server: Charsets | Not a Bug (562 days) | S3 | 8.0.28 | Any | Any | Changing Characterset from Latin1 to utf8mb4 across DBs and Tables. |
| 116484 | 2024-10-26 20:54 | 2024-10-31 15:06 | MySQL Server: Optimizer | Verified (556 days) | S5 | 596f0d23 (9.0.0), 9.1.0 | Any | Any | Unexpected Performance Dropdown for Query 11 in TPC-H |
| 117214 | 2025-01-16 8:10 | 2025-01-17 11:08 | MySQL Server: Optimizer | Not a Bug (478 days) | S3 | 8.0 | Any | Any | inconsistent result of two equivalent query |
| 118216 | 2025-05-16 14:13 | 2025-05-19 14:14 | MySQL Server: Group Replication | Verified (356 days) | S4 | 8.0.40 | Any (5.14.0-503.29.1.el9_5.x86_64) | x86 | read replica gives error for "select group_replication_get_write_concurrency();" |
| 118310 | 2025-05-30 3:36 | 2026-02-06 12:34 | MySQL Server: Optimizer | Verified (93 days) | S3 | 8.0.41 | Any | Any | a query with a impossile having clause, return wrong results |
| 118336 | 2025-06-03 8:24 | 2026-02-06 12:26 | MySQL Server: Optimizer | Verified (93 days) | S3 | 8.0.41 | Any | Any | after adding a having clause equivalent to "having 1", the returned result set is wrong |
| 118398 | 2025-06-09 8:00 | 2025-06-11 12:40 | MySQL Server: DML | Verified (333 days) | S3 | 8.0.41 | Any | Any | Using temporary with avg cause wrong result |
| 118835 | 2025-08-14 2:56 | 2025-08-19 0:17 | MySQL Server: Optimizer | Verified (264 days) | S3 | 8.0.41 | Any | Any | A query statement that returns 0/FALSE in the having clause, the returned result is not null. |
| 118836 | 2025-08-14 3:01 | 2025-08-18 23:56 | MySQL Server: Optimizer | Verified (265 days) | S3 | 8.0.41 | Any | Any | adding a having clause that return 1/TRUE, the query returns a different and wrong empty result. |
| 118837 | 2025-08-14 3:05 | 2025-08-18 23:51 | MySQL Server: Optimizer | Verified (265 days) | S3 | 8.0.41 | Any | Any | After having(col) in the query statement is changed to having min(col), the returned result is incorrect. |
| 118875 | 2025-08-21 12:42 | 2025-08-21 13:16 | MySQL Server: DML | Verified (262 days) | S3 | 8.0.41, 8.0.43 | Any | Any | set optimizer_switch='block_nested_loop=off/on', result is different. |
| 119022 | 2025-09-17 12:40 | 2025-09-23 0:51 | MySQL Server: Optimizer | Verified (230 days) | S2 | 9.4.0 | Any | Any | column value change cased by Union ALL |
| 119047 | 2025-09-20 7:31 | 2025-12-07 20:45 | MySQL Server | Duplicate (230 days) | S3 | 9.4.0 | Any | Any | column value change cased by Union ALL |
| 119055 | 2025-09-22 15:14 | 2025-12-07 20:45 | MySQL Server | Duplicate (230 days) | S3 | 9.4.0 | Any | Any | column value change cased by AVG() changed to SUM()/COUNT() |
| 119056 | 2025-09-22 15:21 | 2025-09-23 2:40 | MySQL Server: Optimizer | Verified (229 days) | S3 | 9.4.0 | Any | Any | column value change cased by SUM(DISTINCT) changed to AVG(DISTINCT)*COUNT(DISTINCT) |
| 119114 | 2025-10-08 7:54 | 2025-12-15 11:41 | MySQL Server | Not a Bug (146 days) | S3 | 9.4.0 | Any | Any | Column Value change caused by COUNT(column) --->COUNT(DISTINCT column) |
| 119165 | 2025-10-16 5:46 | 2026-01-13 20:29 | MySQL Server: Charsets | Not a Bug (117 days) | S3 | 9.4.0 | Any | Any | unexpected value after changing Max to Min |
| 119225 | 2025-10-24 9:11 | 2025-10-31 5:22 | MySQL Server: Optimizer | Verified (191 days) | S3 | 8.0.43 | Any | Any | weedout not work for rematerialized temptable |
| 119321 | 2025-11-07 4:35 | 2025-11-07 7:37 | MySQL Server: Optimizer | Verified (184 days) | S3 | 9.4.0 | Any | Any | Unexpected None after changing SUM to SUM (x*2) |
| 119322 | 2025-11-07 4:58 | 2025-11-07 7:29 | MySQL Server: Optimizer | Verified (184 days) | S3 | 9.4.0 | Any | Any | Unexpected None after adding a window column |
| 119323 | 2025-11-07 5:59 | 2025-11-07 7:26 | MySQL Server: Optimizer | Verified (184 days) | S3 | 9.4.0 | Any | Any | row number become less after changing COUNT(DISTINCT) to COUNT |
| 119327 | 2025-11-07 7:52 | 2026-02-05 21:26 | MySQL Server: Optimizer | Verified (94 days) | S3 | 8.0.45 | Any | Any | after adding an index ,the result return different |
| 119329 | 2025-11-07 8:13 | 2025-11-11 14:02 | MySQL Server: Optimizer | Verified (184 days) | S3 | 8.0.44 | Any | Any | Column name unexpectedly change after changing COUNT to COUNT(DISTINCT) |
| 119360 | 2025-11-11 8:42 | 2026-02-08 14:00 | MySQL Server: Optimizer | Verified (91 days) | S3 | 8.0.41 | Any | Any | Result inconsistency due to sorting in temporary tables |
| 119446 | 2025-11-23 6:46 | 2025-11-27 4:57 | MySQL Server: Optimizer | Verified (164 days) | S3 | 9.4.0 | Any | Any | rows become more after changing COUNT to COUNT(DISTINCT) |
| 119634 | 2026-01-06 21:04 | 2026-01-06 21:04 | MySQL Operator | Open | S3 | 9.4.0-2.2.5 | Any | Any | MySQL Operator backup can fail on Ready pods that haven't fully joined cluster yet |
| 119679 | 2026-01-14 13:40 | 2026-01-15 11:25 | MySQL Server: Optimizer | Verified (115 days) | S3 | 8.0.45 | Any | Any | after changing SUM(t3.c9) to -SUM(-t3.c9),the rows become less |
| 119680 | 2026-01-14 13:51 | 2026-01-15 12:25 | MySQL Server: Optimizer | Verified (115 days) | S3 | 8.0.44 | Any | Any | after changing AVG(cte.col_2) to -AVG(-cte.col_2) ,rows become less |
| 119701 | 2026-01-16 7:18 | 2026-01-16 9:45 | MySQL Server: Optimizer | Verified (114 days) | S3 | 8.0.44 | Any | Any | after changing FLOOR function,col_1’s value unexpectedly change |
| 119702 | 2026-01-16 7:21 | 2026-01-16 9:53 | MySQL Server | Not a Bug (114 days) | S3 | 8.0.x, 8.4.x | Any | Any | after changing max to -min(-),the col_3’s floating-precission loss appear |
| 119741 | 2026-01-22 7:00 | 2026-01-22 8:35 | MySQL Server: Optimizer | Verified (108 days) | S1 | 8.0.44 | Any | Any | internal_tmp_mem_storage_engine = MEMORY setting makes the DISTINCTROW returns incorrect result on 0 and -0 |
| 119752 | 2026-01-22 15:08 | 2026-01-22 21:36 | MySQL Server: Optimizer | Verified (108 days) | S3 | 8.0.44 | Any | Any | after changing MINUTE(subq.c1) to MINUTE(subq.c1 + INTERVAL '60' MINUTE),the result become empty. |
| 119778 | 2026-01-26 12:56 | 2026-01-29 9:27 | MySQL Server: Optimizer | Duplicate (101 days) | S3 | 8.0.x, 8.4.x | Any | Any | after changing SUM(distinct x) to - SUM(distinct -x),the value unexpectedly change |
| 119793 | 2026-01-27 10:32 | 2026-02-04 16:32 | MySQL Server: Prepared statements | Verified (95 days) | S1 | 9.5.0 | Any | Any | Incorrect result of prepared SELECT when running with JDBC |
| 119934 | 2026-02-24 11:54 | 2026-02-24 12:45 | MySQL Server: Optimizer | Verified (75 days) | S7 | 8.0.41 | Any | Any | The table structure and data are the same, but the query results for a partitioned table are different from those for a |
| 119937 | 2026-02-25 4:54 | 2026-02-25 9:25 | MySQL Server: Optimizer | Verified (74 days) | S3 | 8.0 | Any | Any | Result is not correct when using pow function with group by |
| 120102 | 2026-03-19 1:34 | 2026-03-19 8:22 | MySQL Server: JSON | Verified (52 days) | S3 | 8.0.45 | Any | Any | Incorrect DISTINCT behavior with JSON_ARRAYAGG when aggregating NULL-only groups |
| 120107 | 2026-03-19 8:40 | 2026-03-19 13:34 | MySQL Server: JSON | Verified (52 days) | S3 | 8.0.45 | Any | Any | DISTINCT eliminates non-duplicate rows for JSON_OBJECTAGG results |
| 120148 | 2026-03-25 7:41 | 2026-03-25 19:35 | MySQL Server: JSON | Duplicate (46 days) | S3 | 9.6.0 | Any | Any | Wrong result with DISTINCTROW due to constant projection interacting with JSON_ARRAYAGG |
| 120286 | 2026-04-19 5:14 | 2026-04-20 7:53 | MySQL Server: Optimizer | Verified (20 days) | S2 | 8.0.45 | Any | Any | `SUM(DISTINCT pk)` returns `NULL` with a window function when a secondary index is used for group-by scanning |
| 120420 | 2026-05-08 8:19 | 2026-05-08 8:19 | MySQL Server: Optimizer | Open | S3 | 9.7.0 (also reproducible in 8.0.x) | Any | Any | ORDER BY ignored when internal_tmp_mem_storage_engine = TempTable with GROUP BY on temp table |
| 120422 | 2026-05-08 8:56 | 2026-05-08 8:56 | MySQL Server: Optimizer | Open | S2 | 9.7.0 (also reproducible in 8.0.x) | Any | Any | ORDER BY ignored when internal_tmp_mem_storage_engine = TempTable with GROUP BY on CTE |
| 12 | 2002-12-11 17:42 | 2003-11-26 12:14 | MySQL Server | Closed (8201 days) | S3 | 3.23.53 | Any (any) | Any | CASE ... ; and NULLs |
| 147 | 2003-03-12 10:55 | 2003-03-12 10:55 | MySQL Server | Closed (8460 days) | S3 | all | Any (any) | Any | Bug with group by + having involving Date calculations |
| 173 | 2003-03-21 1:21 | 2003-03-26 8:07 | MySQL Server | Closed (8446 days) | S2 | any | Any (any) | Any | REPLACE with GROUP BY truncating result |
| 251 | 2003-04-08 12:50 | 2019-04-08 13:49 | MySQL Server | Closed (8367 days) | S2 | 4.1.0 | Any (All) | Any | DESCRIBE on a query with a grouped subquery crashes mysql |
| 514 | 2003-05-27 2:28 | 2019-05-14 14:26 | MySQL Server | Closed (8347 days) | S2 | 4.0.13 | Any (any) | Any | GROUP BY and LEFT/RIGHT/MID wrong results with charset cp1251 |
| 634 | 2003-06-11 4:24 | 2019-05-14 14:30 | MySQL Server | Can't repeat (6434 days) | S3 | 4.1.1 current BK tree | Any (FreeBBSD-4.6) | Any | SELECT CAST(datetime_value AS DATE) GROUP by 1 |
| 906 | 2003-07-24 4:05 | 2003-08-11 3:09 | MySQL Server | Closed (8308 days) | S3 | 4.1 | Any (any) | Any | union subquery problem |
| 1537 | 2003-10-12 1:11 | 2003-10-13 12:25 | MySQL Server | Closed (8245 days) | S2 | 4.1 | Any (any) | Any | group_by incorrectly work with item which substitute other on fix_fields() |
| 2188 | 2003-12-22 8:22 | 2004-01-20 11:04 | MySQL Server | Closed (8146 days) | S2 | 4.1, 5.0 | Any (all) | Any | Query with select in field list doesn't work with prepared statements |
| 3203 | 2004-03-17 9:00 | 2004-03-26 4:34 | MySQL Server | Closed (8080 days) | S1 | 4.0.19 | Any (any) | Any | A crashing bug with distinct query and a hidden field with SQL_BIG_TABLES |
| 3328 | 2004-03-29 13:01 | 2004-04-05 2:15 | MySQL Server | Closed (8070 days) | S2 | 4.1 | Any (Any) | Any | I can't see group_concat_max_len in a list of variables |
| 3704 | 2004-05-10 22:07 | 2004-05-11 17:33 | MySQL Server | Closed (8034 days) | S2 | 4.1.2 | Any (any) | Any | charset conversion doesn't fix fields for function items |
| 7320 | 2004-12-15 15:41 | 2012-05-18 20:19 | MySQL Server | Duplicate (7003 days) | S3 | 4.1 | Any (any) | Any | wrong response, SUM(..) and correlated subquery after HAVING |
| 7945 | 2005-01-16 18:50 | 2005-03-07 0:03 | MySQL Server | Closed (7734 days) | S3 | 4.1.9 | Any (all) | Any | SQL_CALC_FOUND_ROWS with distinct constant and group by |
| 8092 | 2005-01-22 18:38 | 2013-07-03 5:38 | MySQL Server: Merge storage engine | Open | S4 | Any | Any | INSERT_METHOD feature request | |
| 8510 | 2005-02-15 1:48 | 2011-12-05 13:58 | MySQL Server | Closed (7726 days) | S2 | 4.1.10 | Any (any) | Any | ONLY_FULL_GROUP_BY sql mode is overly restrictive |
| 8652 | 2005-02-21 16:28 | 2010-05-12 5:07 | MySQL Server: Optimizer | Not a Bug (7641 days) | S3 | 4.1.10 | Any | Any | group by part of rand() returns duplicate key error |
| 9082 | 2005-03-09 18:51 | 2009-05-28 11:18 | MySQL Administrator | Won't fix (6191 days) | S4 | 1.0.19 | Any (ALL) | Any | Show Explain Plan in tab "Server Connections" |
| 9228 | 2005-03-16 18:37 | 2005-04-26 21:31 | MySQL Server: Optimizer | Not a Bug (7684 days) | S3 | 4.1.10 | Any (*) | Any | optimizer on alternating function with no ref to columns |
| 9681 | 2005-04-06 15:28 | 2005-04-28 15:41 | MySQL Server: Optimizer | Closed (7682 days) | S3 | 4.1.11 | Any (*) | Any | rollup in from-subquery returns error "collumn cannot be null" |
| 13174 | 2005-09-14 11:21 | 2011-02-16 23:43 | MySQL Server | Closed (5821 days) | S4 | 6.0 | Any | Any | Patch: SHA2 function |
| 14303 | 2005-10-25 18:20 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (6906 days) | S4 | 5.0.26-BK, 5.0.18 | Any (Solaris) | Any | Internal temporary tables consume too much memory |
| 14545 | 2005-11-01 17:01 | 2018-11-16 21:30 | MySQL Server: DML | Verified (7495 days) | S4 | Any (any) | Any | Median SQL Aggregate function | |
| 16556 | 2006-01-17 2:14 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified (7418 days) | S4 | mysql-5.1 | Any | Any | DD: New error messages needed |
| 18408 | 2006-03-21 22:59 | 2006-03-23 17:04 | MySQL Server | Won't fix (7353 days) | S4 | 5.0 | Any (Any) | Any | Reserved words are an anachronism |
| 19205 | 2006-04-19 20:44 | 2011-02-16 23:43 | MySQL Server: Prepared statements | Can't repeat (5993 days) | S3 | 4.1, 5.0-BK | Any (any) | Any | server provides different metadata in ps-protocol and non-ps-protocol mode |
| 19738 | 2006-05-11 19:47 | 2006-10-04 2:41 | MySQL Server: Installing | Closed (7158 days) | S3 | 5.0, 5.1 | Any (Unix) | Any | "make install" tries to build files that "make" should already have built |
| 20191 | 2006-06-01 10:19 | 2006-12-14 20:10 | MySQL Server: Views | Closed (7087 days) | S1 | 5.0.23-BK | Any (all) | Any | getTableName gives wrong or inconsistent result when using VIEWs |
| 20353 | 2006-06-09 11:12 | 2012-05-18 20:19 | MySQL Server: Charsets | Verified (6376 days) | S3 | 4.1, 5.0, 5.1 | Any | Any | Prefix key search return incorrect results for ignorable characters |
| 20630 | 2006-06-22 15:45 | 2011-02-16 23:43 | MySQL Server: General | Verified (7262 days) | S4 | 5.0.22 (+?) | Any (all) | Any | Remove restriction on option file parameters being first |
| 21403 | 2006-08-01 19:21 | 2011-02-16 23:43 | MySQL Server: Errors | Verified | S4 | all | Any (all) | Any | more specific SQL states for 23nnn |
| 23140 | 2006-10-10 14:33 | 2006-10-10 17:07 | MySQL Server | Open (7152 days) | S4 | 5.0 | Any (All) | Any | Explicit support of datetime type for aggregate functions like AVG() |
| 24401 | 2006-11-17 16:53 | 2007-02-07 19:05 | MySQL Server | Closed (7032 days) | S2 | 5.0.30 | Any (any) | Any | MySQL server crashes if you try to retrieve data from corrupted table |
| 25219 | 2006-12-20 15:04 | 2007-02-01 1:55 | MySQL Server | Closed (7038 days) | S1 | 5.0bk | Any (any) | Any | SELECT with subqueries causes MySQL server crash |
| 25876 | 2007-01-26 17:35 | 2007-05-04 7:52 | MySQL Server: Tests | No Feedback (6946 days) | S3 | 5.0.30 | Any (Vista (64 bit)) | Any | regression tests do not run after using "Windows easy transfer". |
| 25951 | 2007-01-30 16:13 | 2007-05-08 1:06 | MySQL Server | Closed (6942 days) | S3 | 4.1.22 and 5.0.33 | Any (*) | Any | ignore/use index does not work with fulltext |
| 26182 | 2007-02-08 11:02 | 2015-07-09 13:30 | MySQL Server: Information schema | Verified | S3 | 6.0 | Any | Any | patch: process percentage of a process -- contributed from Jeremy Cole |
| 26319 | 2007-02-13 13:10 | 2007-04-30 9:21 | MySQL Migration Toolkit | Closed (6950 days) | S2 | 1.1.9/1.1.10 | Any (Server 2003 Enterprise Edition) | Any | The connection to the target database could not be established (error: 0). |
| 26635 | 2007-02-26 13:03 | 2007-03-07 17:52 | MySQL Server: Documentation | Closed (7004 days) | S3 | all | Any (all) | Any | CREATE table and password |
| 27019 | 2007-03-09 22:41 | 2011-02-16 23:43 | MySQL Server | Closed (6287 days) | S4 | Any | Any | nulls in unique composite keys - again! | |
| 27050 | 2007-03-12 15:10 | 2007-04-30 8:51 | MySQL Migration Toolkit | Won't fix (6950 days) | S1 | 1.1.10 | Any (Server 2003 Enterprise Edition) | Any | The schema could not be reverse engineered (error: 0). |
| 27333 | 2007-03-21 14:29 | 2007-07-11 22:21 | MySQL Server | Closed (6878 days) | S3 | 5.0.40/5.1 | Any (*) | Any | subquery grouped for aggregate of outer query / no aggregate of subquery |
| 27348 | 2007-03-21 17:37 | 2007-05-11 19:28 | MySQL Server | Closed (6939 days) | S3 | 5.0.40 | Any (*) | Any | aggregate in subquery executed, even if position in qualifying query is invalid |
| 27386 | 2007-03-22 23:25 | 2007-07-09 8:59 | MySQL Server: General | Not a Bug (6880 days) | S1 | 5.1.17 Beta | Any (Unknown(ISP) and Mac OS X) | Any | Queries are Returning Results Which are not Ordered |
| 27434 | 2007-03-26 8:56 | 2007-04-02 11:20 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6978 days) | S3 | 4.1,5.0,5.1 | Any | Any | Incorrect handling of FragState in take-over during SR |
| 27643 | 2007-04-04 12:13 | 2007-06-19 0:44 | MySQL Server: General | Closed (6900 days) | S2 | 5.0BK | Any | Any | query failed : 1114 (The table '' is full) |
| 27795 | 2007-04-12 22:26 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6968 days) | S4 | 5.0.40, 5.1 | Any | Any | patch for explain extended to show outer aggregates like outer fields |
| 27848 | 2007-04-16 11:59 | 2008-07-18 15:51 | MySQL Server | Closed (6505 days) | S3 | 5.0.40 4.1.23 | Any | Any | rollup in union part causes error with order of union |
| 27908 | 2007-04-18 0:46 | 2008-10-07 12:10 | MySQL Server: Falcon storage engine | Can't repeat (6424 days) | S1 | 6.0.0-alpha-pb507 | Any | Any | Server crashes when obtaining data from Falcon's information_schema tables |
| 27957 | 2007-04-19 16:06 | 2007-05-15 2:56 | MySQL Server | Closed (6935 days) | S3 | 5.0.40 | Any | Any | cast as decimal does not check overflow, also inconsistent with group, subselect |
| 28155 | 2007-04-29 22:37 | 2007-05-02 15:12 | MySQL Server: Documentation | Closed (6948 days) | S3 | Any | Any | Any | Some aggregate functions don't appear in TOC |
| 28300 | 2007-05-08 10:03 | 2011-02-16 23:43 | MySQL Server: GIS | Verified (6942 days) | S4 | any | Any | Any | General RTREE indicies |
| 28811 | 2007-05-31 16:14 | 2007-06-14 19:49 | MySQL Server: Optimizer | Closed (6905 days) | S1 | 5.0.42, 5.0.44-BK | Any | Any | server crash with subqueries and order by |
| 28957 | 2007-06-07 19:30 | 2015-10-22 19:36 | MySQL Server: DML | Verified (6910 days) | S4 | 5.x | Any | Any | Ordered Analytical Functions |
| 29144 | 2007-06-15 16:25 | 2007-06-15 18:26 | MySQL Server | Can't repeat (6904 days) | S1 | 5.0+ | Any | Any | Error on sums |
| 29167 | 2007-06-18 4:57 | 2007-06-23 7:03 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6896 days) | S3 | 5.0-wl2325-5.0, 5.1* | Any | Any | Insufficient nodes for SR |
| 29388 | 2007-06-27 13:53 | 2007-07-11 15:00 | MySQL Enterprise Monitor: Advisors/Rules | Closed (6878 days) | S3 | 1.1.0 | Any | Any | innodb redo log size rule? |
| 29582 | 2007-07-05 18:57 | 2007-08-03 2:29 | MySQL Server: Optimizer | Closed (6855 days) | S1 | 5.0.42, 5.0.46BK | Any | Any | huge memory consumption with union, subselect, joins |
| 29610 | 2007-07-07 10:22 | 2018-09-25 21:45 | MySQL Server: Tests | Closed (6864 days) | S7 | 5.1.20, 5.1 BK | Any (hpux,aix,solaris,osx,linux) | Any | func_group fails with lost connection |
| 29611 | 2007-07-07 10:35 | 2020-05-03 20:45 | MySQL Server | Duplicate (6878 days) | S2 | 5.1 BK | Any | Any | count_distinct3,subselect,func_group fails on 64-bit platforms |
| 29634 | 2007-07-09 1:06 | 2007-12-20 17:02 | MySQL Server | Closed (6716 days) | S3 | 5.1.20 | Any | Any | mysqld_safe does not set err_log variable, error log file is not created |
| 29685 | 2007-07-10 9:40 | 2007-07-10 11:38 | MySQL Server: General | Closed (6879 days) | S2 | >=5.0.40 | Any | Any | SELECT with EXISTS and GROUP BY gives wrong result |
| 30183 | 2007-08-01 17:20 | 2022-12-04 20:45 | MySQL Server: User-defined functions ( UDF ) | Verified (6856 days) | S4 | 5.0 | Any | Any | Redundant UDF calls when grouping by UDF result |
| 30237 | 2007-08-03 22:10 | 2007-10-09 17:07 | MySQL Server: Parser | Closed (6788 days) | S5 | 5.0 | Any | Any | Performance regression in boolean expressions |
| 30325 | 2007-08-09 0:03 | 2007-09-03 13:01 | MySQL Migration Toolkit | Closed (6824 days) | S2 | Any | Any | Migration Toolkit should convert Sybase TINYINT to MySQL UNSIGNED TINYINT | |
| 30436 | 2007-08-15 13:48 | 2022-03-06 20:45 | MySQL Server: MyISAM storage engine | No Feedback (6616 days) | S3 | 5.0.45 | Any | Any | MySQL Key_Reads variable seems to be wrong |
| 30831 | 2007-09-05 12:27 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified (6550 days) | S3 | mysql-5.1 | Any | Any | All data nodes are listed in nodegroup 0 while starting |
| 30936 | 2007-09-10 15:19 | 2007-09-10 15:33 | MySQL Server: Errors | Not a Bug (6817 days) | S3 | MySQL 5.0 | Any | Any | Syntax error |
| 30937 | 2007-09-10 19:07 | 2008-08-02 1:12 | MySQL Enterprise Monitor: Server | Closed (6490 days) | S2 | 2.0 | Any | Any | endless loop with ring-spoke topology |
| 31063 | 2007-09-17 15:58 | 2007-09-18 11:34 | MySQL Server: DML | Can't repeat (6809 days) | S3 | 5.1.21 | Any | Any | GROUP BY WITH ROLLUP inconsistence with derived tables |
| 31070 | 2007-09-17 22:10 | 2007-10-23 0:07 | MySQL Server: Charsets | Closed (6774 days) | S2 | 5.0.50, 5.1.23BK | Any | Any | crash during conversion of charsets |
| 31095 | 2007-09-19 12:22 | 2007-11-09 0:24 | MySQL Server: General | Closed (6757 days) | S1 | 5.0.48, 5.1.23BK | Any | Any | server crashes with group by null with rollup |
| 31133 | 2007-09-21 15:25 | 2007-10-15 9:56 | MySQL Cluster: Disk Data | Can't repeat (6782 days) | S3 | 5.1bk | Any | Any | Disk based statements not accepting magnitude suffixes |
| 31144 | 2007-09-22 13:34 | 2007-11-16 9:47 | MySQL Server: General | Closed (6750 days) | S2 | 5.1.23, 6.0.3 | Any | Any | crash when subquery within order by/group by clause returns spatial datatype |
| 31156 | 2007-09-23 13:20 | 2007-11-01 2:43 | MySQL Server: Data Types | Closed (6765 days) | S2 | 5.0.48-debug, 5.1.23-debug | Any | Any | mysqld: item_sum.cc:918: virtual bool Item_sum_distinct::setup(THD*): Assertion |
| 31203 | 2007-09-26 10:00 | 2007-09-26 10:39 | MySQL Server: Parser | Not a Bug (6801 days) | S1 | 5.0.45 | Any | Any | left join returns error only on v5.0.45 but work fine on versions 3.x and 4.x |
| 31249 | 2007-09-27 16:38 | 2007-10-22 23:55 | MySQL Server: Data Types | Closed (6775 days) | S1 | 5.1 | Any | Any | Assertion `!table || (!table->write_set || bitmap_is_set(table->write_set, fiel |
| 31349 | 2007-10-02 18:13 | 2007-12-20 0:43 | MySQL Server: Data Types | Closed (6716 days) | S3 | 5.1.23-debug, 5.0.48-debug | Any | Any | ERROR 1062 (23000): Duplicate entry '' for key 'group_key' |
| 31351 | 2007-10-02 18:26 | 2007-10-08 8:09 | MySQL Server: Charsets | Not a Bug (6789 days) | S3 | 5.0.45 | Any | Any | provide collations for AaBb... and AB...ab sorting |
| 31398 | 2007-10-04 14:24 | 2007-10-25 1:39 | MySQL Server: Tests | Closed (6772 days) | S3 | 5.1 | Any | Any | problems with mysql-test-run |
| 31472 | 2007-10-09 8:59 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (6671 days) | S3 | 5.0.50 | Any | Any | multi_update crashes at assert about trans_safe |
| 31525 | 2007-10-11 9:49 | 2007-11-06 9:15 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6760 days) | S3 | 4.1,5.0,5.1 | Any | Any | Incorrect handling of ActiveMissed_2, potential "Lost node group" after SR |
| 31899 | 2007-10-28 19:55 | 2007-10-29 11:19 | MySQL Server: General | Not a Bug (6768 days) | S3 | 5.0.45 | Any | Any | Group functions not working properly when joining tables |
| 32030 | 2007-11-01 12:55 | 2007-12-14 19:47 | MySQL Server: DML | Closed (6722 days) | S3 | Any | Any | DELETE does not return an error and deletes rows if error evaluating WHERE | |
| 32083 | 2007-11-03 22:53 | 2008-02-25 19:15 | MySQL Server: InnoDB storage engine | Closed (6649 days) | S1 | 5.0.50 | Any | Any | server crashes on show status when InnoDB is not initialized |
| 32240 | 2007-11-09 16:30 | 2011-02-16 23:43 | Eventum | Won't fix (5608 days) | S3 | 2.1.1 | Any | Any | Mail with undisclosed-recipients causes error |
| 32621 | 2007-11-22 12:42 | 2007-12-03 14:27 | MySQL Server: Falcon storage engine | Closed (6733 days) | S3 | 6.0.4 | Any | Any | falcon_ts.test fails |
| 32993 | 2007-12-05 9:38 | 2008-04-29 17:42 | MySQL Server: Falcon storage engine | Closed (6585 days) | S1 | 6.0.4 | Any | Any | falcon_ts.test fails sporadically |
| 33647 | 2008-01-03 10:16 | 2013-05-16 6:10 | MySQL Server: DML | Not a Bug (4742 days) | S3 | 5.1.22 | Any | Any | WITH ROLLUP fails when using subqueries |
| 33703 | 2008-01-05 13:27 | 2008-01-23 21:23 | MySQL Enterprise Monitor: Localization | Can't repeat (6682 days) | S2 | 1.3J beta | Any | Any | Mistranslation of "Recipients" on Manage Notification Groups page |
| 33824 | 2008-01-11 17:56 | 2008-02-11 21:00 | MySQL Server: Falcon storage engine | Can't repeat (6663 days) | S1 | 6.0.4-p3 | Any | Any | Manipulations on a view and on the underlying table cause duplicate primary key |
| 33876 | 2008-01-15 17:14 | 2008-02-15 17:47 | MySQL Server: General | No Feedback (6659 days) | S3 | 4.1.16 | Any (Not return correct result) | Any | Query run OK in Mysql 5.0.27 but not run at 4.1.16 |
| 33933 | 2008-01-18 20:28 | 2008-10-01 18:09 | MySQL Server: Falcon storage engine | Closed (6430 days) | S1 | 6.0.4-p3-debug | Any | Any | Falcon assertionFailed() in fetchNext() |
| 34313 | 2008-02-05 16:38 | 2012-05-18 20:19 | MySQL Server | Duplicate (6669 days) | S2 | 5.0, 5.1 | Any | Any | Server crash when using EXISTS with a subquery that errors and extra parenthesis |
| 34360 | 2008-02-06 19:06 | 2008-02-07 0:43 | Connector / NET | Not a Bug (6667 days) | S2 | 5.1.4.0 | Any | Any | MySqlDataReader returns zero instead of actual value when doing count(*) |
| 34382 | 2008-02-07 14:55 | 2008-03-07 15:05 | MySQL Server: General | No Feedback (6638 days) | S3 | 5.0.32 | Any (Sorry none) | Any | Error when using ON DUPLICATE KEY UPDATE table1.field1 = table2.field1,.... |
| 34529 | 2008-02-13 16:52 | 2008-07-18 15:48 | MySQL Server: Information schema | Closed (6505 days) | S2 | 6.0-BK | Any | Any | Crash on complex Falcon I_S select after ALTER .. PARTITION BY |
| 34580 | 2008-02-15 8:37 | 2025-12-07 20:45 | MySQL Server: Command-line Clients | Verified (6656 days) | S3 | 6.0.4, 4.1, 5.0, 5.1 | Any | Any | "MySQL Command Line Client" windows client does not work when server not started |
| 34590 | 2008-02-15 11:51 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (5954 days) | S3 | 6.0.4 | Any | Any | Innodb crash in build_template() on multi-table delete |
| 34591 | 2008-02-15 11:56 | 2016-10-09 20:45 | MySQL Server: Optimizer | Duplicate (5954 days) | S1 | 6.0.4 | Any | Any | Innob crash in row_sel_store_mysql_rec() on multi-table delete |
| 34597 | 2008-02-15 15:28 | 2012-05-18 20:19 | MySQL Server: Replication | Verified (6414 days) | S4 | 5.1+ | Any | Any | Warning in error log when calling a function from a trigger |
| 34758 | 2008-02-22 11:46 | 2008-08-11 20:41 | MySQL Server: Backup | Closed (6481 days) | S2 | 6.0.5 | Any | Any | Server crashes if database with views backed up using CS driver |
| 34900 | 2008-02-27 18:20 | 2012-05-18 20:19 | MySQL Enterprise Monitor: Server | Verified (6158 days) | S4 | 2.0.5.7153 | Any | Any | Add Global Status on the MEM replication page to show all Seconds Behind Master |
| 34943 | 2008-02-28 21:43 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5836 days) | S3 | 5.1.23 | Any | Any | effect of combining SQL_%_RESULT modifiers and use in subqueries should be doc'd |
| 35010 | 2008-03-03 18:49 | 2008-11-26 17:07 | MySQL Server: Documentation | Closed (6374 days) | S3 | Any | Any | View mergeability criteria are incorrect in the documentation | |
| 35034 | 2008-03-04 14:35 | 2008-09-29 16:46 | MySQL Server: Falcon storage engine | Can't repeat (6432 days) | S3 | 6.0-falcon-team | Any | Any | Falcon crash on complex I_S query in ResultSet::setValue, ResultSet.cpp line 154 |
| 35090 | 2008-03-05 20:15 | 2025-12-07 20:45 | MySQL Server: General | Verified (6277 days) | S3 | 5.0, 5.1, 6.0 BK | Any (Unix-only?) | Any | umask applied as bitmap instead of as a mask |
| 35311 | 2008-03-15 17:19 | 2022-09-04 20:45 | MySQL Server: Optimizer | Duplicate (6312 days) | S3 | 5.0.38+ | Any | Any | ROW(...) IN (SELECT outer field,... FROM DUAL)" always returns TRUE |
| 36138 | 2008-04-16 13:21 | 2008-04-25 12:06 | MySQL Server: DML | Not a Bug (6589 days) | S1 | 5.0.45 | Any | Any | SELECT with LEFT JOIN and aggregate function returns incorrect results |
| 36603 | 2008-05-08 19:22 | 2009-01-08 9:41 | MySQL Server: Falcon storage engine | Closed (6331 days) | S3 | 6.0.5 | Any | Any | Falcon; Performance drop when ageGroup hits 2^31 |
| 36734 | 2008-05-15 10:27 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (6200 days) | S1 | 6.0.6pre, 6.0.8pre, 6.0-falcon-team tree | Any | Any | Falcon crash in Record::getEncodedValue |
| 36794 | 2008-05-19 7:53 | 2011-02-16 23:43 | MySQL Server: Partitions | Duplicate (6103 days) | S4 | 5.1.24 | Any | Any | Partition by function of time, optimise queries to use only correct tables. |
| 36971 | 2008-05-26 14:43 | 2008-09-25 20:40 | MySQL Server: Falcon storage engine | Can't repeat (6436 days) | S1 | 6.0-falcon-team | Any | Any | Falcon crash in RecordVersion::fetchVersionRecursive on I_S query |
| 37062 | 2008-05-29 10:45 | 2008-05-29 15:30 | MySQL Enterprise Monitor: Web | Not a Bug (6555 days) | S4 | 2.0.0.6047 | Any | Any | changing parameters for a scheduled rule should be possible without unschedule |
| 37415 | 2008-06-15 17:56 | 2011-02-16 23:43 | MySQL Server: Optimizer | Can't repeat (6010 days) | S1 | 6.0 | Any | Any | Crash in row_sel_field_store_in_mysql_format on multiple-table update (innodb) |
| 37726 | 2008-06-29 12:31 | 2008-10-01 12:42 | MySQL Server: Falcon storage engine | Closed (6430 days) | S1 | 6.0-falcon | Any | Any | Falcon crash in WalkDeferred::getNext |
| 37807 | 2008-07-02 12:20 | 2011-02-16 23:43 | Tools: MTR / mysql-test-run | Won't fix (6059 days) | S3 | 6.0-BK | Any | Any | ndb.ndb_dd_basic fails randomly |
| 37842 | 2008-07-03 17:05 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5650 days) | S1 | 6.0 | Any | Any | Assertion in DsMrr_impl::dsmrr_init, at handler.cc:4307 |
| 37846 | 2008-07-03 18:21 | 2011-02-16 23:43 | MySQL Server: Replication | Won't fix (6365 days) | S2 | 5.0 bzr | Any | Any | Bug #23171 (Illegal slave restart (group) position) not fixed in 5.0 |
| 37847 | 2008-07-03 18:26 | 2011-02-16 23:43 | MySQL Server: Replication | Won't fix (6359 days) | S2 | 5.0 bzr | Any | Any | Bug #28618 was not fixed in version 5.0 |
| 37893 | 2008-07-05 20:00 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5976 days) | S1 | 6.0 | Any | Any | Crash in select_describe line 19251 on a FirstMatch query with OUTER JOIN |
| 37894 | 2008-07-05 20:46 | 2008-11-10 18:19 | MySQL Server: Optimizer | Closed (6390 days) | S1 | 5.0,5.1,6.0 | Any | Any | Assertion in init_read_record_seq in handler.h line 1444 |
| 37896 | 2008-07-05 21:32 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5650 days) | S1 | 6.0 | Any | Any | Assertion on entry of Item_in_subselect::exec on subquery with AND NOT |
| 37943 | 2008-07-07 18:39 | 2008-10-18 15:22 | MySQL Server: Optimizer | Closed (6413 days) | S1 | 5.0.51, 5.0.62 | Any | Any | Reproducible mysqld crash/sigsegv in sel_trees_can_be_ored |
| 38043 | 2008-07-11 10:50 | 2008-09-30 20:36 | MySQL Server: Falcon storage engine | Closed (6431 days) | S1 | 6.0-falcon | Any | Any | Deadlock between server and falcon when executing concurrent ALTER + DML |
| 38044 | 2008-07-11 11:01 | 2008-10-04 13:40 | MySQL Server: Falcon storage engine | Closed (6427 days) | S1 | 6.0-falcon | Any | Any | Falcon crash in StorageTable::compareKey at StorageTable.cpp:412 |
| 38130 | 2008-07-15 10:35 | 2009-05-15 16:17 | MySQL Server: Falcon storage engine | Closed (6204 days) | S1 | 6.0-falcon | Any | Any | Falcon assertion in IndexNode::expandKey offset + length <= MAX_PHYSICAL_KEY_LEN |
| 38191 | 2008-07-17 8:13 | 2008-10-05 22:04 | MySQL Server: Optimizer | Closed (6426 days) | S1 | 5.1, 6.0 BZR | Any | Any | Crash in List<Cached_item>::delete_elements at sql_list.h:400 |
| 38541 | 2008-08-04 14:59 | 2008-12-13 9:05 | MySQL Server: Falcon storage engine | Closed (6357 days) | S1 | 6.0-falcon | Any | Any | Falcon RecordVersion::thaw assertion ""bytesRestored > 0 || data.record == NULL" |
| 38798 | 2008-08-14 13:36 | 2008-09-15 17:13 | MySQL Server: Replication | Closed (6446 days) | S1 | 5.1, 6.0 bzr | Any | Any | Assertion mysql_bin_log.is_open() failed in binlog_trans_log_savepos() |
| 38804 | 2008-08-14 16:27 | 2008-10-17 18:16 | MySQL Server: Locking | Closed (6414 days) | S1 | 5.1-bzr | Any | Any | Query deadlock causes all tables to be inaccessible. |
| 38837 | 2008-08-17 4:01 | 2011-02-16 23:43 | MySQL Server: Information schema | Verified | S3 | 5.0+ | Any | Any | need a way to disable information_schema for security |
| 38984 | 2008-08-23 18:53 | 2011-11-26 12:29 | MySQL Server: Information schema | Can't repeat (5279 days) | S1 | 6.0, 5.5.4-m3 | Any | Any | Crash in Field_varstring::sql_type at field.cc:7049 |
| 39081 | 2008-08-27 20:45 | 2009-05-15 17:00 | MySQL Server: Falcon storage engine | Closed (6204 days) | S1 | 6.0-falcon, 6.0.7 | Any | Any | Falcon: segfault in StorageInterface::getDemographics() |
| 39210 | 2008-09-03 11:19 | 2009-01-09 14:58 | MySQL Server: Maria storage engine | Closed (6330 days) | S1 | 5.1-maria, 6.0-maria | Any | Any | Maria deadlock in _ma_bitmap_wait_or_flush |
| 39407 | 2008-09-11 19:12 | 2025-12-07 20:45 | MySQL Server | Duplicate (6425 days) | S1 | 5.1-bzr, 6.0.7 | Any | Any | Auto increment failure on concurrent DML (Innodb and Falcon) |
| 39446 | 2008-09-15 8:49 | 2020-09-13 20:45 | MySQL Server: Maria storage engine | Duplicate (6403 days) | S1 | 6.0-bzr | Any | Any | Maria deadlock in pagecache_read |
| 39479 | 2008-09-16 14:20 | 2011-02-16 23:43 | MySQL Workbench | Won't fix (6046 days) | S3 | 5.0.25 | Any | Any | Model Validation issues |
| 39710 | 2008-09-28 11:34 | 2009-01-08 11:05 | MySQL Server: Maria storage engine | Closed (6331 days) | S1 | 5.1-maria, 6.0-maria | Any | Any | Maria assertion in maria_disable_non_unique_index |
| Showing 1-1000 of 3030 (Edit, Save, CSV, Feed) | Show Next 1000 Entries » |
