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/35724 #35724: Non-found left join data passed as a parameter to a function in WHERE http://bugs.mysql.com/bug.php?id=35724 Submitted by: Tomas Valenta
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: MySQL 5.0.51a-community-nt, 5.1, 6.0 BK
]]> Mon, 31 Mar 2008 22:24:56 +0000 Server: Optimizer http://bugs.mysql.com/44397 #44397: Negative relevancy value for boolean fulltext query using a left join http://bugs.mysql.com/bug.php?id=44397 Submitted by: Tim McLaughlin
Category: Server: FTS
Status: Verified
Severity: 2
OS: Any
Version: 5.0.79, 5.1.33, 5.1.34, 6.0.9
]]> Wed, 22 Apr 2009 02:46:02 +0000 Server: FTS http://bugs.mysql.com/50357 #50357: Innodb blob+text columns: empty strings become NULL after restore http://bugs.mysql.com/bug.php?id=50357 Submitted by: Victor Kirkebo
Category: Server: Backup
Status: Patch queued
Severity: 3
OS: Any
Version: 6.0-backup
]]> Fri, 15 Jan 2010 09:15:10 +0000 Server: Backup http://bugs.mysql.com/51521 #51521: MERGE Algorithm in LEFT JOIN retuns 0000-00-00 instead of NULL http://bugs.mysql.com/bug.php?id=51521 Submitted by: Drew Vogel
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.1.42, 5.1.45-bzr
]]> Thu, 25 Feb 2010 18:03:55 +0000 Server: Optimizer http://bugs.mysql.com/52752 #52752: SQL Editor does not check whether a NOT NULL column has a default value of NULL http://bugs.mysql.com/bug.php?id=52752 Submitted by: Nubio Revoredo
Category: MySQL Workbench: SQL Editor
Status: Verified
Severity: 3
OS: Windows
Version: 5.2.17 OSS
]]> Mon, 12 Apr 2010 06:15:59 +0000 MySQL Workbench: SQL Editor http://bugs.mysql.com/62548 #62548: Different result from memory and myisam table http://bugs.mysql.com/bug.php?id=62548 Submitted by: Zoltn Varga
Category: Server: Memory
Status: Verified
Severity: 2
OS: Linux (Ubuntu)
Version: 5.1.49, 5.1.58
]]> Tue, 27 Sep 2011 10:22:04 +0000 Server: Memory http://bugs.mysql.com/68864 #68864: INTERVAL treats null values of text columns as float/int http://bugs.mysql.com/bug.php?id=68864 Submitted by: Jaik Dean
Category: Server: Types
Status: Verified
Severity: 2
OS: Any
Version: 5.6.10
]]> Thu, 04 Apr 2013 08:17:14 +0000 Server: Types http://bugs.mysql.com/76596 #76596: Loss of Default NULL value http://bugs.mysql.com/bug.php?id=76596 Submitted by: Francimar Mazin
Category: MySQL Workbench: Modeling
Status: Verified
Severity: 3
OS: Windows (7 64 bits)
Version: 6.2.5.0 build 397 (64 bits)
]]> Sun, 05 Apr 2015 15:54:16 +0000 MySQL Workbench: Modeling http://bugs.mysql.com/80019 #80019: Default value NULL gets erased merely by clicking to a default value field http://bugs.mysql.com/bug.php?id=80019 Submitted by: M S
Category: MySQL Workbench: Modeling
Status: Verified
Severity: 2
OS: Windows (7 Professional)
Version: 6.3.6 Build 511 CE 64-bit
]]> Sun, 17 Jan 2016 17:34:47 +0000 MySQL Workbench: Modeling http://bugs.mysql.com/84088 #84088: how operate null value in MySQL? http://bugs.mysql.com/bug.php?id=84088 Submitted by: chong ge
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux (CentOS6.5)
Version: 5.6.29-log, 5.6.34, 5.5.53
]]> Wed, 07 Dec 2016 08:24:53 +0000 Server: DML http://bugs.mysql.com/100670 #100670: Undescribed behavior of INTERVAL function with NULL http://bugs.mysql.com/bug.php?id=100670 Submitted by: Yushan ZHANG
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.21, 5.7.31, 5.6.48
]]> Fri, 28 Aug 2020 06:51:15 +0000 Server: Optimizer http://bugs.mysql.com/100822 #100822: the result of group_concat(field1 order by field2) is unexpect. http://bugs.mysql.com/bug.php?id=100822 Submitted by: GONGTUI FU
Category: Server: DML
Status: Verified
Severity: 3
OS: Red Hat (7.4)
Version: 8.0/5.7/5.6
]]> Sat, 12 Sep 2020 14:39:16 +0000 Server: DML http://bugs.mysql.com/81010 #81010: ALTER TABLE DROP DEFAULT - default value of NULL not forced http://bugs.mysql.com/bug.php?id=81010 Submitted by: Power Gamer
Category: Server: DDL
Status: Verified
Severity: 3
OS: Windows
Version: 5.7.11, 5.6.29, 8.0.17
]]> Fri, 08 Apr 2016 10:34:40 +0000 Server: DDL http://bugs.mysql.com/106297 #106297: Incorrect outputs when combine unique index with NULL http://bugs.mysql.com/bug.php?id=106297 Submitted by: Yu Liang
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Ubuntu (Ubuntu 20.04.3 LTS)
Version: 8.0.27, 8.0.28
]]> Wed, 26 Jan 2022 22:39:41 +0000 Server: Optimizer http://bugs.mysql.com/103233 #103233: wrong results when comparing to null http://bugs.mysql.com/bug.php?id=103233 Submitted by: river fang
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: CentOS
Version: 5.7.33
]]> Wed, 07 Apr 2021 06:58:17 +0000 Server: Optimizer http://bugs.mysql.com/107438 #107438: JSON STORED generated column values are inserted as NULL on replica http://bugs.mysql.com/bug.php?id=107438 Submitted by: Erik Halperin
Category: Server: Replication
Status: Verified
Severity: 2
OS: CentOS (8)
Version: 5.7.38
]]> Tue, 31 May 2022 19:57:23 +0000 Server: Replication http://bugs.mysql.com/109354 #109354: Numeric format change caused by DISTINCT, UNION and NULL http://bugs.mysql.com/bug.php?id=109354 Submitted by: ZongYin Hao
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.21, 8.0.30, 8.0.31
]]> Tue, 13 Dec 2022 05:43:26 +0000 Server: Optimizer http://bugs.mysql.com/110563 #110563: NULL safe equality operator query with wrong result http://bugs.mysql.com/bug.php?id=110563 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Ubuntu (22.04)
Version: 8.0.32
]]> Thu, 30 Mar 2023 08:21:20 +0000 Server: Optimizer http://bugs.mysql.com/120102 #120102: Incorrect DISTINCT behavior with JSON_ARRAYAGG when aggregating NULL-only groups http://bugs.mysql.com/bug.php?id=120102 Submitted by: Wang Ojiken
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.45
]]> Thu, 19 Mar 2026 01:34:21 +0000 Server: JSON http://bugs.mysql.com/120109 #120109: Wrong result: DISTINCT eliminates JSON_ARRAY(NULL) result http://bugs.mysql.com/bug.php?id=120109 Submitted by: Wang Ojiken
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.45
]]> Thu, 19 Mar 2026 09:01:34 +0000 Server: JSON http://bugs.mysql.com/120110 #120110: Wrong result: DISTINCT eliminates JSON_OBJECT result containing NULL value http://bugs.mysql.com/bug.php?id=120110 Submitted by: Wang Ojiken
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.45
]]> Thu, 19 Mar 2026 09:04:41 +0000 Server: JSON http://bugs.mysql.com/120111 #120111: Unexpected row elimination when using DISTINCT on JSON_SET output http://bugs.mysql.com/bug.php?id=120111 Submitted by: Wang Ojiken
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.45
]]> Thu, 19 Mar 2026 09:14:05 +0000 Server: JSON http://bugs.mysql.com/120152 #120152: Unexpected behavior of LEFT JOIN + empty subquery with NULL comparison in WHERE clause http://bugs.mysql.com/bug.php?id=120152 Submitted by: Jasper Andrew
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any (Docker container)
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Wed, 25 Mar 2026 08:50:11 +0000 Server: Optimizer http://bugs.mysql.com/120159 #120159: RIGHT JOIN + Complex Subqueries Returns Extra Rows http://bugs.mysql.com/bug.php?id=120159 Submitted by: Jasper Andrew
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any (Docker container)
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Thu, 26 Mar 2026 11:41:59 +0000 Server: Optimizer 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/120363 #120363: LEFT JOIN ON FALSE causes incorrect NULL comparison result in MySQL http://bugs.mysql.com/bug.php?id=120363 Submitted by: Jasper Andrew
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any (Docker container)
Version: 8.0.43
]]> Tue, 28 Apr 2026 06:58:24 +0000 Server: Optimizer