MySQL Bugs

MySQL Bugs MySQL AB Bugs Database http://bugs.mysql.com/ MySQL Bugs http://bugs.mysql.com/images/mysql_100x52-64.gif http://bugs.mysql.com/ http://bugs.mysql.com/55971 #55971: Adding new collation ended with error "Unknown collation" http://bugs.mysql.com/bug.php?id=55971 Submitted by: Stanislav LOFAJ
Category: Server
Status: Verified
Severity: 3
OS: Any (MS Windows, Linux)
Version: 6.0.11-alpha, 5.5.5, 5.1.49
]]> Fri, 13 Aug 2010 14:11:34 +0000 Server http://bugs.mysql.com/60345 #60345: trim trailing spaces processes data only byte wise (the continue of bug14637) http://bugs.mysql.com/bug.php?id=60345 Submitted by: Linhai Song
Category: Server
Status: Verified
Severity: 5
OS: Any
Version: 5.1.55 6.0.11
]]> Fri, 04 Mar 2011 17:11:45 +0000 Server http://bugs.mysql.com/59581 #59581: Equivalence of sql_modes not reflected in sql_mode returned. http://bugs.mysql.com/bug.php?id=59581 Submitted by: Peter Laursen
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1.54 - likely any 5.x
]]> Tue, 18 Jan 2011 12:36:29 +0000 Server http://bugs.mysql.com/58633 #58633: options after -- are processed incorrectly http://bugs.mysql.com/bug.php?id=58633 Submitted by: Sergei Golubchik
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1
]]> Wed, 01 Dec 2010 14:08:09 +0000 Server http://bugs.mysql.com/57716 #57716: SHOW PROFILE truncates http://bugs.mysql.com/bug.php?id=57716 Submitted by: Peter Laursen
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1.51
]]> Mon, 25 Oct 2010 17:45:36 +0000 Server http://bugs.mysql.com/56939 #56939: mysql-log-rotate has outdated command/option names http://bugs.mysql.com/bug.php?id=56939 Submitted by: Paul DuBois
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1+
]]> Wed, 22 Sep 2010 15:17:48 +0000 Server http://bugs.mysql.com/56694 #56694: mysql.server + large amounts of memory = cannot allocate error http://bugs.mysql.com/bug.php?id=56694 Submitted by: Lig Isler-Turmelle
Category: Server
Status: Verified
Severity: 3
OS: Any
]]> Thu, 09 Sep 2010 15:28:40 +0000 Server http://bugs.mysql.com/56497 #56497: ps_3innodb fails if MTR run with --mysqld=--query-cache-size=1000000 http://bugs.mysql.com/bug.php?id=56497 Submitted by: Sveta Smirnova
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1
]]> Thu, 02 Sep 2010 13:23:29 +0000 Server http://bugs.mysql.com/56466 #56466: main.ps_4heap fails if MTR run with --mysqld=--query-cache-size=1000000 http://bugs.mysql.com/bug.php?id=56466 Submitted by: Sveta Smirnova
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1
]]> Wed, 01 Sep 2010 16:52:17 +0000 Server http://bugs.mysql.com/60348 #60348: trim trailing spaces processes data only byte wise (continue of bug14637 (2)) http://bugs.mysql.com/bug.php?id=60348 Submitted by: Linhai Song
Category: Server
Status: Verified
Severity: 5
OS: Any
Version: 5.1.55
]]> Fri, 04 Mar 2011 20:14:41 +0000 Server http://bugs.mysql.com/53561 #53561: HA_EXTRA_WRITE_CAN_REPLACE does not work with row based replication http://bugs.mysql.com/bug.php?id=53561 Submitted by: Zardosht Kasheff
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1.46, 5.5
]]> Tue, 11 May 2010 12:20:09 +0000 Server http://bugs.mysql.com/51667 #51667: Need status variable for com_ping http://bugs.mysql.com/bug.php?id=51667 Submitted by: Todd Farmer
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1
]]> Tue, 02 Mar 2010 23:49:41 +0000 Server http://bugs.mysql.com/50675 #50675: Passwords are not converted to same character set before comparing http://bugs.mysql.com/bug.php?id=50675 Submitted by: Lawrenty Novitsky
Category: Server
Status: Verified
Severity: 2
OS: Any
Version: 4.1, 5.0, 5,1, 5.5 bzr
]]> Wed, 27 Jan 2010 20:34:35 +0000 Server http://bugs.mysql.com/50657 #50657: my_getopt barfs on --loose-foo if it knows --foo-bar and --foo-baz but not --foo http://bugs.mysql.com/bug.php?id=50657 Submitted by: Bjørn Munch
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1+
]]> Wed, 27 Jan 2010 11:49:16 +0000 Server http://bugs.mysql.com/49895 #49895: use of KEY_PART_INFO->fieldnr inconsistent in handler::create and add_index http://bugs.mysql.com/bug.php?id=49895 Submitted by: Zardosht Kasheff
Category: Server
Status: Verified
Severity: 2
OS: Any (add_index)
Version: 5.1.36, 5.1 bzr
]]> Wed, 23 Dec 2009 16:27:17 +0000 Server http://bugs.mysql.com/49768 #49768: Automatic repair of CSV log files is not announced in the error log http://bugs.mysql.com/bug.php?id=49768 Submitted by: Philip Stoev
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1+
]]> Thu, 17 Dec 2009 13:23:13 +0000 Server http://bugs.mysql.com/363 #363: SHOW SESSION VARIABLES LIKE 'x' != SELECT @@SESSION.x http://bugs.mysql.com/bug.php?id=363 Submitted by: Guilhem Bichot
Category: Server
Status: Verified
Severity: 3
OS: Any (all)
Version: 5.0
]]> Sat, 03 May 2003 06:19:27 +0000 Server http://bugs.mysql.com/47719 #47719: mysqld crashes if handlerton->show_status returns an error http://bugs.mysql.com/bug.php?id=47719 Submitted by: Zardosht Kasheff
Category: Server
Status: Verified
Severity: 2
OS: Any
Version: 5.1.36, 5.1 bzr
]]> Tue, 29 Sep 2009 15:29:44 +0000 Server http://bugs.mysql.com/119431 #119431: Concurrent inserts generate duplicate AUTO_INCREMENT values after changing auto_increment settings http://bugs.mysql.com/bug.php?id=119431 Submitted by: kai zhang
Category: Server
Status: Open
Severity: 3
OS: Any
Version: 8.0.30, 8.0.39
]]> Thu, 20 Nov 2025 07:59:15 +0000 Server http://bugs.mysql.com/120599 #120599: Field_set::sql_type() Corrupts 4-byte UTF-8 Characters, Breaking Replication http://bugs.mysql.com/bug.php?id=120599 Submitted by: fei yang
Category: Server
Status: Open
Severity: 3
OS: Any
Version: 8.0.43
]]> Tue, 02 Jun 2026 08:24:14 +0000 Server http://bugs.mysql.com/120340 #120340: Inconsistent evaluation of NULLIF(ROUND(VAR_SAMP(...)), const) <= value between MySQL and PostgreSQL/DuckDB causes diffe http://bugs.mysql.com/bug.php?id=120340 Submitted by: Jasper Andrew
Category: Server
Status: Open
Severity: 2
OS: Any
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Fri, 24 Apr 2026 09:13:34 +0000 Server http://bugs.mysql.com/120191 #120191: TLP bug: Incorrect result under Ternary Logic Partitioning (TLP) with complex RIGHT JOIN chains http://bugs.mysql.com/bug.php?id=120191 Submitted by: Jasper Andrew
Category: Server
Status: Open
Severity: 2
OS: Any (Docker container)
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Tue, 31 Mar 2026 13:32:17 +0000 Server http://bugs.mysql.com/120190 #120190: TLP Bug: COUNT(*) returns 20, while TLP-partitioned queries return 0 under RIGHT JOIN with LATERAL subqueries http://bugs.mysql.com/bug.php?id=120190 Submitted by: Jasper Andrew
Category: Server
Status: Open
Severity: 2
OS: Any (Docker container)
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Tue, 31 Mar 2026 13:04:13 +0000 Server http://bugs.mysql.com/120189 #120189: TLP Bug: COUNT(*) on orders returns 5, but equivalent TLP-style with complex NULLIF and CASE expressions return 10 http://bugs.mysql.com/bug.php?id=120189 Submitted by: Jasper Andrew
Category: Server
Status: Open
Severity: 2
OS: Any (Docker container)
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Tue, 31 Mar 2026 12:43:19 +0000 Server http://bugs.mysql.com/120188 #120188: Executing the EXPLAIN ANALYZE statement in a loop within a stored procedure triggers a error http://bugs.mysql.com/bug.php?id=120188 Submitted by: Alice Alice
Category: Server
Status: Open
Severity: 3
OS: Any
Version: 9.6, 8.0.45
]]> Tue, 31 Mar 2026 12:00:59 +0000 Server http://bugs.mysql.com/120187 #120187: Bug: COUNT(*) vs SUM(CASE WHEN ...) returns inconsistent results with NULL-sensitive joins http://bugs.mysql.com/bug.php?id=120187 Submitted by: Jasper Andrew
Category: Server
Status: Open
Severity: 2
OS: Any (Docker container)
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Tue, 31 Mar 2026 11:46:24 +0000 Server http://bugs.mysql.com/120180 #120180: NoREC Bug: COUNT(*) and SUM(CASE WHEN ...) return inconsistent results with string-length expression and NULL-sensitive http://bugs.mysql.com/bug.php?id=120180 Submitted by: Jasper Andrew
Category: Server
Status: Open
Severity: 2
OS: Any (Docker container)
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Mon, 30 Mar 2026 13:32:57 +0000 Server http://bugs.mysql.com/48899 #48899: storage requirement for non-MyISAM poorly documented and 'instrumentated' http://bugs.mysql.com/bug.php?id=48899 Submitted by: Peter Laursen
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.0, all
]]> Thu, 19 Nov 2009 10:55:11 +0000 Server http://bugs.mysql.com/117906 #117906: User Defined Functions (UDF) have documented char *is_null, *error, however defined as unsigned char * http://bugs.mysql.com/bug.php?id=117906 Submitted by: Daniel Black
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 8.0, 8.4
]]> Tue, 08 Apr 2025 07:11:38 +0000 Server http://bugs.mysql.com/110519 #110519: Wrong Allowed Values range for connection_memory_chunk_size in documentation. http://bugs.mysql.com/bug.php?id=110519 Submitted by: Pranay Motupalli
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 8.0.28-8.0.32
]]> Tue, 28 Mar 2023 00:31:40 +0000 Server http://bugs.mysql.com/77050 #77050: Syntax error if index type specified http://bugs.mysql.com/bug.php?id=77050 Submitted by: Daniël van Eeden
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.6.24, 5.6.26, 5.7.8
]]> Fri, 15 May 2015 14:17:55 +0000 Server http://bugs.mysql.com/74640 #74640: There is no way to view MyISAM secondary key cache existence or usage http://bugs.mysql.com/bug.php?id=74640 Submitted by: Shawn Green
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.6.20
]]> Thu, 30 Oct 2014 18:24:22 +0000 Server http://bugs.mysql.com/72286 #72286: server-system-variables.html and "Dynamic variable" setting is incomplete http://bugs.mysql.com/bug.php?id=72286 Submitted by: Simon Mudd
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.6+
]]> Wed, 09 Apr 2014 08:49:04 +0000 Server http://bugs.mysql.com/60351 #60351: trim same character processes data only byte wise (continue of bug14637 (4)) http://bugs.mysql.com/bug.php?id=60351 Submitted by: Linhai Song
Category: Server
Status: Verified
Severity: 5
OS: Any
Version: 5.1.55
]]> Fri, 04 Mar 2011 22:15:10 +0000 Server http://bugs.mysql.com/60349 #60349: trim beginning spaces processes data only byte wise (continue of bug14637 (3)) http://bugs.mysql.com/bug.php?id=60349 Submitted by: Linhai Song
Category: Server
Status: Verified
Severity: 5
OS: Any
Version: 5.1.55
]]> Fri, 04 Mar 2011 21:20:06 +0000 Server http://bugs.mysql.com/46945 #46945: enable filesort index rebuild for SPATIAL index http://bugs.mysql.com/bug.php?id=46945 Submitted by: P R
Category: Server
Status: Verified
Severity: 2
OS: Any
Version: 4.1, 5.0, 5,1, next bzr
]]> Wed, 26 Aug 2009 20:10:08 +0000 Server http://bugs.mysql.com/34907 #34907: Handlers cannot replace the plugin variable update func for thread vars http://bugs.mysql.com/bug.php?id=34907 Submitted by: Bill Mitchell
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1.22
]]> Wed, 27 Feb 2008 21:23:18 +0000 Server http://bugs.mysql.com/40320 #40320: select into outfile mistake with multiline strings http://bugs.mysql.com/bug.php?id=40320 Submitted by: Peter Laursen
Category: Server
Status: Verified
Severity: 2
OS: Any
Version: 5.0.67, 4.1, 5.0, 5.1, 6.0 bzr, 8.0.22
]]> Fri, 24 Oct 2008 20:49:11 +0000 Server http://bugs.mysql.com/40475 #40475: my_open.c#my_open accepts space only and special characters as filenames http://bugs.mysql.com/bug.php?id=40475 Submitted by: Jørgen Løland
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 6.0
]]> Mon, 03 Nov 2008 09:03:21 +0000 Server http://bugs.mysql.com/40955 #40955: SHOW TABLE STATUS truncates information http://bugs.mysql.com/bug.php?id=40955 Submitted by: Peter Laursen
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.0.67, 5.0.70
]]> Sun, 23 Nov 2008 14:04:12 +0000 Server http://bugs.mysql.com/41293 #41293: user variables from remote hosts can be considerably slow http://bugs.mysql.com/bug.php?id=41293 Submitted by: Peter Laursen
Category: Server
Status: Verified
Severity: 2
OS: Any
Version: 5.0 bzr, 5.1
]]> Mon, 08 Dec 2008 10:21:00 +0000 Server http://bugs.mysql.com/17979 #17979: my_print_defaults/mysql_install_db ignore [mysqld-X.Y] sections in option files http://bugs.mysql.com/bug.php?id=17979 Submitted by: Geert Vanderkelen
Category: Server
Status: Patch approved
Severity: 3
OS: Any
Version: 5.0
]]> Mon, 06 Mar 2006 18:29:53 +0000 Server http://bugs.mysql.com/42058 #42058: Bit index fails to return all matching rows http://bugs.mysql.com/bug.php?id=42058 Submitted by: Philip Stoev
Category: Server
Status: Verified
Severity: 2
OS: Any
Version: 5.0, 5.1, 6.0 bzr
]]> Mon, 12 Jan 2009 19:00:08 +0000 Server http://bugs.mysql.com/42327 #42327: MySQLDump + Stored Proc bug http://bugs.mysql.com/bug.php?id=42327 Submitted by: Cal Leeming [Simplicity Media Ltd]
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.0.67, 5.0 bzr
]]> Sun, 25 Jan 2009 14:55:46 +0000 Server http://bugs.mysql.com/15089 #15089: BLOB data should not remain in memory http://bugs.mysql.com/bug.php?id=15089 Submitted by: Gili
Category: Server
Status: Verified
Severity: 2
OS: Any (Linux, Windows XP sp2)
Version: 3.1.10, 4.1, 5.0, 5.1, 6.0 bzr
]]> Mon, 21 Nov 2005 04:24:52 +0000 Server http://bugs.mysql.com/43763 #43763: Difference in warnings generated between engines http://bugs.mysql.com/bug.php?id=43763 Submitted by: Nidhi Shrotriya
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 6.0.11, 5.0, 5.1, 6.0 bzr
]]> Fri, 20 Mar 2009 06:30:42 +0000 Server http://bugs.mysql.com/44207 #44207: LEFT JOIN Multi-table DELETE fails to delete records when using foreign keys http://bugs.mysql.com/bug.php?id=44207 Submitted by: Sergey Petrunya
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1/5.0/6.0
]]> Fri, 10 Apr 2009 15:08:00 +0000 Server http://bugs.mysql.com/44300 #44300: mysqld does not establish a new session (posix setsid) http://bugs.mysql.com/bug.php?id=44300 Submitted by: Paul Green
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.0.75, 5.1, 5.1-telco
]]> Wed, 15 Apr 2009 15:53:50 +0000 Server http://bugs.mysql.com/44372 #44372: bug 22125 affects handler::index_next_same in 5.1 http://bugs.mysql.com/bug.php?id=44372 Submitted by: Zardosht Kasheff
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1.30, 5.1 bzr
]]> Mon, 20 Apr 2009 20:17:55 +0000 Server http://bugs.mysql.com/44469 #44469: my_bitmap overallocates the memory http://bugs.mysql.com/bug.php?id=44469 Submitted by: Konstantin Osipov
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.0, 5.1, 6.0 bzr
]]> Fri, 24 Apr 2009 18:58:45 +0000 Server http://bugs.mysql.com/14668 #14668: funktions storing in machine independent format not optimized for PPC http://bugs.mysql.com/bug.php?id=14668 Submitted by: Gunnar von Boehn
Category: Server
Status: Verified
Severity: 5
OS: Any (any)
Version: 5.0.16-BK, 5.1.34
]]> Sat, 05 Nov 2005 08:19:09 +0000 Server http://bugs.mysql.com/44943 #44943: ORDER BY on SHOW INDEXES http://bugs.mysql.com/bug.php?id=44943 Submitted by: Jared S
Category: Server
Status: Verified
Severity: 3
OS: Any (NT)
Version: 5.1.34, 4.1, 5.0, 5.1, 6.0 bzr
]]> Tue, 19 May 2009 04:35:23 +0000 Server http://bugs.mysql.com/45258 #45258: missing stuff in mysql internals http://bugs.mysql.com/bug.php?id=45258 Submitted by: d di
Category: Server
Status: Verified
Severity: 3
OS: Any
]]> Tue, 02 Jun 2009 10:03:47 +0000 Server http://bugs.mysql.com/45278 #45278: retargeting needed for hundreds of bug reports http://bugs.mysql.com/bug.php?id=45278 Submitted by: Peter Laursen
Category: Server
Status: Verified
Severity: 2
OS: Any
Version: good question!
]]> Tue, 02 Jun 2009 21:58:29 +0000 Server http://bugs.mysql.com/3329 #3329: Incomplete lower_case_table_names=2 implementation http://bugs.mysql.com/bug.php?id=3329 Submitted by: Sergei Kulakov
Category: Server
Status: Verified
Severity: 3
OS: Any (Windows, MacOSX)
Version: 4.0.18/4.0.19 Source, 5.0, 5.1, 6.0 bzr
]]> Mon, 29 Mar 2004 22:23:31 +0000 Server http://bugs.mysql.com/45413 #45413: Field_blob::unpack ignores "to" parameter http://bugs.mysql.com/bug.php?id=45413 Submitted by: Zardosht Kasheff
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1.30, 5.1 bzr
]]> Tue, 09 Jun 2009 20:05:34 +0000 Server http://bugs.mysql.com/45689 #45689: SESSION 'interactive_timeout' variable is useless http://bugs.mysql.com/bug.php?id=45689 Submitted by: Peter Laursen
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 4.1, 5.0, 5.1 bzr
]]> Tue, 23 Jun 2009 19:37:16 +0000 Server http://bugs.mysql.com/46089 #46089: .frm file uses 2 bytes to store key flags, KEY structure uses 4. http://bugs.mysql.com/bug.php?id=46089 Submitted by: Zardosht Kasheff
Category: Server
Status: Verified
Severity: 3
OS: Any
Version: 5.1.30, 5.0, 5.4
]]> Thu, 09 Jul 2009 15:09:20 +0000 Server http://bugs.mysql.com/14709 #14709: LOAD DATA INFILE: Indexes get disabled by LOAD DATA http://bugs.mysql.com/bug.php?id=14709 Submitted by: martin koegler
Category: Server
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 4.1.16-BK, 4.1.14 (4.1.15),5.0.16
]]> Mon, 07 Nov 2005 15:30:22 +0000 Server http://bugs.mysql.com/4291 #4291: max_heap_table_size affects creation of disk-based temporary tables http://bugs.mysql.com/bug.php?id=4291 Submitted by: Dean Ellis
Category: Server
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 4.0.21
]]> Fri, 25 Jun 2004 23:30:51 +0000 Server