MySQL Bugs

#3686: prepared statement, union + group by, inconsistent behaviour during prepare

Fri, 07 May 2004 12:24:58 +0000

Bug ID: 3686
Submitted by: Matthias Leich
Category: Server
Status: Closed
Severity: 3
Version: 4.1.2

#1458: configure options outside [group] works in 3.23.x but not 4.0.13

Wed, 01 Oct 2003 13:47:25 +0000

Bug ID: 1458
Submitted by: Arjen Lentz
Category: Server
Status: Won't fix
Severity: 4
Version: 4.0.13

#17276: Unwanted behaviour WITH ROLLUP

Thu, 09 Feb 2006 14:51:00 +0000

Bug ID: 17276
Submitted by: John Baxter
Category: Server
Status: Won't fix
Severity: 4

#21648: information_schema test fails --with-ndbcluster

Tue, 15 Aug 2006 06:12:22 +0000

Bug ID: 21648
Submitted by: Stewart Smith
Category: Server: Tests
Status: Closed
Severity: 3
Version: 5.1.12bk

#22342: No results returned for query using max and group by

Thu, 14 Sep 2006 12:37:17 +0000

Bug ID: 22342
Submitted by: David Crimmins
Category: Server
Status: Closed
Severity: 2
Version: 5.0.22-pro-nt-log

#387: ERROR 1055: 'NULL' isn't in GROUP BY -- in ANSI mode

Wed, 07 May 2003 06:02:57 +0000

Bug ID: 387
Submitted by:
Category: Server
Status: Closed
Severity: 3
OS: pc-linux (i686)
Version: 4.0.12

#807: Crash using CASE INTERVAL(...) ... GROUP BY

Mon, 07 Jul 2003 19:10:13 +0000

Bug ID: 807
Submitted by: Melt van Schoor
Category: Server
Status: Closed
Severity: 2
OS: pc-linux (i686)
Version: 4.0.12

#16842: DD : Crash on drop logfile group after SR

Fri, 27 Jan 2006 14:12:13 +0000

Bug ID: 16842
Submitted by: Jonas Oreland
Category: Server: Cluster
Status: Closed
Severity: 3
Version: 5.1.6

#18348: AGGREGATE BY clause as alternative to GROUP BY

Mon, 20 Mar 2006 06:36:56 +0000

Bug ID: 18348
Submitted by: Robin Edwards
Category: Server
Status: Won't fix
Severity: 4

#18492: mysqld reports ER_ILLEGAL_REFERENCE in --ps-protocol

Fri, 24 Mar 2006 15:53:17 +0000

Bug ID: 18492
Submitted by: Andrei Elkin
Category: Server: PS
Status: Closed
Severity: 3
Version: 5.1.8, 5.0.21, 4.1.19

#19452: mysql_upgrade: reads [client] group, but doesn't understand host option

Sun, 30 Apr 2006 23:49:47 +0000

Bug ID: 19452
Submitted by: Paul DuBois
Category: Server: Installing
Status: Closed
Severity: 3
Version: 5.0, 5.1

#20128: outer JOIN + GROUP BY: wrong result

Mon, 29 May 2006 15:55:40 +0000

Bug ID: 20128
Submitted by: Matthias Leich
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
Version: 5.0

#154: Wrong group by or distinct on Innodb table indexed column with NULLs

Sat, 15 Mar 2003 05:44:08 +0000

Bug ID: 154
Submitted by: Alexander Keremidarski
Category: Server: InnoDB
Status: Closed
Severity: 2
Version: All

#314: GROUP BY forces functions to treat multy-byte charset values as single-byte

Tue, 22 Apr 2003 17:01:42 +0000

Bug ID: 314
Submitted by: Alexander Keremidarski
Category: Server
Status: Closed
Severity: 3
Version: 4.0

#1335: "Filesort" is missing in EXPLAIN

Thu, 18 Sep 2003 10:06:58 +0000

Bug ID: 1335
Submitted by: Peter Zaitsev
Category: Server
Status: Closed
Severity: 3
Version: 4.0.15

#1456: cast with union and group by with rollup displays incorrect results

Wed, 01 Oct 2003 08:23:45 +0000

Bug ID: 1456
Submitted by: Georg Richter
Category: Server
Status: Closed
Severity: 3
Version: 4.1.1

#2063: Strange GROUP BY behavior with user variables

Tue, 09 Dec 2003 12:45:07 +0000

Bug ID: 2063
Submitted by: Dean Ellis
Category: Server
Status: Won't fix
Severity: 3
Version: 4.0.17

#3405: No explanation of "formula" for Group By/Order By in Select

Tue, 06 Apr 2004 22:04:22 +0000

Bug ID: 3405
Submitted by: Sergei Kulakov
Category: Server: Docs
Status: Closed
Severity: 3
Version: 5

#3659: >1 concurrent update causes deadlock

Wed, 05 May 2004 10:34:02 +0000

Bug ID: 3659
Submitted by: Johan Andersson
Category: Server: Cluster
Status: Closed
Severity: 1
OS: FermiLinux LTS 3.01
Version: mysql-4.1.2-alpha bk

#8653: 5.0.3 leaves an InnoDB trx open after connection ends; InnoDB shutdown hangs

Mon, 21 Feb 2005 16:33:16 +0000

Bug ID: 8653
Submitted by: Heikki Tuuri
Category: Server
Status: Closed
Severity: 1

#13556: Incorrect parsing of create tablespace statement in 64-bit release

Wed, 28 Sep 2005 09:23:26 +0000

Bug ID: 13556
Submitted by: Jonas Oreland
Category: Server: Cluster
Status: Closed
Severity: 3
Version: 5.1-ndb-dd

#14445: ANALYSE() computes wrong STD value for integer types

Fri, 28 Oct 2005 22:36:37 +0000

Bug ID: 14445
Submitted by: Evgeny Potemkin
Category: Server
Status: Closed
Severity: 3
Version: 5.0

#14536: ./mysql-test-run --ps-protocol user_var fails

Tue, 01 Nov 2005 07:37:44 +0000

Bug ID: 14536
Submitted by: Oleksandr Byelkin
Category: Server
Status: Closed
Severity: 2
Version: 5.0

#16854: tinyint(1) are not treated as booleans in group by

Fri, 27 Jan 2006 20:27:10 +0000

Bug ID: 16854
Submitted by: Andre Timmer
Category: Server
Status: Duplicate
Severity: 1
Version: MySQL 5.0.18

#17499: Alter table of ndb partitioned tables causes mysqld to core

Fri, 17 Feb 2006 01:51:19 +0000

Bug ID: 17499
Submitted by: Nikolay Grishakin
Category: Server: Partition
Status: Closed
Severity: 1

#18490: cluster: binlog events lost on remote mysqld (asynchronous)

Fri, 24 Mar 2006 15:46:34 +0000

Bug ID: 18490
Submitted by: Tomas Ulin
Category: Server: Cluster
Status: Closed
Severity: 2
Version: 5.1.8 bk src

#21010: GROUP BY clause resolves a string as an identifier

Wed, 12 Jul 2006 17:38:25 +0000

Bug ID: 21010
Submitted by: Dean Ellis
Category: Server
Status: Duplicate
Severity: 3
Version: 4.0 4.1 5.0 5.1

#23539: Expression evaluation stops after adding notification group to Heat Chart rule

Mon, 23 Oct 2006 04:09:16 +0000

Bug ID: 23539
Submitted by: Andy Bang
Category: Monitoring: Server
Status: Closed
Severity: 1

#23800: Correlated sub query returning incorrect results when operated upon

Tue, 31 Oct 2006 10:47:29 +0000

Bug ID: 23800
Submitted by: Andrew Rose
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: GNU/Linux (Archlinux)
Version: 5.0.26-27/4.1BK/5.0BK/5.1BK

#24420: (a,b) IN (SELECT a,min(b) FROM t GROUP BY a) can produce wrong results

Sat, 18 Nov 2006 22:49:11 +0000

Bug ID: 24420
Submitted by: Igor Babaev
Category: Server: Optimizer
Status: Closed
Severity: 2

#24915: using a view to retrieve a large number of entries

Fri, 08 Dec 2006 15:38:53 +0000

Bug ID: 24915
Submitted by: Xavier Pointe
Category: Server: Views
Status: Closed
Severity: 3
Version: 5.0.16

#25696: Alternatives to rows with group-wise maximum

Thu, 18 Jan 2007 15:22:05 +0000

Bug ID: 25696
Submitted by: Scott Noyes
Category: Server: Docs
Status: Closed
Severity: 4

#25718: group by with alias in expression (follow up bug #11694)

Fri, 19 Jan 2007 12:32:49 +0000

Bug ID: 25718
Submitted by: Martin Friebe
Category: Server
Status: Can't repeat
Severity: 3
Version: 4.1.22 and 5.0.27

#26087: Empty Result Set Returned When COUNT(), GROUP BY, and WHERE Are Used Together

Mon, 05 Feb 2007 15:27:25 +0000

Bug ID: 26087
Submitted by: Jason DeVelvis
Category: Server
Status: Closed
Severity: 3
OS: Unix
Version: 5.0

#26613: convert not working on mysql can u give me the example

Sat, 24 Feb 2007 13:02:00 +0000

Bug ID: 26613
Submitted by: rohit sampat
Category: Server
Status: Not a Bug
Severity: 2

#14: query results in a differnt number of rows depending if sql_big_tables

Sat, 21 Dec 2002 09:21:22 +0000

Bug ID: 14
Submitted by: Michael Widenius
Category: Server
Status: Closed
Severity: 3
Version: 3.23.44

#265: misspelling of SEPARATOR in documentation

Wed, 09 Apr 2003 18:04:43 +0000

Bug ID: 265
Submitted by: Rob Lineweaver
Category: Server: Docs
Status: Closed
Severity: 3

#443: Crash in query with ORDER BY, GROUP BY and subqueries

Sat, 17 May 2003 11:39:24 +0000

Bug ID: 443
Submitted by: jocelyn fournier
Category: Server
Status: Duplicate
Severity: 1
Version: 4.1.1

#804: Missed Mensioning "Bug Fix" (Or Miss Fixing a Bug)

Mon, 07 Jul 2003 13:25:16 +0000

Bug ID: 804
Submitted by: Asuka Kenji Siu Ching Pong
Category: MySQL.com
Status: Duplicate
Severity: 2
OS: N/A
Version: 08 JUL 2003

#805: Missed Mensioning "Bug Fix" (Or Miss Fixing a Bug)

Mon, 07 Jul 2003 13:27:05 +0000

Bug ID: 805
Submitted by: Asuka Kenji Siu Ching Pong
Category: MySQL.com
Status: Not a Bug
Severity: 2
OS: N/A
Version: N/A

#968: script needs fixing

Thu, 31 Jul 2003 12:19:12 +0000

Bug ID: 968
Submitted by: Philip Brown
Category: Server: Installing
Status: Closed
Severity: 3

#1315: having clauses don't accept quotes around aliased column name

Tue, 16 Sep 2003 19:39:15 +0000

Bug ID: 1315
Submitted by: Baron Schwartz
Category: Client
Status: Not a Bug
Severity: 3
OS: sun-solaris2.7 (sparc)
Version: Ver 11.15 Distrib 3.23.37

#1434: MySQL crashes on CREATE TABLE IF NOT EXISTS ... SELECT ...

Mon, 29 Sep 2003 13:24:52 +0000

Bug ID: 1434
Submitted by: Alexander Keremidarski
Category: Server
Status: Closed
Severity: 1

#1451: Export Table Creation - Error with Foreign Key

Tue, 30 Sep 2003 16:24:22 +0000

Bug ID: 1451
Submitted by: Andrés Montañez
Category: Server: InnoDB
Status: Closed
Severity: 2
Version: 4.0.13

#1708: InnoDB crash on a subquery

Thu, 30 Oct 2003 00:56:33 +0000

Bug ID: 1708
Submitted by: Indrek Siitan
Category: Server: InnoDB
Status: Closed
Severity: 2
Version: 4.1.1 (2003-10-30)

#2001: Problems with table names

Wed, 03 Dec 2003 03:23:34 +0000

Bug ID: 2001
Submitted by: Rafal Kedziorski
Category: Server
Status: Not a Bug
Severity: 3

#2495: Crash with default-character-set=tis620

Fri, 23 Jan 2004 11:51:53 +0000

Bug ID: 2495
Submitted by: Alexander Keremidarski
Category: Server
Status: Closed
Severity: 3
Version: 5.0

#3190: Standard Deviation STDDEV - 2 different calculations

Tue, 16 Mar 2004 09:45:07 +0000

Bug ID: 3190
Submitted by: Juliana Chua
Category: Server
Status: Closed
Severity: 4

#3626: Unable to remove graphs and groups

Sun, 02 May 2004 01:19:10 +0000

Bug ID: 3626
Submitted by: Harrison Fisk
Category: MySQL Administrator
Status: Closed
Severity: 3
Version: 1.0.3

#4215: Intel 4.1.2 mysql_install_db fails

Fri, 18 Jun 2004 23:30:11 +0000

Bug ID: 4215
Submitted by: Darryl Rodden
Category: Server: Installing
Status: Duplicate
Severity: 2
OS: REL 3
Version: 4.1.2

#4253: add a "herarchical data structure" - table type

Tue, 22 Jun 2004 23:20:28 +0000

Bug ID: 4253
Submitted by: shimon doodkin
Category: Server
Status: Won't fix
Severity: 4

#5269: Error 127 from query, check/repair report no problems

Fri, 27 Aug 2004 21:56:48 +0000

Bug ID: 5269
Submitted by: Dave Dyer
Category: Server: MyISAM
Status: Can't repeat
Severity: 2

#6016: Strange crash with blobs + different DATABASES

Mon, 11 Oct 2004 11:38:51 +0000

Bug ID: 6016
Submitted by: Magnus Blåudd
Category: Server: Cluster
Status: Closed
Severity: 2

#6818: undocumented change in alias behavior

Thu, 25 Nov 2004 01:42:39 +0000

Bug ID: 6818
Submitted by: Michael Stassen
Category: Server: Docs
Status: Closed
Severity: 3
Version: 4.1.7

#7946: distinct with subquery and group by

Sun, 16 Jan 2005 19:20:27 +0000

Bug ID: 7946
Submitted by: Martin Friebe
Category: Server
Status: Closed
Severity: 3
Version: 4.1.9

#8616: distinct with group by, suppresses rollup (and/or parts of result)

Sat, 19 Feb 2005 01:56:45 +0000

Bug ID: 8616
Submitted by: Martin Friebe
Category: Server
Status: Closed
Severity: 3
Version: 4.1.10

#8638: Test 'sp' fails: Stored Procedure often sends warning 1329

Mon, 21 Feb 2005 08:32:07 +0000

Bug ID: 8638
Submitted by: Joerg Bruehe
Category: Server
Status: Closed
Severity: 3
OS: Almost all Unix
Version: 5.0.3-pre

#8640: Server crash due to 'flush status' in various tests

Mon, 21 Feb 2005 09:47:38 +0000

Bug ID: 8640
Submitted by: Joerg Bruehe
Category: Server
Status: Closed
Severity: 2
OS: some Unix 64-bit
Version: 5.0.3-pre

#9618: Test 'group_by' returns more rows than expected when NDB is included

Mon, 04 Apr 2005 18:16:06 +0000

Bug ID: 9618
Submitted by: Joerg Bruehe
Category: Server: Cluster
Status: Closed
Severity: 2
OS: x86: Linux, OpenBSD, QNX, Sol 8
Version: 4.1.11

#11314: SELECT GROUP HAVING DEFAULT(a) hangs

Tue, 14 Jun 2005 12:41:10 +0000

Bug ID: 11314
Submitted by: Alexey Botchkov
Category: Server
Status: Closed
Severity: 2
Version: 5.0

#11375: Unbalanced data for number of nodes not on the form 2 ** n

Thu, 16 Jun 2005 10:57:37 +0000

Bug ID: 11375
Submitted by: Mikael Ronström
Category: Server: Docs
Status: No Feedback
Severity: 2

#11829: D.1.3. Changes in release 5.0.8 - bad example code

Sat, 09 Jul 2005 02:19:11 +0000

Bug ID: 11829
Submitted by: Ondra Zizka
Category: Server: Docs
Status: Closed
Severity: 3

#12121: C-API: mysql_real_connect documentation is not exact

Fri, 22 Jul 2005 18:57:30 +0000

Bug ID: 12121
Submitted by: Ingo Krabbe
Category: Server: Docs
Status: Closed
Severity: 3

#13081: NDB gets incorrect result in test-ATIS

Fri, 09 Sep 2005 07:36:35 +0000

Bug ID: 13081
Submitted by: Stewart Smith
Category: Server: Cluster
Status: Closed
Severity: 2
Version: 5.0.13

#13088: Documentation Bug for the ENUM field

Fri, 09 Sep 2005 13:35:16 +0000

Bug ID: 13088
Submitted by: Peter Volk
Category: Server: Docs
Status: Closed
Severity: 3

#13180: server accepts sometimes group in update's where condition

Wed, 14 Sep 2005 13:50:27 +0000

Bug ID: 13180
Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: * / freebsd/Suse 9.3
Version: 4.1.14/5.0 BK source

#13475: yassl: octane2 server crash

Mon, 26 Sep 2005 08:40:29 +0000

Bug ID: 13475
Submitted by: Magnus Blåudd
Category: Server
Status: Duplicate
Severity: 3
OS: mips-sgi-irix6.5

#14418: RBR: Uncertain behaviour when stopping updates in the middle

Fri, 28 Oct 2005 09:02:36 +0000

Bug ID: 14418
Submitted by: Mats Kindahl
Category: Server: Replication
Status: Closed
Severity: 2

#16109: doubled words in 5.0.17 manual

Fri, 30 Dec 2005 23:35:31 +0000

Bug ID: 16109
Submitted by:
Category: Server: Docs
Status: Closed
Severity: 3
OS: n/a
Version: n/a

#17594: Various NDB startup / restart problems

Mon, 20 Feb 2006 19:41:22 +0000

Bug ID: 17594
Submitted by: Joerg Bruehe
Category: Server: Cluster
Status: No Feedback
Severity: 1
OS: Various Unix
Version: 5.1.7-beta

#18451: Restoring a backup changes fragement type

Thu, 23 Mar 2006 08:46:33 +0000

Bug ID: 18451
Submitted by: Geert Vanderkelen
Category: Server: Cluster
Status: Closed
Severity: 1
Version: 5.1

#18742: Test 'group_min_max' fails if "classic" configuration in 5.0

Mon, 03 Apr 2006 15:05:46 +0000

Bug ID: 18742
Submitted by: Kent Boortz
Category: Server
Status: Closed
Severity: 3
Version: 5.0.21-pre

#18765: query with subquery hangs server.

Tue, 04 Apr 2006 05:00:30 +0000

Bug ID: 18765
Submitted by: peter conza
Category: Server
Status: No Feedback
Severity: 2
OS: server 2003 or winXP
Version: 5.0.19-nt

#19737: Some file modes too restrictive for other-user "make install"

Thu, 11 May 2006 18:36:06 +0000

Bug ID: 19737
Submitted by: Paul DuBois
Category: Server: Installing
Status: Closed
Severity: 3
OS: Unix
Version: 4.0-BK, 4.1-BK, 5.0-BK

#21810: parser bug perhaps?

Thu, 24 Aug 2006 12:29:23 +0000

Bug ID: 21810
Submitted by: d di
Category: Server
Status: Duplicate
Severity: 3
Version: 5.0.22

#21924: func_group test fails in 5.1

Wed, 30 Aug 2006 15:05:46 +0000

Bug ID: 21924
Submitted by: Reggie Burnett
Category: Server: Tests
Status: Duplicate
Severity: 3

#21981: ndbd crashes during CREATE LOGFILE GROUP if compiled with gcc4 (on some platform

Sun, 03 Sep 2006 09:31:01 +0000

Bug ID: 21981
Submitted by: Jonas Oreland
Category: Server: ClusterDD
Status: Closed
Severity: 3

#22965: Feature request: WEIGHTED_AVG

Tue, 03 Oct 2006 23:15:08 +0000

Bug ID: 22965
Submitted by: Jason Miele
Category: Server
Status: Closed
Severity: 4

#23340: Calculate Age Function (days,months and years of age)

Mon, 16 Oct 2006 17:01:40 +0000

Bug ID: 23340
Submitted by: Luis Antonio Castro Henriques
Category: Server
Status: Open
Severity: 4

#25375: The log-level option for the [agent] group is not documented in the manual

Tue, 02 Jan 2007 21:51:36 +0000

Bug ID: 25375
Submitted by: Harrison Fisk
Category: Monitoring: Docs
Status: Closed
Severity: 4
Version: 1.0.0

#26937: Wrong results when using GROUP BY SUBSTRING(..) and LONGTEXT

Wed, 07 Mar 2007 21:46:44 +0000

Bug ID: 26937
Submitted by: Morgan Tocker
Category: Server
Status: Duplicate
Severity: 1
Version: 4.1,5.0,5.1

#26990: Typo in 5.1 Documentation Chapter 13.1.9.

Fri, 09 Mar 2007 09:14:53 +0000

Bug ID: 26990
Submitted by: Manuel Kiessling
Category: Server: Docs
Status: Closed
Severity: 3

#98782: Using TempTable engine for GROUP BY is slower than using MEMORY engine

Fri, 28 Feb 2020 18:57:32 +0000

Bug ID: 98782
Submitted by: Øystein Grøvlen
Category: Server: InnoDB
Status: Can't repeat
Severity: 5
OS: Any
Version: 8.0.19

#91057: GR recovery can retry infinitely if count is modified to lower value on the fly

Tue, 29 May 2018 10:31:19 +0000

Bug ID: 91057
Submitted by: Narendra Singh Chauhan
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7.23

#33266: regression test subselect fails

Sun, 16 Dec 2007 07:33:28 +0000

Bug ID: 33266
Submitted by: Giuseppe Maxia
Category: Server: Tests
Status: Closed
Severity: 7
OS: Any
Version: 5.0.54,5.1.23, 5.1.24-BK, 6.0-BK

#56470: Stop slave at middle of the transaction can cause fatal error

Wed, 01 Sep 2010 19:28:28 +0000

Bug ID: 56470
Submitted by: Serge Kozlov
Category: Server: RBR
Status: No Feedback
Severity: 1
OS: Any
Version: 5.6.99-m5

#17590: Different key-len and # rows reported on all platforms

Mon, 20 Feb 2006 17:44:24 +0000

Bug ID: 17590
Submitted by: Joerg Bruehe
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: Any (All)
Version: 5.1.7-beta

#74095: "MySQL Extensions to GROUP BY" documentation needs update

Fri, 26 Sep 2014 08:04:13 +0000

Bug ID: 74095
Submitted by: Roland Bouman
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: mysql 5.7.5m15

#55453: Agent resends the same example query over and over every 2 minutes

Wed, 21 Jul 2010 18:01:09 +0000

Bug ID: 55453
Submitted by: Diego Medina
Category: Monitoring: Agent
Status: Closed
Severity: 1
OS: Any
Version: 2.2.2.1729

#80660: MySQL could detect functional dependency on group expressions

Tue, 08 Mar 2016 16:38:04 +0000

Bug ID: 80660
Submitted by: Guilhem Bichot
Category: Server: Optimizer
Status: Open
Severity: 4
OS: Any
Version: 5.7

#108118: group replication reconfiguration should not require destroying the group

Thu, 11 Aug 2022 12:22:46 +0000

Bug ID: 108118
Submitted by: Simon Mudd
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 8.0.30

#71199: Optimizer's estimated number of rows is 2 times wrong for (loose?) index scans

Sat, 21 Dec 2013 18:16:34 +0000

Bug ID: 71199
Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.6.14, 5.6.15, 5.5.35

#81388: min/max optimization ignores group by

Thu, 12 May 2016 06:32:21 +0000

Bug ID: 81388
Submitted by: Trey Raymond
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.6.29

#98770: Non-covering full index scan is always preferred over table scan for GROUP BY

Fri, 28 Feb 2020 04:02:57 +0000

Bug ID: 98770
Submitted by: Øystein Grøvlen
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 8.0.19

#114638: ROLLUP misses a summary NULL

Fri, 12 Apr 2024 16:33:24 +0000

Bug ID: 114638
Submitted by: Guilhem Bichot
Category: Server: DML
Status: Closed
Severity: 4
OS: Any
Version: 8.0

#71512: Servers in the same group should use a single user/password

Wed, 29 Jan 2014 15:34:22 +0000

Bug ID: 71512
Submitted by: Alfranio Tavares Correia Junior
Category: MySQL Fabric
Status: Closed
Severity: 3
OS: Any
Version: 1.4.0

#74093: ONLY_FULL_GROUP_BY documentation not up to date

Fri, 26 Sep 2014 07:18:05 +0000

Bug ID: 74093
Submitted by: Roland Bouman
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.7.5m15

#80554: Binlog schema distribution timeout and fails when another mysql node start

Mon, 29 Feb 2016 09:43:22 +0000

Bug ID: 80554
Submitted by: Ole John Aske
Category: Server: Cluster
Status: Closed
Severity: 3
OS: Any
Version: 7.4.11

#103378: sql_mode=only_full_group_by error 1055 is not appear for DELETE and UPDATE

Tue, 20 Apr 2021 03:34:05 +0000

Bug ID: 103378
Submitted by: Nikolai Ikhalainen
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0.23

#30477: Allow returning unordered result from GROUP BY

Fri, 17 Aug 2007 15:12:20 +0000

Bug ID: 30477
Submitted by: Roland Bouman
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: all, or asap

#62053: columns in SELECT clause not affected by group fn must be declared in GROUP BY

Tue, 02 Aug 2011 04:14:50 +0000

Bug ID: 62053
Submitted by: LUIS ANTONIO GAMA MORENO
Category: Server: DML
Status: Not a Bug
Severity: 1
OS: Any
Version: 5.5

#70203: GROUP BY is consistent with ORDER BY in subquery

Fri, 30 Aug 2013 16:38:16 +0000

Bug ID: 70203
Submitted by: Anthony Master
Category: Server: Docs
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.5.32

#71097: Wrong results for a simple query with GROUP BY

Thu, 05 Dec 2013 18:26:35 +0000

Bug ID: 71097
Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.1.70, 5.5.33, 5.5.35, 5.6.14, 5.6.15

#71495: Logging of MTS breakage is insufficient.

Mon, 27 Jan 2014 20:34:07 +0000

Bug ID: 71495
Submitted by: Simon Mudd
Category: Server: Replication
Status: Verified
Severity: 3
OS: Any
Version: 5.6.14

#78183: Similar query with aggregate functions returns inconsistent result

Mon, 24 Aug 2015 09:01:58 +0000

Bug ID: 78183
Submitted by: Su Dylan
Category: Server: DML
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.6.22

#90494: gr_exit_state_action=ABORT_SERVER is not considered on compatibility checks

Wed, 18 Apr 2018 12:04:03 +0000

Bug ID: 90494
Submitted by: Nuno Carvalho
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.12

#97207: MySQL Group Replication Old incarnation

Mon, 14 Oct 2019 01:18:34 +0000

Bug ID: 97207
Submitted by: HULONG CUI
Category: Server: Replication
Status: Verified
Severity: 3
OS: Any
Version: 5.7.26, 5.7.27

#106312: Huge value in GROUP BY clause cause unexpected output

Thu, 27 Jan 2022 18:14:20 +0000

Bug ID: 106312
Submitted by: Yu Liang
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any (Ubuntu 20.04.3 LTS)
Version: 5.7

#106526: Having a group member rejoining a group stalls writes to the group

Mon, 21 Feb 2022 14:12:41 +0000

Bug ID: 106526
Submitted by: Eduardo Ortega
Category: Server: GCS
Status: Verified
Severity: 3
OS: Any
Version: 8.0.27

#118027: Transform MySQL into a Structure-Aware, Flexible, AI-Compatible Engine with Infinite Grouping, Symbolic Linking, and Loc

Tue, 22 Apr 2025 06:43:53 +0000

