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/119129 #119129: Unexpected error `BIGINT value is out of range in '--9223372036854775808'` http://bugs.mysql.com/bug.php?id=119129 Submitted by: chi zhang
Category: Server
Status: Not a Bug
Severity: 3
OS: Any
Version: 5.7
]]> Fri, 10 Oct 2025 14:13:24 +0000 Server http://bugs.mysql.com/117214 #117214: inconsistent result of two equivalent query http://bugs.mysql.com/bug.php?id=117214 Submitted by: chi zhang
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0
]]> Thu, 16 Jan 2025 08:10:28 +0000 Server: Optimizer http://bugs.mysql.com/118601 #118601: Inconstant type between constants in prepare statement and SELECT statement http://bugs.mysql.com/bug.php?id=118601 Submitted by: chi zhang
Category: Server: PS
Status: Not a Bug
Severity: 3
OS: Any
Version: 8.0.42, 8.4.5
]]> Tue, 08 Jul 2025 09:30:36 +0000 Server: PS http://bugs.mysql.com/119790 #119790: Unexpected result of expression IN NULL http://bugs.mysql.com/bug.php?id=119790 Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.0.44
]]> Tue, 27 Jan 2026 10:14:03 +0000 Server: Optimizer http://bugs.mysql.com/119687 #119687: Inconsistent behaviour between normal and prepared INSERT http://bugs.mysql.com/bug.php?id=119687 Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.0.44
]]> Thu, 15 Jan 2026 10:23:58 +0000 Server: Optimizer http://bugs.mysql.com/119670 #119670: Incorrect result caused by index http://bugs.mysql.com/bug.php?id=119670 Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.0.44
]]> Tue, 13 Jan 2026 13:46:57 +0000 Server: Optimizer http://bugs.mysql.com/119669 #119669: Inconsistent behaviour between normal query and prepared statement http://bugs.mysql.com/bug.php?id=119669 Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.0.44
]]> Tue, 13 Jan 2026 13:27:18 +0000 Server: Optimizer http://bugs.mysql.com/119692 #119692: The normal query generated a non-optimal query plan. http://bugs.mysql.com/bug.php?id=119692 Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.0.44
]]> Fri, 16 Jan 2026 05:23:16 +0000 Server: Optimizer http://bugs.mysql.com/119716 #119716: Suboptimal query plan generated by normal query compare to prepared statement http://bugs.mysql.com/bug.php?id=119716 Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.0.44
]]> Mon, 19 Jan 2026 01:36:07 +0000 Server: Optimizer http://bugs.mysql.com/120011 #120011: The normal query generated a non-optimal query plan with index. http://bugs.mysql.com/bug.php?id=120011 Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.0.44
]]> Mon, 09 Mar 2026 10:29:58 +0000 Server: Optimizer http://bugs.mysql.com/119741 #119741: internal_tmp_mem_storage_engine = MEMORY setting makes the DISTINCTROW returns incorrect result on 0 and -0 http://bugs.mysql.com/bug.php?id=119741 Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.0.44
]]> Thu, 22 Jan 2026 07:00:02 +0000 Server: Optimizer http://bugs.mysql.com/119140 #119140: DISTINCT works inconsistently in normal SELECT and prepared statement for 0 and -0 http://bugs.mysql.com/bug.php?id=119140 Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.4
]]> Mon, 13 Oct 2025 08:01:33 +0000 Server: Optimizer http://bugs.mysql.com/117620 #117620: NumberFormatException in JDBC http://bugs.mysql.com/bug.php?id=117620 Submitted by: chi zhang
Category: Connector/J
Status: Duplicate
Severity: 3
OS: Any
Version: 9.2.0
]]> Wed, 05 Mar 2025 03:20:39 +0000 Connector/J http://bugs.mysql.com/118595 #118595: NULL are transformed to false in certain expression in prepared statement http://bugs.mysql.com/bug.php?id=118595 Submitted by: chi zhang
Category: Server: PS
Status: Not a Bug
Severity: 1
OS: Any
Version: 9.3.0
]]> Mon, 07 Jul 2025 15:16:40 +0000 Server: PS http://bugs.mysql.com/118625 #118625: index makes query generate incorrect result http://bugs.mysql.com/bug.php?id=118625 Submitted by: chi zhang
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Any
Version: 9.3.0
]]> Thu, 10 Jul 2025 03:04:09 +0000 Server: DDL http://bugs.mysql.com/118630 #118630: INSERT IGNORE failed but insert a different value http://bugs.mysql.com/bug.php?id=118630 Submitted by: chi zhang
Category: Server: DML
Status: Not a Bug
Severity: 3
OS: Any
Version: 9.3.0
]]> Thu, 10 Jul 2025 09:05:23 +0000 Server: DML http://bugs.mysql.com/118749 #118749: internal_tmp_mem_storage_engine=memory make the query generate different result on -0 and 0 http://bugs.mysql.com/bug.php?id=118749 Submitted by: chi zhang
Category: Server: Optimizer
Status: Duplicate
Severity: 3
OS: Any
Version: 9.3.0
]]> Wed, 30 Jul 2025 02:41:57 +0000 Server: Optimizer http://bugs.mysql.com/118750 #118750: binary comparison has different results in prepared statement and normal SELECT query http://bugs.mysql.com/bug.php?id=118750 Submitted by: chi zhang
Category: Server: PS
Status: Analyzing
Severity: 3
OS: Any
Version: 9.3.0
]]> Wed, 30 Jul 2025 03:33:38 +0000 Server: PS http://bugs.mysql.com/118592 #118592: Unexpected result of prepared statement http://bugs.mysql.com/bug.php?id=118592 Submitted by: chi zhang
Category: Server: PS
Status: Duplicate
Severity: 1
OS: Any
Version: 9.3.0
]]> Mon, 07 Jul 2025 12:12:29 +0000 Server: PS http://bugs.mysql.com/118591 #118591: empty string parse to 0 in SET statement, which is different from that in the SELECT query http://bugs.mysql.com/bug.php?id=118591 Submitted by: chi zhang
Category: Server: Types
Status: Duplicate
Severity: 1
OS: Any
Version: 9.3.0
]]> Mon, 07 Jul 2025 11:28:33 +0000 Server: Types http://bugs.mysql.com/118621 #118621: subquery_to_derived optimizer makes query produce incorrect result http://bugs.mysql.com/bug.php?id=118621 Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 9.3.0, 8.0.42
]]> Wed, 09 Jul 2025 12:39:09 +0000 Server: Optimizer http://bugs.mysql.com/119386 #119386: unexpected error "Can't write; duplicate key in table '/tmp/#sql1_372_1'" http://bugs.mysql.com/bug.php?id=119386 Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 9.4.0
]]> Thu, 13 Nov 2025 11:44:41 +0000 Server: Optimizer http://bugs.mysql.com/119139 #119139: Unexpected error `Incorrect DECIMAL value: '0' for column '' at row -1` http://bugs.mysql.com/bug.php?id=119139 Submitted by: chi zhang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 9.4.0
]]> Mon, 13 Oct 2025 07:30:11 +0000 Server: Optimizer http://bugs.mysql.com/119058 #119058: `\` is inconsistent in prepared statement and normal query http://bugs.mysql.com/bug.php?id=119058 Submitted by: chi zhang
Category: Server: PS
Status: Verified
Severity: 1
OS: Any
Version: 9.4.0
]]> Tue, 23 Sep 2025 00:57:56 +0000 Server: PS http://bugs.mysql.com/119048 #119048: inconsistent result of two equivalent query with operator ~ http://bugs.mysql.com/bug.php?id=119048 Submitted by: chi zhang
Category: Server: PS
Status: Verified
Severity: 2
OS: Any
Version: 9.4.0
]]> Sun, 21 Sep 2025 12:57:23 +0000 Server: PS http://bugs.mysql.com/118982 #118982: Unexpected result of IN operator http://bugs.mysql.com/bug.php?id=118982 Submitted by: chi zhang
Category: Server: Optimizer
Status: Not a Bug
Severity: 1
OS: Linux
Version: 9.4.0
]]> Wed, 10 Sep 2025 06:55:26 +0000 Server: Optimizer http://bugs.mysql.com/119793 #119793: Incorrect result of prepared SELECT when running with JDBC http://bugs.mysql.com/bug.php?id=119793 Submitted by: chi zhang
Category: Server: PS
Status: Verified
Severity: 1
OS: Any
Version: 9.5.0
]]> Tue, 27 Jan 2026 10:32:17 +0000 Server: PS http://bugs.mysql.com/119650 #119650: IN operator returns unexpected result when one of values in the list is NULL http://bugs.mysql.com/bug.php?id=119650 Submitted by: chi zhang
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: Any
Version: 9.5.0
]]> Fri, 09 Jan 2026 02:04:38 +0000 Server: Optimizer http://bugs.mysql.com/119637 #119637: Data type of value changed by prepared statement http://bugs.mysql.com/bug.php?id=119637 Submitted by: chi zhang
Category: Server
Status: Not a Bug
Severity: 1
OS: Any
Version: 9.5.0
]]> Wed, 07 Jan 2026 08:15:31 +0000 Server http://bugs.mysql.com/119833 #119833: Inconsistent behaviour between normal and prepared SELECT on subquery http://bugs.mysql.com/bug.php?id=119833 Submitted by: chi zhang
Category: Server
Status: Not a Bug
Severity: 1
OS: Any
Version: 9.5.0
]]> Mon, 02 Feb 2026 12:57:05 +0000 Server