Bug ID: 118027
Submitted by: Reza Rezaei
Category: Server: Types
Status: Verified
Severity: 4
OS: Any
Version: 10.x (Future Planning / Major Architectu

#57815: There was a problem generating the Support Report for Group "".

Thu, 28 Oct 2010 14:52:46 +0000

Bug ID: 57815
Submitted by: Ulf Wendel
Category: Monitoring: Web
Status: Verified
Severity: 3
OS: Any
Version: 2.3.0.2036

#75287: Python does not work with HASH sahrding in MySQL Fabric

Mon, 22 Dec 2014 13:44:59 +0000

Bug ID: 75287
Submitted by: Ted Wennmark
Category: Connector/Python
Status: Closed
Severity: 1
OS: Any
Version: 2.0

#86957: SETTING gr_force_members HITS ERROR1231 SOMETIMES WHILE UNBLOCKING THE GROUP

Wed, 05 Jul 2017 12:49:50 +0000

Bug ID: 86957
Submitted by: Dhruthi Komarlu Vasudeva Murthy
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7.20

#87834: node joins group even though it is not whitelisted on one of the group member

Fri, 22 Sep 2017 08:00:39 +0000

Bug ID: 87834
Submitted by: Dhruthi Komarlu Vasudeva Murthy
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7.21

#88304: SOMETIMES MEMBERS ENTER IN ERROR STATE AFTER LONG RECOVERY

Tue, 31 Oct 2017 11:16:47 +0000

Bug ID: 88304
Submitted by: Vitor Oliveira
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.3

#89195: Total ordering of transactions is not respected in Group Replication.

Thu, 11 Jan 2018 19:15:36 +0000

Bug ID: 89195
Submitted by: Jean-François Gagné
Category: Server: GCS
Status: Closed
Severity: 2
OS: Any
Version: 5.7.20, 8.0.3

#103869: Duplicate computation of aggregate function when referred in HAVING clause

Mon, 31 May 2021 14:29:10 +0000

Bug ID: 103869
Submitted by: Øystein Grøvlen
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 8.0.24, 8.0.25

#107821: Result error : SQL with group by with rollup and const field

Fri, 08 Jul 2022 18:02:44 +0000

Bug ID: 107821
Submitted by: Ze Yang
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0, 8.0.29

#33655: UDF documentation is unclear on pre-5.0 and 5.0 differences

Thu, 03 Jan 2008 16:06:40 +0000

Bug ID: 33655
Submitted by: Baron Schwartz
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any

#34659: Unexpected error & wrong msg.: 1054: Unknown column '...' in 'having clause'

Tue, 19 Feb 2008 10:36:34 +0000

Bug ID: 34659
Submitted by: Gleb Shchepa
Category: Server: Errors
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.0+

#36798: aggregate functions with columns and aggregate functions works (shouldn't?)

Mon, 19 May 2008 13:05:28 +0000

Bug ID: 36798
Submitted by: Tobias Asplund
Category: Server: Docs
Status: Closed
Severity: 2
OS: Any
Version: 5.1.23/5.1.24

#57833: MEM Dashboard: You must log in to access the requested resource...

Fri, 29 Oct 2010 08:05:00 +0000

Bug ID: 57833
Submitted by: Ulf Wendel
Category: Monitoring: Web
Status: Closed
Severity: 3
OS: Any
Version: 2.3.0.2036

#78534: Different results are coming when ran a same Query in two different applications

Wed, 23 Sep 2015 17:29:51 +0000

Bug ID: 78534
Submitted by: GaneshPandiaraj Subburajan
Category: Server: DML
Status: Can't repeat
Severity: 3
OS: Any

#83136: for libmysql the [client] group may be read twice

Sat, 24 Sep 2016 15:47:03 +0000

Bug ID: 83136
Submitted by: John Fawcett
Category: C API
Status: No Feedback
Severity: 3
OS: Any
Version: 5.7.15

#87474: Slave channels start before group replication starts preventing joins

Fri, 18 Aug 2017 11:07:11 +0000

Bug ID: 87474
Submitted by: Pedro Gomes
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7.20

#89042: START GR HANGS AND WITH THAT NO NEW CONNECTION IS ALLOWED ON THAT SERVER

Sat, 23 Dec 2017 06:47:30 +0000

Bug ID: 89042
Submitted by: Narendra Singh Chauhan
Category: Server: GCS
Status: Closed
Severity: 2
OS: Any
Version: 8.0.5

#90986: Config issue makes server skips own details in ER_GRP_RPL_MEMBER_CHANGE msg

Wed, 23 May 2018 09:40:44 +0000

Bug ID: 90986
Submitted by: Narendra Singh Chauhan
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7.23

#99838: FULL GROUP BY violation insides a subquery

Wed, 10 Jun 2020 08:57:17 +0000

Bug ID: 99838
Submitted by: Yushan ZHANG
Category: Server: Parser
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0.20

#120461: InnoDB Batch Commit for Faster Source and Replica Execution

Tue, 12 May 2026 19:56:29 +0000

Bug ID: 120461
Submitted by: Nuno Carvalho
Category: Server
Status: Open
Severity: 4
OS: Any
Version: 10.x

#4907: feature request - SQL extensions

Thu, 05 Aug 2004 09:23:49 +0000

Bug ID: 4907
Submitted by: Ram Nahtaniel
Category: Server
Status: Closed
Severity: 4
OS: Any (any)
Version: any

#28691: GROUP BY optimization ignores functional dependency on unique/primary key

Fri, 25 May 2007 20:16:34 +0000

Bug ID: 28691
Submitted by: Roland Bouman
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.1.18

#28977: cannot change the group mysqld runs as

Fri, 08 Jun 2007 14:35:59 +0000

Bug ID: 28977
Submitted by: Markus Wernig
Category: Server: General
Status: Not a Bug
Severity: 2
OS: Any
Version: 5.0.37, 5.0.22

#42094: Optimizer chooses a wrong index when group by, order by and limit is present

Tue, 13 Jan 2009 23:01:53 +0000

Bug ID: 42094
Submitted by: Alexander Rubin
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.1

#54515: Crash in opt_range.cc::get_best_group_min_max on SELECT from VIEW with GROUP BY

Tue, 15 Jun 2010 14:14:53 +0000

Bug ID: 54515
Submitted by: John Embretsen
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.5.5-m3-Celosia, 5.6.99-Dahlia, 6.0.14

#55188: GROUP BY, GROUP_CONCAT and TEXT - inconsistent results

Mon, 12 Jul 2010 21:01:46 +0000

Bug ID: 55188
Submitted by: Lig Isler-Turmelle
Category: Server: DML
Status: Closed
Severity: 2
OS: Any
Version: 5.1.46sp1

#56690: Wrong results with subquery with GROUP BY inside < ANY clause

Thu, 09 Sep 2010 13:30:51 +0000

Bug ID: 56690
Submitted by: John Embretsen
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.0, 5.1, 5.5

#62372: Wrong query results with SQL_CALC_FOUND_ROWS, GROUP BY, LIMIT and Using index

Wed, 07 Sep 2011 11:48:09 +0000

Bug ID: 62372
Submitted by: Mateusz Kijowski
Category: Server: DML
Status: Closed
Severity: 3
OS: Any
Version: 5.5.15, 5.5.17

#64454: Routine Groups Can Not Be Resized

Sat, 25 Feb 2012 20:49:08 +0000

Bug ID: 64454
Submitted by: Matthew Kastor
Category: MySQL Workbench: Modeling
Status: Verified
Severity: 4
OS: Any
Version: 5.2.37, 5.2.38

#71191: Loose index scan is used even though full table scan/tight index scan is faster

Fri, 20 Dec 2013 15:30:25 +0000

Bug ID: 71191
Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.5.33

#77508: Update new rpl tests to work with Group Replication

Fri, 26 Jun 2015 14:12:30 +0000

Bug ID: 77508
Submitted by: Nuno Carvalho
Category: Server: Replication
Status: Closed
Severity: 3
OS: Any
Version: 5.7.8

#84587: WL#9236: including or excluding columns from SELECT list makes results wrong

Fri, 20 Jan 2017 13:43:50 +0000

Bug ID: 84587
Submitted by: Guilhem Bichot
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 8.0

#89870: Group by optimization not used with partitioned tables

Thu, 01 Mar 2018 14:21:43 +0000

Bug ID: 89870
Submitted by: Arnaud Adant
Category: Server: Partition
Status: Not a Bug
Severity: 4
OS: Any
Version: 5.7.18

#96579: Unexpected error message when using an outer reference in HAVING

Sun, 18 Aug 2019 19:59:31 +0000

Bug ID: 96579
Submitted by: Igor Babaev
Category: Server: Errors
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.6/5.7/8.0

#102433: Lightweigth group replication consensus member without the full database

Mon, 01 Feb 2021 08:49:04 +0000

Bug ID: 102433
Submitted by: Eduardo Ortega
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 8.0

#104117: MGR all second node abnormal stop

Sat, 26 Jun 2021 02:36:39 +0000

Bug ID: 104117
Submitted by: yongliang lee
Category: Server: GCS
Status: Closed
Severity: 2
OS: Any
Version: mysql8.0.23 mysql8.0.24

#104118: MGR all second node abnormal stop

Sat, 26 Jun 2021 02:42:48 +0000

Bug ID: 104118
Submitted by: peng gao
Category: Server: Privileges
Status: Verified
Severity: 2
OS: Any
Version: 8.0.24

#107559: Why Switch_ref_item_slice in TemptableAggregateIterator::Init

Tue, 14 Jun 2022 08:45:08 +0000

Bug ID: 107559
Submitted by: lou shuai
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any

#113404: Loose Index Scan limitations

Wed, 13 Dec 2023 10:19:35 +0000

Bug ID: 113404
Submitted by: Jinhao Zhan
Category: Server: Optimizer
Status: Can't repeat
Severity: 4
OS: Any
Version: 8.0.22

#113974: improve GR error reporting

Tue, 13 Feb 2024 09:05:47 +0000

Bug ID: 113974
Submitted by: Simon Mudd
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 8.0

#15643: Can't group on calculated field aliased as other field

Fri, 09 Dec 2005 18:42:51 +0000

Bug ID: 15643
Submitted by: Nathan Tanner
Category: Server: Docs
Status: Closed
Severity: 2
OS: Any (All)
Version: 5.0.15/5.0.18 BK/5.0.22

#23462: Group BY and MAX not selecting MAX result

Thu, 19 Oct 2006 13:42:20 +0000

Bug ID: 23462
Submitted by: Joseph Wilk
Category: Server
Status: Not a Bug
Severity: 3
OS: Any
Version: mysql 5.0

#27885: command line clients puke on 'init-command' in my.cnf

Tue, 17 Apr 2007 15:13:46 +0000

Bug ID: 27885
Submitted by: Axel Schwenke
Category: Client
Status: Verified
Severity: 3
OS: Any
Version: 5.0.38

#34751: Inside HAVING clause subqueries with aggregates and without GROUP BY rise error

Thu, 21 Feb 2008 22:19:07 +0000

Bug ID: 34751
Submitted by: Gleb Shchepa
Category: Server: DML
Status: Closed
Severity: 3
OS: Any
Version: 5.0+

#45267: GROUP BY does not group NULLs on certain JOINs

Tue, 02 Jun 2009 13:01:25 +0000

Bug ID: 45267
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.4

#48703: nontrivial ORDER/GROUP BY expressions: ambiguous statements not detected

Wed, 11 Nov 2009 21:58:27 +0000

Bug ID: 48703
Submitted by: Gleb Shchepa
Category: Server: Optimizer
Status: In progress
Severity: 3
OS: Any
Version: 5.0+

#49111: Change in execution plan for count_distinct_group_on_key causes peformance drop

Wed, 25 Nov 2009 20:11:05 +0000

Bug ID: 49111
Submitted by: Alexey Stroganov
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.5.0-beta, 5.1

#51017: Batched key access gives wrong results for SELECT with LEFT JOIN, GROUP BY

Tue, 09 Feb 2010 09:07:18 +0000

Bug ID: 51017
Submitted by: Guilhem Bichot
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 6.0-codebase-bugfixing

#54481: GROUP BY loses effect with JOIN + ORDER BY + LIMIT and join caching

Mon, 14 Jun 2010 11:10:25 +0000

Bug ID: 54481
Submitted by: John Embretsen
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.1-bzr, 5.6.99-m4, mysql-next-mr-opt-backporting

#58782: Missing rows with SELECT .. WHERE .. IN subquery with full GROUP BY and no aggr

Tue, 07 Dec 2010 10:46:32 +0000

Bug ID: 58782
Submitted by: John Embretsen
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: bzr_WL1393

#78349: w/ ONLY_FULL_GROUP_BY, having/order by + column alias have different results

Sun, 06 Sep 2015 12:12:20 +0000

Bug ID: 78349
Submitted by: Su Dylan
Category: Server: DML
Status: Closed
Severity: 3
OS: Any
Version: 5.6.22, 5.6.26

#78402: GROUP BY with expression fails (should succeed)

Fri, 11 Sep 2015 02:23:28 +0000

Bug ID: 78402
Submitted by: Su Dylan
Category: Server: Parser
Status: Duplicate
Severity: 3
OS: Any
Version: 5.6.22

#78424: w/ c1&&c2 appears in select list, group by clause and order by clause, SQL fails

Mon, 14 Sep 2015 02:29:00 +0000

Bug ID: 78424
Submitted by: Su Dylan
Category: Server: DML
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.7.7

#78785: Grouping on aggregated results not always rejected

Fri, 09 Oct 2015 12:54:57 +0000

Bug ID: 78785
Submitted by: Knut Anders Hatlen
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.7.9

#80726: GROUP BY on derived table, expression of aggregate and group column: error

Mon, 14 Mar 2016 10:49:51 +0000

Bug ID: 80726
Submitted by: Guilhem Bichot
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.7

#81760: Rename RealFragment to Partition in Ndb kernel code.

Tue, 07 Jun 2016 20:27:10 +0000

Bug ID: 81760
Submitted by: Mauritz Sundell
Category: Server: Cluster
Status: Closed
Severity: 3
OS: Any
Version: 7.5.2

#87300: mysql-shell dba.checkInstanceConfiguration()

Thu, 03 Aug 2017 10:18:24 +0000

Bug ID: 87300
Submitted by: forthedream for
Category: Server: Shell CLI
Status: Closed
Severity: 2
OS: Any
Version: mysqlsh Ver 1.0.10 for Linux on x86_64

#87670: Force index for group by is not always honored

Tue, 05 Sep 2017 09:32:28 +0000

Bug ID: 87670
Submitted by: Arnaud Adant
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.7.18, 5.6.37, 5.7.19

#89147: The field end_log_pos in Group Replication error messages is ambiguous.

Mon, 08 Jan 2018 22:18:18 +0000

Bug ID: 89147
Submitted by: Jean-François Gagné
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 5.7.20,8.0.3

#91870: ALL MEMBERS ARE EXITED FROM GR WHEN 1/4 NODE TRIED TO REJOIN AFTER network drop

Thu, 02 Aug 2018 11:33:13 +0000

Bug ID: 91870
Submitted by: Ramana Yeruva
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.13

#99778: Error when processing certification information in the incremental recovery proc

Thu, 04 Jun 2020 12:27:43 +0000

Bug ID: 99778
Submitted by: Snehal Bhavsar
Category: Server: GCS
Status: Closed
Severity: 2
OS: Any
Version: 8.0.18

#101391: Performance Schema storage engine doesn't use index optimizations on group by

Fri, 30 Oct 2020 03:04:01 +0000

Bug ID: 101391
Submitted by: Agustín G
Category: Server: Performance Schema
Status: Verified
Severity: 5
OS: Any
Version: 8.0, 8.0.22

#102945: MTS fail due to ignore stop event when logical timestamp reset on new binary fil

Fri, 12 Mar 2021 08:04:02 +0000

Bug ID: 102945
Submitted by: Ray Jung
Category: Server: Replication
Status: Verified
Severity: 3
OS: Any
Version: mysql.5.7

#103766: please document external (network) protocol used by group replication

Fri, 21 May 2021 11:35:27 +0000

Bug ID: 103766
Submitted by: Simon Mudd
Category: Server: Docs
Status: Verified
Severity: 4
OS: Any
Version: 8.0

#108417: Innodb cluster failed after primary removed

Wed, 07 Sep 2022 15:27:38 +0000

Bug ID: 108417
Submitted by: Jay Janssen
Category: Server: GCS
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0.30

#110888: checkInstanceConfiguration and docs disagree on binlog_transaction_dependency_tr

Tue, 02 May 2023 18:51:10 +0000

Bug ID: 110888
Submitted by: Marcos Albe
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 8.0.31

#112193: All nodes elected as PRIMARY

Mon, 28 Aug 2023 03:07:22 +0000

Bug ID: 112193
Submitted by: zetang zeng
Category: Server: ClusterNDB
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.7

#114248: Incomplete query results when backward scan and concurrent page merge

Wed, 06 Mar 2024 16:22:40 +0000

Bug ID: 114248
Submitted by: Dmitry Lenev
Category: Server: InnoDB
Status: Verified
Severity: 3
OS: Any
Version: 8.0.36, 5.7.44

#115087: SSL connection server_capabilities has overflow

Thu, 23 May 2024 03:10:47 +0000

Bug ID: 115087
Submitted by: peng gao
Category: Server: GCS
Status: Verified
Severity: 3
OS: Any
Version: 8.0.36

#20293: group by cuts off value from time_format

Tue, 06 Jun 2006 13:12:32 +0000

Bug ID: 20293
Submitted by: Martin Friebe
Category: Server
Status: Closed
Severity: 2
OS: Any (*)
Version: 4.1-BK, 5.0-BK, 4.1.20 and 5.0.22

#24860: Incorrect SLAVE_TRANSACTION_RETRIES code can result in slave stuck

Wed, 06 Dec 2006 18:17:12 +0000

Bug ID: 24860
Submitted by: Rafal Somla
Category: Server: Replication
Status: Closed
Severity: 3
OS: Any
Version: 5.1.12

#28449: Server crashes on closing a temporary table after SELECT ... GROUP BY

Tue, 15 May 2007 15:50:30 +0000

Bug ID: 28449
Submitted by: Alexey Kopytov
Category: Server: General
Status: Closed
Severity: 2
OS: Any
Version: 5.0, 5.1.19

#29360: SELECT aggregate function GROUP BY enum returns incorrect result

Tue, 26 Jun 2007 13:49:59 +0000

Bug ID: 29360
Submitted by: Gleb Shchepa
Category: Server
Status: Closed
Severity: 3
OS: Any
Version: 4.1, 5.0, 5.1

#29421: MySQL allows mixing of GROUP columns with no GROUP columns in complex terms

Thu, 28 Jun 2007 13:43:41 +0000

Bug ID: 29421
Submitted by: Szymon Nowakowski
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.1.14-beta/5.0

#30039: Add "Using group-by" to Extra column in EXPLAIN output

Wed, 25 Jul 2007 13:35:13 +0000

Bug ID: 30039
Submitted by: Baron Schwartz
Category: Server: DML
Status: Verified
Severity: 4
OS: Any

#30612: Rename "remove all from group" to "delete group"

Fri, 24 Aug 2007 00:42:54 +0000

Bug ID: 30612
Submitted by: Gary Whizin
Category: Monitoring: Web
Status: Closed
Severity: 3
OS: Any
Version: 1.2.0.7214

#31559: "group by" changed the implicit ordering

Fri, 12 Oct 2007 09:23:40 +0000

Bug ID: 31559
Submitted by: Joerg Bruehe
Category: Server: Tests
Status: Closed
Severity: 7
OS: Any
Version: 5.0.50

#33170: New CREATE TABLESPACE behavoir with Falcon

Wed, 12 Dec 2007 15:45:03 +0000

Bug ID: 33170
Submitted by: Philip Stoev
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 6.0.5

#35628: 5.0.52+ undocumented incompatible change in default GROUP BY behavior

Fri, 28 Mar 2008 01:41:28 +0000

Bug ID: 35628
Submitted by: Sean Pringle
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.0.52

#37344: Crash in IndexWalker::rebalanceDelete

Wed, 11 Jun 2008 13:59:42 +0000

Bug ID: 37344
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Closed
Severity: 1
OS: Any
Version: 6.0-falcon

#37362: Crash in do_field_eq

Thu, 12 Jun 2008 11:30:59 +0000

Bug ID: 37362
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 6.0-falcon, 5.0, 5.1, 6.0 bzr

#45504: Support batch add-to-group on Manager servers' tab

Mon, 15 Jun 2009 15:11:27 +0000

Bug ID: 45504
Submitted by: Diego Medina
Category: Monitoring: Web
Status: Closed
Severity: 4
OS: Any
Version: 2.1.0.1060

#45940: issues around rli->last_event_start_time

Fri, 03 Jul 2009 14:58:09 +0000

Bug ID: 45940
Submitted by: Andrei Elkin
Category: Server: Replication
Status: Closed
Severity: 3
OS: Any
Version: 5.1+

#46328: Use of aggregate function without GROUP BY clause returns many rows (vs. one )

Tue, 21 Jul 2009 20:54:12 +0000

Bug ID: 46328
Submitted by: Patrick Crews
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 6.0

#48089: Can't change UNDO_BUFFER_SIZE with ALTER LOGFILE GROUP ...

Thu, 15 Oct 2009 15:41:29 +0000

Bug ID: 48089
Submitted by: Hartmut Holzgraefe
Category: Server: ClusterDD
Status: In progress
Severity: 3
OS: Any
Version: mysql-5.1-telco-7.0

#48472: Loose index scan inappropriately chosen for some WHERE conditions

Mon, 02 Nov 2009 13:39:03 +0000

Bug ID: 48472
Submitted by: Alexey Kopytov
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.0.88, 5.1.41

#58218: "Key" groupped by cannot be used in linq2e, group by subquery cannot be executed

Tue, 16 Nov 2010 07:23:40 +0000

Bug ID: 58218
Submitted by: Whikiey Yan
Category: Connector/Net
Status: Duplicate
Severity: 1
OS: Any
Version: 6.3.4

#64855: Stored Procedure with GROUP/ORDER BY return unpredicatable results with CASE/IF

Tue, 03 Apr 2012 14:53:06 +0000

Bug ID: 64855
Submitted by: Patrick Mulvany
Category: Server: SP
Status: Verified
Severity: 2
OS: Any
Version: 5.5.21, 5.6.5-m8, 5.1.64, 5.6.6, 5.5.25, 5.5.20-ndb-7.2.5

#65798: ONLY_FULL_GROUP_BY documentation doesn't mention implicit group by

Tue, 03 Jul 2012 15:16:44 +0000

Bug ID: 65798
Submitted by: Raghavendra Prabhu
Category: Server: DML
Status: Closed
Severity: 3
OS: Any
Version: 5.5.26

#71125: A server must belong to a single group

Wed, 11 Dec 2013 08:38:31 +0000

Bug ID: 71125
Submitted by: Mats Kindahl
Category: MySQL Fabric
Status: Closed
Severity: 3
OS: Any
Version: 1.4.0

#71149: Assertion `((Item_result_field*)item)->result_field' fails in create_tmp_field

Mon, 16 Dec 2013 09:37:02 +0000

Bug ID: 71149
Submitted by: Elena Stepanova
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.6.15, 5.7.3-m13

#71762: Allow the agent installer to hint at the replication group name

Tue, 18 Feb 2014 15:51:31 +0000

Bug ID: 71762
Submitted by: Simon Mudd
Category: Monitoring: Install
Status: Verified
Severity: 4
OS: Any
Version: 3.0.6

#71891: GROUP BY performance differs wildly for tautologically equal columns

Fri, 28 Feb 2014 20:27:58 +0000

Bug ID: 71891
Submitted by: Doug Cook
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.6.15

#76319: MySQL Fabric Service - Monitoring from external monitoring software

Fri, 13 Mar 2015 19:36:57 +0000

Bug ID: 76319
Submitted by: SASTRY VEDANTAM
Category: MySQL Fabric
Status: Won't fix
Severity: 4
OS: Any
Version: 1.5

#81494: mysqldump can't get all databases backup with Group Replication

Thu, 19 May 2016 03:22:32 +0000

Bug ID: 81494
Submitted by: Yoshiaki Yamasaki
Category: Client: mysqldump
Status: Closed
Severity: 4
OS: Any
Version: 5.7.10, 5.7.17

#83142: Documentation clarifications about how default option files are used

Sun, 25 Sep 2016 18:38:59 +0000

Bug ID: 83142
Submitted by: John Fawcett
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.7.15

#84008: GR+MTS: ER1755 can be improved for MTS LC -> MTS DATABASE

Tue, 29 Nov 2016 18:24:12 +0000

Bug ID: 84008
Submitted by: Narendra Singh Chauhan
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.1

#85164: GR SHOULD BLOCK OPERATIONS ON NON-COMPLAINT TABLES IN GR+ASYNC SETUP

Fri, 24 Feb 2017 09:31:44 +0000

Bug ID: 85164
Submitted by: Dhruthi Komarlu Vasudeva Murthy
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7.18

#86475: Error with functions and group by with ONLY_FULL_GROUP_BY

Fri, 26 May 2017 10:51:10 +0000

Bug ID: 86475
Submitted by: Arnaud Adant
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 5.7.18

#86956: Joining group timeout on permissions error

Wed, 05 Jul 2017 12:04:00 +0000

Bug ID: 86956
Submitted by: Jervin R
Category: Server: GCS
Status: Verified
Severity: 3
OS: Any
Version: 5.7.18

#88717: MySQL Group Replication Large Transactions Limit

Thu, 30 Nov 2017 14:10:09 +0000

Bug ID: 88717
Submitted by: Hugo Dubois
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.7.19

#89141: Error in Group Replication caused by bad Write Set tracking.

Mon, 08 Jan 2018 22:07:31 +0000

Bug ID: 89141
Submitted by: Jean-François Gagné
Category: Server: GCS
Status: Duplicate
Severity: 2
OS: Any
Version: 5.7.20,8.0.3

#89148: The timestamp of the GITD events in the GR relay log look wrong.

Mon, 08 Jan 2018 22:23:32 +0000

Bug ID: 89148
Submitted by: Jean-François Gagné
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 5.7.20 and 8.0.3

#89404: inconsistent support of CIDR or subnet notation

Thu, 25 Jan 2018 11:51:03 +0000

Bug ID: 89404
Submitted by: Geert Vanderkelen
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 8.0.4

#90217: Add IPv6 support for Group Replication

Mon, 26 Mar 2018 15:07:33 +0000

Bug ID: 90217
Submitted by: Artem Danilov
Category: Server: GCS
Status: Closed
Severity: 1
OS: Any
Version: 8.0

#94429: MySQL 5.7 lowest member version join check should be with group lowest

Thu, 21 Feb 2019 18:00:37 +0000

Bug ID: 94429
Submitted by: Jaideep Karande
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7.26

#95068: Group Replication does not support SSL wildcard certificates

Sat, 20 Apr 2019 04:22:04 +0000

Bug ID: 95068
Submitted by: Andrew Garner
Category: Server: GCS
Status: Closed
Severity: 4
OS: Any
Version: 8.0.15

#100764: Rename Table causes other SQL execution plans to change.

Tue, 08 Sep 2020 08:50:24 +0000

Bug ID: 100764
Submitted by: kfpanda kf
Category: Server: Optimizer
Status: No Feedback
Severity: 1
OS: Any
Version: 8.0

#102706: Update group replication docs replication configuration requirements

Tue, 23 Feb 2021 15:02:00 +0000

Bug ID: 102706
Submitted by: Eduardo Ortega
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 8.0.21, 8.0.23

#106430: Timeout on wait for view after joining group

Thu, 10 Feb 2022 08:41:47 +0000

Bug ID: 106430
Submitted by: yashar ne
Category: Server: GCS
Status: Can't repeat
Severity: 3
OS: Any (OKD)

#107460: SKIP SCAN result wrong

Thu, 02 Jun 2022 08:07:23 +0000

Bug ID: 107460
Submitted by: Ze Yang
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 8.0

#107635: event scheduler cause error on group replication

Wed, 22 Jun 2022 14:47:38 +0000

Bug ID: 107635
Submitted by: lou shuai
Category: Server: GCS
Status: Closed
Severity: 1
OS: Any
Version: 8.0.*

#109034: Slow log Rows_examined value is inaccurate

Wed, 09 Nov 2022 04:15:37 +0000

Bug ID: 109034
Submitted by: peng gao
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any
Version: 8.0

#109580: Timeout on wait for view after joining group

Wed, 11 Jan 2023 08:02:21 +0000

Bug ID: 109580
Submitted by: zetang zeng
Category: Server: GCS
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.7.40

#109615: Timeout on wait for view after joining group

Fri, 13 Jan 2023 07:14:49 +0000

Bug ID: 109615
Submitted by: zetang zeng
Category: Server: GCS
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.7.40

#110773: group_replication start faild use different ips and same port on same server

Sun, 23 Apr 2023 07:56:03 +0000

Bug ID: 110773
Submitted by: chao wang
Category: Server: GCS
Status: Verified
Severity: 3
OS: Any
Version: mysql 8.0.32

#115679: Block Nested-Loops Join can sometimes slow down the query

Wed, 24 Jul 2024 09:04:11 +0000

Bug ID: 115679
Submitted by: hongjun xiao
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 8.0.37

#117927: duplicate key in table while using tmp table for group by a json data

Thu, 10 Apr 2025 06:25:28 +0000

Bug ID: 117927
Submitted by: Jinyou Ma
Category: Server: JSON
Status: Verified
Severity: 2
OS: Any
Version: 8.0.41, 8.4

#119584: The HAVING clause cannot recognize alias columns defined by Boolean expressions in derived tables

Mon, 22 Dec 2025 16:09:27 +0000

Bug ID: 119584
Submitted by: b a
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.44

#119674: Doc: Group Replication “write set” definition is unclear/misleading (group-replication-summary)

Wed, 14 Jan 2026 05:25:32 +0000

Bug ID: 119674
Submitted by: Balkrishna Basisthnarayan
Category: Server: GCS
Status: Open
Severity: 3
OS: Any
Version: 9.2

#2467: Use of an alias in a 'group by function'?

Wed, 21 Jan 2004 01:56:08 +0000

Bug ID: 2467
Submitted by: Sébastien Vanvelthem
Category: Server
Status: No Feedback
Severity: 4
OS: Any (All)
Version: 4.0.17

#4402: Equivalence is not considered in group by and order by

Sun, 04 Jul 2004 08:21:16 +0000

Bug ID: 4402
Submitted by: Peter Zaitsev
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (all)
Version: 4.1, 5.1.28, 6.0.6

#4463: GROUP takes the first-found values

Thu, 08 Jul 2004 15:01:28 +0000

Bug ID: 4463
Submitted by: Mr. Venom
Category: Server: Replication
Status: Not a Bug
Severity: 4
OS: Any (doesn't matter)
Version: <4.1

#5029: mysql command to be able to use different configuration groups

Fri, 13 Aug 2004 11:49:38 +0000

Bug ID: 5029
Submitted by: alain williams
Category: Client
Status: Closed
Severity: 4
OS: Any (all)
Version: all

#8614: distinct sometimes ignored with group by "CONST"

Sat, 19 Feb 2005 00:53:02 +0000

Bug ID: 8614
Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any (*)
Version: 4.1.10

#10005: RFE - security patch, to prevent plaintext passwords in config files from leaki

Tue, 19 Apr 2005 17:40:10 +0000

Bug ID: 10005
Submitted by: R Herrold
Category: Eventum
Status: Closed
Severity: 3
OS: Any (All)
Version: current

#12803: selecting a consistent row of aggrigate data during a group

Thu, 25 Aug 2005 13:24:51 +0000

Bug ID: 12803
Submitted by: Are you mortal Then prepare to die.
Category: Server
Status: Closed
Severity: 4
OS: Any (all)
Version: next

#15131: On-disk temporary tables created for GROUP BY should use indexes

Tue, 22 Nov 2005 11:44:08 +0000

Bug ID: 15131
Submitted by: Domas Mituzas
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 4.1,5.0

#20536: md5() with GROUP BY and UCS2 return different results on myisam/innodb

Mon, 19 Jun 2006 13:36:34 +0000

Bug ID: 20536
Submitted by: Shane Bester
Category: Server: Charsets
Status: Closed
Severity: 3
OS: Any (*)
Version: 5.0.23BK, 4.1

#23171: Illegal slave restart (group) position

Wed, 11 Oct 2006 10:09:55 +0000

Bug ID: 23171
Submitted by: Lars Thalmann
Category: Server: Replication
Status: Closed
Severity: 3
OS: Any
Version: 5.1

#29017: Problem with subqueries and GROUP BY

Mon, 11 Jun 2007 11:43:12 +0000

Bug ID: 29017
Submitted by: Liesbeth Lyssens
Category: Server
Status: Can't repeat
Severity: 2
OS: Any
Version: 5.0.41

#29209: Loose index scan is not used if key parts are in different order in the GROUP BY

Tue, 19 Jun 2007 12:54:10 +0000

Bug ID: 29209
Submitted by: Sergey Petrunya
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.0.44/5.1BK

#29285: --log-slow-queries + --log-queries-not-using-indexes works incorrect

Thu, 21 Jun 2007 20:32:02 +0000

Bug ID: 29285
Submitted by: Valeriy Kravchuk
Category: Server
Status: Not a Bug
Severity: 1
OS: Any ((Linux, Windows))
Version: 5.0.36, 5.0.37, 5.0.60

#30219: GROUP BY with DISTINCT broken with BIT type in MyISAM in many cases

Fri, 03 Aug 2007 03:40:29 +0000

Bug ID: 30219
Submitted by: Jeremy Cole
Category: Server: MyISAM
Status: Closed
Severity: 2
OS: Any
Version: 5.0 (all)

#30596: GROUP BY optimization gives wrong result order

Thu, 23 Aug 2007 14:07:31 +0000

Bug ID: 30596
Submitted by: Martin Hansson
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any

#33193: group name is not displayed

Thu, 13 Dec 2007 02:15:55 +0000

Bug ID: 33193
Submitted by: Mikiya Okuno
Category: Monitoring: Web
Status: Closed
Severity: 2
OS: Any
Version: 1.3.0.8528

#34620: item_row.cc:50: Item_row::illegal_method_call(const char*): Assertion `0' failed

Sat, 16 Feb 2008 17:16:48 +0000

Bug ID: 34620
Submitted by: Gleb Shchepa
Category: Server: DML
Status: Closed
Severity: 3
OS: Any
Version: 5.0+, 5.0.58-BK

#37851: Crash in test_if_skip_sort_order tab->select is zero

Thu, 03 Jul 2008 20:20:05 +0000

Bug ID: 37851
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 6.0

#37868: Crash in test_if_skip_sort_order, bad value for used_key_parts

Fri, 04 Jul 2008 11:42:18 +0000

Bug ID: 37868
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Duplicate
Severity: 1
OS: Any
Version: 6.0

#37977: Wrong result returned on GROUP BY + OR + Innodb

Tue, 08 Jul 2008 20:38:23 +0000

Bug ID: 37977
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 6.0

#38862: Usability: Drag/Drop options for routines - routine groups

Mon, 18 Aug 2008 15:34:53 +0000

Bug ID: 38862
Submitted by: Roland Bouman
Category: MySQL Workbench
Status: Verified
Severity: 4
OS: Any
Version: 5.0.24

#39455: Would be useful to ORDER BY arithmetic expressions on GROUP BY columns

Mon, 15 Sep 2008 15:01:22 +0000

Bug ID: 39455
Submitted by: Chris Wilson
Category: Server: Parser
Status: Verified
Severity: 4
OS: Any
Version: 5.0.51a-3ubuntu5.1

#39905: Incorrect result with HAVING and no GROUP BY

Tue, 07 Oct 2008 10:43:27 +0000

Bug ID: 39905
Submitted by: michael last name
Category: Server: InnoDB
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.0

#43342: FORCE INDEX hint does not differentiate between ORDER BY and GROUP BY

Tue, 03 Mar 2009 21:54:37 +0000

Bug ID: 43342
Submitted by: Igor Babaev
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.1, 6.0

#45224: SELECT col_1 WHERE column(s) IN (subquery) AND condition GROUP BY col_n fails

Sun, 31 May 2009 22:34:36 +0000

Bug ID: 45224
Submitted by: Patrick Crews
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.4

#45226: extra rows returned for queries using IN,GROUP BY and HAVING clauses

Sun, 31 May 2009 22:42:34 +0000

Bug ID: 45226
Submitted by: Patrick Crews
Category: Server: Optimizer
Status: No Feedback
Severity: 3
OS: Any
Version: 5.4

#45228: Queries with WHERE AND GROUP BY produce bad results

Sun, 31 May 2009 22:56:40 +0000

Bug ID: 45228
Submitted by: Patrick Crews
Category: Server: Optimizer
Status: No Feedback
Severity: 3
OS: Any
Version: 5.4

#45738: routine object is deleted when its code is removed from routine-groups code

Thu, 25 Jun 2009 08:41:48 +0000

Bug ID: 45738
Submitted by: Johannes Taxacher
Category: MySQL Workbench
Status: Won't fix
Severity: 3
OS: Any
Version: 5.1.14

#46567: Aggregate function documentation needs clarification for non-GROUP BY behavior

Wed, 05 Aug 2009 14:24:03 +0000

Bug ID: 46567
Submitted by: Patrick Crews
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.0, 5.1, 5.4/6.0

#48118: Server processing HAVING clauses incorrectly without a LIMIT clause

Fri, 16 Oct 2009 14:22:44 +0000

Bug ID: 48118
Submitted by: Patrick Crews
Category: Server: Optimizer
Status: Duplicate
Severity: 3
OS: Any
Version: 5.1, 6.0

#49630: Segfault in select_describe() with double nested subquery and materialization

Fri, 11 Dec 2009 16:30:41 +0000

Bug ID: 49630
Submitted by: Patrick Crews
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 6.0

#50916: Trying to remove a server that has QUAN inventory, but purged data, fails

Thu, 04 Feb 2010 15:14:56 +0000

Bug ID: 50916
Submitted by: Mark Leith
Category: Monitoring: Server
Status: Closed
Severity: 3
OS: Any
Version: 2.1.1.1138

#52081: Index hint/forcing for GROUP BY / ORDER BY is broken

Tue, 16 Mar 2010 08:38:57 +0000

Bug ID: 52081
Submitted by: Ole John Aske
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.1.41, 5.1.44, 5.6.99

#53161: Left join optimized into join leads to incorrect results

Mon, 26 Apr 2010 13:12:19 +0000

Bug ID: 53161
Submitted by: Adam Trotter
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.1.37, 5.1.46, 5.1.47

#59557: MySQL uses order of fields in GROUP BY when ORDER BY NULL is specified

Mon, 17 Jan 2011 15:26:08 +0000

Bug ID: 59557
Submitted by: Shlomo Priymak
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.1, 5.5

#59831: ndbinfo - counters not increasing after first query

Mon, 31 Jan 2011 06:06:59 +0000

Bug ID: 59831
Submitted by: John David Duncan
Category: Server: Cluster
Status: Closed
Severity: 3
OS: Any
Version: 7.1.6

#60808: Duplicate entry for key 'group_key'; Can't write, duplicate key in table

Fri, 08 Apr 2011 15:06:21 +0000

Bug ID: 60808
Submitted by: Thomas Mayer
Category: Server: General
Status: Duplicate
Severity: 2
OS: Any (win7 64bit, ubuntu 10.04 64 bit)
Version: 5.5.11, 5.1.54, 5.1.41

#62712: RPM-based install of the test suite is useless for non-root users.

Thu, 13 Oct 2011 00:54:08 +0000

Bug ID: 62712
Submitted by: Davi Arnaut
Category: Tools: MTR / mysql-test-run
Status: Closed
Severity: 7
OS: Any
Version: 5.5.17

#67978: Signed zero is handled incorrectly by HASH indexes and GROUP BY

Thu, 27 Dec 2012 06:13:53 +0000

Bug ID: 67978
Submitted by: Alexey Kopytov
Category: Server: Memory
Status: Verified
Severity: 3
OS: Any
Version: 5.1, 5.5, 5.6

#69268: LEFT JOIN plus GROUP BY incorrectly returns NULL

Fri, 17 May 2013 14:51:13 +0000

Bug ID: 69268
Submitted by: Scott Noyes
Category: Server: Optimizer
Status: Duplicate
Severity: 2
OS: Any
Version: 5.6

#71844: option to join FAULTY MySQL instance back into group

Wed, 26 Feb 2014 13:31:28 +0000

Bug ID: 71844
Submitted by: Ted Wennmark
Category: MySQL Fabric
Status: Closed
Severity: 4
OS: Any
Version: 1.4.1

#72281: mysqlfabric group promote may break replication

Wed, 09 Apr 2014 00:02:31 +0000

Bug ID: 72281
Submitted by: Fernando Ipar
Category: MySQL Fabric
Status: Won't fix
Severity: 3
OS: Any

#73066: Replication stall with multi-threaded replication

Fri, 20 Jun 2014 15:45:18 +0000

Bug ID: 73066
Submitted by: Ovais Tariq
Category: Server: Replication
Status: Closed
Severity: 2
OS: Any
Version: 5.6.17

#73582: Documentation says group commit for the binary log works only if sync_binlog=0

Thu, 14 Aug 2014 12:18:19 +0000

Bug ID: 73582
Submitted by: Przemyslaw Malkowski
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.6 5.7

#74415: Advisor doesn't use the correct thresholds

Thu, 16 Oct 2014 07:34:44 +0000

Bug ID: 74415
Submitted by: Daniël van Eeden
Category: Monitoring: Advisors/Rules
Status: Can't repeat
Severity: 3
OS: Any
Version: 3.0.14

#74859: Assertion `scale >= 0 && precision > 0 && scale <= precision' failed

Fri, 14 Nov 2014 09:50:26 +0000

Bug ID: 74859
Submitted by: Roel Van de Paar
Category: Server: DML
Status: Closed
Severity: 6
OS: Any
Version: 5.6.20, 5.6.23, 5.7.6

#76501: "select + distinct + group by " works incorrectly

Fri, 27 Mar 2015 06:50:29 +0000

Bug ID: 76501
Submitted by: Su Dylan
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.6.22

#77006: 5.6 incompatible change in DELETE/SELECT ... WHERE NOT IN (subquery)

Mon, 11 May 2015 21:03:49 +0000

Bug ID: 77006
Submitted by: Sveta Smirnova
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: Any
Version: 5.6.24, 5.6.26, 5.6.10, 5.7.8

#77742: join query returns in-correct result

Wed, 15 Jul 2015 22:02:44 +0000

Bug ID: 77742
Submitted by: Son Nguyen
Category: Server
Status: No Feedback
Severity: 2
OS: Any
Version: 5.7.7

#78417: Valid select with expression in group by under "only_full_group_by" fails

Sat, 12 Sep 2015 09:48:47 +0000

Bug ID: 78417
Submitted by: Su Dylan
Category: Server: Optimizer
Status: Won't fix
Severity: 3
OS: Any
Version: 5.6.22

#79100: MySQL Manual does not explain when ORDER BY NULL does NOT prevent filesort

Tue, 03 Nov 2015 17:01:10 +0000

Bug ID: 79100
Submitted by: Valeriy Kravchuk
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: any, 5.5, 5.6, 5.7

#80604: The command line doesn't show the full status of a group

Thu, 03 Mar 2016 12:36:17 +0000

Bug ID: 80604
Submitted by: James Bewley
Category: MySQL Fabric: CLI
Status: Won't fix
Severity: 4
OS: Any
Version: 1.5.6

#80682: Inconsistent behavior with GROUP BY alias, w/ different sequence in select list

Thu, 10 Mar 2016 08:44:24 +0000

Bug ID: 80682
Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8, 5.7.11

#81910: WRITE SET HASHES SHOULD HAVE A 64BITS OPTION TO REDUCE WRITE CONFLICTS

Fri, 17 Jun 2016 16:35:43 +0000

Bug ID: 81910
Submitted by: Pedro Gomes
Category: Server: Replication
Status: Closed
Severity: 3
OS: Any
Version: 5.7.14

#82544: Duplicate entry '' for key '' while doing group by

Thu, 11 Aug 2016 14:36:51 +0000

Bug ID: 82544
Submitted by: Shahriyar Rzayev
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.7.14

#84337: Configure mgr with out root user encounter an error

Mon, 26 Dec 2016 08:50:07 +0000

Bug ID: 84337
Submitted by: ruiaylin lin
Category: Server: GCS
Status: Closed
Severity: 2
OS: Any
Version: mysql 5.7.17

#84631: Group Replication Installation Documentation

Tue, 24 Jan 2017 01:38:02 +0000

Bug ID: 84631
Submitted by: Kenny Gryp
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.7

#85026: GROUP MEMBERS BECOMES 'UNREACHABLE' WHEN SERVER WITH LOWER VERSION TRIES TO JOIN

Thu, 16 Feb 2017 17:43:53 +0000

Bug ID: 85026
Submitted by: Dhruthi Komarlu Vasudeva Murthy
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.1

#85047: Secondaries allows transactions through ASYNC setup into the group

Fri, 17 Feb 2017 11:03:17 +0000

Bug ID: 85047
Submitted by: Narendra Singh Chauhan
Category: Server: GCS
Status: Closed
Severity: 2
OS: Any
Version: 5.7.18

#85977: The doc. of slave-parallel-type=LOGICAL_CLOCK wrongly reference Group Commit.

Tue, 18 Apr 2017 02:02:36 +0000

Bug ID: 85977
Submitted by: Jean-François Gagné
Category: Server: Docs
Status: Verified
Severity: 3
OS: Any
Version: 5.7 and 8.0

#86047: FROM sub query with 'group by' is cached by mistake

Sun, 23 Apr 2017 07:58:10 +0000

Bug ID: 86047
Submitted by: Meiji Kimura
Category: Server: Query Cache
Status: Closed
Severity: 2
OS: Any
Version: 5.6,5.7,8.0, 5.6.36

#86359: Avoid setting group_replication_force_members in a partition that holds majority

Wed, 17 May 2017 14:53:21 +0000

Bug ID: 86359
Submitted by: Tiago Jorge
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7.18

#89194: Wrong certification lead to data inconsistency and GR breakage.

Thu, 11 Jan 2018 19:14:41 +0000

Bug ID: 89194
Submitted by: Jean-François Gagné
Category: Server: GCS
Status: Duplicate
Severity: 2
OS: Any
Version: 5.7.20, 8.0.3

#90553: group replication installation docs lead to errors in the logs

Sat, 21 Apr 2018 10:46:35 +0000

Bug ID: 90553
Submitted by: Giuseppe Maxia
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 8.0.11

#91151: Add a Learner/Observer role to leverage it in WAN setup

Tue, 05 Jun 2018 17:12:57 +0000

Bug ID: 91151
Submitted by: Artem Danilov
Category: Server: GCS
Status: Verified
Severity: 3
OS: Any
Version: 8.0.11

#91254: mysqlpump doesn't read "mysqlpump" group from option files

Thu, 14 Jun 2018 11:49:35 +0000

Bug ID: 91254
Submitted by: Mikiya Okuno
Category: Client: mysqlpump
Status: Duplicate
Severity: 3
OS: Any
Version: 8.0.11

#91386: Index for group-by is not used with primary key for SELECT COUNT(DISTINCT a)

Sun, 24 Jun 2018 00:30:51 +0000

Bug ID: 91386
Submitted by: monty solomon
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 5.7.18

#91433: when a member goes to ERROR, other members see it UNREACHABLE

Wed, 27 Jun 2018 08:12:57 +0000

Bug ID: 91433
Submitted by: Dhruthi Komarlu Vasudeva Murthy
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.13-wl11570

#92210: Mysql initilize replication component failed

Tue, 28 Aug 2018 12:01:54 +0000

Bug ID: 92210
Submitted by: Pin Lin
Category: Server: Replication
Status: Can't repeat
Severity: 2
OS: Any
Version: 5.7.23

#93347: VIEW_CHANGE_LOG_EVENT may not be logged on a overloaded primary

Mon, 26 Nov 2018 14:56:37 +0000

Bug ID: 93347
Submitted by: Nuno Carvalho
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7

#94754: Error getting group, by name, in native pattern class

Fri, 22 Mar 2019 15:11:54 +0000

Bug ID: 94754
Submitted by: Marco G
Category: Connector/J
Status: No Feedback
Severity: 3
OS: Any
Version: 8.0.15

#98533: createCluster and addInstance result in group_replication plugin errors in log

Mon, 10 Feb 2020 12:26:51 +0000

Bug ID: 98533
Submitted by: Sergey Kuzmichev
Category: Server: Shell IDC
Status: Closed
Severity: 3
OS: Any
Version: 8.0.19

#99931: Aggregate group by returns incorrect result when loose index scan is used

Thu, 18 Jun 2020 19:41:39 +0000

Bug ID: 99931
Submitted by: Bart Dubelaar
Category: Server: DML
Status: Closed
Severity: 2
OS: Any
Version: 8.0.12, 8.0.18

#100395: No error reports on aggregates without group-by with ONLY_FULL_GROUP_BY sql_mode

Fri, 31 Jul 2020 06:41:49 +0000

Bug ID: 100395
Submitted by: Hubery Lu
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0.13, 8.0.18, 8.0.21, 5.7.31

#100734: Select with group by returns different results

Thu, 03 Sep 2020 17:19:55 +0000

Bug ID: 100734
Submitted by: Ross Barbieri
Category: Server: DML
Status: No Feedback
Severity: 3
OS: Any (Tried on windows, mac, centos)
Version: 8.021

#100985: Stored value for 0.001 is inconsistent, and casted to decimal is also different

Tue, 29 Sep 2020 07:42:50 +0000

Bug ID: 100985
Submitted by: Yushan ZHANG
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.21, 5.7.31, 5.6.48

#102515: Group replication member remains ONLINE even when it gets (far) behind

Sun, 07 Feb 2021 11:03:54 +0000

Bug ID: 102515
Submitted by: Matthias Crauwels
Category: Server: GCS
Status: Verified
Severity: 2
OS: Any
Version: 8.0.23

#103930: Result mismatch when unicode collation with special data

Mon, 07 Jun 2021 18:06:21 +0000

Bug ID: 103930
Submitted by: Ze Yang
Category: Server: DML
Status: Verified
Severity: 2
OS: Any
Version: 5.7.34

#107535: Group by does not use loose scan unless full prefix is given

Thu, 09 Jun 2022 22:56:15 +0000

Bug ID: 107535
Submitted by: Manuel Ung
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.29, 5.7.38

#107700: Performance of Temptable is worse than Memory in GROUP BY scenario

Wed, 29 Jun 2022 11:18:42 +0000

Bug ID: 107700
Submitted by: Jiayu Zhou
Category: Server: InnoDB
Status: Closed
Severity: 5
OS: Any
Version: 8.0.29

#108411: cluster instance status reports clone information during distributed recovery

Wed, 07 Sep 2022 12:26:48 +0000

Bug ID: 108411
Submitted by: Jay Janssen
Category: Server: Shell IDC
Status: Can't repeat
Severity: 3
OS: Any

#108573: using 'manualStartOnBoot': true in create_replica_cluster causes issues

Wed, 21 Sep 2022 17:08:21 +0000

Bug ID: 108573
Submitted by: Jay Janssen
Category: Server: Shell IDC
Status: Can't repeat
Severity: 3
OS: Any
Version: 8.0.30

#108821: DOC issue with group_replication_communication_debug_options description

Wed, 19 Oct 2022 10:01:00 +0000

Bug ID: 108821
Submitted by: Przemyslaw Malkowski
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 8.0.31

#110245: Issue with NOT IN

Wed, 01 Mar 2023 03:56:25 +0000

Bug ID: 110245
Submitted by: Pinhan Zhao
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0.32

#111414: HASH JOIN results in wrong query results

Wed, 14 Jun 2023 09:26:30 +0000

Bug ID: 111414
Submitted by: yijun xie
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
OS: Any
Version: 8.0.33

#111435: Hash join results in incorrect query results

Thu, 15 Jun 2023 11:14:03 +0000

Bug ID: 111435
Submitted by: yijun xie
Category: Server: Optimizer
Status: Duplicate
Severity: 3
OS: Any
Version: 8.0.32

#112280: Incorrect costing of group by loose index scans

Wed, 06 Sep 2023 20:38:32 +0000

Bug ID: 112280
Submitted by: Manuel Ung
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.34

#112881: Allow forcing a specific resource group for MySQL users for limiting CPU usage

Mon, 30 Oct 2023 09:17:44 +0000

Bug ID: 112881
Submitted by: Yoni Sade
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any
Version: 8.2

#118849: after add HINT:JOIN_ORDER, the result is wrong.

Mon, 18 Aug 2025 12:14:38 +0000

Bug ID: 118849
Submitted by: Alice Alice
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41

#119011: Execute some acl statements to a cluster without quorum in group replication makes login stuck

Mon, 15 Sep 2025 16:04:28 +0000

Bug ID: 119011
Submitted by: toki ye
Category: Server: GCS
Status: Verified
Severity: 3
OS: Any
Version: 9.4.0

#119174: unexpected value after changing Max to Min

Thu, 16 Oct 2025 13:18:51 +0000

Bug ID: 119174
Submitted by: cl hl
Category: Server
Status: Not a Bug
Severity: 3
OS: Any
Version: 9.4.0

#119669: Inconsistent behaviour between normal query and prepared statement

Tue, 13 Jan 2026 13:27:18 +0000

Bug ID: 119669
Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.0.44

#119714: after changing ASIN(hpg31.c1) in group clause,the col_1’s value unexpectedly change.

Sun, 18 Jan 2026 12:26:15 +0000

Bug ID: 119714
Submitted by: Aaditya Dubey
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.44

#119724: after changing asin function in group clause,column's value unexpectedly change

Tue, 20 Jan 2026 05:55:04 +0000

Bug ID: 119724
Submitted by: cl hl
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.44

#120043: mysql shell server upgrade checks ignoring cross database foreign key references in foreignKeyReferences check

Thu, 12 Mar 2026 21:19:05 +0000

Bug ID: 120043
Submitted by: Chelluru Vidyadhar
Category: Server: Shell UPD
Status: Verified
Severity: 3
OS: Any
Version: 8.4.8

#2007: mysqlcc doesn't read [client] group

Wed, 03 Dec 2003 18:58:58 +0000

Bug ID: 2007
Submitted by: Paul DuBois
Category: MySQLCC
Status: Closed
Severity: 3
OS: Any (all)
Version: 0.9.3

#8093: GROUP BY can alter some values of a grouped by column

Sat, 22 Jan 2005 20:08:17 +0000

Bug ID: 8093
Submitted by: paul van den berg
Category: Server: MyISAM
Status: Closed
Severity: 3
OS: Any (*)
Version: 4.1.8

#9090: Optimization Problem with a subquery in an IN Operation

Thu, 10 Mar 2005 10:30:34 +0000

Bug ID: 9090
Submitted by: Andre Justus
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 4.1.x, 5.x

#10982: A query from olap.test returns a wrong result set

Tue, 31 May 2005 12:02:19 +0000

Bug ID: 10982
Submitted by: Igor Babaev
Category: Server
Status: Closed
Severity: 2
OS: Any (all)
Version: 5.0

#13024: optimizer does not use index when where has (field1,field2,..)=(value1,value2,.

Tue, 06 Sep 2005 23:04:30 +0000

Bug ID: 13024
Submitted by: Jason Pyeron
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 4.1.14, 5.0.11

#13432: C API: sending a group of rows at a time

Fri, 23 Sep 2005 16:05:21 +0000

Bug ID: 13432
Submitted by: Jacek Becla
Category: Server
Status: Closed
Severity: 4
OS: Any (ANY)
Version: ANY

#14019: group by converts literal string to column name

Thu, 13 Oct 2005 22:45:11 +0000

Bug ID: 14019
Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any (*)
Version: 4.1.14 / 5.1.13

#24114: selecting no notifcations and a notification group results in an error

Wed, 08 Nov 2006 23:43:25 +0000

Bug ID: 24114
Submitted by: Joshua Ganderson
Category: Monitoring: Web
Status: Closed
Severity: 4
OS: Any (all)
Version: 1.0.0

#26830: subquery, group by .. with rollup crashes server

Sun, 04 Mar 2007 05:43:49 +0000

Bug ID: 26830
Submitted by: Shane Bester
Category: Server: General
Status: Closed
Severity: 1
OS: Any (*)
Version: 5.0.38BK, 5.1.17BK

#27721: In current Event Scheduler you cannot relate one temporal event to another one

Mon, 09 Apr 2007 20:12:17 +0000

Bug ID: 27721
Submitted by: Jacob Nikom
Category: Server: SP
Status: Verified
Severity: 4
OS: Any
Version: 5.1

#28601: Incoherent results when using GROUP BY (regression)

Tue, 22 May 2007 16:49:22 +0000

Bug ID: 28601
Submitted by: Jorge Bernal
Category: Server: Parser
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.0.41

#29438: rollup with multiple "group by" column repeats last grouping column final rollup

Fri, 29 Jun 2007 03:36:41 +0000

Bug ID: 29438
Submitted by: avi weiss
Category: Server: General
Status: No Feedback
Severity: 3
OS: Any
Version: 5.0.41

#29530: undocumented options in 'create logfile group' & 'create tablespace' statements

Tue, 03 Jul 2007 20:15:50 +0000

Bug ID: 29530
Submitted by: Sergei Tkachenko
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.1

#29606: LAST ENTRY of a GROUP BY sql statement

Fri, 06 Jul 2007 18:57:25 +0000

Bug ID: 29606
Submitted by: numpsy beelzebub
Category: Server: General
Status: Not a Bug
Severity: 4
OS: Any
Version: 5.1

#29845: GROUP BY does not make best use of indicies when evaluating SUM aggregates

Tue, 17 Jul 2007 13:10:35 +0000

Bug ID: 29845
Submitted by: Chris Ricks
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 6.0.0-alpha

#30075: Allow reordering of servers within a group

Thu, 26 Jul 2007 15:33:25 +0000

Bug ID: 30075
Submitted by: Mark Leith
Category: Monitoring: Web
Status: Won't fix
Severity: 4
OS: Any
Version: 1.2.0

#31772: Select statement got warning after add a long name log/data file

Tue, 23 Oct 2007 02:33:29 +0000

Bug ID: 31772
Submitted by: li zhou
Category: Server: ClusterDD
Status: Closed
Severity: 3
OS: Any
Version: 5.1.22

#33049: Assert while running test-as3ap test(mysql-bench suite)

Thu, 06 Dec 2007 21:52:42 +0000

Bug ID: 33049
Submitted by: Alexey Stroganov
Category: Server: Views
Status: Closed
Severity: 3
OS: Any
Version: 5.0.56-debug, 5.1.24-rc-debug, 6.0.4-debug, 6.0.5pre-DEBUG

#34203: Stops responding

Thu, 31 Jan 2008 19:31:28 +0000

Bug ID: 34203
Submitted by: Ilija Poznic
Category: MySQL Workbench
Status: No Feedback
Severity: 2
OS: Any
Version: 5.0.12

#34763: item_subselect.cc:1235:Item_in_subselect::row_value_transformer:Assertion failed

Fri, 22 Feb 2008 19:20:24 +0000

Bug ID: 34763
Submitted by: Gleb Shchepa
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.0+

#35038: Falcon crash on I_S query in RecordVersion::fetchVersion line 98

Tue, 04 Mar 2008 15:40:41 +0000

Bug ID: 35038
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Unsupported
Severity: 3
OS: Any
Version: 6.0-falcon-team

#36314: GRANT is missing in SQL documentation

Thu, 24 Apr 2008 11:16:39 +0000

Bug ID: 36314
Submitted by: Susanne Ebrecht
Category: Server: Docs
Status: Not a Bug
Severity: 3
OS: Any
Version: all

#36511: MySQL allows fields in SELECT list that are not in the GROUP BY statement

Mon, 05 May 2008 16:09:06 +0000

Bug ID: 36511
Submitted by: Daniel Magliola
Category: Server: General
Status: Not a Bug
Severity: 2
OS: Any
Version: 5.0.51

#36772: When using UTF8, CONVERT with GROUP BY returns truncated results

Fri, 16 May 2008 23:04:27 +0000

Bug ID: 36772
Submitted by: Gregory Golberg
Category: Server: Charsets
Status: Closed
Severity: 2
OS: Any (Ubuntu (5.0.38-Ubuntu_0ubuntu1.4-log) and WinXP (5.0.45-community-nt))
Version: 5.0BK/5.1BK/6.0BK

#37870: Assertion in convert_constant_item: result = 0

Fri, 04 Jul 2008 13:00:50 +0000

Bug ID: 37870
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.0 -r2646, 5.1 - r2673 , 6.0 - r2764

#37954: java.lang.NullPointerException when creating server group

Tue, 08 Jul 2008 02:22:04 +0000

Bug ID: 37954
Submitted by: Akiko Yonemura
Category: Monitoring
Status: Closed
Severity: 3
OS: Any
Version: 1.3.2.9126

#38217: GROUP BY with subquery fails.

Thu, 17 Jul 2008 21:35:41 +0000

Bug ID: 38217
Submitted by: Adam Dixon
Category: Server: Optimizer
Status: Duplicate
Severity: 3
OS: Any
Version: 5.0.60, 5.0.64, 5.1.28

#38858: ORDERGROUP BY construct

Mon, 18 Aug 2008 13:56:54 +0000

Bug ID: 38858
Submitted by: Lig Isler-Turmelle
Category: Server: Parser
Status: Verified
Severity: 4
OS: Any

#38859: limiting a group - LIMITGROUP

Mon, 18 Aug 2008 14:17:06 +0000

Bug ID: 38859
Submitted by: Lig Isler-Turmelle
Category: Server: Parser
Status: Verified
Severity: 4
OS: Any
Version: 6.0

#39168: ERROR: the age of the last checkpoint ... exceeds the log group capacity

Mon, 01 Sep 2008 19:54:15 +0000

Bug ID: 39168
Submitted by: Louis Breda van
Category: Server: InnoDB
Status: Closed
Severity: 2
OS: Any
Version: any

#40037: Incorrect result from MIN/MAX when no GROUP, and independent subquery predicate

Wed, 15 Oct 2008 09:34:24 +0000

Bug ID: 40037
Submitted by: Timour Katchaounov
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.x, 6.x

#41036: Easier Configuration Change On Cluster Disk Objects

Tue, 25 Nov 2008 22:23:24 +0000

Bug ID: 41036
Submitted by: Mikiya Okuno
Category: Server: ClusterDD
Status: Verified
Severity: 4
OS: Any
Version: mysql-5.1-telco-7.0

#41266: rename group fails if the new name differs only in case from existing name

Fri, 05 Dec 2008 15:36:05 +0000

Bug ID: 41266
Submitted by: Carsten Segieth
Category: Monitoring: Web
Status: Closed
Severity: 3
OS: Any
Version: 2.0.0.7119

#42955: Wrong results returned by join queries with group by/order by when BKA is used

Wed, 18 Feb 2009 04:07:05 +0000

Bug ID: 42955
Submitted by: Igor Babaev
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 6.0-bzr

#43241: Inconsistancy in warnings on create table / create tablespace with unknown engin

Thu, 26 Feb 2009 17:54:51 +0000

Bug ID: 43241
Submitted by: Hartmut Holzgraefe
Category: Server: ClusterDD
Status: Verified
Severity: 3
OS: Any
Version: mysql-5.1-telco-6.3

#43474: Invalid page number referenced from IndexRootPage::findLeaf()

Sat, 07 Mar 2009 16:55:26 +0000

Bug ID: 43474
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Duplicate
Severity: 1
OS: Any
Version: 6.0-falcon-team

#43669: Falcon returns diff. no of digits than other engines with MIN() for YEAR values

Mon, 16 Mar 2009 09:16:41 +0000

Bug ID: 43669
Submitted by: Nidhi Shrotriya
Category: Server: Types
Status: Unsupported
Severity: 3
OS: Any
Version: 6.0.11

#43815: New topology is not discovered after previous replication group is renamed

Tue, 24 Mar 2009 00:47:01 +0000

Bug ID: 43815
Submitted by: Bill Weber
Category: Monitoring: Server
Status: Closed
Severity: 2
OS: Any
Version: 2.0.5.7153

#43912: 'Column * cannot be null' when derived table has count() with no results

Fri, 27 Mar 2009 13:56:33 +0000

Bug ID: 43912
Submitted by: Shane Bester
Category: Server: DML
Status: Won't fix
Severity: 3
OS: Any
Version: 5.0.91

#45261: Crash, stored procedure + decimal

Tue, 02 Jun 2009 10:47:54 +0000

Bug ID: 45261
Submitted by: Matthias Leich
Category: Server: SP
Status: Closed
Severity: 3
OS: Any
Version: 5.1,5.4

#45361: parser behaves too primitive here!

Sun, 07 Jun 2009 21:58:32 +0000

Bug ID: 45361
Submitted by: Peter Laursen
Category: Server: Parser
Status: Not a Bug
Severity: 3
OS: Any
Version: any

#45373: INDEX FOR GROUP BY is not used if there is a LIMIT clause in the query

Mon, 08 Jun 2009 13:14:02 +0000

Bug ID: 45373
Submitted by: Alex Bolenok
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.35-community, 5.1.36-bzr

#45897: Do not add the name of the stored procedure in the routine group

Thu, 02 Jul 2009 05:51:20 +0000

Bug ID: 45897
Submitted by: Pavel Dobryakov
Category: MySQL Workbench
Status: Can't repeat
Severity: 2
OS: Any
Version: 5.1.16

#45963: DWIM: Allow group functions in WHERE clause, by doing GROUP BY first

Mon, 06 Jul 2009 08:48:40 +0000

Bug ID: 45963
Submitted by: Chris Hennick
Category: Server: DML
Status: Not a Bug
Severity: 4
OS: Any
Version: 5.0.75-0ubuntu10.2 (Ubuntu)

#46004: Crash in row_sel_field_store_in_mysql_format on a SELECT + LIMIT

Tue, 07 Jul 2009 12:33:02 +0000

Bug ID: 46004
Submitted by: Philip Stoev
Category: Server: InnoDB
Status: Duplicate
Severity: 2
OS: Any
Version: 5.1

#46038: MEM Admin setting does not save when creating a notification group

Wed, 08 Jul 2009 11:12:18 +0000

Bug ID: 46038
Submitted by: Mark Leith
Category: Monitoring: Server
Status: Closed
Severity: 3
OS: Any
Version: 2.1.0.1074

#46211: SQL_BIG_RESULT, SQL_SMALL_RESULT, SQL_BUFFER_RESULT should be mutually exclusive

Wed, 15 Jul 2009 18:16:07 +0000

Bug ID: 46211
Submitted by: Paul DuBois
Category: Server: Parser
Status: Not a Bug
Severity: 3
OS: Any

#46344: [graphs]: Show hint with instance name which caused maximum contribution

Thu, 23 Jul 2009 08:08:32 +0000

Bug ID: 46344
Submitted by: Andrii Nikitin
Category: Monitoring: Web
Status: Closed
Severity: 4
OS: Any

#46923: select count(*) from partitioned table fails with ONLY_FULL_GROUP_BY

Tue, 25 Aug 2009 18:07:29 +0000

Bug ID: 46923
Submitted by: Shane Bester
Category: Server: Partition
Status: Closed
Severity: 2
OS: Any
Version: 5.1.37, 5.1.39, 5.4.x

#46986: SQL formatter fails for SELECT ... WHERE .. NOT IN ( SELECT ... ) GROUP BY

Fri, 28 Aug 2009 22:08:51 +0000

Bug ID: 46986
Submitted by: Carsten Segieth
Category: Monitoring: Web
Status: Verified
Severity: 3
OS: Any
Version: 2.0.6.7159

#47106: Crash / segfault on adding EXPLAIN to a non-crashing query

Thu, 03 Sep 2009 16:44:39 +0000

Bug ID: 47106
Submitted by: Patrick Crews
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.1, 5.4/6.0

#47649: crash during CALL procedure

Fri, 25 Sep 2009 13:25:53 +0000

Bug ID: 47649
Submitted by: Matthias Leich
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.1,6.0.14

#47650: using group by with rollup without indexes returns incorrect results with where

Fri, 25 Sep 2009 16:53:43 +0000

Bug ID: 47650
Submitted by: Derrek Leute
Category: Server: DML
Status: Closed
Severity: 3
OS: Any (Mac OS X Snow leopard, Linux)
Version: 5.0.X, 5.1.39, next-mr

#48475: DISTINCT is ignored with GROUP BY WITH ROLLUP and only const tables

Mon, 02 Nov 2009 14:06:41 +0000

Bug ID: 48475
Submitted by: Alexey Kopytov
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.0.88, 5.1.41

#49326: Support group commit for the binlog

Wed, 02 Dec 2009 05:22:25 +0000

Bug ID: 49326
Submitted by: Mark Callaghan
Category: Server: Replication
Status: Closed
Severity: 4
OS: Any
Version: 5.0,5.1

#49360: In some circumstances, GROUP BY WITH ROLLUP is faster then GROUP BY

Wed, 02 Dec 2009 17:53:43 +0000

Bug ID: 49360
Submitted by: Rene' Cannao'
Category: Server: Optimizer
Status: No Feedback
Severity: 3
OS: Any
Version: 5.0.66 , 5.0.84 , 5.0.84 , 5.1.41, 5.1.43

#49431: Routine groups seems busted

Thu, 03 Dec 2009 22:05:50 +0000

Bug ID: 49431
Submitted by: Todd Farmer
Category: MySQL Workbench: Modeling
Status: No Feedback
Severity: 2
OS: Any (XP)
Version: 5.2.10 r4680

#49846: Valid dependent views result with ERROR 1055 (42000): 'xxx' isn't in GROUP BY

Mon, 21 Dec 2009 12:42:10 +0000

Bug ID: 49846
Submitted by: Shlomi Noach
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.0.90, 5.1.34-log, 5.1.41

#50843: Optimizer ignores clustered index for GROUP BY even when it improves performance

Tue, 02 Feb 2010 18:12:51 +0000

Bug ID: 50843
Submitted by: Chris Calender
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.1.42

#50910: confusing docs lines about replication group termination wth stop slave

Thu, 04 Feb 2010 12:05:32 +0000

Bug ID: 50910
Submitted by: Andrei Elkin
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.1+

#51111: ALTER LOGFILE GROUP missing error message

Thu, 11 Feb 2010 16:21:27 +0000

Bug ID: 51111
Submitted by: Andrew Hutchings
Category: Server: ClusterDD
Status: Closed
Severity: 3
OS: Any
Version: mysql-5.1-telco-6.3

#51318: implement "if exists" for DROP LOGFILE GROUP, DROP TABLESPACE commands

Fri, 19 Feb 2010 10:48:29 +0000

Bug ID: 51318
Submitted by: Victoria Reznichenko
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any
Version: 5.1

#51439: doc refers to [proxy] group in config file instead of [mysql-proxy]

Wed, 24 Feb 2010 01:43:58 +0000

Bug ID: 51439
Submitted by: Dario Souza
Category: Proxy: Docs
Status: Closed
Severity: 3
OS: Any
Version: 0.8.0

#52029: GROUP BY results in much slower query

Sat, 13 Mar 2010 12:26:53 +0000

Bug ID: 52029
Submitted by: Greg Hazel
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 5.1.44

#52156: Incomplete log message shows wrong log group

Wed, 17 Mar 2010 19:09:04 +0000

Bug ID: 52156
Submitted by: Andrew Hutchings
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Any
Version: mysql-5.1-telco-6.3

#53144: GROUP BY with ROLLUP includes previous data in rollup

Sun, 25 Apr 2010 17:09:43 +0000

Bug ID: 53144
Submitted by: John Larsen
Category: Server: General
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.0.88

#53544: Server hangs during JOIN query in stored procedure called twice in a row

Mon, 10 May 2010 16:50:27 +0000

Bug ID: 53544
Submitted by: John Embretsen
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.1.47, 5.6.99-m4 Dahlia, bzr_mysql-6.0-codebase-bugfixing

#56118: STOP SLAVE does not wait till trx with CREATE TMP TABLE ends, replication aborts

Thu, 19 Aug 2010 13:12:55 +0000

Bug ID: 56118
Submitted by: Elena Stepanova
Category: Server: Replication
Status: Closed
Severity: 3
OS: Any
Version: 5.1.49, 5.5.6-m3, 5.6.99

#57334: FULL OUTER JOIN is not working

Fri, 08 Oct 2010 04:58:17 +0000

Bug ID: 57334
Submitted by: Anil Alpati
Category: Server
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.1.45

#57813: MEM Dashboard: could not insert: [com.mysql.etools.monitor.pom.hib.HibNamed

Thu, 28 Oct 2010 14:40:03 +0000

Bug ID: 57813
Submitted by: Ulf Wendel
Category: Monitoring: Web
Status: Verified
Severity: 3
OS: Any
Version: 2.3.0.2036

#58775: Table Field Name - Group

Tue, 07 Dec 2010 00:55:42 +0000

Bug ID: 58775
Submitted by: Adam Alicki
Category: Server: Errors
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.1.52

#58838: Wrong results with HAVING + LIMIT without GROUP BY when ICP is enabled

Thu, 09 Dec 2010 12:05:56 +0000

Bug ID: 58838
Submitted by: John Embretsen
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.6.1-m5

#59502: race condition in drop logfile group

Fri, 14 Jan 2011 13:13:13 +0000

Bug ID: 59502
Submitted by: Jonas Oreland
Category: Server: ClusterDD
Status: Closed
Severity: 3
OS: Any

#60023: No Loose Index Scan for GROUP BY / DISTINCT on InnoDB partitioned table

Tue, 08 Feb 2011 21:45:53 +0000

Bug ID: 60023
Submitted by: Rene' Cannao'
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 5.5.8 , 5.1.51

#60589: LINQ Group By Generating Broken Query

Tue, 22 Mar 2011 15:06:03 +0000

Bug ID: 60589
Submitted by: Nick Berardi
Category: Connector/Net
Status: Duplicate
Severity: 1
OS: Any
Version: 6.3.6

#60702: GROUP BY orders when used inside a UNION query, though it should not

Wed, 30 Mar 2011 23:25:14 +0000

Bug ID: 60702
Submitted by: Alex Bolenok
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 5.1.57

#61943: Syntax to specify a field from select_expr for Group By

Thu, 21 Jul 2011 13:16:38 +0000

Bug ID: 61943
Submitted by: Sergei Kulakov
Category: Server: DML
Status: Verified
Severity: 4
OS: Any
Version: 5.5.12

#64002: Aggregate queries with multiple columns and no GROUP BY produce bogus results

Wed, 11 Jan 2012 20:01:01 +0000

Bug ID: 64002
Submitted by: Daniel Grace
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any (Debian, Windows XP)
Version: 5.5.19

#67089: Mysql error log group owned by root.

Thu, 04 Oct 2012 18:50:29 +0000

Bug ID: 67089
Submitted by: Rolf Martin-Hoster
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any
Version: 5.1.54, 5.6.21

#68086: Heap tables don't use index for group by

Tue, 15 Jan 2013 08:41:35 +0000

Bug ID: 68086
Submitted by: Andy Svensson
Category: Server: Memory
Status: Verified
Severity: 3
OS: Any
Version: 5.5.29, 5.5.30, 5.7.1

#69590: Problem using between with group by functions

Wed, 26 Jun 2013 15:59:26 +0000

Bug ID: 69590
Submitted by: Claudio Fumagalli
Category: Server: DML
Status: Closed
Severity: 3
OS: Any
Version: 5.5.32

#69684: The update and select behave differently under the same conditions.

Sun, 07 Jul 2013 10:44:44 +0000

Bug ID: 69684
Submitted by: yu hongyu
Category: Server: DML
Status: Closed
Severity: 2
OS: Any
Version: 5.5, 5.6

#70880: GROUP BY function produces truncated columns in combination with CONV() or BIN()

Mon, 11 Nov 2013 14:31:45 +0000

Bug ID: 70880
Submitted by: Thomas Teves
Category: Server
Status: No Feedback
Severity: 2
OS: Any
Version: 5.5.24-log

#71942: Select * -- does it have to be "indeterminate" when using ORDER BY and GROUP BY

Wed, 05 Mar 2014 15:21:54 +0000

Bug ID: 71942
Submitted by: John Pratt
Category: Server
Status: Not a Bug
Severity: 5
OS: Any

#72553: Concurrency control is not locking the right objects

Tue, 06 May 2014 15:00:14 +0000

Bug ID: 72553
Submitted by: Alfranio Tavares Correia Junior
Category: MySQL Fabric
Status: Closed
Severity: 3
OS: Any
Version: 1.4.0

#72814: Assertion `!(ordered_index_usage == ordered_index_void && ... fails

Fri, 30 May 2014 09:31:22 +0000

Bug ID: 72814
Submitted by: Elena Stepanova
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.6.17

#72988: Slave thread fails with MTS + GTID + replicate_same_server_id

Thu, 12 Jun 2014 15:36:59 +0000

Bug ID: 72988
Submitted by: Sven Sandberg
Category: Server: Replication
Status: Closed
Severity: 2
OS: Any
Version: 5.7

#73873: Locking error in the failure detector

Wed, 10 Sep 2014 09:44:58 +0000

Bug ID: 73873
Submitted by: Alfranio Tavares Correia Junior
Category: MySQL Fabric
Status: Closed
Severity: 2
OS: Any

#76099: Make rpl.rpl_sp_privileges test work with Group Replication

Mon, 02 Mar 2015 14:20:29 +0000

Bug ID: 76099
Submitted by: Nuno Carvalho
Category: Server: Replication
Status: Closed
Severity: 3
OS: Any
Version: 5.7.7

#76283: Incorrect result for DISTINCT SELECT

Thu, 12 Mar 2015 09:50:14 +0000

Bug ID: 76283
Submitted by: Benny Wang
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.7

#77392: Slave group event parser does not recognize XA ROLLBACK as a boundary

Wed, 17 Jun 2015 16:22:12 +0000

Bug ID: 77392
Submitted by: Andrei Elkin
Category: Server: Replication
Status: Closed
Severity: 3
OS: Any
Version: 5.7.7

#79044: group by WITH CUBE

Sat, 31 Oct 2015 19:28:59 +0000

Bug ID: 79044
Submitted by: Zhe Dong
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 5.7, 8.0

#80224: CONCAT_WS duplication of arguments when used in conjunction with HAVING

Mon, 01 Feb 2016 19:13:07 +0000

Bug ID: 80224
Submitted by: Fredric Johansson
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.5.46, 5.6.28, 5.7.11

#80244: "Using index for group-by" queries can return no data with LE/LEQ and rounding

Tue, 02 Feb 2016 23:30:55 +0000

Bug ID: 80244
Submitted by: Andrew Bloomgarden
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.7.10, but at least as far back as 5.6

#81188: select json type get garbled reason

Sun, 24 Apr 2016 11:16:16 +0000

Bug ID: 81188
Submitted by: xiao zhou
Category: Connector/J
Status: Duplicate
Severity: 3
OS: Any
Version: 5.1.37

#82171: GROUP BY Optimization clarification

Fri, 08 Jul 2016 19:24:18 +0000

Bug ID: 82171
Submitted by: monty solomon
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any

#82317: Unrelevant error message: Unknown column in 'having' clause

Fri, 22 Jul 2016 07:42:41 +0000

Bug ID: 82317
Submitted by: Dmitry Savchenkov
Category: Server: Parser
Status: Verified
Severity: 3
OS: Any (v14.04.1)
Version: 5.5.49

#83005: When the Optimiser is using index for group-by it often gives wrong results

Thu, 15 Sep 2016 06:56:53 +0000

Bug ID: 83005
Submitted by: Yoseph Phillips
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.6.10, 5.6.33, 5.7.15, 5.5.52

#83144: mysqlpump reads mysql_dump group, not mysqlpump in config-group

Mon, 26 Sep 2016 06:48:25 +0000

Bug ID: 83144
Submitted by: Tsubasa Tanaka
Category: Client: mysqlpump
Status: Closed
Severity: 3
OS: Any
Version: 5.7.15, 5.7.21, 8.0.0, 8.0.4, 8.0.18

#84371: Missing documentation for backup/recover when using MySQL Group Replication

Thu, 29 Dec 2016 19:14:15 +0000

Bug ID: 84371
Submitted by: Ted Wennmark
Category: Server: Docs
Status: Won't fix
Severity: 3
OS: Any
Version: 5.7.17

#84537: GROUP BY DESC gives wrong result when groups on DECIMAL and sees a NULL

Tue, 17 Jan 2017 14:11:23 +0000

Bug ID: 84537
Submitted by: Guilhem Bichot
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 8.0.1

#84731: Group Replication: mysql client connections hang during group replication start

Tue, 31 Jan 2017 08:56:16 +0000

Bug ID: 84731
Submitted by: Kenny Gryp
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7.17

#85119: Innodb needs an instant checksum.

Wed, 22 Feb 2017 03:08:33 +0000

Bug ID: 85119
Submitted by: yun chen
Category: Server: InnoDB
Status: Unsupported
Severity: 4
OS: Any
Version: 5.6 5.7

#85998: SELECT ... FOR UPDATE not listed as possibe limitation with Group Replication

Wed, 19 Apr 2017 09:02:11 +0000

Bug ID: 85998
Submitted by: Frederic Descamps
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.7

#86858: Confusing GR error message: check credentials, but issue is hostnanme resolving

Thu, 29 Jun 2017 03:19:29 +0000

Bug ID: 86858
Submitted by: Jesper wisborg Krogh
Category: Server: GCS
Status: Closed
Severity: 2
OS: Any
Version: 5.7.18

#86993: Incorrect statement about InnoDB group commit in the manual

Sun, 09 Jul 2017 18:28:04 +0000

Bug ID: 86993
Submitted by: Alexey Kopytov
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.6, 5.7

#87190: Test main.group_by is unstable

Wed, 26 Jul 2017 03:07:57 +0000

Bug ID: 87190
Submitted by: Laurynas Biveinis
Category: Tests: Server
Status: Verified
Severity: 3
OS: Any
Version: 8.0.2,8.0.4

#87208: Flow control mechanism does not prevent nodes from lagging further behind

Wed, 26 Jul 2017 14:05:44 +0000

Bug ID: 87208
Submitted by: Kenny Gryp
Category: Server: GCS
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.7.18

#87631: LOAD DELAYS SWITCHING A GR NODE FROM RECOVERING TO ONLINE

Thu, 31 Aug 2017 16:06:14 +0000

Bug ID: 87631
Submitted by: Vitor Oliveira
Category: Server: GCS
Status: Closed
Severity: 2
OS: Any
Version: 8.0.3

#87998: MySQL Group By slow even when indexed

Thu, 05 Oct 2017 16:42:04 +0000

Bug ID: 87998
Submitted by: Bram Kivenko
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.7

#88228: "ORDER BY Optimization" doc contradiction re: GROUP BY

Wed, 25 Oct 2017 19:22:37 +0000

Bug ID: 88228
Submitted by: Gillian Gunson
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 8.0

#88452: No Check for duplicatio @@server_uuid when joining group

Mon, 13 Nov 2017 01:15:51 +0000

Bug ID: 88452
Submitted by: Jesper wisborg Krogh
Category: Server: GCS
Status: Closed
Severity: 2
OS: Any
Version: 5.7.19

#88749: Assertion `item->type() == Item::FIELD_ITEM || (item->type() == Item::REF_ITEM &

Tue, 05 Dec 2017 02:41:35 +0000

Bug ID: 88749
Submitted by: Roel Van de Paar
Category: Server: DML
Status: Verified
Severity: 6
OS: Any
Version: 5.5.58

#88841: Typos in 'Initialized group communication with configuration' message

Sat, 09 Dec 2017 15:07:10 +0000

Bug ID: 88841
Submitted by: Narendra Singh Chauhan
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.4

#89059: LAST_CONFLICT_FREE_TRANSACTION shows different values in group (empty on joiner)

Tue, 26 Dec 2017 18:54:57 +0000

Bug ID: 89059
Submitted by: Narendra Singh Chauhan
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.11

#89142: Make FLUSH RELAY LOGS work for Group Replication.

Mon, 08 Jan 2018 22:09:10 +0000

Bug ID: 89142
Submitted by: Jean-François Gagné
Category: Server: GCS
Status: Closed
Severity: 4
OS: Any
Version: 5.7.20, 8.0.3

#89143: Commit order deadlock + retry logic is not considering trx error cases

Mon, 08 Jan 2018 22:10:55 +0000

Bug ID: 89143
Submitted by: Jean-François Gagné
Category: Server: Replication
Status: Closed
Severity: 2
OS: Any
Version: 5.7.20

#89145: Provide relay log details in case of Group Replication applier failure.

Mon, 08 Jan 2018 22:15:40 +0000

Bug ID: 89145
Submitted by: Jean-François Gagné
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 5.7.20,8.0.3

#89686: Need to add "offset is provided by server_id and increment is 7" to GR manual.

Fri, 16 Feb 2018 07:47:17 +0000

Bug ID: 89686
Submitted by: Meiji Kimura
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.7, 8.0

#89688: server crash when group replication starts with mysqld-debug

Fri, 16 Feb 2018 08:49:37 +0000

Bug ID: 89688
Submitted by: Giuseppe Maxia
Category: Server: Compiling
Status: Verified
Severity: 4
OS: Any (linux and macos)
Version: 5.7.21, 8.0.3, 8.0.4

#90951: Contribution by Facebook: Enhance group-by loose index scan

Mon, 21 May 2018 16:18:14 +0000

Bug ID: 90951
Submitted by: FBContrib Admin
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.6.35

#91150: Force primary to stop accept writes on low number of members in the group

Tue, 05 Jun 2018 16:02:47 +0000

Bug ID: 91150
Submitted by: Artem Danilov
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 8.0.11

#91793: Use the new shutdown service when gr_exit_state_action=ABORT_SERVER

Wed, 25 Jul 2018 16:25:58 +0000

Bug ID: 91793
Submitted by: Nuno Carvalho
Category: Server: GCS
Status: Closed
Severity: 4
OS: Any
Version: 8.0.12

#92110: Errors when joining on start may lead to a stale view of the group

Tue, 21 Aug 2018 18:02:50 +0000

Bug ID: 92110
Submitted by: Pedro Gomes
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.13

#92293: MySQL InnoDB Cluster/Group Replication Server StartUp Sequence Request

Wed, 05 Sep 2018 08:32:47 +0000

Bug ID: 92293
Submitted by: Ivan Ma
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 5.7, 8.0

#92526: MAKE GR REPLICATION CHANNELS ROTATE RELAY LOG ON FLUSH LOGS

Fri, 21 Sep 2018 10:29:19 +0000

Bug ID: 92526
Submitted by: João Gramacho
Category: Server: Replication
Status: Closed
Severity: 3
OS: Any
Version: 8.0.14

#94186: replication_group_members table's document page is incomplete for server status

Mon, 04 Feb 2019 08:23:01 +0000

Bug ID: 94186
Submitted by: Yoshimi Takahashi
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.7

#94213: group_replication_consistency=AFTER does not include BEFORE_ON_PRIMARY_FAILOVER

Wed, 06 Feb 2019 10:31:34 +0000

Bug ID: 94213
Submitted by: Nuno Carvalho
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.14

#96071: TempTable engine uses much more memory than MEMORY engine for temporary table

Tue, 02 Jul 2019 10:43:58 +0000

Bug ID: 96071
Submitted by: Øystein Grøvlen
Category: Server: InnoDB
Status: Verified
Severity: 3
OS: Any
Version: 8.0.16

#96217: Confliction of resource group and thread pool plugin, invalid memory access

Tue, 16 Jul 2019 09:25:08 +0000

Bug ID: 96217
Submitted by: Fangxin Flou
Category: Server: Connection Handling
Status: Can't repeat
Severity: 3
OS: Any
Version: 8.0

#96479: JapaneseDocumentBug

Thu, 08 Aug 2019 20:50:37 +0000

Bug ID: 96479
Submitted by: Jyuuzou Aketi
Category: Server: Docs JP
Status: Verified
Severity: 3
OS: Any
Version: 5.6

#96549: MySQL query optimizer rewrites query and gets different results than MySQL5.5

Thu, 15 Aug 2019 10:59:21 +0000

Bug ID: 96549
Submitted by: lalit Choudhary
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.6,5.7,8.0, 5.6.45, 5.7.27, 8.0.17

#97417: Typo in Group Replication Settings docs

Tue, 29 Oct 2019 13:33:36 +0000

Bug ID: 97417
Submitted by: Hrvoje Matijakovic
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 8.0 5.7

#97707: group replication lost transaction when init by ansible

Wed, 20 Nov 2019 12:39:20 +0000

Bug ID: 97707
Submitted by: Haixing Weng
Category: Server: GCS
Status: Can't repeat
Severity: 1
OS: Any
Version: all version with MGR

#98630: The same expression in GROUP BY and in output is not distinguished

Mon, 17 Feb 2020 09:36:35 +0000

Bug ID: 98630
Submitted by: Владислав Сокол
Category: Server
Status: Not a Bug
Severity: 3
OS: Any

#99100: GROUP BY will throw table is full when temptable memory allocation exceed limit

Fri, 27 Mar 2020 13:22:24 +0000

Bug ID: 99100
Submitted by: Dean Zhou
Category: Server: InnoDB
Status: Closed
Severity: 2
OS: Any
Version: 8.0

#99459: SQL run with GROUP_MIN_MAX may infinite loop and never return

Wed, 06 May 2020 08:17:26 +0000

Bug ID: 99459
Submitted by: Ze Yang
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.6,5.7,8.0

#100378: GROUP_REPLICATION member cannot join

Thu, 30 Jul 2020 08:57:36 +0000

Bug ID: 100378
Submitted by: fox yao
Category: Server: Replication
Status: Can't repeat
Severity: 3
OS: Any
Version: 8.0.21

#100398: The results of aggregation operations are inconsistent in different partitions

Fri, 31 Jul 2020 08:33:45 +0000

Bug ID: 100398
Submitted by: jiaona chen
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.19, 5.7.31, 8.0.21

#100597: INDEX hint does not affect count(*) execution

Fri, 21 Aug 2020 07:10:19 +0000

Bug ID: 100597
Submitted by: Øystein Grøvlen
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 8.0

#100723: slow MTS recovery in startup

Thu, 03 Sep 2020 07:30:19 +0000

Bug ID: 100723
Submitted by: Qilu Wei
Category: Server: Replication
Status: Verified
Severity: 5
OS: Any
Version: 8.0

#101228: date group and sort groups similar dates in different groups

Mon, 19 Oct 2020 15:55:41 +0000

Bug ID: 101228
Submitted by: Freddy Andersen
Category: Server: DML
Status: Not a Bug
Severity: 2
OS: Any
Version: 8.0.22

#101838: Adding GROUP BY slows down a query.

Wed, 02 Dec 2020 19:17:47 +0000

Bug ID: 101838
Submitted by: Jean-François Gagné
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 8.0

#102942: prepare execute result is different from a query execute directly

Fri, 12 Mar 2021 06:53:23 +0000

Bug ID: 102942
Submitted by: track ay
Category: Server: PS
Status: Not a Bug
Severity: 1
OS: Any
Version: 8.0.23

#105748: Why is group_replication_consistency = AFTER crashing a Group Replication cluste

Tue, 30 Nov 2021 11:47:42 +0000

Bug ID: 105748
Submitted by: Marco Tusa
Category: Server: GCS
Status: Duplicate
Severity: 2
OS: Any

#106814: The type varchar can't use if optimizer don't do derived_merge

Thu, 24 Mar 2022 05:05:43 +0000

Bug ID: 106814
Submitted by: xincheng xie
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0.18

#106815: improve instrumentation of group replication group changes

Thu, 24 Mar 2022 08:45:18 +0000

Bug ID: 106815
Submitted by: Simon Mudd
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 8.0.28

#107599: Improve GR server throttling documentation to provide more details

Mon, 20 Jun 2022 06:26:55 +0000

Bug ID: 107599
Submitted by: Simon Mudd
Category: Server: Docs
Status: Verified
Severity: 4
OS: Any
Version: 8.0

#108792: Clone plugin is not supported btw commercial and community version

Sun, 16 Oct 2022 02:34:49 +0000

Bug ID: 108792
Submitted by: Mughees Ahmed
Category: Server: Clone Plugin
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0.21

#109548: Poor performance when using HASH field to check unique

Mon, 09 Jan 2023 07:55:03 +0000

Bug ID: 109548
Submitted by: Hope Lee
Category: Server: DML
Status: Closed
Severity: 5
OS: Any
Version: 8.0.13,8.0.31

#110447: Not able to create innodb cluster

Tue, 21 Mar 2023 04:45:20 +0000

Bug ID: 110447
Submitted by: Tanu Ajmera
Category: Server: Shell OPR
Status: No Feedback
Severity: 2
OS: Any
Version: 8.0.32-2.0.8

#110537: MySQL cluster fail to auto recover

Wed, 29 Mar 2023 04:02:49 +0000

Bug ID: 110537
Submitted by: zetang zeng
Category: Server: GCS
Status: Can't repeat
Severity: 1
OS: Any
Version: 5.7.40

#111189: Scalar correlated subquery with group by clause mistakenly transformed

Mon, 29 May 2023 15:04:00 +0000

Bug ID: 111189
Submitted by: chen jiang
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 8.0

#112401: Node group assumed to start from 0

Wed, 20 Sep 2023 18:44:40 +0000

Bug ID: 112401
Submitted by: Mikael Ronström
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Any
Version: 8.0.34

#112888: View_change_log_event's in secondary cluster break cross-DC failovers

Mon, 30 Oct 2023 21:35:31 +0000

Bug ID: 112888
Submitted by: Marcos Albe
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.27

#113838: Async connection failover prevents failed Group Replication member rejoin

Wed, 31 Jan 2024 19:24:33 +0000

Bug ID: 113838
Submitted by: Matthew Boehm
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0+

#114762: invalid result set with join lateral and group by on a generated field

Wed, 24 Apr 2024 10:05:40 +0000

Bug ID: 114762
Submitted by: soheil rahsaz
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0

#115040: Incorrect result from lateral join with group by month/monthname function inside

Thu, 16 May 2024 12:09:00 +0000

Bug ID: 115040
Submitted by: Behnam Gogiev
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0

#115671: The optimizer has chosen a poor execution plan.

Tue, 23 Jul 2024 09:47:49 +0000

Bug ID: 115671
Submitted by: hongjun xiao
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 8.0.37, 8.0.39

#116534: Another Performance of TPC-H Query 16

Sun, 03 Nov 2024 10:40:04 +0000

Bug ID: 116534
Submitted by: JINSHENG BA
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 596f0d23 (9.0.0)

#116645: Improved search in Connections list

Wed, 13 Nov 2024 14:18:49 +0000

Bug ID: 116645
Submitted by: IGG t
Category: MySQL Workbench
Status: Verified
Severity: 4
OS: Any (11)
Version: 8.0

#116932: Not update the slave_relay_log_info table in time causes replication recovery failure

Wed, 11 Dec 2024 01:45:32 +0000

Bug ID: 116932
Submitted by: karry zhang
Category: Server: Replication
Status: Verified
Severity: 3
OS: Any
Version: MySQL8.0,5.7

#117408: Tight index scan not used when group by does not begin with first part of key, but where condition is list of constants

Fri, 07 Feb 2025 04:26:18 +0000

Bug ID: 117408
Submitted by: Jacob Brown
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 8.0.41

#118165: Ensure MySQL automatic connection failover handling can handle mixed MySQL "upstream" versions

Mon, 12 May 2025 08:39:00 +0000

Bug ID: 118165
Submitted by: Simon Mudd
Category: Server: Replication
Status: Closed
Severity: 4
OS: Any
Version: 8.0+

#118592: Unexpected result of prepared statement

Mon, 07 Jul 2025 12:12:29 +0000

Bug ID: 118592
Submitted by: chi zhang
Category: Server: PS
Status: Duplicate
Severity: 1
OS: Any
Version: 9.3.0

#118898: Cluster endup having two primary nodes, also if group_replication_single_primary_mode is ON.

Tue, 26 Aug 2025 12:35:35 +0000

Bug ID: 118898
Submitted by: Marco Tusa
Category: Server: GCS
Status: Verified
Severity: 3
OS: Any
Version: 8.4.6

#119605: GROUP BY brings unnecessary order columns

Mon, 29 Dec 2025 09:37:34 +0000

Bug ID: 119605
Submitted by: huahua xu
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.27

#119808: Error 3569 with HIGH_PRIORITY + VIEW + GROUP BY + FOR UPDATE

Thu, 29 Jan 2026 14:44:48 +0000

Bug ID: 119808
Submitted by: Chunling Qin
Category: Server: DML
Status: Open
Severity: 2
OS: Any

#176: Mixing aliases and aggregate functions in GROUP BY results in empty set

Fri, 21 Mar 2003 11:32:45 +0000

Bug ID: 176
Submitted by: Alexander Keremidarski
Category: Server
Status: Closed
Severity: 3
OS: Any
Version: all

#380: MySQL crashes with InnoDB + group

Tue, 06 May 2003 10:14:00 +0000

Bug ID: 380
Submitted by: Dmitry Katsubo
Category: Server
Status: Closed
Severity: 2
OS: Any (any)
Version: 4.1.0

#1790: BIT_AND() result in GROUP BY different when SQL_BIG_RESULT used

Mon, 10 Nov 2003 00:45:34 +0000

Bug ID: 1790
Submitted by: Arjen Lentz
Category: Server
Status: Closed
Severity: 2
OS: Any (any)
Version: 3.23,4.0,4.1

#1941: Allow aliases in WHERE clauses for queries without GROUP BY

Mon, 24 Nov 2003 21:26:51 +0000

Bug ID: 1941
Submitted by: Bob Terrell
Category: Server
Status: Not a Bug
Severity: 4
OS: Any (all)
Version: all

#4065: remove the need to mention column name in select in order to use it in having

Tue, 08 Jun 2004 21:31:26 +0000

Bug ID: 4065
Submitted by: Gökhan Demir
Category: Server: DML
Status: Won't fix
Severity: 4
OS: Any (all)
Version: all

#4400: incorrect error message about aggregate function in subquery

Sat, 03 Jul 2004 20:52:11 +0000

Bug ID: 4400
Submitted by: Oleksandr Byelkin
Category: Server
Status: Closed
Severity: 3
OS: Any (all)
Version: 4.1

#5615: type of aggregate function column wrong when using group by

Thu, 16 Sep 2004 19:37:15 +0000

Bug ID: 5615
Submitted by: Jim Nusbaum
Category: Server
Status: Closed
Severity: 1
OS: Any (any)
Version: 4.1.3

#6931: Date Type column problem when using UNION-Table.

Thu, 02 Dec 2004 03:45:29 +0000

Bug ID: 6931
Submitted by: Poh Chuan Sim
Category: Server
Status: Closed
Severity: 3
OS: Any (any)
Version: 4.1.8

#7101: Usage of LEFT() function in GROUP BY crashes a server

Wed, 08 Dec 2004 12:19:56 +0000

Bug ID: 7101
Submitted by: SINISA MILIVOJEVIC
Category: Server
Status: Closed
Severity: 1
OS: Any (all)
Version: 4.1

#9213: GROUP BY query on utf-8 key returns wrong results (empty set)

Wed, 16 Mar 2005 02:34:29 +0000

Bug ID: 9213
Submitted by: Timothy Smith
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any (any)
Version: 4.1.11

#11640: automatic key creation on CREATE TABLE ... SELECT

Wed, 29 Jun 2005 13:29:17 +0000

Bug ID: 11640
Submitted by: Thomas Belot
Category: Server: DDL
Status: Won't fix
Severity: 4
OS: Any

#13669: Group commit is broken in 5.0

Fri, 30 Sep 2005 19:18:42 +0000

Bug ID: 13669
Submitted by: Peter Zaitsev
Category: Server: InnoDB
Status: Closed
Severity: 4
OS: Any (all)
Version: 5.0

#15135: Dependent subquery performs very badly

Tue, 22 Nov 2005 14:28:05 +0000

Bug ID: 15135
Submitted by: Dominic Binks
Category: Server: Optimizer
Status: Closed
Severity: 5
OS: Any (NT)
Version: 4.1.14

#15584: Server can not tell clients about generated keys

Thu, 08 Dec 2005 12:25:25 +0000

Bug ID: 15584
Submitted by: David Newcomb
Category: Server
Status: Analyzing
Severity: 4
OS: Any

#17974: INSERT ... SELECT with GROUP BY causes truncation of DECIMAL

Mon, 06 Mar 2006 16:16:32 +0000

Bug ID: 17974
Submitted by: Mark Leith
Category: Server
Status: Won't fix
Severity: 3
OS: Any (Any)
Version: 4.1.18

#19089: CREATE TABLE ... SELECT * FROM a view with an ENUM column and GROUP BY fails

Thu, 13 Apr 2006 20:49:22 +0000

Bug ID: 19089
Submitted by: Beat Vontobel
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any (any)
Version: 5.0.20

#19103: --defaults-group-suffix not documented

Fri, 14 Apr 2006 13:04:29 +0000

Bug ID: 19103
Submitted by: Sergei Golubchik
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.0

#20203: SEC_TO_TIME(SUM(TIME_TO_SEC( doesn't work correctly with a VIEW

Thu, 01 Jun 2006 13:45:15 +0000

Bug ID: 20203
Submitted by: Martijn van Dongen
Category: Server: Views
Status: Not a Bug
Severity: 3
OS: Any (All)
Version: 5.0.22, 4.1.21-BK

#20284: There is no description of "copying to group table"

Tue, 06 Jun 2006 07:57:26 +0000

Bug ID: 20284
Submitted by: Gleb Paharenko
Category: Server: Docs
Status: Closed
Severity: 4
OS: Any (All)
Version: 5.0.20

#20709: Collation not used in group by on 4.1

Tue, 27 Jun 2006 00:20:27 +0000

Bug ID: 20709
Submitted by: Morgan Tocker
Category: Server: MyISAM
Status: Closed
Severity: 3
OS: Any (ALL)
Version: 4.1

#22138: Server crash on complex select

Sat, 09 Sep 2006 03:13:43 +0000

Bug ID: 22138
Submitted by: Dave Pullin
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any (*)
Version: 5.0.24a,5.0BK,5.1BK

#22781: SQL_BIG_RESULT fails to influence sort plan

Thu, 28 Sep 2006 14:51:42 +0000

Bug ID: 22781
Submitted by: John David Duncan
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.0.24/5.0BK

#24984: Administrator provides no way to debug problems with scheduled backups

Mon, 11 Dec 2006 23:42:58 +0000

Bug ID: 24984
Submitted by: Matthew Lord
Category: MySQL Administrator
Status: Closed
Severity: 3
OS: Any (all)
Version: all

#25758: quoted string in ORDER BY causes GROUP BY

Mon, 22 Jan 2007 18:01:47 +0000

Bug ID: 25758
Submitted by: Matthew Lord
Category: Server
Status: Can't repeat
Severity: 2
OS: Any (all)
Version: 5.0.25+, 4.1.19+

#26183: Can't find a bug using up-level category

Thu, 08 Feb 2007 12:02:47 +0000

Bug ID: 26183
Submitted by: Sergei Kulakov
Category: bugs.mysql.com
Status: Verified
Severity: 2
OS: Any (www)
Version: http://bugs.mysql.com/search.php

#26520: offer sending a test mail to a notification group on SAVE and UPDATE

Wed, 21 Feb 2007 11:58:38 +0000

Bug ID: 26520
Submitted by: Carsten Segieth
Category: Monitoring: Web
Status: Won't fix
Severity: 4
OS: Any
Version: 1.1.0.4785

#27177: SHOW PROCESSLIST Syntax - add descriptions for state

Thu, 15 Mar 2007 15:14:31 +0000

Bug ID: 27177
Submitted by: Matthew Miller
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: All Versions

#27278: aggregate of outer query for subquery not documented

Mon, 19 Mar 2007 23:47:34 +0000

Bug ID: 27278
Submitted by: Martin Friebe
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any (*)
Version: 5.0

#27530: Incorrect calculation CRC32 value in GROUP BY requests

Thu, 29 Mar 2007 17:17:10 +0000

Bug ID: 27530
Submitted by: Philip Jayasinghe
Category: Server
Status: Closed
Severity: 3
OS: Any (pc-linux-gnu x86_64)
Version: 5.0.37-log

#28337: NOT EXISTS with GROUP BY behaves different in 5.0.40 (regression)

Wed, 09 May 2007 16:58:17 +0000

Bug ID: 28337
Submitted by: Morgan Tocker
Category: Server
Status: Closed
Severity: 2
OS: Any
Version: 5.0.40

#28526: Correlated subquery with GROUP BY on outer query returns no results in 5.0.40+

Fri, 18 May 2007 17:15:40 +0000

Bug ID: 28526
Submitted by: Zak Kipling
Category: Server
Status: Duplicate
Severity: 2
OS: Any
Version: 5.0.40, 5.0.41, 5.0.42-20070517

#28618: Skipping into the middle of a group with SQL_SLAVE_SKIP_COUNTER is possible

Wed, 23 May 2007 12:30:12 +0000

Bug ID: 28618
Submitted by: Mats Kindahl
Category: Server: Replication
Status: Closed
Severity: 2
OS: Any
Version: 5.1

#28829: replication breaks due to binlogs events written in wrong order

Fri, 01 Jun 2007 10:01:17 +0000

Bug ID: 28829
Submitted by: Shane Bester
Category: Server: Replication
Status: Duplicate
Severity: 2
OS: Any
Version: 4.1.21,5.0.44

#28888: CAST on TEXT field returns BLOB when ORDERED BY

Tue, 05 Jun 2007 01:25:07 +0000

Bug ID: 28888
Submitted by: Jim Palmer
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Any
Version: 4.0.25

#29317: COUNT() listed in other functions

Sat, 23 Jun 2007 13:42:14 +0000

Bug ID: 29317
Submitted by: Jakub Vrána
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.0

#29357: Filtering on view with group don't works.

Tue, 26 Jun 2007 11:34:42 +0000

Bug ID: 29357
Submitted by: Mauro Braggio
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: Any
Version: 5.1.19-beta-log MySQL, 5.0 BK

#29900: MySQL does not return an error to the client if INFORMAT SCHEMA fill table fails

Thu, 19 Jul 2007 14:39:11 +0000

Bug ID: 29900
Submitted by: Vasil Dimov
Category: Server: I_S
Status: Verified
Severity: 3
OS: Any
Version: 5.1.21-23

#30245: BIT type gets cast to LONG when DISTINCT or GROUP BY is used

Sun, 05 Aug 2007 20:44:23 +0000

Bug ID: 30245
Submitted by: Jeremy Cole
Category: Server
Status: Closed
Severity: 3
OS: Any
Version: 5.0/5.1

#30324: Grouping queries with COUNT(DISTINCT bit column) return wrong results

Wed, 08 Aug 2007 23:31:30 +0000

Bug ID: 30324
Submitted by: Igor Babaev
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.0-bk, 5.1-bk

#30363: TPC-D complex query slower by 2.6x to 6x times in 5.2 then in 5.1

Fri, 10 Aug 2007 17:58:19 +0000

Bug ID: 30363
Submitted by: Omer Barnir
Category: Server
Status: Closed
Severity: 5
OS: Any
Version: 5.2.4

#30368: GROUP BY primary_key query's output is not ordered when the PK is not ordered

Sat, 11 Aug 2007 02:26:54 +0000

Bug ID: 30368
Submitted by: Sergey Petrunya
Category: Server
Status: Duplicate
Severity: 3
OS: Any
Version: 4.1/5.0/5.1

#30559: Some NDB space management commands do not fail as expected

Wed, 22 Aug 2007 11:21:30 +0000

Bug ID: 30559
Submitted by: Joerg Bruehe
Category: Server: Cluster
Status: Closed
Severity: 3
OS: Any
Version: 5.1.21

#30587: mysql crashes when trying to group by TIME div NUMBER

Thu, 23 Aug 2007 08:45:12 +0000

Bug ID: 30587
Submitted by: Oleg Petrachev
Category: Server: Types
Status: Closed
Severity: 2
OS: Any
Version: 4.1, 5.0, 5.1

#30665: Inconsistent optimization of IGNORE INDEX FOR {ORDER BY|GROUP BY}

Tue, 28 Aug 2007 08:03:48 +0000

Bug ID: 30665
Submitted by: Martin Hansson
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.1.17

#30772: Exceptions in catalina.out for support zip feature as replication info disabled

Mon, 03 Sep 2007 16:34:23 +0000

Bug ID: 30772
Submitted by: Mark Leith
Category: Monitoring: Server
Status: Closed
Severity: 3
OS: Any
Version: 1.2.0.7406

#31035: select from function, group by result crasher

Fri, 14 Sep 2007 20:47:43 +0000

Bug ID: 31035
Submitted by: Shane Bester
Category: Server: General
Status: Closed
Severity: 1
OS: Any
Version: 5.0.50, 5.1.23

#31293: create logfile group/tablespace returns OK with warning when engine=myisam

Sat, 29 Sep 2007 16:57:19 +0000

Bug ID: 31293
Submitted by: Matthew Montgomery
Category: Server: DDL
Status: Closed
Severity: 3
OS: Any
Version: 5.1.22-ndb-6.3.2-telco-log

#31694: SIGSEGV in Field_string::type (this=0x80372c660) at field.h:1200

Thu, 18 Oct 2007 15:59:26 +0000

Bug ID: 31694
Submitted by: Vasil Dimov
Category: Server
Status: Can't repeat
Severity: 2
OS: Any
Version: 5.1-bk (5.1.23-beta-debug)

#31794: no syntax error on SELECT id FROM t HAVING count(*)>2;

Tue, 23 Oct 2007 18:03:45 +0000

Bug ID: 31794
Submitted by: Grigory Rubtsov
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.1.20-beta

#32155: translate the Replication group names

Tue, 06 Nov 2007 22:31:30 +0000

Bug ID: 32155
Submitted by: Sloan Childers
Category: Monitoring: Web
Status: Closed
Severity: 3
OS: Any
Version: 2.0

#32202: ORDER BY not working with GROUP BY

Thu, 08 Nov 2007 22:30:06 +0000

Bug ID: 32202
Submitted by: Gary Pendergast
Category: Server: General
Status: Closed
Severity: 2
OS: Any
Version: 5.0.50

#32256: malfunction of JOIN with 'GROUP BY ... HAVING ...' clause

Sat, 10 Nov 2007 11:56:48 +0000

Bug ID: 32256
Submitted by: Dmitry Samborskiy
Category: Server
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.0.52-BK, 5.0.45

#32400: Complex SELECT query returns correct result only on some occasions

Wed, 14 Nov 2007 22:49:54 +0000

Bug ID: 32400
Submitted by: huji huji
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.0.41/5.0BK/5.1BK

#32478: Udf HAVING problem

Sun, 18 Nov 2007 12:44:38 +0000

Bug ID: 32478
Submitted by: ngs ngs
Category: Server: UDF
Status: No Feedback
Severity: 3
OS: Any

#32481: Why different result?

Sun, 18 Nov 2007 17:03:48 +0000

Bug ID: 32481
Submitted by: ngs ngs
Category: Server: UDF
Status: No Feedback
Severity: 3
OS: Any

#32556: assert in "using index for group-by" : is_last_prefix <= 0, file .\opt_range.cc

Wed, 21 Nov 2007 05:11:55 +0000

Bug ID: 32556
Submitted by: Shane Bester
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.0.50,5.1.23,6.0.3

#32558: group by null-returning expression with rollup causes crash

Wed, 21 Nov 2007 06:46:01 +0000

Bug ID: 32558
Submitted by: Shane Bester
Category: Server: General
Status: Closed
Severity: 1
OS: Any
Version: 5.1.23

#33085: Stored functions crash server when used in select list and group by

Sat, 08 Dec 2007 13:22:51 +0000

Bug ID: 33085
Submitted by: Mark Leith
Category: Server: SP
Status: Duplicate
Severity: 2
OS: Any
Version: 5.1-BK

#33520: Description for UDF aggregate function XXX_add not correct

Thu, 27 Dec 2007 00:29:16 +0000

Bug ID: 33520
Submitted by: Roland Bouman
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.1.22

#34666: Incomplete metadata returned to client on view + group by + Innodb/Falcon

Tue, 19 Feb 2008 14:11:01 +0000

Bug ID: 34666
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.0/5.1/6.0.4

#34874: Wrong result with IN(SELECT aggregate FROM DUAL)

Wed, 27 Feb 2008 09:47:06 +0000

Bug ID: 34874
Submitted by: Gleb Shchepa
Category: Server: DML
Status: Closed
Severity: 3
OS: Any
Version: 5.0+

#35331: Crash in Field::maybe_null on view updates

Mon, 17 Mar 2008 11:18:49 +0000

Bug ID: 35331
Submitted by: Philip Stoev
Category: Server: Views
Status: Can't repeat
Severity: 3
OS: Any
Version: 6.0-falcon-team

#35954: cluster 5.1.22-rc rolling upgrade to 5.1.23-rc broken

Thu, 10 Apr 2008 06:12:49 +0000

Bug ID: 35954
Submitted by: Sean Pringle
Category: Server: Cluster
Status: Closed
Severity: 2
OS: Any
Version: 5.1.22-rc

#36007: Display which notification group(s) are subscribed to which advisors

Fri, 11 Apr 2008 22:39:03 +0000

Bug ID: 36007
Submitted by: Todd Farmer
Category: Monitoring: Web
Status: Closed
Severity: 4
OS: Any
Version: 1.3.0

#36084: name_const with negative, subquery, group by causes crash

Tue, 15 Apr 2008 08:34:27 +0000

Bug ID: 36084
Submitted by: Shane Bester
Category: Server: DML
Status: Duplicate
Severity: 3
OS: Any
Version: 5.0.58

#36460: Subqueries eliminating duplicates needed by group by

Fri, 02 May 2008 00:14:57 +0000

Bug ID: 36460
Submitted by: Barry Leslie
Category: Server
Status: Closed
Severity: 2
OS: Any
Version: 5.1

#37343: Assertion in IndexNode::parseNode, ASSERT(key - (UCHAR*) indexNode < 14);

Wed, 11 Jun 2008 13:42:35 +0000

Bug ID: 37343
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Closed
Severity: 1
OS: Any
Version: 6.0-falcon

#37348: Crash in or immediately after JOIN::make_sum_func_list

Wed, 11 Jun 2008 15:30:04 +0000

Bug ID: 37348
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.1/6.0-falcon

#37463: COLLATE possible in ORDER BY and GROUP BY, but not in both at same time

Tue, 17 Jun 2008 21:33:29 +0000

Bug ID: 37463
Submitted by: Peter Laursen
Category: Server
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.0.51b

#37769: main.error_simulation fails randomly

Tue, 01 Jul 2008 15:05:49 +0000

Bug ID: 37769
Submitted by: Alexander Nozdrin
Category: Tests
Status: Closed
Severity: 3
OS: Any
Version: 6.0-BK

#37936: ASSERT_COLUMN_MARKED_FOR_WRITE in Field_datetime::store , Field_varstring::store

Mon, 07 Jul 2008 16:07:57 +0000

Bug ID: 37936
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.1.28-bzr, 6.0, 6.0.7-bzr

#38061: select from view w/group by ignores view order

Fri, 11 Jul 2008 21:16:36 +0000

Bug ID: 38061
Submitted by: Derek Price
Category: Server: Views
Status: Not a Bug
Severity: 2
OS: Any
Version: 5.0.51a

#38326: contribution from a member of Japanese MySQL User Group about translation

Thu, 24 Jul 2008 02:50:10 +0000

Bug ID: 38326
Submitted by: Ryusuke Kajiyama
Category: MySQL Workbench
Status: Verified
Severity: 4
OS: Any
Version: 5.0.23

#39472: directly access a group or host

Tue, 16 Sep 2008 08:59:12 +0000

Bug ID: 39472
Submitted by: Bogdan Kecman
Category: Monitoring: Web
Status: Closed
Severity: 4
OS: Any
Version: 1.x, 2.0

#39656: Behaviour different for agg functions with & without where - ONLY_FULL_GROUP_BY

Fri, 26 Sep 2008 02:15:04 +0000

Bug ID: 39656
Submitted by: Kishor Grandhe
Category: Server: DML
Status: Closed
Severity: 1
OS: Any (Windows XP, Fedora 9)
Version: 5.0.67, 5.1.28

#39800: Notification emails fail when using more than one address in the group

Thu, 02 Oct 2008 03:51:40 +0000

Bug ID: 39800
Submitted by: Jonathon Coombes
Category: Monitoring: Server
Status: Can't repeat
Severity: 2
OS: Any

#39844: Query Crash Mysql Server 5.0.67

Fri, 03 Oct 2008 19:36:36 +0000

Bug ID: 39844
Submitted by: giovanni silva
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any (MS Windows SP2 - XP 5.1.2600, Linux)
Version: 5.0+

#40002: Wrong result using group by

Mon, 13 Oct 2008 14:18:12 +0000

Bug ID: 40002
Submitted by: Andre Timmer
Category: Server
Status: Can't repeat
Severity: 1
OS: Any
Version: 5.0.18

#40136: Group by is ignored when join buffer is used for an outer join

Sun, 19 Oct 2008 04:33:34 +0000

Bug ID: 40136
Submitted by: Igor Babaev
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 6.0-BKA

#40157: ndb_dd_alter fails sporadically on pushbuild

Sun, 19 Oct 2008 20:01:08 +0000

Bug ID: 40157
Submitted by: Sven Sandberg
Category: Tests: Cluster
Status: Won't fix
Severity: 7
OS: Any
Version: 5.1, 6.0

#40775: Provide rules to enable agents to be automatically added to server groups

Mon, 17 Nov 2008 09:26:25 +0000

Bug ID: 40775
Submitted by: Simon Mudd
Category: Monitoring: Server
Status: Verified
Severity: 4
OS: Any
Version: 2.0.0.7088

#40781: Browser behaviour appears different on Safari when adding servers to group

Mon, 17 Nov 2008 12:27:29 +0000

Bug ID: 40781
Submitted by: Simon Mudd
Category: Monitoring: Web
Status: Not a Bug
Severity: 3
OS: Any
Version: 2.0.0.7088

#40823: Add number of servers affected in mouse over of heatchart icons on groups

Tue, 18 Nov 2008 13:40:02 +0000

Bug ID: 40823
Submitted by: Mark Leith
Category: Monitoring: Web
Status: Closed
Severity: 4
OS: Any
Version: 2.0.0

#40999: Cluster cannot increase undo log buffer size.

Tue, 25 Nov 2008 05:34:17 +0000

Bug ID: 40999
Submitted by: Mikiya Okuno
Category: Server: ClusterDD
Status: Verified
Severity: 4
OS: Any
Version: mysql-5.1-telco-6.3

#41223: cannot remove server from self-created goup: Error U0002: You must log in to ...

Thu, 04 Dec 2008 11:53:59 +0000

Bug ID: 41223
Submitted by: Carsten Segieth
Category: Monitoring: Web
Status: Closed
Severity: 3
OS: Any
Version: 2.0.0.7105

#41890: Falcon: New execution plans with MRR cause slowdown for group of queries

Mon, 05 Jan 2009 22:53:29 +0000

Bug ID: 41890
Submitted by: Alexey Stroganov
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 6.0.9-release

#42294: errors in the upgrade process while converting the database to UTF-8

Fri, 23 Jan 2009 09:51:22 +0000

Bug ID: 42294
Submitted by: Andrejs Dubovskis
Category: Eventum
Status: Closed
Severity: 3
OS: Any
Version: 2.2

#42319: ALTER LOGFILE GROUP is not in online help

Sat, 24 Jan 2009 06:32:34 +0000

Bug ID: 42319
Submitted by: John David Duncan
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.1.30 / NDB 6.3.20

#42341: Falcon assertion (key - (UCHAR*) indexNode < 14) in IndexNode::parseNode

Mon, 26 Jan 2009 09:37:28 +0000

Bug ID: 42341
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Closed
Severity: 1
OS: Any
Version: 6.0-falcon-team

#43027: Global changes of notifications and Advisors in Enterprise Dashboard

Thu, 19 Feb 2009 16:09:52 +0000

Bug ID: 43027
Submitted by: Kyle Joiner
Category: Monitoring: Advisors/Rules
Status: Verified
Severity: 4
OS: Any
Version: 2.0

#43816: Replication group is renamed back to default after new topology discovered

Tue, 24 Mar 2009 00:57:36 +0000

Bug ID: 43816
Submitted by: Bill Weber
Category: Monitoring: Server
Status: Closed
Severity: 3
OS: Any
Version: 2.0.5.7153

#43846: Error when renaming replication group to a previous name

Tue, 24 Mar 2009 23:04:30 +0000

Bug ID: 43846
Submitted by: Bill Weber
Category: Monitoring: Server
Status: Closed
Severity: 3
OS: Any
Version: 2.0.5.7153

#44117: ORDER BY does nor work for a GROUP BY alias

Mon, 06 Apr 2009 19:22:45 +0000

Bug ID: 44117
Submitted by: Louis Breda van
Category: Server: Parser
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.1.33

#44303: Assertion failures in Field_xxx::store_xxx for materialized InsideOut semijoins

Thu, 16 Apr 2009 01:55:12 +0000

Bug ID: 44303
Submitted by: Elena Stepanova
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 6.0.10-debug, 6.0.12-debug, 5.4.4-alpha-debug

#44511: MTR2: add an option not to kill other servers when one from the group exits

Tue, 28 Apr 2009 11:21:04 +0000

Bug ID: 44511
Submitted by: Elena Stepanova
Category: Tools: MTR / mysql-test-run
Status: Closed
Severity: 4
OS: Any

#45642: Generated INSERT statements don't have database name

Sun, 21 Jun 2009 20:35:35 +0000

Bug ID: 45642
Submitted by: Mark M
Category: MySQL Workbench
Status: Closed
Severity: 2
OS: Any
Version: 5.1.14RC

#45782: Query with nested JOIN + GROUP BY sporadically returns bad results

Fri, 26 Jun 2009 10:10:30 +0000

Bug ID: 45782
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Duplicate
Severity: 2
OS: Any
Version: 5.1

#46277: differing results for equivalent queries using VAR_POP() & AVG() with DISTINCT

Fri, 17 Jul 2009 21:33:42 +0000

Bug ID: 46277
Submitted by: Patrick Crews
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.0, 5.1, 5.4, 6.0

#46356: Certain queries aren't recognizing GROUP BY w/ join_cache_level = 1

Thu, 23 Jul 2009 14:06:44 +0000

Bug ID: 46356
Submitted by: Patrick Crews
Category: Server: Optimizer
Status: Duplicate
Severity: 3
OS: Any
Version: 5.4, 6.0

#46989: NULL attribute gets lost when "CREATE TABLE AS SELECT ... GROUP BY WITH ROLLUP"

Sat, 29 Aug 2009 05:52:37 +0000

Bug ID: 46989
Submitted by: Alexander Barkov
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1,5.4

#47150: Assertion in Field_long::val_int() on MERGE + TRIGGER + multi-table UPDATE

Sat, 05 Sep 2009 11:13:49 +0000

Bug ID: 47150
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.1,5.4

#47367: Crash in Name_resolution_context::process_error

Wed, 16 Sep 2009 12:00:58 +0000

Bug ID: 47367
Submitted by: Matthias Leich
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 6.0

#47744: innodb.innodb-timeout fails sporadically

Wed, 30 Sep 2009 13:19:39 +0000

Bug ID: 47744
Submitted by: Alexander Nozdrin
Category: Tests: Engine
Status: Closed
Severity: 3
OS: Any
Version: 5.4.5 (mysql-trunk)

#47746: main.innodb_mysql fails sporadically

Wed, 30 Sep 2009 13:27:16 +0000

Bug ID: 47746
Submitted by: Alexander Nozdrin
Category: Tests: Engine
Status: Closed
Severity: 3
OS: Any
Version: 5.1

#48092: Addition of DISTINCT clause results in incorrect exclusions from result set

Thu, 15 Oct 2009 17:38:20 +0000

Bug ID: 48092
Submitted by: Patrick Crews
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.1, 6.0

#48141: UI: add servers to a group shows all servers and not only the selected ones

Mon, 19 Oct 2009 08:55:21 +0000

Bug ID: 48141
Submitted by: Carsten Segieth
Category: Monitoring: Web
Status: Closed
Severity: 3
OS: Any
Version: 2.2.0.1514

#48167: dashboard full-graph popup doesn't reflect group/server selection

Mon, 19 Oct 2009 18:54:37 +0000

Bug ID: 48167
Submitted by: Josh Sled
Category: Monitoring: Web
Status: Closed
Severity: 3
OS: Any

#48333: group/server nav tree styling regression

Mon, 26 Oct 2009 22:40:55 +0000

Bug ID: 48333
Submitted by: Josh Sled
Category: Monitoring: Web
Status: Closed
Severity: 3
OS: Any
Version: 2.2 alpha

#48736: missing node group error sometimes causes Sig 11 instead

Thu, 12 Nov 2009 16:03:40 +0000

Bug ID: 48736
Submitted by: Andrew Hutchings
Category: Server: Cluster
Status: Can't repeat
Severity: 3
OS: Any
Version: mysql-5.1-telco-6.3.26

#48760: assert in __cxa_pure_virtual called by Item_field::result_type

Fri, 13 Nov 2009 13:36:32 +0000

Bug ID: 48760
Submitted by: Matthias Leich
Category: Server: SP
Status: Duplicate
Severity: 3
OS: Any
Version: 5.1

#49453: re-execution of prepared statement with view and semijoin crashes

Fri, 04 Dec 2009 10:31:40 +0000

Bug ID: 49453
Submitted by: Tor Didriksen
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 6.0

#49632: Crash in fix_semijoin_strategies_for_picked_join_order with semijoin=on (return)

Fri, 11 Dec 2009 20:47:10 +0000

Bug ID: 49632
Submitted by: Patrick Crews
Category: Server: Optimizer
Status: Duplicate
Severity: 3
OS: Any
Version: 6.0

#50089: Second call of procedure with view in subselect crashes server

Tue, 05 Jan 2010 14:57:09 +0000

Bug ID: 50089
Submitted by: Jørgen Løland
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 6.0

#50394: Regression in EXPLAIN with index scan, LIMIT, GROUP BY and ORDER BY computed col

Sun, 17 Jan 2010 04:55:36 +0000

Bug ID: 50394
Submitted by: Morgan Tocker
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.1.41, 5.1, 5.5.99 bzr

#50539: GROUP BY + COUNT(DISTINCT ) on an int column shows results off by one

Fri, 22 Jan 2010 10:36:34 +0000

Bug ID: 50539
Submitted by: Benjamin Schuster-Böckler
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any (64bit)
Version: 5.5.0, 5.5.2-m2, 6.0.14-bzr

#50930: Cluster crash when node is restarted 255 times and encountering error 1204

Thu, 04 Feb 2010 20:41:03 +0000

Bug ID: 50930
Submitted by: Jonas Oreland
Category: Server: Cluster
Status: Closed
Severity: 3
OS: Any
Version: mysql-5.1-telco-6.2

#50939: Loose Index Scan unduly relies on engine to remember range endpoints

Fri, 05 Feb 2010 09:10:07 +0000

Bug ID: 50939
Submitted by: Martin Hansson
Category: Server: Optimizer
Status: Closed
Severity: 5
OS: Any
Version: all

#51055: Replication failure on duplicate key + traditional SQL mode

Wed, 10 Feb 2010 10:43:15 +0000

Bug ID: 51055
Submitted by: Philip Stoev
Category: Server: Replication
Status: Closed
Severity: 3
OS: Any
Version: mysql-5.1

#51745: Lack of GROUP BY fails to stop query execution with non-aggregated column

Fri, 05 Mar 2010 04:29:24 +0000

Bug ID: 51745
Submitted by: Michael McLaughlin
Category: Server: General
Status: Not a Bug
Severity: 2
OS: Any
Version: Community 5.1

#53103: MTR test ps crashes in optimize_cond() when running with --debug

Fri, 23 Apr 2010 09:34:30 +0000

Bug ID: 53103
Submitted by: Olav Sandstå
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 6.0.14

#53137: Optimizer may be confused by an index

Sat, 24 Apr 2010 00:14:03 +0000

Bug ID: 53137
Submitted by: Mikhail T
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: Any (FreeBSD 7.3/amd64, Linux)
Version: 5.0.90, 4.1, 5.0, 5.1, 5.6.99

#53534: Incorrect 'select SQL_BIG_RESULT...' with GROUP BY on subquery columns

Mon, 10 May 2010 08:50:05 +0000

Bug ID: 53534
Submitted by: Ole John Aske
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.1.44, 5.1.47, 5.1.49, 5.0, 5.6.99

#53587: what are the semantics of the rand function

Tue, 11 May 2010 22:57:03 +0000

Bug ID: 53587
Submitted by: Mark Callaghan
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.0,5.1

#54023: crash in fix_semijoin_strategies_for_picked_join_order with semijoin=off

Thu, 27 May 2010 09:54:13 +0000

Bug ID: 54023
Submitted by: John Embretsen
Category: Server: Optimizer
Status: Duplicate
Severity: 1
OS: Any
Version: 5.5.5_Celosia, 5.6.99_Dahlia, bzr_mysql-next-mr-opt-backporting

#54056: Incorrect number format in output from SELECT

Fri, 28 May 2010 06:43:51 +0000

Bug ID: 54056
Submitted by: Kristian Nielsen
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.47, 5.1.48, 5.6.99

#54407: My SQL frequent errors# 144, 2006

Thu, 10 Jun 2010 19:45:17 +0000

Bug ID: 54407
Submitted by: fareed Quraishi
Category: Server: Errors
Status: Not a Bug
Severity: 1
OS: Any

#54747: Deadlock between REORGANIZE PARTITION and SELECT is not detected

Wed, 23 Jun 2010 16:06:22 +0000

Bug ID: 54747
Submitted by: Elena Stepanova
Category: Server: Locking
Status: Closed
Severity: 3
OS: Any
Version: 5.5.3-m3, 5.5.5-m3

#54812: assert in Diagnostics_area::set_ok_status during EXPLAIN

Fri, 25 Jun 2010 14:58:50 +0000

Bug ID: 54812
Submitted by: Matthias Leich
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.1, 5.5

#54859: >2 replica: Hanging if 1 node can not be restored using REDO log during SR

Mon, 28 Jun 2010 09:12:59 +0000

Bug ID: 54859
Submitted by: Jonas Oreland
Category: Server: Cluster
Status: Closed
Severity: 3
OS: Any

#55487: Edit|Preferences|Model|Column Defaults: Types lack flag support (and validation)

Thu, 22 Jul 2010 16:22:22 +0000

Bug ID: 55487
Submitted by: Walter Stanish
Category: MySQL Workbench: Modeling
Status: Closed
Severity: 2
OS: Any (Linux, Mac OS X)
Version: 5.2.25

#56165: Bad Optimization

Sat, 21 Aug 2010 08:12:37 +0000

Bug ID: 56165
Submitted by: Serge Igitov
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.0.not_sure, 5.0, 5.1, 5.6.99 bzr

#56190: improve error messages for 'the age of the last checkpoint ..which exceeds the '

Mon, 23 Aug 2010 14:23:56 +0000

Bug ID: 56190
Submitted by: Shane Bester
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any
Version: 5.1.50, 5.5.5

#56309: turn off auto-close notification

Thu, 26 Aug 2010 19:31:26 +0000

Bug ID: 56309
Submitted by: Lig Isler-Turmelle
Category: Monitoring: Server
Status: Verified
Severity: 4
OS: Any
Version: 2.2.0

#57230: STOP SLAVE hangs if executed in parallel with a group of events

Mon, 04 Oct 2010 21:46:31 +0000

Bug ID: 57230
Submitted by: Elena Stepanova
Category: Server: Replication
Status: Won't fix
Severity: 3
OS: Any
Version: 5.1

#58081: Duplicate entry error when doing GROUP BY

Tue, 09 Nov 2010 12:29:09 +0000

Bug ID: 58081
Submitted by: Alexander Barkov
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.1.52, 5.5.8

#58655: Assertion failed, server crashes with mysqld got signal 6

Thu, 02 Dec 2010 12:38:53 +0000

Bug ID: 58655
Submitted by: Nidhi Shrotriya
Category: Server
Status: Closed
Severity: 3
OS: Any
Version: 5.1.55-debug

#60325: partition optimization

Thu, 03 Mar 2011 21:29:01 +0000

Bug ID: 60325
Submitted by: Roberto Spadim
Category: Server: Partition
Status: Verified
Severity: 3
OS: Any
Version: 5.5, 5.1.57, 5.6.3

#60867: QUERY ERROR - "WHERE" IS OMMITED

Thu, 14 Apr 2011 09:54:25 +0000

Bug ID: 60867
Submitted by: fernando diaz toledano
Category: Server
Status: No Feedback
Severity: 2
OS: Any
Version: 6.0.5-alpha-community

#61120: Ability to create real sub-folders within DB folders

Wed, 11 May 2011 00:31:21 +0000

Bug ID: 61120
Submitted by: Rich Gosselin
Category: MySQL Workbench: Modeling
Status: Won't fix
Severity: 4
OS: Any
Version: 5.2.33b - all

#61399: Wrong result with GROUP BY and indexes

Fri, 03 Jun 2011 15:03:26 +0000

Bug ID: 61399
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.5/5.0/5.1

#61468: mysqldump values() group size

Thu, 09 Jun 2011 21:54:26 +0000

Bug ID: 61468
Submitted by: Chris Wagner
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any

#61551: Loose index scan is not used for select COUNT(distinct a)

Fri, 17 Jun 2011 12:26:11 +0000

Bug ID: 61551
Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.56

#65970: AVG group function when dealing with maximum number give wrong results

Fri, 20 Jul 2012 21:50:53 +0000

Bug ID: 65970
Submitted by: calle kula
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.5.19, 5.5.26

#67196: ENUM type not treated correctly in HAVING w/ MAX()

Thu, 11 Oct 2012 21:00:08 +0000

Bug ID: 67196
Submitted by: Mark Matthews
Category: Server: InnoDB
Status: Verified
Severity: 3
OS: Any
Version: 5.5, 5.6

#67529: GROUP BY treats +0 and -0 as different values

Fri, 09 Nov 2012 00:20:43 +0000

Bug ID: 67529
Submitted by: Igor T.
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.1.41, 5.1.67, 5.5.29, 5.7.0

#68254: subquery optimize to wrong semi-join with extensions syntax to group by

Sat, 02 Feb 2013 10:31:33 +0000

Bug ID: 68254
Submitted by: lou shuai
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: Any
Version: 5.6.10

#69168: COUNT(*)...GROUP BY sometimes returns wrong results on partitioned InnoDB tables

Tue, 07 May 2013 19:20:13 +0000

Bug ID: 69168
Submitted by: Mike Andrews
Category: Server: InnoDB
Status: Closed
Severity: 2
OS: Any (FreeBSD, Linux)
Version: 5.6.11, 5.6.12

#69310: Valid SQL statement rejected in ONLY_FULL_GROUP_BY

Thu, 23 May 2013 11:47:26 +0000

Bug ID: 69310
Submitted by: Shlomi Noach
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.6, 5.0.97, 5.1.70, 5.5.32, 5.6.12, 5.7.2

#69439: Documented minimal value of innodb_log_file_size is wrong in 5.1 and 5.5

Tue, 11 Jun 2013 09:00:18 +0000

Bug ID: 69439
Submitted by: Tsubasa Tanaka
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.1.70, 5.5.32

#69824: Add support for group

Tue, 23 Jul 2013 12:42:03 +0000

Bug ID: 69824
Submitted by: Michal Hrusecky
Category: Server: Packaging
Status: Won't fix
Severity: 4
OS: Any
Version: 5.6.12

#70002: very low performance join - eq_ref and ref access broken for compound indexes

Mon, 12 Aug 2013 19:23:22 +0000

Bug ID: 70002
Submitted by: Justin Swanhart
Category: Server: Optimizer
Status: Duplicate
Severity: 2
OS: Any
Version: 5.6.13, 5.5, 5.1

#70162: Wrong result for @i:=@i+1 in query while using group by and order by

Tue, 27 Aug 2013 12:57:09 +0000

Bug ID: 70162
Submitted by: vin chen
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: Any
Version: 5.1 5.5 5.6

#70173: please remove sort aborted errors from the error log

Wed, 28 Aug 2013 07:58:50 +0000

Bug ID: 70173
Submitted by: Shane Bester
Category: Server: Optimizer
Status: Closed
Severity: 4
OS: Any
Version: 5.7.3

#70220: Grouping with a view may report 'Invalid use of group function'

Tue, 03 Sep 2013 06:14:45 +0000

Bug ID: 70220
Submitted by: Roy Lyseng
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.1,5.5, 5.6, 5.7.2-m12

#70359: Wrong result (missing rows) with group by, multi-part key, equality conditions

Mon, 16 Sep 2013 23:02:10 +0000

Bug ID: 70359
Submitted by: Elena Stepanova
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1, 5.5, 5.6, 5.7

#70548: timestamp column being set to current time

Mon, 07 Oct 2013 22:37:32 +0000

Bug ID: 70548
Submitted by: Don Cohen
Category: Server
Status: Not a Bug
Severity: 2
OS: Any
Version: 5.5.9-log

#70894: GROUP BY HAVING with MAX returns not all results

Wed, 13 Nov 2013 09:02:12 +0000

Bug ID: 70894
Submitted by: Nico Huene
Category: Server
Status: Not a Bug
Severity: 2
OS: Any
Version: 5.5, 5.6

#71140: Optimizer does NOT use range checks in typical self-join for InnoDB tables

Fri, 13 Dec 2013 09:16:24 +0000

Bug ID: 71140
Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.1, 5.5, 5.6.15, 5.7.7

#71189: Manual does not provide enough details on how loose index scan really works

Fri, 20 Dec 2013 14:56:53 +0000

Bug ID: 71189
Submitted by: Valeriy Kravchuk
Category: Server: Docs
Status: Verified
Severity: 3
OS: Any
Version: 5.5, any

#71201: More than one stage named "stage/sql/init"?

Sat, 21 Dec 2013 20:01:20 +0000

Bug ID: 71201
Submitted by: Valeriy Kravchuk
Category: Server: Performance Schema
Status: Closed
Severity: 3
OS: Any
Version: 5.6.14, 5.6.15

#71204: Timing for stages in P_S is different from what SHOW PROFILE reports

Sun, 22 Dec 2013 15:42:09 +0000

Bug ID: 71204
Submitted by: Valeriy Kravchuk
Category: Server: Performance Schema
Status: Verified
Severity: 3
OS: Any
Version: 5.6.14, 5.6.16

#71244: Wrong result computation using ALL() and GROUP BY

Mon, 30 Dec 2013 09:48:05 +0000

Bug ID: 71244
Submitted by: Ralf Adams
Category: Server: DML
Status: Closed
Severity: 2
OS: Any
Version: 5.6.15, 5.5.35, 5.1.72, 5.7.3

#71804: Unnecessary filesort when joining on unique column using group by.

Sat, 22 Feb 2014 22:29:41 +0000

Bug ID: 71804
Submitted by: Jan Filipiak
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any (sqlfiddle.com)
Version: 5.6.6 m9, 5.5.32, 5.1.61

#72098: select * from (subquery) get different result with subquery.

Fri, 21 Mar 2014 20:47:26 +0000

Bug ID: 72098
Submitted by: Ben Lin
Category: Server: DML
Status: Closed
Severity: 3
OS: Any
Version: 5.5, 5.5.38

#72119: "group add" hangs with server as localhost:32274

Mon, 24 Mar 2014 23:45:58 +0000

Bug ID: 72119
Submitted by: Alfranio Tavares Correia Junior
Category: MySQL Fabric
Status: Closed
Severity: 3
OS: Any
Version: 1.4.0

#73018: improve performance when binlog_order_commits=0 and sync_binlog >1

Tue, 17 Jun 2014 03:20:36 +0000

Bug ID: 73018
Submitted by: zhai weixiang
Category: Server: Replication
Status: Verified
Severity: 5
OS: Any
Version: 5.6

#73168: locking/unlocking overhead for THD::LOCK_thd_data

Wed, 02 Jul 2014 04:14:18 +0000

Bug ID: 73168
Submitted by: liu hickey
Category: Server: InnoDB
Status: Verified
Severity: 5
OS: Any
Version: 5.6/5.7

#73202: write/sync redo log before flush thread cache to binlog

Sat, 05 Jul 2014 00:31:15 +0000

Bug ID: 73202
Submitted by: zhai weixiang
Category: Server: InnoDB
Status: Closed
Severity: 3
OS: Any
Version: 5.6, 5.7.5

#73277: REGEXP escape of - not escaped properly in character group

Fri, 11 Jul 2014 13:23:41 +0000

Bug ID: 73277
Submitted by: Robert Pazurek
Category: Server: Parser
Status: Verified
Severity: 3
OS: Any
Version: 5.537-35.1-log, 5.0.97, 5.1.74, 5.5.39, 5.6.21, 5.7.5

#73495: MySQL Fabric database permissions need to be more clearly documented

Thu, 07 Aug 2014 08:27:48 +0000

Bug ID: 73495
Submitted by: Andrew Morgan
Category: MySQL Fabric
Status: Won't fix
Severity: 3
OS: Any
Version: 1.4.4

#73927: SELECT DISTINCT SUM() RETURNS DUPLICATE ROWS

Tue, 16 Sep 2014 10:12:17 +0000

Bug ID: 73927
Submitted by: Guilhem Bichot
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.7

#74221: ctype-ucs2.c:1545: my_strnncollsp_utf16_bin: Assertion `(slen % 2) == 0' failed.

Sat, 04 Oct 2014 06:23:14 +0000

Bug ID: 74221
Submitted by: Roel Van de Paar
Category: Server: Charsets
Status: Closed
Severity: 6
OS: Any
Version: 5.6.20

#74980: "where" condition after "group by" statement does not work/give any warnings

Mon, 24 Nov 2014 13:01:27 +0000

Bug ID: 74980
Submitted by: isa ölmez
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.5, 5.6

#75270: query results are different when opening or closing semijoin optimizer_switch

Fri, 19 Dec 2014 01:33:14 +0000

Bug ID: 75270
Submitted by: Frank Li
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 5.6.16

#75299: group commit with GTID enabled need more optimization

Tue, 23 Dec 2014 15:45:36 +0000

Bug ID: 75299
Submitted by: zhai weixiang
Category: Server: Replication
Status: Duplicate
Severity: 3
OS: Any
Version: 5.6

#75756: mysqlmonitoragent install add to group in MEM console

Tue, 03 Feb 2015 23:36:27 +0000

Bug ID: 75756
Submitted by: brendan mccauley
Category: Monitoring: Agent
Status: Not a Bug
Severity: 4
OS: Any

#75851: SHOW CREATE VIEW should retain original view formatting and definition

Tue, 10 Feb 2015 19:21:18 +0000

Bug ID: 75851
Submitted by: Justin Swanhart
Category: Server: DDL
Status: Verified
Severity: 2
OS: Any
Version: 5.6.22, 5.6.25, 5.6.27

#75890: A new feature request of slave mts apply

Fri, 13 Feb 2015 09:41:43 +0000

Bug ID: 75890
Submitted by: Fangxin Flou
Category: Server: RBR
Status: Open
Severity: 4
OS: Any
Version: 5.6.x

#76468: void Item_row::illegal_method_call(const char*): Assertion `0' failed.

Tue, 24 Mar 2015 00:06:05 +0000

Bug ID: 76468
Submitted by: Roel Van de Paar
Category: Server: DML
Status: Duplicate
Severity: 1
OS: Any
Version: 5.6.22, 5.5.44, 5.6.23, 5.6.25

#76901: binlog_max_flush_queue_time variable is not used in current MySQL 5.7

Thu, 30 Apr 2015 09:42:59 +0000

Bug ID: 76901
Submitted by: Valeriy Kravchuk
Category: Server: Options
Status: Closed
Severity: 3
OS: Any
Version: 5.7.6

#77345: The aggregate functions of MySQL is too slow, too much CPU for type convertion

Sun, 14 Jun 2015 09:26:25 +0000

Bug ID: 77345
Submitted by: Fangxin Flou
Category: Server
Status: Open
Severity: 4
OS: Any
Version: All

#77863: slowdown caused by memset in sql_digest_storage.reset()

Tue, 28 Jul 2015 19:00:43 +0000

Bug ID: 77863
Submitted by: Domas Mituzas
Category: Server: Performance Schema
Status: Closed
Severity: 5
OS: Any
Version: 5.6.26

#78181: Group by different behavior in mysql 5.6.21

Mon, 24 Aug 2015 06:59:45 +0000

Bug ID: 78181
Submitted by: Zafar Malik
Category: Server: DML
Status: Verified
Severity: 2
OS: Any
Version: 5.6.21, 5.6.26, 5.7.9

#78330: handle_fatal_signal (sig=6) in Item_row::illegal_method_call on SELECT

Sat, 05 Sep 2015 00:12:10 +0000

Bug ID: 78330
Submitted by: Roel Van de Paar
Category: Server: DML
Status: Duplicate
Severity: 1
OS: Any
Version: 5.6.23

#78360: More than 1 row is returned when using "having count(alias)"

Tue, 08 Sep 2015 06:14:27 +0000

Bug ID: 78360
Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.6.22, 5.6.26

#78380: Update rpl suite tests to work on Group Replication

Wed, 09 Sep 2015 10:58:22 +0000

Bug ID: 78380
Submitted by: Nuno Carvalho
Category: Tests: Replication
Status: Closed
Severity: 3
OS: Any
Version: 5.7.9

#78383: Bug with group by & group_concat

Wed, 09 Sep 2015 14:51:13 +0000

Bug ID: 78383
Submitted by: T. M.
Category: Server: General
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.5 / 5.6

#78508: Subquery result with aggregate function() in outer table is not understandable

Tue, 22 Sep 2015 03:20:49 +0000

Bug ID: 78508
Submitted by: Su Dylan
Category: Server: DML
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.6.22

#78512: /var/log/mysqld.log has incorrect permissions after installing server from repo

Tue, 22 Sep 2015 08:49:28 +0000

Bug ID: 78512
Submitted by: Ramana Yeruva
Category: Server: Packaging
Status: Closed
Severity: 3
OS: Any
Version: 5.7.9

#79040: please merge more temptables

Fri, 30 Oct 2015 21:49:01 +0000

Bug ID: 79040
Submitted by: Domas Mituzas
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 5.7

#79403: Switchover does not work with fabric plugin

Wed, 25 Nov 2015 07:35:59 +0000

Bug ID: 79403
Submitted by: Ted Wennmark
Category: Router
Status: Can't repeat
Severity: 1
OS: Any
Version: 2.0.2

#79564: MySQL Group Replication stop replicate on conflict operations

Wed, 09 Dec 2015 06:59:00 +0000

Bug ID: 79564
Submitted by: Ivan Tu
Category: Server: GCS
Status: Not a Bug
Severity: 3
OS: Any
Version: 0.6, 0.8

#79942: MySQL Fabric log-bin or gtid requirement logic failure

Wed, 13 Jan 2016 00:57:25 +0000

Bug ID: 79942
Submitted by: Matthew Boehm
Category: MySQL Fabric: Install/Config
Status: Won't fix
Severity: 3
OS: Any
Version: 1.6.3

#79994: HASH sharding not true HASH; implemented as RANGE

Fri, 15 Jan 2016 00:10:14 +0000

Bug ID: 79994
Submitted by: Matthew Boehm
Category: MySQL Fabric: Sharding
Status: Won't fix
Severity: 3
OS: Any

#80010: Error: 1871 when promoting an instance on H/A group (mysql 5.7.x)

Fri, 15 Jan 2016 19:27:35 +0000

Bug ID: 80010
Submitted by: Miguel Araujo
Category: MySQL Fabric: HA
Status: Closed
Severity: 3
OS: Any
Version: 1.6.3

#80310: Regression for a grouping query with DISTINCT

Tue, 09 Feb 2016 03:55:46 +0000

Bug ID: 80310
Submitted by: Igor Babaev
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.7, 5.6.29, 5.7.11

#80653: COUNT DISTINCT GROUP BY ROLLUP return wrong number

Tue, 08 Mar 2016 06:43:08 +0000

Bug ID: 80653
Submitted by: Yinghong Lu
Category: Server
Status: Closed
Severity: 2
OS: Any
Version: 5.7.10

#80846: Specific partitioned tables always place first partition on node group 0

Thu, 24 Mar 2016 10:32:35 +0000

Bug ID: 80846
Submitted by: Mikael Ronström
Category: Server: Cluster
Status: Closed
Severity: 3
OS: Any
Version: 7.5.1

#80898: Replication stops after transaction is rolled back asynchronously in master

Wed, 30 Mar 2016 05:00:23 +0000

Bug ID: 80898
Submitted by: Debarun Banerjee
Category: Server: InnoDB
Status: Closed
Severity: 3
OS: Any
Version: 5.7

#81128: Master host list overwritten by slave list when loadBalanceConnectionGroup used

Mon, 18 Apr 2016 13:41:37 +0000

Bug ID: 81128
Submitted by: Mathieu ROUSSELLE
Category: Connector/J
Status: Closed
Severity: 3
OS: Any
Version: 5.1.38

#81377: Specifying a name for view's column in CREATE VIEW makes SELECT fail

Wed, 11 May 2016 08:50:26 +0000

Bug ID: 81377
Submitted by: Guilhem Bichot
Category: Server: DDL
Status: Closed
Severity: 3
OS: Any
Version: 5.7

#81450: void make_sortkey(SORTPARAM, uchar, uchar*): Assertion `0' failed make_sortkey

Tue, 17 May 2016 05:28:07 +0000

Bug ID: 81450
Submitted by: Roel Van de Paar
Category: Server: DML
Status: Closed
Severity: 6
OS: Any
Version: 5.5.49

#81684: select + where exists( select + group by + limit) works incorrectly

Thu, 02 Jun 2016 06:05:43 +0000

Bug ID: 81684
Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 1
OS: Any
Version: 5.7.8, 5.6.30, 5.7.12

#81716: TX_ISOLATION INFORMATION SHOULD BE ADDED TO TRAN_CONTEXT_INFO (REQUIRED FOR GR)

Fri, 03 Jun 2016 16:19:51 +0000

Bug ID: 81716
Submitted by: Venkatesh Duggirala
Category: Server: Replication
Status: Closed
Severity: 3
OS: Any
Version: 5.7

#82481: MySQL Group Replication 0.8 is asynchronous

Sat, 06 Aug 2016 17:28:25 +0000

Bug ID: 82481
Submitted by: Vadim Tkachenko
Category: Server: GCS
Status: Closed
Severity: 1
OS: Any
Version: 5.7.14

#82687: group replication should not require root@'%' to exist and have privileges

Tue, 23 Aug 2016 01:59:00 +0000

Bug ID: 82687
Submitted by: Ben Krug
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any

#83246: Improve dba.validateInstance() error output to include my.cnf format

Mon, 03 Oct 2016 13:43:19 +0000

Bug ID: 83246
Submitted by: Ronald Bradford
Category: Server: DocStore: XShell
Status: Won't fix
Severity: 4
OS: Any
Version: 5.7.15-labs-gr090

#84674: Having an unresolvable hostname in group_repl should not block group replication

Wed, 25 Jan 2017 22:05:02 +0000

Bug ID: 84674
Submitted by: Kenny Gryp
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7.latest

#84710: group replication does not respect localhost IP

Mon, 30 Jan 2017 08:45:25 +0000

Bug ID: 84710
Submitted by: Giuseppe Maxia
Category: Server: GCS
Status: Duplicate
Severity: 1
OS: Any
Version: 5.7.17

#84728: Not Possible To Avoid MySQL From Starting When GR Cannot Start

Tue, 31 Jan 2017 08:22:03 +0000

Bug ID: 84728
Submitted by: Kenny Gryp
Category: Server: GCS
Status: Closed
Severity: 2
OS: Any
Version: 5.7.17

#84729: Group Replication: Block Reads On Partitioned Nodes

Tue, 31 Jan 2017 08:39:57 +0000

Bug ID: 84729
Submitted by: Kenny Gryp
Category: Server: GCS
Status: Closed
Severity: 4
OS: Any
Version: 5.7.17

#84730: Feature: Troubleshoot Group Replication Transaction Rollbacks

Tue, 31 Jan 2017 08:43:53 +0000

Bug ID: 84730
Submitted by: Kenny Gryp
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 5.7.17

#84733: Cannot Start GR with super_read_only=1

Tue, 31 Jan 2017 09:15:52 +0000

Bug ID: 84733
Submitted by: Kenny Gryp
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7.17

#84784: Group Replication nodes do not rejoin cluster after network connectivity issues

Thu, 02 Feb 2017 03:06:59 +0000

Bug ID: 84784
Submitted by: Kenny Gryp
Category: Server: GCS
Status: Closed
Severity: 2
OS: Any
Version: 5.7.17, 8.0.4

#84785: Prevent Large Transactions in Group Replication

Thu, 02 Feb 2017 03:38:40 +0000

Bug ID: 84785
Submitted by: Kenny Gryp
Category: Server: GCS
Status: Closed
Severity: 2
OS: Any
Version: 5.7.17

#84798: Group Replication can use some verbosity in the error log

Thu, 02 Feb 2017 14:32:21 +0000

Bug ID: 84798
Submitted by: Kenny Gryp
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7.17

#86254: Assertion `0' failed in Item::tmp_table_field_from_field_type

Wed, 10 May 2017 04:39:50 +0000

Bug ID: 86254
Submitted by: Roel Van de Paar
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.7.17

#86515: Statstistics for binlog group commits

Wed, 31 May 2017 06:43:32 +0000

Bug ID: 86515
Submitted by: Bhupinder Singh
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any
Version: 5.7

#86581: GCS timeout waiting for executing stop group_replication when loss majority

Mon, 05 Jun 2017 04:48:54 +0000

Bug ID: 86581
Submitted by: jianxin chen
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 5.7.18

#86859: Group Replication does not honor skip-name-resolve

Thu, 29 Jun 2017 04:23:29 +0000

Bug ID: 86859
Submitted by: Jesper wisborg Krogh
Category: Server: GCS
Status: Closed
Severity: 2
OS: Any
Version: 5.7.18

#87207: select distinct with secondary key for 'Using index for group-by' bad results

Wed, 26 Jul 2017 13:56:32 +0000

Bug ID: 87207
Submitted by: Shane Bester
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.7.18

#87295: Test group_replication.gr_single_primary_majority_loss_1 produces warnings

Thu, 03 Aug 2017 08:16:20 +0000

Bug ID: 87295
Submitted by: Laurynas Biveinis
Category: Tests: Group Replication
Status: Verified
Severity: 3
OS: Any
Version: 8.0.2

#87560: XA PREPARE log order error in replication and binlog recovery

Mon, 28 Aug 2017 09:14:28 +0000

Bug ID: 87560
Submitted by: Wei Zhao
Category: Server: XA
Status: Verified
Severity: 2
OS: Any
Version: mysql-5.7.17

#87577: Field* Item::tmp_table_field_from_field_type(TABLE*, bool):Assertion `0' failed

Tue, 29 Aug 2017 10:23:56 +0000

Bug ID: 87577
Submitted by: Roel Van de Paar
Category: Server: DML
Status: Duplicate
Severity: 1
OS: Any
Version: 5.7.19

#87719: cant't change master info for group replication

Sun, 10 Sep 2017 13:12:57 +0000

Bug ID: 87719
Submitted by: victor zheng
Category: Server
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.7.18

#87780: Unwarranted error indicating window name not defined

Fri, 15 Sep 2017 21:25:00 +0000

Bug ID: 87780
Submitted by: Dag Wanvik
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 8.0.3

#88005: Figure 17.13 seems incorrect in group replication document

Fri, 06 Oct 2017 04:39:32 +0000

Bug ID: 88005
Submitted by: 黄炎-爱可生
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.7

#88053: too few rows when query contains group_concat, left join, and no group by

Wed, 11 Oct 2017 09:05:42 +0000

Bug ID: 88053
Submitted by: Shane Bester
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.7.19

#88120: Backport BUG#26277771 to 5.7

Tue, 17 Oct 2017 11:22:25 +0000

Bug ID: 88120
Submitted by: Nuno Carvalho
Category: Server: Replication
Status: Closed
Severity: 3
OS: Any
Version: 5.7.17

#88668: UNISTALL Group Replication can deadlock with GR Start on server start

Mon, 27 Nov 2017 17:30:51 +0000

Bug ID: 88668
Submitted by: Pedro Gomes
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.4

#88830: With plugin-load and typo debugger aborts with missing DBUG_RETURN in '?func'

Fri, 08 Dec 2017 09:55:20 +0000

Bug ID: 88830
Submitted by: Narendra Singh Chauhan
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 9.0.0

#89196: Please add GTID in applier error messages.

Thu, 11 Jan 2018 19:16:21 +0000

Bug ID: 89196
Submitted by: Jean-François Gagné
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any
Version: 5.7.20, 8.0.3

#89287: Enforce that all members do have the same lower_case_table_names value

Wed, 17 Jan 2018 15:49:50 +0000

Bug ID: 89287
Submitted by: Nuno Carvalho
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 5.7.21

#89743: Missing an efficient way of getting the last row in each group of an index

Wed, 21 Feb 2018 06:40:58 +0000

Bug ID: 89743
Submitted by: Yoseph Phillips
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 8.0

#89914: Debug assert when executing create resource group in stored function

Mon, 05 Mar 2018 14:12:12 +0000

Bug ID: 89914
Submitted by: Sven Sandberg
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 8.0

#89918: Operation with user-defined variables depends on index

Mon, 05 Mar 2018 17:06:23 +0000

Bug ID: 89918
Submitted by: jocelyn fournier
Category: Server
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.5, 5.6, 5.7, 8

#90398: Duplicate entry for key '' error

Thu, 12 Apr 2018 04:16:46 +0000

Bug ID: 90398
Submitted by: Yoseph Phillips
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 5.7.17 EE, 5.7.22

#90599: Window function with RAND() is not random with GROUP BY

Tue, 24 Apr 2018 09:41:10 +0000

Bug ID: 90599
Submitted by: Daniël van Eeden
Category: Server: DML
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0.11

#91876: PREPARED statement fails for SET RESOURCE GROUP

Thu, 02 Aug 2018 17:52:29 +0000

Bug ID: 91876
Submitted by: Kedar Vaijanapurkar
Category: Server: PS
Status: Closed
Severity: 3
OS: Any
Version: 8, 8.0.12

#92209: AVG(YEAR(datetime_field)) makes an error result beacuse of overflow

Tue, 28 Aug 2018 11:08:54 +0000

Bug ID: 92209
Submitted by: Pin Lin
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 8.0.12, 5.7.23, 5.6.41, 5.5.61

#93212: Some threads are not registered in the global thread manager

Thu, 15 Nov 2018 15:34:58 +0000

Bug ID: 93212
Submitted by: Pedro Gomes
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.13

#93586: Query state "Removing duplicates"

Thu, 13 Dec 2018 09:50:20 +0000

Bug ID: 93586
Submitted by: Aftab Khan
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 8.0, 8.0.13

#93599: Columns not named in group by clause should increase warnings in P_S tables

Thu, 13 Dec 2018 20:21:18 +0000

Bug ID: 93599
Submitted by: Oli Sennhauser
Category: Server: Performance Schema
Status: Verified
Severity: 4
OS: Any

#93703: EXPLAIN SELECT returns inconsistent number of ROWS in main.group_by

Thu, 20 Dec 2018 12:30:31 +0000

Bug ID: 93703
Submitted by: Przemysław Skibiński
Category: Server: Tests
Status: Verified
Severity: 7
OS: Any
Version: 8.0.13, 8.0.14

#93875: mysqldump per-table dump is slow since 5.7 on instances with many tables

Thu, 10 Jan 2019 13:25:29 +0000

Bug ID: 93875
Submitted by: Nikolai Ikhalainen
Category: Client: mysqldump
Status: Closed
Severity: 3
OS: Any
Version: 5.7.24, 8.0.13

#94014: Primary / Secondary role not shown in P_S.replication_group_members

Wed, 23 Jan 2019 09:11:21 +0000

Bug ID: 94014
Submitted by: Matthias Crauwels
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.7

#94224: [5.6] Optimizer reconsiders index based on index definition order, not value

Wed, 06 Feb 2019 16:45:32 +0000

Bug ID: 94224
Submitted by: Domas Mituzas
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any (any)
Version: 5.6, 5.6.43

#95306: _get_communication_protocol() fails if one or more members are RECOVERING

Wed, 08 May 2019 17:20:19 +0000

Bug ID: 95306
Submitted by: Miguel Araujo
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.17

#96447: Group Replication Clone process might conflict with recovery phase 0

Wed, 07 Aug 2019 10:59:12 +0000

Bug ID: 96447
Submitted by: Pedro Gomes
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0.17

#97101: Allow CREATE TABLE ... SELECT ... to work with group replication

Fri, 04 Oct 2019 04:53:47 +0000

Bug ID: 97101
Submitted by: Yoseph Phillips
Category: Server: GCS
Status: Closed
Severity: 4
OS: Any

#97149: S.O.S order by in sub query not working

Tue, 08 Oct 2019 23:30:36 +0000

Bug ID: 97149
Submitted by: musef habra
Category: Server
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.7.18

#97540: errors not showing on ps.replication_applier_status_by_worker on single applier

Thu, 07 Nov 2019 17:59:48 +0000

Bug ID: 97540
Submitted by: Nuno Carvalho
Category: Server: GCS
Status: Closed
Severity: 3
OS: Any
Version: 8.0

#98070: Optimize write performance when group commit

Wed, 25 Dec 2019 12:33:49 +0000

Bug ID: 98070
Submitted by: Zhao Jianwei
Category: Server: Replication
Status: Verified
Severity: 5
OS: Any
Version: 8.0.18

#98151: group replication with wrong member_state after server shutdown

Wed, 08 Jan 2020 01:03:59 +0000

Bug ID: 98151
Submitted by: phoenix Zhang
Category: Server: GCS
Status: Can't repeat
Severity: 3
OS: Any
Version: 8.0.18

#98473: group replication will be block after lock table

Tue, 04 Feb 2020 04:18:59 +0000

Bug ID: 98473
Submitted by: phoenix Zhang
Category: Server: GCS
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0.18

#98663: ROLLUP output is not reasonable when same fields exist in the group by syntax

Wed, 19 Feb 2020 10:53:13 +0000

Bug ID: 98663
Submitted by: Hope Lee
Category: Server: DML
Status: Closed
Severity: 3
OS: Any
Version: 8.0.16

#98682: Parameter names in error message are omitted "group_replciation" prefix

Thu, 20 Feb 2020 10:27:51 +0000

Bug ID: 98682
Submitted by: Tsubasa Tanaka
Category: Server: Errors
Status: Closed
Severity: 3
OS: Any
Version: 8.0.19

#99158: x$memory_global_by_current_bytes is not same as memory_global_by_current_bytes

Thu, 02 Apr 2020 10:35:30 +0000

Bug ID: 99158
Submitted by: lalit Choudhary
Category: Server: SYS Schema
Status: Verified
Severity: 3
OS: Any
Version: 8.0, 8.0.19

#99679: stop group_replication will assert

Mon, 25 May 2020 02:32:23 +0000

Bug ID: 99679
Submitted by: phoenix Zhang
Category: Server
Status: Can't repeat
Severity: 3
OS: Any
Version: 8.0.18

#100259: decimal returned function value overflow when group by

Mon, 20 Jul 2020 04:41:41 +0000

Bug ID: 100259
Submitted by: andy zhang
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 8.0,5.6.48, 5.7.31, 8.0.21

#100268: 8.0.20: LEFT JOIN w/ unique index does not work properly w/ non-strict GROUP BY

Mon, 20 Jul 2020 17:13:00 +0000

Bug ID: 100268
Submitted by: Ephi Blanshey
Category: Server: DML
Status: Not a Bug
Severity: 2
OS: Any
Version: 8.0.20

#100962: memory_summary_%_by_event_name Have different values

Sat, 26 Sep 2020 05:17:06 +0000

Bug ID: 100962
Submitted by: hongyu dong
Category: Server: Performance Schema
Status: Analyzing
Severity: 3
OS: Any
Version: 5.7

#101111: document bug

Sat, 10 Oct 2020 02:30:53 +0000

Bug ID: 101111
Submitted by: Ronggang Yu
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any

#101274: Clone Operation succeed but node failing join GR when relay logs are present

Thu, 22 Oct 2020 11:45:16 +0000

Bug ID: 101274
Submitted by: Marco Tusa
Category: Server: GCS
Status: No Feedback
Severity: 2
OS: Any
Version: 8.0.22

#101514: The requirements of Group Replication is not complete.

Mon, 09 Nov 2020 04:46:31 +0000

Bug ID: 101514
Submitted by: Zhou Shu
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.7, 8.0

#101515: The requirements of Group Replication are not complete.

Mon, 09 Nov 2020 04:50:18 +0000

Bug ID: 101515
Submitted by: Zhou Shu
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.7, 8.0

#101521: The user/group permission should be specified about system variable 'datadir'

Mon, 09 Nov 2020 07:35:19 +0000

Bug ID: 101521
Submitted by: Zhou Shu
Category: Server: Docs
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.7

#101691: Use substring_index and rank() in a sql cause wrong result

Fri, 20 Nov 2020 07:25:33 +0000

Bug ID: 101691
Submitted by: Baolin Huang
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.22, 8.0.17, 8.0.18

#102169: tinyint DIV a small value expression return wrong

Thu, 07 Jan 2021 09:42:20 +0000

Bug ID: 102169
Submitted by: zetao wei
Category: Server: DML
Status: Verified
Severity: 2
OS: Any
Version: 8.0.18, 5.6.50, 5.7.32, 8.0.22

#102886: 1.3 MySQL 8.0 の新機能（リソース管理～）

Tue, 09 Mar 2021 13:21:31 +0000

Bug ID: 102886
Submitted by: Hiroyasu Matsuhisa
Category: Server: Docs JP
Status: Closed
Severity: 3
OS: Any
Version: 8.0.23

#103027: prepare execute result is different from a query execute directly

Thu, 18 Mar 2021 03:21:39 +0000

Bug ID: 103027
Submitted by: Guo Wenxuan
Category: Server: PS
Status: Not a Bug
Severity: 2
OS: Any
Version: 8.0.23

#103194: Prepare execution result is wrong

Fri, 02 Apr 2021 08:02:12 +0000

Bug ID: 103194
Submitted by: Guo Wenxuan
Category: Server: DML
Status: Not a Bug
Severity: 2
OS: Any
Version: 8.0.23

#103296: Aggregate function group by primary key/non-primary key has differnet result

Tue, 13 Apr 2021 05:35:40 +0000

Bug ID: 103296
Submitted by: Shenghui Wu
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.22, 5.7.33, 8.0.23

#103316: Group replication assertion / memory corruption

Wed, 14 Apr 2021 11:49:39 +0000

Bug ID: 103316
Submitted by: Marcelo Altmann
Category: Server: GCS
Status: Verified
Severity: 6
OS: Any
Version: 8.0.23

#103317: Using temptable, query with many columns and group by clause alerts 1022 error

Wed, 14 Apr 2021 11:50:19 +0000

Bug ID: 103317
Submitted by: Steven Duan
Category: Server: InnoDB
Status: Duplicate
Severity: 6
OS: Any
Version: 8.0.18/8.0.22/8.0.23

#103583: Dump/Restore fails with nested VIEWS having ROLLUP over DISTINCT groups

Wed, 05 May 2021 08:21:19 +0000

Bug ID: 103583
Submitted by: Ronald Stutz
Category: Server: DDL
Status: Closed
Severity: 1
OS: Any
Version: 8.0.24, 8.0.23, 8.0.21

#103961: Error: "Unknown column 'foo' in 'having clause'" when using function in HAVING

Wed, 09 Jun 2021 14:01:23 +0000

Bug ID: 103961
Submitted by: Laurents Meyer
Category: Server
Status: Not a Bug
Severity: 2
OS: Any
Version: 8.0.25

#104023: Wrong translation in 8.2.1.1 WHERE 句の最適化

Tue, 15 Jun 2021 09:15:46 +0000

Bug ID: 104023
Submitted by: Tsubasa Tanaka
Category: Server: Docs JP
Status: Verified
Severity: 3
OS: Any
Version: 8.0

#104523: Improve logging of GCS communication issues.

Tue, 03 Aug 2021 14:44:49 +0000

Bug ID: 104523
Submitted by: Simon Mudd
Category: Server: GCS
Status: Closed
Severity: 4
OS: Any
Version: 8.0.26

#104527: SELECT incorrectly shows NULL first time for user-defined variable

Wed, 04 Aug 2021 01:42:48 +0000

Bug ID: 104527
Submitted by: George McGinn
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any (20.04)
Version: 8.0

#105170: wrong data returned grouping on substring and bit

Fri, 08 Oct 2021 09:03:53 +0000

Bug ID: 105170
Submitted by: Simon Sawyer
Category: Server: Types
Status: Verified
Severity: 3
OS: Any (v10)
Version: 5.7

#105289: Optimizer choose index scan but not index range for query with range condition

Thu, 21 Oct 2021 14:54:36 +0000

Bug ID: 105289
Submitted by: Ze Yang
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.7

#105437: Wrong answer when got multiple count(distinct)

Wed, 03 Nov 2021 07:53:54 +0000

Bug ID: 105437
Submitted by: jiangtao guo
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
OS: Any
Version: 8.0.23

#105526: Query result is incompatible with the SQL standard

Thu, 11 Nov 2021 09:00:06 +0000

Bug ID: 105526
Submitted by: Yukun Liang
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.7

#106463: Running DDL queries in a Multi-Primary Cluster

Tue, 15 Feb 2022 10:55:53 +0000

Bug ID: 106463
Submitted by: IGG t
Category: Server: Shell IDC
Status: Closed
Severity: 4
OS: Any
Version: 8.0.28

#106623: Incorrect multi-index hint example

Wed, 02 Mar 2022 22:01:11 +0000

Bug ID: 106623
Submitted by: Matt Lord
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 8.0

#106754: Index-loose scan doesn't work for signle table partition Query

Thu, 17 Mar 2022 07:06:01 +0000

Bug ID: 106754
Submitted by: raolh rao
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 5.7, 8.0, 5.7.37, 8.0.28

#107663: Assertion `keyparts > 0' failed in MySQL 8.0.29

Sun, 26 Jun 2022 14:56:14 +0000

Bug ID: 107663
Submitted by: Wang Ke
Category: Server: Optimizer
Status: Verified
Severity: 6
OS: Any
Version: 8.0.29

#108339: dba.rebootClusterFromCompleteOutage() hanging

Tue, 30 Aug 2022 18:16:29 +0000

Bug ID: 108339
Submitted by: Jay Janssen
Category: Server: Shell CLI
Status: Closed
Severity: 2
OS: Any
Version: 8.0.30

#108421: Events remain in SLAVESIDE_DISABLED after a node is promoted to PRIMARY in GR

Wed, 07 Sep 2022 21:52:29 +0000

Bug ID: 108421
Submitted by: Marcos Albe
Category: Server: GCS
Status: Not a Bug
Severity: 2
OS: Any
Version: 8.0.29

#108582: mysqldump with --compatible=ANSI displays error

Thu, 22 Sep 2022 17:57:14 +0000

Bug ID: 108582
Submitted by: Power Gamer
Category: Client: mysqldump
Status: Verified
Severity: 3
OS: Any
Version: 8.0

#108824: GCS_DEBUG_TRACE log not possible to rotate/archive without downtime

Wed, 19 Oct 2022 10:21:12 +0000

Bug ID: 108824
Submitted by: Przemyslaw Malkowski
Category: Server: GCS
Status: Verified
Severity: 3
OS: Any
Version: 8.0.31

#109361: MySQL 8.0.29+ is slower than MySQL 8.0.28 with queries using JOINS

Tue, 13 Dec 2022 12:06:55 +0000

Bug ID: 109361
Submitted by: Satya Bodapati
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any
Version: 8.0.29

#109897: Field_double::val_str causes string truncation

Thu, 02 Feb 2023 10:08:26 +0000

Bug ID: 109897
Submitted by: haizhen xue
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.31

#110155: Improve GR error MY-013780 reporting

Tue, 21 Feb 2023 14:07:42 +0000

Bug ID: 110155
Submitted by: Simon Mudd
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 8.0.32

#111057: group by or distinct clause result doesn't match collation expectation

Wed, 17 May 2023 12:23:39 +0000

Bug ID: 111057
Submitted by: wei lee
Category: Server
Status: Closed
Severity: 3
OS: Any
Version: 8.0.30

#111095: Enhance film_list view by GROUP_CONCATing category.name column values

Sun, 21 May 2023 09:42:44 +0000

Bug ID: 111095
Submitted by: Jin Kwon
Category: Server: Docs
Status: Unsupported
Severity: 3
OS: Any

#111210: please add weight to replication_group_members

Wed, 31 May 2023 06:40:29 +0000

Bug ID: 111210
Submitted by: Simon Mudd
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any
Version: 8.0

#111415: Correlated group query wrong result

Wed, 14 Jun 2023 09:39:11 +0000

Bug ID: 111415
Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0

#111706: Incorrect result

Mon, 10 Jul 2023 08:24:55 +0000

Bug ID: 111706
Submitted by: Doris Li
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.28, 8.0.33

#112001: Wrong Authorized User

Wed, 09 Aug 2023 03:27:58 +0000

Bug ID: 112001
Submitted by: Haoyuan Zhang
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 8.0, 8.1

#112011: RESOURCE GROUP hint fails when used within a prepared statement

Wed, 09 Aug 2023 12:06:34 +0000

Bug ID: 112011
Submitted by: Iwo P
Category: Server: PS
Status: Verified
Severity: 3
OS: Any
Version: 8.0

#112103: The query takes too long to execute with no results

Fri, 18 Aug 2023 02:02:16 +0000

Bug ID: 112103
Submitted by: Sakurajima Mai
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Any

#112212: Subquery to derived result mismatch(HASH JOIN/BNL JOIN result mismatch)

Tue, 29 Aug 2023 16:01:50 +0000

Bug ID: 112212
Submitted by: Ze Yang
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.34

#112293: Wrong result if non-breaking space is contained in varchar

Thu, 07 Sep 2023 14:04:56 +0000

Bug ID: 112293
Submitted by: quan chen
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 8.0, 8.0.34, 5.7.43

#112390: The group by combined with GROUP_CONCAT will return undefined result

Tue, 19 Sep 2023 14:58:54 +0000

Bug ID: 112390
Submitted by: karry zhang
Category: Server
Status: Not a Bug
Severity: 3
OS: Any
Version: MySQL 5.7

#112951: Assertion `fixed' failed in MySQL 8.1.0

Fri, 03 Nov 2023 10:05:40 +0000

Bug ID: 112951
Submitted by: Wang Ke
Category: Server: DDL
Status: Verified
Severity: 6
OS: Any
Version: 8.1.0, 8.0.35, 8.2.0

#113211: The latest version 8.0 returns abnormal results for complex queries

Fri, 24 Nov 2023 12:14:39 +0000

Bug ID: 113211
Submitted by: Bob Wong
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.0.35, 8.1.0, 8.2.0

#113384: Queried with partitions,returned result is error

Sat, 09 Dec 2023 08:05:18 +0000

Bug ID: 113384
Submitted by: Alice Alice
Category: Server: Types
Status: Verified
Severity: 3
OS: Any
Version: 8.0

#113548: Cloning failing in Mysql Group replication

Thu, 04 Jan 2024 07:38:10 +0000

Bug ID: 113548
Submitted by: Pravata Dash
Category: Server: GCS
Status: Duplicate
Severity: 2
OS: Any
Version: 8.0.34-26

#114186: Make ANY_VALUE standard compliant

Fri, 01 Mar 2024 15:32:59 +0000

Bug ID: 114186
Submitted by: Markus Winand
Category: Server: DML
Status: Verified
Severity: 4
OS: Any
Version: 8.0

#114282: Inconsistent result may caused by group by NULL

Fri, 08 Mar 2024 13:10:53 +0000

Bug ID: 114282
Submitted by: Ye Shiyang
Category: Server: DML
Status: Verified
Severity: 2
OS: Any
Version: 8.35, 8.0.36

#114312: Item_ref::used_tables wrong when ref to a rollup constant

Tue, 12 Mar 2024 06:30:40 +0000

Bug ID: 114312
Submitted by: Xinhao Zhao
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 8.0

#114358: Access denied when SECONDARY connect to PRIMARY

Thu, 14 Mar 2024 18:21:14 +0000

Bug ID: 114358
Submitted by: Bing Ma
Category: Server: Shell OPR
Status: Not a Bug
Severity: 1
OS: Any
Version: 2.1.1

#114666: Incorrect results for combination of left join, match & group by

Wed, 17 Apr 2024 11:28:35 +0000

Bug ID: 114666
Submitted by: Tom Ward
Category: Server: FTS
Status: Verified
Severity: 6
OS: Any
Version: 8.0

#114725: sometimes sidecar container will complain kopf._cogs.clients.errors.APIForbidden

Mon, 22 Apr 2024 09:05:15 +0000

Bug ID: 114725
Submitted by: Bing Ma
Category: Server: Shell OPR
Status: Can't repeat
Severity: 2
OS: Any
Version: 8.3.0-2.1.2

#114884: Incorrect inner join with group by execution

Sun, 05 May 2024 09:03:50 +0000

Bug ID: 114884
Submitted by: Xiu Tang
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.2.0, 8.0.37

#114885: Incorrect group by execution

Sun, 05 May 2024 09:07:29 +0000

Bug ID: 114885
Submitted by: Xiu Tang
Category: Server: Optimizer
Status: Documenting
Severity: 1
OS: Any
Version: 8.2.0, 8.0.37

#114886: Incorrect semi-join with group by execution

Sun, 05 May 2024 09:16:47 +0000

Bug ID: 114886
Submitted by: Xiu Tang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.2.0, 8.0.37

#114887: Incorrect Muti-table join with group by execution

Sun, 05 May 2024 09:20:01 +0000

Bug ID: 114887
Submitted by: Xiu Tang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.2.0, 8.0.37

#114934: In Heavy workload, it degenerates to use single thread replication in fact

Thu, 09 May 2024 07:33:07 +0000

Bug ID: 114934
Submitted by: Cai Minshen
Category: Server: Replication
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.7.44

#114982: Query result about list partition table is incorrect

Mon, 13 May 2024 11:47:33 +0000

Bug ID: 114982
Submitted by: hel le
Category: Server: Partition
Status: Verified
Severity: 2
OS: Any
Version: 8.0

#115132: group by with COLLATE return unexpected result

Mon, 27 May 2024 02:48:58 +0000

Bug ID: 115132
Submitted by: Yang Yu
Category: Server: Charsets
Status: Can't repeat
Severity: 3
OS: Any
Version: 8.0.32

#115351: page tracking cannot find stop point

Mon, 17 Jun 2024 04:32:34 +0000

Bug ID: 115351
Submitted by: gang liu
Category: Server: InnoDB
Status: Can't repeat
Severity: 3
OS: Any
Version: mysql-8.0.32

#115796: derived_merge affect exists-subselect condition pushdown

Thu, 08 Aug 2024 10:18:44 +0000

Bug ID: 115796
Submitted by: tianfeng li
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.30,8.4.0

#115983: Implicit internal temp table reports ’The table '/tmp/#sql_XXX'‘ is full;

Tue, 03 Sep 2024 02:27:46 +0000

Bug ID: 115983
Submitted by: Fan Lyu
Category: Server: InnoDB
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.7.44

#116010: grouping connections

Thu, 05 Sep 2024 10:27:40 +0000

Bug ID: 116010
Submitted by: IGG t
Category: Server: Shell VSC
Status: Verified
Severity: 4
OS: Any
Version: 1.16.x

#116027: The Problems with Paxos Variant Algorithms in Group Replication

Fri, 06 Sep 2024 11:37:54 +0000

Bug ID: 116027
Submitted by: Bin Wang
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any

#116476: Changing Characterset from Latin1 to utf8mb4 across DBs and Tables.

Fri, 25 Oct 2024 04:50:49 +0000

Bug ID: 116476
Submitted by: Kishan Kumar
Category: Server: Charsets
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0.28

#116484: Unexpected Performance Dropdown for Query 11 in TPC-H

Sat, 26 Oct 2024 20:54:04 +0000

Bug ID: 116484
Submitted by: JINSHENG BA
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 596f0d23 (9.0.0), 9.1.0

#117214: inconsistent result of two equivalent query

Thu, 16 Jan 2025 08:10:28 +0000

Bug ID: 117214
Submitted by: chi zhang
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0

#118216: read replica gives error for "select group_replication_get_write_concurrency();"

Fri, 16 May 2025 14:13:42 +0000

Bug ID: 118216
Submitted by: Keith Hollman
Category: Server: GCS
Status: Verified
Severity: 4
OS: Any (5.14.0-503.29.1.el9_5.x86_64)
Version: 8.0.40

#118310: a query with a impossile having clause, return wrong results

Fri, 30 May 2025 03:36:27 +0000

Bug ID: 118310
Submitted by: SamonBing SamonBing
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41

#118336: after adding a having clause equivalent to "having 1", the returned result set is wrong

Tue, 03 Jun 2025 08:24:32 +0000

Bug ID: 118336
Submitted by: SamonBing SamonBing
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41

#118398: Using temporary with avg cause wrong result

Mon, 09 Jun 2025 08:00:33 +0000

Bug ID: 118398
Submitted by: haizhen xue
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41

#118835: A query statement that returns 0/FALSE in the having clause, the returned result is not null.

Thu, 14 Aug 2025 02:56:22 +0000

Bug ID: 118835
Submitted by: Alice Alice
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41

#118836: adding a having clause that return 1/TRUE, the query returns a different and wrong empty result.

Thu, 14 Aug 2025 03:01:10 +0000

Bug ID: 118836
Submitted by: Alice Alice
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41

#118837: After having(col) in the query statement is changed to having min(col), the returned result is incorrect.

Thu, 14 Aug 2025 03:05:17 +0000

Bug ID: 118837
Submitted by: Alice Alice
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41

#118875: set optimizer_switch='block_nested_loop=off/on', result is different.

Thu, 21 Aug 2025 12:42:01 +0000

Bug ID: 118875
Submitted by: Alice Alice
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41, 8.0.43

#119022: column value change cased by Union ALL

Wed, 17 Sep 2025 12:40:11 +0000

Bug ID: 119022
Submitted by: cl hl
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 9.4.0

#119047: column value change cased by Union ALL

Sat, 20 Sep 2025 07:31:46 +0000

Bug ID: 119047
Submitted by: cl hl
Category: Server
Status: Duplicate
Severity: 3
OS: Any
Version: 9.4.0

#119055: column value change cased by AVG() changed to SUM()/COUNT()

Mon, 22 Sep 2025 15:14:23 +0000

Bug ID: 119055
Submitted by: cl hl
Category: Server
Status: Duplicate
Severity: 3
OS: Any
Version: 9.4.0

#119056: column value change cased by SUM(DISTINCT) changed to AVG(DISTINCT)*COUNT(DISTINCT)

Mon, 22 Sep 2025 15:21:11 +0000

Bug ID: 119056
Submitted by: cl hl
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 9.4.0

#119114: Column Value change caused by COUNT(column) --->COUNT(DISTINCT column)

Wed, 08 Oct 2025 07:54:06 +0000

Bug ID: 119114
Submitted by: cl hl
Category: Server
Status: Not a Bug
Severity: 3
OS: Any
Version: 9.4.0

#119165: unexpected value after changing Max to Min

Thu, 16 Oct 2025 05:46:39 +0000

Bug ID: 119165
Submitted by: cl hl
Category: Server: Charsets
Status: Not a Bug
Severity: 3
OS: Any
Version: 9.4.0

#119225: weedout not work for rematerialized temptable

Fri, 24 Oct 2025 09:11:35 +0000

Bug ID: 119225
Submitted by: jump mason
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.43

#119321: Unexpected None after changing SUM to SUM (x*2)

Fri, 07 Nov 2025 04:35:20 +0000

Bug ID: 119321
Submitted by: cl hl
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 9.4.0

#119322: Unexpected None after adding a window column

Fri, 07 Nov 2025 04:58:40 +0000

Bug ID: 119322
Submitted by: cl hl
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 9.4.0

#119323: row number become less after changing COUNT(DISTINCT) to COUNT

Fri, 07 Nov 2025 05:59:26 +0000

Bug ID: 119323
Submitted by: cl hl
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 9.4.0

#119327: after adding an index ,the result return different

Fri, 07 Nov 2025 07:52:07 +0000

Bug ID: 119327
Submitted by: cl hl
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.45

#119329: Column name unexpectedly change after changing COUNT to COUNT(DISTINCT)

Fri, 07 Nov 2025 08:13:38 +0000

Bug ID: 119329
Submitted by: cl hl
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.44

#119360: Result inconsistency due to sorting in temporary tables

Tue, 11 Nov 2025 08:42:09 +0000

Bug ID: 119360
Submitted by: Go Yakult
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41

#119446: rows become more after changing COUNT to COUNT(DISTINCT)

Sun, 23 Nov 2025 06:46:00 +0000

Bug ID: 119446
Submitted by: cl hl
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 9.4.0

#119634: MySQL Operator backup can fail on Ready pods that haven't fully joined cluster yet

Tue, 06 Jan 2026 21:04:13 +0000

Bug ID: 119634
Submitted by: Thomas Rock
Category: Server: Shell OPR
Status: Open
Severity: 3
OS: Any
Version: 9.4.0-2.2.5

#119679: after changing SUM(t3.c9) to -SUM(-t3.c9),the rows become less

Wed, 14 Jan 2026 13:40:55 +0000

Bug ID: 119679
Submitted by: cl hl
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.45

#119680: after changing AVG(cte.col_2) to -AVG(-cte.col_2) ,rows become less

Wed, 14 Jan 2026 13:51:07 +0000

Bug ID: 119680
Submitted by: cl hl
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.44

#119701: after changing FLOOR function,col_1’s value unexpectedly change

Fri, 16 Jan 2026 07:18:32 +0000

Bug ID: 119701
Submitted by: Aaditya Dubey
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.44

#119702: after changing max to -min(-),the col_3’s floating-precission loss appear

Fri, 16 Jan 2026 07:21:34 +0000

Bug ID: 119702
Submitted by: Aaditya Dubey
Category: Server
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0.x, 8.4.x

#119741: internal_tmp_mem_storage_engine = MEMORY setting makes the DISTINCTROW returns incorrect result on 0 and -0

Thu, 22 Jan 2026 07:00:02 +0000

Bug ID: 119741
Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.0.44

#119752: after changing MINUTE(subq.c1) to MINUTE(subq.c1 + INTERVAL '60' MINUTE),the result become empty.

Thu, 22 Jan 2026 15:08:56 +0000

Bug ID: 119752
Submitted by: cl hl
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.44

#119778: after changing SUM(distinct x) to - SUM(distinct -x),the value unexpectedly change

Mon, 26 Jan 2026 12:56:06 +0000

Bug ID: 119778
Submitted by: Aaditya Dubey
Category: Server: Optimizer
Status: Duplicate
Severity: 3
OS: Any
Version: 8.0.x, 8.4.x

#119793: Incorrect result of prepared SELECT when running with JDBC

Tue, 27 Jan 2026 10:32:17 +0000

Bug ID: 119793
Submitted by: chi zhang
Category: Server: PS
Status: Verified
Severity: 1
OS: Any
Version: 9.5.0

#119934: The table structure and data are the same, but the query results for a partitioned table are different from those for a

Tue, 24 Feb 2026 11:54:36 +0000

Bug ID: 119934
Submitted by: Alice Alice
Category: Server: Optimizer
Status: Verified
Severity: 7
OS: Any
Version: 8.0.41

#119937: Result is not correct when using pow function with group by

Wed, 25 Feb 2026 04:54:16 +0000

Bug ID: 119937
Submitted by: Gou Xie
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0

#120102: Incorrect DISTINCT behavior with JSON_ARRAYAGG when aggregating NULL-only groups

Thu, 19 Mar 2026 01:34:21 +0000

Bug ID: 120102
Submitted by: Wang Ojiken
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.45

#120107: DISTINCT eliminates non-duplicate rows for JSON_OBJECTAGG results

Thu, 19 Mar 2026 08:40:53 +0000

Bug ID: 120107
Submitted by: Wang Ojiken
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.45

#120148: Wrong result with DISTINCTROW due to constant projection interacting with JSON_ARRAYAGG

Wed, 25 Mar 2026 07:41:12 +0000

Bug ID: 120148
Submitted by: Wang Ojiken
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 9.6.0

#120286: `SUM(DISTINCT pk)` returns `NULL` with a window function when a secondary index is used for group-by scanning

Sun, 19 Apr 2026 05:14:56 +0000

Bug ID: 120286
Submitted by: Peiyuan Liu
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.0.45

#120420: ORDER BY ignored when internal_tmp_mem_storage_engine = TempTable with GROUP BY on temp table

Fri, 08 May 2026 08:19:50 +0000

Bug ID: 120420
Submitted by: quan chen
Category: Server: Optimizer
Status: Need Feedback
Severity: 3
OS: Any
Version: 9.7.0 (also reproducible in 8.0.x)

#120422: ORDER BY ignored when internal_tmp_mem_storage_engine = TempTable with GROUP BY on CTE

Fri, 08 May 2026 08:56:26 +0000

Bug ID: 120422
Submitted by: Zining Zhou
Category: Server: Optimizer
Status: Need Feedback
Severity: 2
OS: Any
Version: 9.7.0 (also reproducible in 8.0.x)

#120477: Index Not Used for HAVING Without GROUP BY or aggregate functions

Thu, 14 May 2026 15:50:07 +0000

Bug ID: 120477
Submitted by: jinhui lai
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 9.7.0

#120641: Derived condition pushdown causes wrong row filtering due to incorrect constant folding with any_value() aggregation

Tue, 09 Jun 2026 10:23:43 +0000

Bug ID: 120641
Submitted by: Annie liu
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any (Storage Engine: InnoDB)
Version: 9.7.0

#12: CASE ... ; and NULLs

Wed, 11 Dec 2002 17:42:48 +0000

Bug ID: 12
Submitted by: Alexander Keremidarski
Category: Server
Status: Closed
Severity: 3
OS: Any (any)
Version: 3.23.53

#147: Bug with group by + having involving Date calculations

Wed, 12 Mar 2003 10:55:31 +0000

Bug ID: 147
Submitted by: Alexander Keremidarski
Category: Server
Status: Closed
Severity: 3
OS: Any (any)
Version: all

#173: REPLACE with GROUP BY truncating result

Fri, 21 Mar 2003 01:21:26 +0000

Bug ID: 173
Submitted by: Indrek Siitan
Category: Server
Status: Closed
Severity: 2
OS: Any (any)
Version: any

#251: DESCRIBE on a query with a grouped subquery crashes mysql

Tue, 08 Apr 2003 12:50:05 +0000

Bug ID: 251
Submitted by: Daniel Penning
Category: Server
Status: Closed
Severity: 2
OS: Any (All)
Version: 4.1.0

#514: GROUP BY and LEFT/RIGHT/MID wrong results with charset cp1251

Tue, 27 May 2003 02:28:55 +0000

Bug ID: 514
Submitted by: Alexander Keremidarski
Category: Server
Status: Closed
Severity: 2
OS: Any (any)
Version: 4.0.13

#634: SELECT CAST(datetime_value AS DATE) GROUP by 1

Wed, 11 Jun 2003 04:24:58 +0000

Bug ID: 634
Submitted by: Alexander Barkov
Category: Server
Status: Can't repeat
Severity: 3
OS: Any (FreeBBSD-4.6)
Version: 4.1.1 current BK tree

#906: union subquery problem

Thu, 24 Jul 2003 04:05:57 +0000

Bug ID: 906
Submitted by: Oleksandr Byelkin
Category: Server
Status: Closed
Severity: 3
OS: Any (any)
Version: 4.1

#1537: group_by incorrectly work with item which substitute other on fix_fields()

Sun, 12 Oct 2003 01:11:32 +0000

Bug ID: 1537
Submitted by: Oleksandr Byelkin
Category: Server
Status: Closed
Severity: 2
OS: Any (any)
Version: 4.1

#2188: Query with select in field list doesn't work with prepared statements

Mon, 22 Dec 2003 08:22:03 +0000

Bug ID: 2188
Submitted by: Konstantin Osipov
Category: Server
Status: Closed
Severity: 2
OS: Any (all)
Version: 4.1, 5.0

#3203: A crashing bug with distinct query and a hidden field with SQL_BIG_TABLES

Wed, 17 Mar 2004 09:00:55 +0000

Bug ID: 3203
Submitted by: SINISA MILIVOJEVIC
Category: Server
Status: Closed
Severity: 1
OS: Any (any)
Version: 4.0.19

#3328: I can't see group_concat_max_len in a list of variables

Mon, 29 Mar 2004 13:01:14 +0000

Bug ID: 3328
Submitted by: Vasily Kishkin
Category: Server
Status: Closed
Severity: 2
OS: Any (Any)
Version: 4.1

#3704: charset conversion doesn't fix fields for function items

Mon, 10 May 2004 22:07:23 +0000

Bug ID: 3704
Submitted by: Timothy Smith
Category: Server
Status: Closed
Severity: 2
OS: Any (any)
Version: 4.1.2

#7320: wrong response, SUM(..) and correlated subquery after HAVING

Wed, 15 Dec 2004 15:41:18 +0000

Bug ID: 7320
Submitted by: Matthias Leich
Category: Server
Status: Duplicate
Severity: 3
OS: Any (any)
Version: 4.1

#7945: SQL_CALC_FOUND_ROWS with distinct constant and group by

Sun, 16 Jan 2005 18:50:10 +0000

Bug ID: 7945
Submitted by: Martin Friebe
Category: Server
Status: Closed
Severity: 3
OS: Any (all)
Version: 4.1.9

#8092: INSERT_METHOD feature request

Sat, 22 Jan 2005 18:38:07 +0000

Bug ID: 8092
Submitted by: Wilfried Schobeiri
Category: Server: Merge
Status: Open
Severity: 4
OS: Any

#8510: ONLY_FULL_GROUP_BY sql mode is overly restrictive

Tue, 15 Feb 2005 01:48:22 +0000

Bug ID: 8510
Submitted by: Timothy Smith
Category: Server
Status: Closed
Severity: 2
OS: Any (any)
Version: 4.1.10

#8652: group by part of rand() returns duplicate key error

Mon, 21 Feb 2005 16:28:32 +0000

Bug ID: 8652
Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 4.1.10

#9082: Show Explain Plan in tab "Server Connections"

Wed, 09 Mar 2005 18:51:10 +0000

Bug ID: 9082
Submitted by: Jens Schanz
Category: MySQL Administrator
Status: Won't fix
Severity: 4
OS: Any (ALL)
Version: 1.0.19

#9228: optimizer on alternating function with no ref to columns

Wed, 16 Mar 2005 18:37:46 +0000

Bug ID: 9228
Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any (*)
Version: 4.1.10

#9681: rollup in from-subquery returns error "collumn cannot be null"

Wed, 06 Apr 2005 15:28:01 +0000

Bug ID: 9681
Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any (*)
Version: 4.1.11

#13174: Patch: SHA2 function

Wed, 14 Sep 2005 11:21:29 +0000

Bug ID: 13174
Submitted by: Ariel Kass
Category: Server
Status: Closed
Severity: 4
OS: Any
Version: 6.0

#14303: Internal temporary tables consume too much memory

Tue, 25 Oct 2005 18:20:13 +0000

Bug ID: 14303
Submitted by: Andre Timmer
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (Solaris)
Version: 5.0.26-BK, 5.0.18

#14545: Median SQL Aggregate function

Tue, 01 Nov 2005 17:01:13 +0000

Bug ID: 14545
Submitted by: Joe Genshlea
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (any)

#16556: DD: New error messages needed

Tue, 17 Jan 2006 02:14:19 +0000

Bug ID: 16556
Submitted by: Nikolay Grishakin
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Any
Version: mysql-5.1

#18408: Reserved words are an anachronism

Tue, 21 Mar 2006 22:59:36 +0000

Bug ID: 18408
Submitted by: craigb spengler
Category: Server
Status: Won't fix
Severity: 4
OS: Any (Any)
Version: 5.0

#19205: server provides different metadata in ps-protocol and non-ps-protocol mode

Wed, 19 Apr 2006 20:44:05 +0000

Bug ID: 19205
Submitted by: Evgeny Potemkin
Category: Server: PS
Status: Can't repeat
Severity: 3
OS: Any (any)
Version: 4.1, 5.0-BK

#19738: "make install" tries to build files that "make" should already have built

Thu, 11 May 2006 19:47:54 +0000

Bug ID: 19738
Submitted by: Paul DuBois
Category: Server: Installing
Status: Closed
Severity: 3
OS: Any (Unix)
Version: 5.0, 5.1

#20191: getTableName gives wrong or inconsistent result when using VIEWs

Thu, 01 Jun 2006 10:19:29 +0000

Bug ID: 20191
Submitted by: Wai Wong
Category: Server: Views
Status: Closed
Severity: 1
OS: Any (all)
Version: 5.0.23-BK

#20353: Prefix key search return incorrect results for ignorable characters

Fri, 09 Jun 2006 11:12:36 +0000

Bug ID: 20353
Submitted by: Alexander Barkov
Category: Server: Charsets
Status: Verified
Severity: 3
OS: Any
Version: 4.1, 5.0, 5.1

#20630: Remove restriction on option file parameters being first

Thu, 22 Jun 2006 15:45:54 +0000

Bug ID: 20630
Submitted by: Rob Desbois
Category: Server: General
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.0.22 (+?)

#21403: more specific SQL states for 23nnn

Tue, 01 Aug 2006 19:21:16 +0000

Bug ID: 21403
Submitted by: Matthew Lord
Category: Server: Errors
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#23140: Explicit support of datetime type for aggregate functions like AVG()

Tue, 10 Oct 2006 14:33:01 +0000

Bug ID: 23140
Submitted by: Benjamin Root
Category: Server
Status: Open
Severity: 4
OS: Any (All)
Version: 5.0

#24401: MySQL server crashes if you try to retrieve data from corrupted table

Fri, 17 Nov 2006 16:53:16 +0000

Bug ID: 24401
Submitted by: Victoria Reznichenko
Category: Server
Status: Closed
Severity: 2
OS: Any (any)
Version: 5.0.30

#25219: SELECT with subqueries causes MySQL server crash

Wed, 20 Dec 2006 15:04:08 +0000

Bug ID: 25219
Submitted by: Victoria Reznichenko
Category: Server
Status: Closed
Severity: 1
OS: Any (any)
Version: 5.0bk

#25876: regression tests do not run after using "Windows easy transfer".

Fri, 26 Jan 2007 17:35:24 +0000

Bug ID: 25876
Submitted by: Horst Hunger
Category: Server: Tests
Status: No Feedback
Severity: 3
OS: Any (Vista (64 bit))
Version: 5.0.30

#25951: ignore/use index does not work with fulltext

Tue, 30 Jan 2007 16:13:38 +0000

Bug ID: 25951
Submitted by: Martin Friebe
Category: Server
Status: Closed
Severity: 3
OS: Any (*)
Version: 4.1.22 and 5.0.33

#26182: patch: process percentage of a process -- contributed from Jeremy Cole

Thu, 08 Feb 2007 11:02:38 +0000

Bug ID: 26182
Submitted by: Chad MILLER
Category: Server: I_S
Status: Verified
Severity: 3
OS: Any
Version: 6.0

#26319: The connection to the target database could not be established (error: 0).

Tue, 13 Feb 2007 13:10:32 +0000

Bug ID: 26319
Submitted by: Christoph Moebus
Category: MySQL Migration Toolkit
Status: Closed
Severity: 2
OS: Any (Server 2003 Enterprise Edition)
Version: 1.1.9/1.1.10

#26635: CREATE table and password

Mon, 26 Feb 2007 13:03:36 +0000

Bug ID: 26635
Submitted by: Peter Laursen
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any (all)
Version: all

#27019: nulls in unique composite keys - again!

Fri, 09 Mar 2007 22:41:07 +0000

Bug ID: 27019
Submitted by: Robert Nice
Category: Server
Status: Closed
Severity: 4
OS: Any

#27050: The schema could not be reverse engineered (error: 0).

Mon, 12 Mar 2007 15:10:23 +0000

Bug ID: 27050
Submitted by: Christoph Moebus
Category: MySQL Migration Toolkit
Status: Won't fix
Severity: 1
OS: Any (Server 2003 Enterprise Edition)
Version: 1.1.10

#27333: subquery grouped for aggregate of outer query / no aggregate of subquery

Wed, 21 Mar 2007 14:29:11 +0000

Bug ID: 27333
Submitted by: Martin Friebe
Category: Server
Status: Closed
Severity: 3
OS: Any (*)
Version: 5.0.40/5.1

#27348: aggregate in subquery executed, even if position in qualifying query is invalid

Wed, 21 Mar 2007 17:37:48 +0000

Bug ID: 27348
Submitted by: Martin Friebe
Category: Server
Status: Closed
Severity: 3
OS: Any (*)
Version: 5.0.40

#27386: Queries are Returning Results Which are not Ordered

Thu, 22 Mar 2007 23:25:17 +0000

Bug ID: 27386
Submitted by: Bryan Anderson
Category: Server: General
Status: Not a Bug
Severity: 1
OS: Any (Unknown(ISP) and Mac OS X)
Version: 5.1.17 Beta

#27434: Incorrect handling of FragState in take-over during SR

Mon, 26 Mar 2007 08:56:18 +0000

Bug ID: 27434
Submitted by: Jonas Oreland
Category: Server: Cluster
Status: Closed
Severity: 3
OS: Any
Version: 4.1,5.0,5.1

#27643: query failed : 1114 (The table '' is full)

Wed, 04 Apr 2007 12:13:11 +0000

Bug ID: 27643
Submitted by: Shane Bester
Category: Server: General
Status: Closed
Severity: 2
OS: Any
Version: 5.0BK

#27795: patch for explain extended to show outer aggregates like outer fields

Thu, 12 Apr 2007 22:26:05 +0000

Bug ID: 27795
Submitted by: Martin Friebe
Category: Server: DML
Status: Verified
Severity: 4
OS: Any
Version: 5.0.40, 5.1

#27848: rollup in union part causes error with order of union

Mon, 16 Apr 2007 11:59:39 +0000

Bug ID: 27848
Submitted by: Martin Friebe
Category: Server
Status: Closed
Severity: 3
OS: Any
Version: 5.0.40 4.1.23

#27908: Server crashes when obtaining data from Falcon's information_schema tables

Wed, 18 Apr 2007 00:46:45 +0000

Bug ID: 27908
Submitted by: Alexey Stroganov
Category: Server: Falcon
Status: Can't repeat
Severity: 1
OS: Any
Version: 6.0.0-alpha-pb507

#27957: cast as decimal does not check overflow, also inconsistent with group, subselect

Thu, 19 Apr 2007 16:06:10 +0000

Bug ID: 27957
Submitted by: Martin Friebe
Category: Server
Status: Closed
Severity: 3
OS: Any
Version: 5.0.40

#28155: Some aggregate functions don't appear in TOC

Sun, 29 Apr 2007 22:37:39 +0000

Bug ID: 28155
Submitted by: Baron Schwartz
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: Any

#28300: General RTREE indicies

Tue, 08 May 2007 10:03:10 +0000

Bug ID: 28300
Submitted by: Kristian Koehntopp
Category: Server: GIS
Status: Verified
Severity: 4
OS: Any
Version: any

#28811: server crash with subqueries and order by

Thu, 31 May 2007 16:14:06 +0000

Bug ID: 28811
Submitted by: Shane Bester
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.0.42, 5.0.44-BK

#28957: Ordered Analytical Functions

Thu, 07 Jun 2007 19:30:11 +0000

Bug ID: 28957
Submitted by: Jason Shuler
Category: Server: DML
Status: Verified
Severity: 4
OS: Any
Version: 5.x

#29144: Error on sums

Fri, 15 Jun 2007 16:25:31 +0000

Bug ID: 29144
Submitted by: francisco santana
Category: Server
Status: Can't repeat
Severity: 1
OS: Any
Version: 5.0+

#29167: Insufficient nodes for SR

Mon, 18 Jun 2007 04:57:59 +0000

Bug ID: 29167
Submitted by: Jonas Oreland
Category: Server: Cluster
Status: Closed
Severity: 3
OS: Any
Version: 5.0-wl2325-5.0, 5.1*

#29388: innodb redo log size rule?

Wed, 27 Jun 2007 13:53:00 +0000

Bug ID: 29388
Submitted by: Kristian Koehntopp
Category: Monitoring: Advisors/Rules
Status: Closed
Severity: 3
OS: Any
Version: 1.1.0

#29582: huge memory consumption with union, subselect, joins

Thu, 05 Jul 2007 18:57:57 +0000

Bug ID: 29582
Submitted by: Shane Bester
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.0.42, 5.0.46BK

#29610: func_group fails with lost connection

Sat, 07 Jul 2007 10:22:01 +0000

Bug ID: 29610
Submitted by: Daniel Fischer
Category: Server: Tests
Status: Closed
Severity: 7
OS: Any (hpux,aix,solaris,osx,linux)
Version: 5.1.20, 5.1 BK

#29611: count_distinct3,subselect,func_group fails on 64-bit platforms

Sat, 07 Jul 2007 10:35:05 +0000

Bug ID: 29611
Submitted by: Daniel Fischer
Category: Server
Status: Duplicate
Severity: 2
OS: Any
Version: 5.1 BK

#29634: mysqld_safe does not set err_log variable, error log file is not created

Mon, 09 Jul 2007 01:06:19 +0000

Bug ID: 29634
Submitted by: Anatoly Pidruchny
Category: Server
Status: Closed
Severity: 3
OS: Any
Version: 5.1.20

#29685: SELECT with EXISTS and GROUP BY gives wrong result

Tue, 10 Jul 2007 09:40:30 +0000

Bug ID: 29685
Submitted by: Daniel Penning
Category: Server: General
Status: Closed
Severity: 2
OS: Any
Version: >=5.0.40

#30183: Redundant UDF calls when grouping by UDF result

Wed, 01 Aug 2007 17:20:46 +0000

Bug ID: 30183
Submitted by: Hartmut Holzgraefe
Category: Server: UDF
Status: Verified
Severity: 4
OS: Any
Version: 5.0

#30237: Performance regression in boolean expressions

Fri, 03 Aug 2007 22:10:21 +0000

Bug ID: 30237
Submitted by: Marc ALFF
Category: Server: Parser
Status: Closed
Severity: 5
OS: Any
Version: 5.0

#30325: Migration Toolkit should convert Sybase TINYINT to MySQL UNSIGNED TINYINT

Thu, 09 Aug 2007 00:03:47 +0000

Bug ID: 30325
Submitted by: Trent Lloyd
Category: MySQL Migration Toolkit
Status: Closed
Severity: 2
OS: Any

#30436: MySQL Key_Reads variable seems to be wrong

Wed, 15 Aug 2007 13:48:37 +0000

Bug ID: 30436
Submitted by: Peter Zaitsev
Category: Server: MyISAM
Status: No Feedback
Severity: 3
OS: Any
Version: 5.0.45

#30831: All data nodes are listed in nodegroup 0 while starting

Wed, 05 Sep 2007 12:27:52 +0000

Bug ID: 30831
Submitted by: Kai Voigt
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Any
Version: mysql-5.1

#30936: Syntax error

Mon, 10 Sep 2007 15:19:13 +0000

Bug ID: 30936
Submitted by: karthik ram
Category: Server: Errors
Status: Not a Bug
Severity: 3
OS: Any
Version: MySQL 5.0

#30937: endless loop with ring-spoke topology

Mon, 10 Sep 2007 19:07:29 +0000

Bug ID: 30937
Submitted by: Sloan Childers
Category: Monitoring: Server
Status: Closed
Severity: 2
OS: Any
Version: 2.0

#31063: GROUP BY WITH ROLLUP inconsistence with derived tables

Mon, 17 Sep 2007 15:58:01 +0000

Bug ID: 31063
Submitted by: Peter Zaitsev
Category: Server: DML
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.1.21

#31070: crash during conversion of charsets

Mon, 17 Sep 2007 22:10:41 +0000

Bug ID: 31070
Submitted by: Shane Bester
Category: Server: Charsets
Status: Closed
Severity: 2
OS: Any
Version: 5.0.50, 5.1.23BK

#31095: server crashes with group by null with rollup

Wed, 19 Sep 2007 12:22:45 +0000

Bug ID: 31095
Submitted by: Shane Bester
Category: Server: General
Status: Closed
Severity: 1
OS: Any
Version: 5.0.48, 5.1.23BK

#31133: Disk based statements not accepting magnitude suffixes

Fri, 21 Sep 2007 15:25:03 +0000

Bug ID: 31133
Submitted by: Geert Vanderkelen
Category: Server: ClusterDD
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.1bk

#31144: crash when subquery within order by/group by clause returns spatial datatype

Sat, 22 Sep 2007 13:34:17 +0000

Bug ID: 31144
Submitted by: Shane Bester
Category: Server: General
Status: Closed
Severity: 2
OS: Any
Version: 5.1.23, 6.0.3

#31156: mysqld: item_sum.cc:918: virtual bool Item_sum_distinct::setup(THD*): Assertion

Sun, 23 Sep 2007 13:20:03 +0000

Bug ID: 31156
Submitted by: Shane Bester
Category: Server: Types
Status: Closed
Severity: 2
OS: Any
Version: 5.0.48-debug, 5.1.23-debug

#31203: left join returns error only on v5.0.45 but work fine on versions 3.x and 4.x

Wed, 26 Sep 2007 10:00:02 +0000

Bug ID: 31203
Submitted by: Kevin Saitta
Category: Server: Parser
Status: Not a Bug
Severity: 1
OS: Any
Version: 5.0.45

#31249: Assertion `!table || (!table->write_set || bitmap_is_set(table->write_set, fiel

Thu, 27 Sep 2007 16:38:38 +0000

Bug ID: 31249
Submitted by: Shane Bester
Category: Server: Types
Status: Closed
Severity: 1
OS: Any
Version: 5.1

#31349: ERROR 1062 (23000): Duplicate entry '' for key 'group_key'

Tue, 02 Oct 2007 18:13:02 +0000

Bug ID: 31349
Submitted by: Shane Bester
Category: Server: Types
Status: Closed
Severity: 3
OS: Any
Version: 5.1.23-debug, 5.0.48-debug

#31351: provide collations for AaBb... and AB...ab sorting

Tue, 02 Oct 2007 18:26:44 +0000

Bug ID: 31351
Submitted by: Maciej Pilichowski
Category: Server: Charsets
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.0.45

#31398: problems with mysql-test-run

Thu, 04 Oct 2007 14:24:10 +0000

Bug ID: 31398
Submitted by: Jani Tolonen
Category: Server: Tests
Status: Closed
Severity: 3
OS: Any
Version: 5.1

#31472: multi_update crashes at assert about trans_safe

Tue, 09 Oct 2007 08:59:06 +0000

Bug ID: 31472
Submitted by: Andrei Elkin
Category: Server: DML
Status: Duplicate
Severity: 3
OS: Any
Version: 5.0.50

#31525: Incorrect handling of ActiveMissed_2, potential "Lost node group" after SR

Thu, 11 Oct 2007 09:49:46 +0000

Bug ID: 31525
Submitted by: Jonas Oreland
Category: Server: Cluster
Status: Closed
Severity: 3
OS: Any
Version: 4.1,5.0,5.1

#31899: Group functions not working properly when joining tables

Sun, 28 Oct 2007 19:55:45 +0000

Bug ID: 31899
Submitted by: Svavar Kjarrval
Category: Server: General
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.0.45

#32030: DELETE does not return an error and deletes rows if error evaluating WHERE

Thu, 01 Nov 2007 12:55:14 +0000

Bug ID: 32030
Submitted by: Konstantin Osipov
Category: Server: DML
Status: Closed
Severity: 3
OS: Any

#32083: server crashes on show status when InnoDB is not initialized

Sat, 03 Nov 2007 22:53:22 +0000

Bug ID: 32083
Submitted by: Alexey Stroganov
Category: Server: InnoDB
Status: Closed
Severity: 1
OS: Any
Version: 5.0.50

#32240: Mail with undisclosed-recipients causes error

Fri, 09 Nov 2007 16:30:00 +0000

Bug ID: 32240
Submitted by: Mattias Eriksson
Category: Eventum
Status: Won't fix
Severity: 3
OS: Any
Version: 2.1.1

#32621: falcon_ts.test fails

Thu, 22 Nov 2007 12:42:05 +0000

Bug ID: 32621
Submitted by: Sergey Vojtovich
Category: Server: Falcon
Status: Closed
Severity: 3
OS: Any
Version: 6.0.4

#32993: falcon_ts.test fails sporadically

Wed, 05 Dec 2007 09:38:26 +0000

Bug ID: 32993
Submitted by: Alexander Nozdrin
Category: Server: Falcon
Status: Closed
Severity: 1
OS: Any
Version: 6.0.4

#33647: WITH ROLLUP fails when using subqueries

Thu, 03 Jan 2008 10:16:04 +0000

Bug ID: 33647
Submitted by: Christian Caesar
Category: Server: DML
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.1.22

#33703: Mistranslation of "Recipients" on Manage Notification Groups page

Sat, 05 Jan 2008 13:27:03 +0000

Bug ID: 33703
Submitted by: Toru Sugihara
Category: Monitoring: Localization
Status: Can't repeat
Severity: 2
OS: Any
Version: 1.3J beta

#33824: Manipulations on a view and on the underlying table cause duplicate primary key

Fri, 11 Jan 2008 17:56:37 +0000

Bug ID: 33824
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Can't repeat
Severity: 1
OS: Any
Version: 6.0.4-p3

#33876: Query run OK in Mysql 5.0.27 but not run at 4.1.16

Tue, 15 Jan 2008 17:14:51 +0000

Bug ID: 33876
Submitted by: Marco Túlio
Category: Server: General
Status: No Feedback
Severity: 3
OS: Any (Not return correct result)
Version: 4.1.16

#33933: Falcon assertionFailed() in fetchNext()

Fri, 18 Jan 2008 20:28:36 +0000

Bug ID: 33933
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Closed
Severity: 1
OS: Any
Version: 6.0.4-p3-debug

#34313: Server crash when using EXISTS with a subquery that errors and extra parenthesis

Tue, 05 Feb 2008 16:38:04 +0000

Bug ID: 34313
Submitted by: David Shrewsbury
Category: Server
Status: Duplicate
Severity: 2
OS: Any
Version: 5.0, 5.1

#34360: MySqlDataReader returns zero instead of actual value when doing count(*)

Wed, 06 Feb 2008 19:06:10 +0000

Bug ID: 34360
Submitted by: t s
Category: Connector/Net
Status: Not a Bug
Severity: 2
OS: Any
Version: 5.1.4.0

#34382: Error when using ON DUPLICATE KEY UPDATE table1.field1 = table2.field1,....

Thu, 07 Feb 2008 14:55:30 +0000

Bug ID: 34382
Submitted by: Ben Nelson
Category: Server: General
Status: No Feedback
Severity: 3
OS: Any (Sorry none)
Version: 5.0.32

#34529: Crash on complex Falcon I_S select after ALTER .. PARTITION BY

Wed, 13 Feb 2008 16:52:25 +0000

Bug ID: 34529
Submitted by: Philip Stoev
Category: Server: I_S
Status: Closed
Severity: 2
OS: Any
Version: 6.0-BK

#34580: "MySQL Command Line Client" windows client does not work when server not started

Fri, 15 Feb 2008 08:37:36 +0000

Bug ID: 34580
Submitted by: Philip Stoev
Category: Client
Status: Verified
Severity: 3
OS: Any
Version: 6.0.4, 4.1, 5.0, 5.1

#34590: Innodb crash in build_template() on multi-table delete

Fri, 15 Feb 2008 11:51:03 +0000

Bug ID: 34590
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Duplicate
Severity: 3
OS: Any
Version: 6.0.4

#34591: Innob crash in row_sel_store_mysql_rec() on multi-table delete

Fri, 15 Feb 2008 11:56:20 +0000

Bug ID: 34591
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Duplicate
Severity: 1
OS: Any
Version: 6.0.4

#34597: Warning in error log when calling a function from a trigger

Fri, 15 Feb 2008 15:28:12 +0000

Bug ID: 34597
Submitted by: Sébastien Gourdet
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any
Version: 5.1+

#34758: Server crashes if database with views backed up using CS driver

Fri, 22 Feb 2008 11:46:33 +0000

Bug ID: 34758
Submitted by: Rafal Somla
Category: Server: Backup
Status: Closed
Severity: 2
OS: Any
Version: 6.0.5

#34900: Add Global Status on the MEM replication page to show all Seconds Behind Master

Wed, 27 Feb 2008 18:20:26 +0000

Bug ID: 34900
Submitted by: Chris Calender
Category: Monitoring: Server
Status: Verified
Severity: 4
OS: Any
Version: 2.0.5.7153

#34943: effect of combining SQL_%_RESULT modifiers and use in subqueries should be doc'd

Thu, 28 Feb 2008 21:43:03 +0000

Bug ID: 34943
Submitted by: Roland Bouman
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any
Version: 5.1.23

#35010: View mergeability criteria are incorrect in the documentation

Mon, 03 Mar 2008 18:49:51 +0000

Bug ID: 35010
Submitted by: Sergey Petrunya
Category: Server: Docs
Status: Closed
Severity: 3
OS: Any

#35034: Falcon crash on complex I_S query in ResultSet::setValue, ResultSet.cpp line 154

Tue, 04 Mar 2008 14:35:47 +0000

Bug ID: 35034
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Can't repeat
Severity: 3
OS: Any
Version: 6.0-falcon-team

#35090: umask applied as bitmap instead of as a mask

Wed, 05 Mar 2008 20:15:18 +0000

Bug ID: 35090
Submitted by: d di
Category: Server: General
Status: Verified
Severity: 3
OS: Any (Unix-only?)
Version: 5.0, 5.1, 6.0 BK

#35311: ROW(...) IN (SELECT outer field,... FROM DUAL)" always returns TRUE

Sat, 15 Mar 2008 17:19:50 +0000

Bug ID: 35311
Submitted by: Gleb Shchepa
Category: Server: Optimizer
Status: Duplicate
Severity: 3
OS: Any
Version: 5.0.38+

#36138: SELECT with LEFT JOIN and aggregate function returns incorrect results

Wed, 16 Apr 2008 13:21:55 +0000

Bug ID: 36138
Submitted by: Rafal Rosiak
Category: Server: DML
Status: Not a Bug
Severity: 1
OS: Any
Version: 5.0.45

#36603: Falcon; Performance drop when ageGroup hits 2^31

Thu, 08 May 2008 19:22:00 +0000

Bug ID: 36603
Submitted by: Kevin Lewis
Category: Server: Falcon
Status: Closed
Severity: 3
OS: Any
Version: 6.0.5

#36734: Falcon crash in Record::getEncodedValue

Thu, 15 May 2008 10:27:37 +0000

Bug ID: 36734
Submitted by: Alexey Stroganov
Category: Server: Falcon
Status: Duplicate
Severity: 1
OS: Any
Version: 6.0.6pre, 6.0.8pre, 6.0-falcon-team tree

#36794: Partition by function of time, optimise queries to use only correct tables.

Mon, 19 May 2008 07:53:37 +0000

Bug ID: 36794
Submitted by: Ben Clewett
Category: Server: Partition
Status: Duplicate
Severity: 4
OS: Any
Version: 5.1.24

#36971: Falcon crash in RecordVersion::fetchVersionRecursive on I_S query

Mon, 26 May 2008 14:43:59 +0000

Bug ID: 36971
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Can't repeat
Severity: 1
OS: Any
Version: 6.0-falcon-team

#37062: changing parameters for a scheduled rule should be possible without unschedule

Thu, 29 May 2008 10:45:33 +0000

Bug ID: 37062
Submitted by: Carsten Segieth
Category: Monitoring: Web
Status: Not a Bug
Severity: 4
OS: Any
Version: 2.0.0.6047

#37415: Crash in row_sel_field_store_in_mysql_format on multiple-table update (innodb)

Sun, 15 Jun 2008 17:56:43 +0000

Bug ID: 37415
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Can't repeat
Severity: 1
OS: Any
Version: 6.0

#37726: Falcon crash in WalkDeferred::getNext

Sun, 29 Jun 2008 12:31:03 +0000

Bug ID: 37726
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Closed
Severity: 1
OS: Any
Version: 6.0-falcon

#37807: ndb.ndb_dd_basic fails randomly

Wed, 02 Jul 2008 12:20:02 +0000

Bug ID: 37807
Submitted by: Alexander Nozdrin
Category: Tools: MTR / mysql-test-run
Status: Won't fix
Severity: 3
OS: Any
Version: 6.0-BK

#37842: Assertion in DsMrr_impl::dsmrr_init, at handler.cc:4307

Thu, 03 Jul 2008 17:05:47 +0000

Bug ID: 37842
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 6.0

#37846: Bug #23171 (Illegal slave restart (group) position) not fixed in 5.0

Thu, 03 Jul 2008 18:21:04 +0000

Bug ID: 37846
Submitted by: Sveta Smirnova
Category: Server: Replication
Status: Won't fix
Severity: 2
OS: Any
Version: 5.0 bzr

#37847: Bug #28618 was not fixed in version 5.0

Thu, 03 Jul 2008 18:26:57 +0000

Bug ID: 37847
Submitted by: Sveta Smirnova
Category: Server: Replication
Status: Won't fix
Severity: 2
OS: Any
Version: 5.0 bzr

#37893: Crash in select_describe line 19251 on a FirstMatch query with OUTER JOIN

Sat, 05 Jul 2008 20:00:51 +0000

Bug ID: 37893
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Duplicate
Severity: 1
OS: Any
Version: 6.0

#37894: Assertion in init_read_record_seq in handler.h line 1444

Sat, 05 Jul 2008 20:46:49 +0000

Bug ID: 37894
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.0,5.1,6.0

#37896: Assertion on entry of Item_in_subselect::exec on subquery with AND NOT

Sat, 05 Jul 2008 21:32:59 +0000

Bug ID: 37896
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 6.0

#37943: Reproducible mysqld crash/sigsegv in sel_trees_can_be_ored

Mon, 07 Jul 2008 18:39:03 +0000

Bug ID: 37943
Submitted by: Erik Smit
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.0.51, 5.0.62

#38043: Deadlock between server and falcon when executing concurrent ALTER + DML

Fri, 11 Jul 2008 10:50:49 +0000

Bug ID: 38043
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Closed
Severity: 1
OS: Any
Version: 6.0-falcon

#38044: Falcon crash in StorageTable::compareKey at StorageTable.cpp:412

Fri, 11 Jul 2008 11:01:15 +0000

Bug ID: 38044
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Closed
Severity: 1
OS: Any
Version: 6.0-falcon

#38130: Falcon assertion in IndexNode::expandKey offset + length <= MAX_PHYSICAL_KEY_LEN

Tue, 15 Jul 2008 10:35:58 +0000

Bug ID: 38130
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Closed
Severity: 1
OS: Any
Version: 6.0-falcon

#38191: Crash in List::delete_elements at sql_list.h:400

Thu, 17 Jul 2008 08:13:07 +0000

Bug ID: 38191
Submitted by: Philip Stoev
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 5.1, 6.0 BZR

#38541: Falcon RecordVersion::thaw assertion ""bytesRestored > 0 || data.record == NULL"

Mon, 04 Aug 2008 14:59:27 +0000

Bug ID: 38541
Submitted by: Philip Stoev
Category: Server: Falcon
Status: Closed
Severity: 1
OS: Any
Version: 6.0-falcon

#38798: Assertion mysql_bin_log.is_open() failed in binlog_trans_log_savepos()

Thu, 14 Aug 2008 13:36:26 +0000

Bug ID: 38798
Submitted by: Philip Stoev
Category: Server: Replication
Status: Closed
Severity: 1
OS: Any
Version: 5.1, 6.0 bzr

#38804: Query deadlock causes all tables to be inaccessible.

Thu, 14 Aug 2008 16:27:16 +0000

Bug ID: 38804
Submitted by: Philip Stoev
Category: Server: Locking
Status: Closed
Severity: 1
OS: Any
Version: 5.1-bzr

#38837: need a way to disable information_schema for security

Sun, 17 Aug 2008 04:01:40 +0000

Bug ID: 38837
Submitted by: Morgan Tocker
Category: Server: I_S
Status: Verified
Severity: 3
OS: Any
Version: 5.0+

#38984: Crash in Field_varstring::sql_type at field.cc:7049

Sat, 23 Aug 2008 18:53:36 +0000

Bug ID: 38984
Submitted by: Philip Stoev
Category: Server: I_S
Status: Can't repeat
Severity: 1
OS: Any
Version: 6.0, 5.5.4-m3

#39081: Falcon: segfault in StorageInterface::getDemographics()

Wed, 27 Aug 2008 20:45:04 +0000

Bug ID: 39081
Submitted by: Christopher Powers
Category: Server: Falcon
Status: Closed
Severity: 1
OS: Any
Version: 6.0-falcon, 6.0.7

#39210: Maria deadlock in _ma_bitmap_wait_or_flush

Wed, 03 Sep 2008 11:19:55 +0000

Bug ID: 39210
Submitted by: Philip Stoev
Category: Server: Maria
Status: Closed
Severity: 1
OS: Any
Version: 5.1-maria, 6.0-maria

#39407: Auto increment failure on concurrent DML (Innodb and Falcon)

Thu, 11 Sep 2008 19:12:43 +0000

Bug ID: 39407
Submitted by: Philip Stoev
Category: Server
Status: Duplicate
Severity: 1
OS: Any
Version: 5.1-bzr, 6.0.7