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/78415 #78415: Equivalent SQL like "select cast( varchar as decimal)" returns different results http://bugs.mysql.com/bug.php?id=78415 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.6.22, 5.6.26, 5.7.9
]]> Sat, 12 Sep 2015 06:17:03 +0000 Server: DML http://bugs.mysql.com/100567 #100567: Unexpected cast to float from attribute of a JSON datum http://bugs.mysql.com/bug.php?id=100567 Submitted by: Marcos Albe
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0, 8.0.21, 8.0.11
]]> Wed, 19 Aug 2020 03:37:42 +0000 Server: JSON http://bugs.mysql.com/46037 #46037: Inconsistent behavior when casting floating point numbers to integer http://bugs.mysql.com/bug.php?id=46037 Submitted by: Øystein Grøvlen
Category: Server: Types
Status: Verified
Severity: 3
OS: Any
Version: mysql-azalea/5.1
]]> Wed, 08 Jul 2009 11:11:51 +0000 Server: Types http://bugs.mysql.com/50567 #50567: CAST from large double to integer produces inconsistent results http://bugs.mysql.com/bug.php?id=50567 Submitted by: Alexey Kopytov
Category: Server: General
Status: Verified
Severity: 3
OS: Any
Version: 5.1+
]]> Sat, 23 Jan 2010 15:46:12 +0000 Server: General http://bugs.mysql.com/119032 #119032: Inconsistency with MySQL 8.0.36 in MySQL 9.2.0: Equivalent INTERSECT query does not match INNER JOIN result and returns http://bugs.mysql.com/bug.php?id=119032 Submitted by: 策 吕
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 9.2.0
]]> Thu, 18 Sep 2025 07:52:42 +0000 Server: Optimizer http://bugs.mysql.com/79917 #79917: Func COALESCE( date, timestamp) and datetime are not working consistently http://bugs.mysql.com/bug.php?id=79917 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8, 5.5.48, 5.6.28, 5.7.10
]]> Mon, 11 Jan 2016 12:41:56 +0000 Server: DML http://bugs.mysql.com/116335 #116335: Multi-valued index isn't used with some range scans on composite indexes http://bugs.mysql.com/bug.php?id=116335 Submitted by: Maciej Dobrzanski
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 8.0.39
]]> Thu, 10 Oct 2024 16:53:47 +0000 Server: Optimizer http://bugs.mysql.com/31776 #31776: CAST AS CHAR with SELECT DISTINCT http://bugs.mysql.com/bug.php?id=31776 Submitted by: david beau
Category: Server: DML
Status: Verified
Severity: 3
OS: Any (Linux, Microsoft Windows XP SP2)
Version: 5.0.45, 4.1, 5.0, 5.1, 5.2 BK
]]> Tue, 23 Oct 2007 08:19:15 +0000 Server: DML http://bugs.mysql.com/79915 #79915: Function NULLIF + CAST is not working as expected http://bugs.mysql.com/bug.php?id=79915 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8, 5.6.28, 5.7.10
]]> Mon, 11 Jan 2016 08:18:32 +0000 Server: DML http://bugs.mysql.com/118278 #118278: two query SQL statements filling with opposite semantics in the where clause, result same result http://bugs.mysql.com/bug.php?id=118278 Submitted by: SamonBing SamonBing
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41
]]> Tue, 27 May 2025 08:29:06 +0000 Server: Optimizer http://bugs.mysql.com/118833 #118833: Two queries that use the where clause with opposite semantics return the same result. http://bugs.mysql.com/bug.php?id=118833 Submitted by: Alice Alice
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41
]]> Thu, 14 Aug 2025 02:43:05 +0000 Server: Optimizer http://bugs.mysql.com/118837 #118837: After having(col) in the query statement is changed to having min(col), the returned result is incorrect. http://bugs.mysql.com/bug.php?id=118837 Submitted by: Alice Alice
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41
]]> Thu, 14 Aug 2025 03:05:17 +0000 Server: Optimizer http://bugs.mysql.com/34562 #34562: CAST does not accept standard-sql numeric types http://bugs.mysql.com/bug.php?id=34562 Submitted by: Ken Johanson
Category: Server: Types
Status: Verified
Severity: 3
OS: Any
Version: 5.1.22-rc-log
]]> Thu, 14 Feb 2008 18:55:16 +0000 Server: Types http://bugs.mysql.com/34564 #34564: CAST does not accept varchar type http://bugs.mysql.com/bug.php?id=34564 Submitted by: Ken Johanson
Category: Server: Parser
Status: Verified
Severity: 3
OS: Any
Version: 5.1.22-rc-log
]]> Thu, 14 Feb 2008 19:20:47 +0000 Server: Parser http://bugs.mysql.com/44363 #44363: IDIV not rounding off float/decimals correctly ? http://bugs.mysql.com/bug.php?id=44363 Submitted by: Prafulla Tekawade
Category: Server: General
Status: Verified
Severity: 2
OS: Any
Version: 5.1.15, 5.1.35-bzr
]]> Mon, 20 Apr 2009 09:56:49 +0000 Server: General http://bugs.mysql.com/79925 #79925: String const '69E5' is not treated as scientific notation when casting to int http://bugs.mysql.com/bug.php?id=79925 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8, 5.5.48, 5.6.28, 5.7.10
]]> Tue, 12 Jan 2016 08:07:49 +0000 Server: DML http://bugs.mysql.com/81673 #81673: UNION ALL returned incorrect result http://bugs.mysql.com/bug.php?id=81673 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8
]]> Wed, 01 Jun 2016 11:12:06 +0000 Server: DML http://bugs.mysql.com/116723 #116723: Issues with explicit type casting using CAST. http://bugs.mysql.com/bug.php?id=116723 Submitted by: PeiQi Luo
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.4.2, 8.0.40
]]> Wed, 20 Nov 2024 07:35:34 +0000 Server: Optimizer http://bugs.mysql.com/36539 #36539: data truncation and implicit cast return different values than explicit cast http://bugs.mysql.com/bug.php?id=36539 Submitted by: Scott Noyes
Category: Server: Types
Status: Verified
Severity: 2
OS: Any
Version: 5.0.38+, 5.1, 6.0
]]> Tue, 06 May 2008 15:44:46 +0000 Server: Types http://bugs.mysql.com/68759 #68759: Inconsistent results on comparison a time field with a non-time literal http://bugs.mysql.com/bug.php?id=68759 Submitted by: Elena Stepanova
Category: Server: Types
Status: Verified
Severity: 3
OS: Any
Version: 5.6.10
]]> Sun, 24 Mar 2013 12:49:59 +0000 Server: Types http://bugs.mysql.com/79110 #79110: When casting a BIG number to unsigned, get inconsistent result for same number http://bugs.mysql.com/bug.php?id=79110 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8,5.1.77,5.5.47,5.6.27,5.7.9
]]> Wed, 04 Nov 2015 04:17:16 +0000 Server: DML http://bugs.mysql.com/79292 #79292: cast('-123.9' as signed) returns -123, not expected -124 http://bugs.mysql.com/bug.php?id=79292 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.0/5.1/5.5/5.6/5.7
]]> Mon, 16 Nov 2015 09:48:58 +0000 Server: DML http://bugs.mysql.com/79518 #79518: Get inconsistent string when converting year column to char http://bugs.mysql.com/bug.php?id=79518 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8, 5.5.48, 5.6.29, 5.7.11
]]> Fri, 04 Dec 2015 07:42:49 +0000 Server: DML http://bugs.mysql.com/81508 #81508: Type in meta data for "cast('a' as char(100))" is VAR_STRING http://bugs.mysql.com/bug.php?id=81508 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8, 5.7.12, 5.6.30
]]> Thu, 19 May 2016 13:22:19 +0000 Server: DML http://bugs.mysql.com/84558 #84558: Cast to NUMERIC not working http://bugs.mysql.com/bug.php?id=84558 Submitted by: Yuri Farina
Category: Server: Types
Status: Verified
Severity: 3
OS: Any
Version: 5.5/5.6/5.7/8.0
]]> Wed, 18 Jan 2017 17:07:21 +0000 Server: Types http://bugs.mysql.com/100985 #100985: Stored value for 0.001 is inconsistent, and casted to decimal is also different http://bugs.mysql.com/bug.php?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
]]> Tue, 29 Sep 2020 07:42:50 +0000 Server: Optimizer http://bugs.mysql.com/102831 #102831: transaction-isolation level is not honored when changed at session level http://bugs.mysql.com/bug.php?id=102831 Submitted by: FRANCISCO BORDENAVE
Category: Server: InnoDB
Status: Verified
Severity: 2
OS: Any (CentOS, Ubuntu)
Version: 5.7.31, 5.7.33
]]> Fri, 05 Mar 2021 16:32:06 +0000 Server: InnoDB http://bugs.mysql.com/112816 #112816: Inconsistent results when JOINed in different order http://bugs.mysql.com/bug.php?id=112816 Submitted by: Wang Ke
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.0, 8.1
]]> Tue, 24 Oct 2023 16:15:06 +0000 Server: Optimizer http://bugs.mysql.com/112910 #112910: Incorrect results when add an uncorrelated row http://bugs.mysql.com/bug.php?id=112910 Submitted by: Wang Ke
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.1.0, 8.0.35
]]> Wed, 01 Nov 2023 07:20:21 +0000 Server: Optimizer http://bugs.mysql.com/117714 #117714: Incorrect row filtering when using CAST(... AS DATE) adding an AND condition. http://bugs.mysql.com/bug.php?id=117714 Submitted by: Xenovate Xenovate
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.7.42
]]> Fri, 14 Mar 2025 15:36:48 +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/119035 #119035: Incorrect result for BETWEEN with mixed types on a BINARY column with a UNIQUE key http://bugs.mysql.com/bug.php?id=119035 Submitted by: zz z
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 9.4.0 8.4.6
]]> Thu, 18 Sep 2025 10:11:21 +0000 Server: Optimizer http://bugs.mysql.com/119369 #119369: MySQL 8.0 sys.x$innodb_lock_waits has Unnecessary type conversion http://bugs.mysql.com/bug.php?id=119369 Submitted by: wen cai
Category: Server: SYS Schema
Status: Open
Severity: 3
OS: Any
Version: MySQL 8.0
]]> Wed, 12 Nov 2025 09:10:22 +0000 Server: SYS Schema 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/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/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/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/47483 #47483: SELECT UNION wrong length after prepare http://bugs.mysql.com/bug.php?id=47483 Submitted by: Ulf Wendel
Category: C API
Status: Verified
Severity: 3
OS: Any
Version: 5.1
]]> Mon, 21 Sep 2009 14:05:56 +0000 C API http://bugs.mysql.com/78640 #78640: CAST OF 'DOUBLE' VALUE TO 'UNSIGNED' GIVES INCORRECT VALUE http://bugs.mysql.com/bug.php?id=78640 Submitted by: Guilhem Bichot
Category: Server: Types
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8, 5.5.47, 5.6.28, 5.7.10
]]> Wed, 30 Sep 2015 08:42:21 +0000 Server: Types http://bugs.mysql.com/78821 #78821: When comparing bigint and varchar constant, inconsistent results are returned http://bugs.mysql.com/bug.php?id=78821 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 2
OS: Any
Version: 5.7.8, 5.7.10, 5.6.27, 5.5.47
]]> Tue, 13 Oct 2015 15:28:07 +0000 Server: DML http://bugs.mysql.com/79295 #79295: select cast(-1 as unsigned) returns 18446744073709551615 http://bugs.mysql.com/bug.php?id=79295 Submitted by: Su Dylan
Category: Server: Types
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8
]]> Mon, 16 Nov 2015 15:48:58 +0000 Server: Types http://bugs.mysql.com/79916 #79916: Comparison gives inconsistent result for time(1) column and explicit cast result http://bugs.mysql.com/bug.php?id=79916 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8, 5.6.28, 5.7.10
]]> Mon, 11 Jan 2016 09:34:37 +0000 Server: DML http://bugs.mysql.com/88033 #88033: Generated INT column with value from JSON document http://bugs.mysql.com/bug.php?id=88033 Submitted by: Geert Vanderkelen
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.24, 5.7.19
]]> Mon, 09 Oct 2017 18:38:37 +0000 Server: JSON http://bugs.mysql.com/96983 #96983: can not CAST( anything AS JSON) in stored routines , triggers http://bugs.mysql.com/bug.php?id=96983 Submitted by: YAN LOONG LIM
Category: MySQL Workbench: Modeling
Status: Verified
Severity: 3
OS: Any
Version: 8.0.17
]]> Tue, 24 Sep 2019 06:43:00 +0000 MySQL Workbench: Modeling http://bugs.mysql.com/114380 #114380: Incorrect query result may caused by TIMESTAMP http://bugs.mysql.com/bug.php?id=114380 Submitted by: Ye Shiyang
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 8.0.13, 8.0.35, 8.0.36
]]> Sun, 17 Mar 2024 13:19:23 +0000 Server: DML http://bugs.mysql.com/115778 #115778: Cast DATE_ADD/SUB result as double get wrong result. http://bugs.mysql.com/bug.php?id=115778 Submitted by: Shenghui Wu
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 8.4.0, 8.0
]]> Tue, 06 Aug 2024 06:24:42 +0000 Server: DML http://bugs.mysql.com/116726 #116726: Issues with the combination of CAST and DATE. http://bugs.mysql.com/bug.php?id=116726 Submitted by: PeiQi Luo
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.4.2, 8.0.40
]]> Wed, 20 Nov 2024 08:22:55 +0000 Server: Optimizer http://bugs.mysql.com/116846 #116846: The logical error of the NULLIF function in the WHERE condition. http://bugs.mysql.com/bug.php?id=116846 Submitted by: wang jack
Category: Server: Types
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Mon, 02 Dec 2024 14:42:21 +0000 Server: Types http://bugs.mysql.com/117927 #117927: duplicate key in table while using tmp table for group by a json data http://bugs.mysql.com/bug.php?id=117927 Submitted by: Jinyou Ma
Category: Server: JSON
Status: Verified
Severity: 2
OS: Any
Version: 8.0.41, 8.4
]]> Thu, 10 Apr 2025 06:25:28 +0000 Server: JSON http://bugs.mysql.com/119354 #119354: IN subquery evaluates incorrectly when using IFNULL and CAST AS DATETIME http://bugs.mysql.com/bug.php?id=119354 Submitted by: zz z
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 9.4.0 8.4.6
]]> Mon, 10 Nov 2025 15:51:50 +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/39125 #39125: Result file for test contains a "temporary error", how can this be stable ? http://bugs.mysql.com/bug.php?id=39125 Submitted by: Joerg Bruehe
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Any
Version: mysql-5.1-telco-6.3
]]> Fri, 29 Aug 2008 16:31:35 +0000 Server: Cluster http://bugs.mysql.com/62156 #62156: main.func_str fails when run with --repeat=2 http://bugs.mysql.com/bug.php?id=62156 Submitted by: Oleg Tsarev
Category: Server: Tests
Status: Verified
Severity: 3
OS: Any
Version: 5.5
]]> Fri, 12 Aug 2011 15:57:25 +0000 Server: Tests http://bugs.mysql.com/64791 #64791: Mixed String/Int values in IN list cause full table scan http://bugs.mysql.com/bug.php?id=64791 Submitted by: Gavin Towey
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.1.61, 5.5
]]> Wed, 28 Mar 2012 20:17:16 +0000 Server: Optimizer http://bugs.mysql.com/79656 #79656: "'2' + 0.0, group_concat('2') + 0.0" are returning different result http://bugs.mysql.com/bug.php?id=79656 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8, 5.5.48, 5.6.28, 5.7.10
]]> Wed, 16 Dec 2015 04:00:01 +0000 Server: DML http://bugs.mysql.com/79974 #79974: "Out of range value for column '(null)'" is not clear enough http://bugs.mysql.com/bug.php?id=79974 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8, 5.5.48, 5.6.28, 5.7.10
]]> Thu, 14 Jan 2016 03:04:14 +0000 Server: DML http://bugs.mysql.com/80154 #80154: Function ROUND( int value, 10) gets padding 0s http://bugs.mysql.com/bug.php?id=80154 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.0/5.1/5.5/5.6/5.7
]]> Tue, 26 Jan 2016 12:33:54 +0000 Server: DML http://bugs.mysql.com/93010 #93010: JSON_SET() does not create intermediate objects http://bugs.mysql.com/bug.php?id=93010 Submitted by: Alfredo Kojima
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.13
]]> Tue, 30 Oct 2018 14:40:14 +0000 Server: JSON http://bugs.mysql.com/94925 #94925: Wrong Query Sample Text in Performance Query http://bugs.mysql.com/bug.php?id=94925 Submitted by: Peter Zaitsev
Category: Server: Performance Schema
Status: Verified
Severity: 3
OS: Any
Version: 8.0.15
]]> Sat, 06 Apr 2019 00:15:33 +0000 Server: Performance Schema http://bugs.mysql.com/105875 #105875: Unexpected output for CAST('2000' AS YEAR) when using MySQL Shell http://bugs.mysql.com/bug.php?id=105875 Submitted by: Daniël van Eeden
Category: Server: Shell CLI
Status: Verified
Severity: 1
OS: Any
Version: 8.0.27
]]> Mon, 13 Dec 2021 09:40:01 +0000 Server: Shell CLI http://bugs.mysql.com/106225 #106225: select bin("") should return 0 instead of null http://bugs.mysql.com/bug.php?id=106225 Submitted by: Huaiyu Xu
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7, 8.0, 8.0.32
]]> Thu, 20 Jan 2022 09:54:36 +0000 Server: DML http://bugs.mysql.com/106654 #106654: join on json key can not use index, but join on virtual column can use index http://bugs.mysql.com/bug.php?id=106654 Submitted by: mingsen xie
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 8.0
]]> Mon, 07 Mar 2022 12:06:40 +0000 Server: Optimizer http://bugs.mysql.com/107645 #107645: the cast function gets an incorrect result if with wrong encoding http://bugs.mysql.com/bug.php?id=107645 Submitted by: x j
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.38, 8.0.29
]]> Fri, 24 Jun 2022 03:00:24 +0000 Server: DML http://bugs.mysql.com/108357 #108357: inconsistent behavior about the cast function and modify column http://bugs.mysql.com/bug.php?id=108357 Submitted by: x j
Category: Server: DDL
Status: Verified
Severity: 3
OS: Any
Version: 8.0.26, 5.7.39, 8.0.30
]]> Thu, 01 Sep 2022 04:10:23 +0000 Server: DDL http://bugs.mysql.com/111415 #111415: Correlated group query wrong result http://bugs.mysql.com/bug.php?id=111415 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Wed, 14 Jun 2023 09:39:11 +0000 Server: Optimizer http://bugs.mysql.com/115085 #115085: INDEX using CAST (json_column) AS ARRAY drops rows containing empty array http://bugs.mysql.com/bug.php?id=115085 Submitted by: Ronald Bradford
Category: Server: DML
Status: Verified
Severity: 2
OS: Any (Docker Image)
Version: 8.0.34, 8.4.0
]]> Wed, 22 May 2024 20:39:18 +0000 Server: DML http://bugs.mysql.com/116775 #116775: Performance of TPC-DS Query 16 http://bugs.mysql.com/bug.php?id=116775 Submitted by: JINSHENG BA
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 596f0d23 (9.0.0), 8.0.40
]]> Mon, 25 Nov 2024 18:34:40 +0000 Server: Optimizer http://bugs.mysql.com/117130 #117130: error occurs when using cast collate binary http://bugs.mysql.com/bug.php?id=117130 Submitted by: ximin liang
Category: Server: Parser
Status: Verified
Severity: 3
OS: Any
Version: 9.1.0
]]> Wed, 08 Jan 2025 07:03:18 +0000 Server: Parser http://bugs.mysql.com/118336 #118336: after adding a having clause equivalent to "having 1", the returned result set is wrong http://bugs.mysql.com/bug.php?id=118336 Submitted by: SamonBing SamonBing
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41
]]> Tue, 03 Jun 2025 08:24:32 +0000 Server: Optimizer 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/118836 #118836: adding a having clause that return 1/TRUE, the query returns a different and wrong empty result. http://bugs.mysql.com/bug.php?id=118836 Submitted by: Alice Alice
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41
]]> Thu, 14 Aug 2025 03:01:10 +0000 Server: Optimizer http://bugs.mysql.com/119033 #119033: Incorrect filtering when comparing a BINARY-cast integer to a BIT column with a UNIQUE key http://bugs.mysql.com/bug.php?id=119033 Submitted by: zz z
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 9.4.0 8.4.6
]]> Thu, 18 Sep 2025 09:16:13 +0000 Server: Optimizer http://bugs.mysql.com/119346 #119346: CASE expression evaluates incorrectly http://bugs.mysql.com/bug.php?id=119346 Submitted by: zz z
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Mon, 10 Nov 2025 09:43:37 +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/119752 #119752: after changing MINUTE(subq.c1) to MINUTE(subq.c1 + INTERVAL '60' MINUTE),the result become empty. http://bugs.mysql.com/bug.php?id=119752 Submitted by: cl hl
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.44
]]> Thu, 22 Jan 2026 15:08:56 +0000 Server: Optimizer 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/119823 #119823: drop index can lead to different results http://bugs.mysql.com/bug.php?id=119823 Submitted by: fan liu
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.44
]]> Sun, 01 Feb 2026 11:42:38 +0000 Server: Optimizer http://bugs.mysql.com/119955 #119955: Semantically equivalent scalar expressions yield different result sets in WHERE clause involving RPAD() http://bugs.mysql.com/bug.php?id=119955 Submitted by: Jasper Andrew
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any (Docker container)
Version: 8.0.43 (MySQL Community Server - GPL)
]]> Fri, 27 Feb 2026 05:03:41 +0000 Server: Optimizer http://bugs.mysql.com/24424 #24424: CHAR data-type not space-padding http://bugs.mysql.com/bug.php?id=24424 Submitted by: Michael Austin
Category: Server: Types
Status: Verified
Severity: 1
OS: Any (ALL)
Version: 5.1.11
]]> Sun, 19 Nov 2006 04:28:27 +0000 Server: Types http://bugs.mysql.com/29202 #29202: Result of UDF in subquery is truncated http://bugs.mysql.com/bug.php?id=29202 Submitted by: Sergei Golubchik
Category: Server: UDF
Status: Verified
Severity: 3
OS: Any
Version: 5.1
]]> Tue, 19 Jun 2007 09:11:11 +0000 Server: UDF http://bugs.mysql.com/56025 #56025: Weird date between behavior, not consistent between versions http://bugs.mysql.com/bug.php?id=56025 Submitted by: Kevin ultimate
Category: Server: General
Status: Verified
Severity: 3
OS: Any
Version: 5.0.67, 5.0, 5.1, 5.6.99
]]> Mon, 16 Aug 2010 18:25:19 +0000 Server: General http://bugs.mysql.com/64589 #64589: Alphanumeric strings bring back results on integer columns - SQL mode needed! http://bugs.mysql.com/bug.php?id=64589 Submitted by: Ryan Klefas
Category: Server: Types
Status: Verified
Severity: 3
OS: Any
Version: 5.1; 5.5
]]> Thu, 08 Mar 2012 05:08:59 +0000 Server: Types http://bugs.mysql.com/64769 #64769: comparing indexed ENUM with 0+string constant does not use index properly http://bugs.mysql.com/bug.php?id=64769 Submitted by: Frederic Briere
Category: Server: DML
Status: Verified
Severity: 3
OS: Any (Debian unstable)
Version: 5.1.61
]]> Mon, 26 Mar 2012 22:27:29 +0000 Server: DML 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/70684 #70684: HAVING referring to subquery results in WARNING 1292 http://bugs.mysql.com/bug.php?id=70684 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.5.33, 5.6.14
]]> Tue, 22 Oct 2013 08:13:59 +0000 Server: Optimizer http://bugs.mysql.com/76215 #76215: Implicit casts to string by COLLATE don't use character_set_connection http://bugs.mysql.com/bug.php?id=76215 Submitted by: Alan Egerton
Category: Server: Charsets
Status: Verified
Severity: 3
OS: Any
Version: 5.5.44, 5.6.25
]]> Mon, 09 Mar 2015 01:57:24 +0000 Server: Charsets http://bugs.mysql.com/80045 #80045: Syntax error returned for invalid D in DECIMAL(M, D), ERROR 1427 expected http://bugs.mysql.com/bug.php?id=80045 Submitted by: Su Dylan
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.7.8, 5.5.48, 5.6.28, 5.7.10
]]> Tue, 19 Jan 2016 09:03:03 +0000 Server: DML http://bugs.mysql.com/82308 #82308: use of DISTINCT with BIT and LONGTEXT leads to erroneous results http://bugs.mysql.com/bug.php?id=82308 Submitted by: Andreas Heinzel
Category: Server: MyISAM
Status: Verified
Severity: 1
OS: Any
Version: 5.7
]]> Thu, 21 Jul 2016 14:54:00 +0000 Server: MyISAM http://bugs.mysql.com/84082 #84082: JSON_OBJECT("k", dateTime) adds milliseconds to time http://bugs.mysql.com/bug.php?id=84082 Submitted by: enzo mdd
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 5.7.14-google-log
]]> Tue, 06 Dec 2016 19:01:28 +0000 Server: JSON http://bugs.mysql.com/86043 #86043: Can't use BigInt or Double as userId instead of Int32 (default) http://bugs.mysql.com/bug.php?id=86043 Submitted by: Sachin Erande
Category: Connector/Net
Status: Analyzing
Severity: 1
OS: Any
Version: 6.8.8
]]> Sat, 22 Apr 2017 02:23:50 +0000 Connector/Net http://bugs.mysql.com/101945 #101945: JSON Unsigned Integer out of range for Unsigned Bigint column http://bugs.mysql.com/bug.php?id=101945 Submitted by: Morgan Tocker
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 5.7.31, 8.0.22
]]> Wed, 09 Dec 2020 22:03:42 +0000 Server: JSON http://bugs.mysql.com/102224 #102224: dtuple_get_nth_field is not const clean http://bugs.mysql.com/bug.php?id=102224 Submitted by: david zhang
Category: Server: InnoDB
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Mon, 11 Jan 2021 23:14:20 +0000 Server: InnoDB http://bugs.mysql.com/102873 #102873: implicit cast WHERE datetime_column = 0 not producing Incorrect DATETIME value http://bugs.mysql.com/bug.php?id=102873 Submitted by: Nikolai Ikhalainen
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 8.0.23
]]> Tue, 09 Mar 2021 07:23:15 +0000 Server: DML http://bugs.mysql.com/105652 #105652: buffer pool flush_rbt could be disorded with innodb tablespace > 32TB http://bugs.mysql.com/bug.php?id=105652 Submitted by: Fungo Wang
Category: Server: InnoDB
Status: Verified
Severity: 2
OS: Any
Version: 5.7, 8.0
]]> Mon, 22 Nov 2021 04:41:10 +0000 Server: InnoDB http://bugs.mysql.com/106437 #106437: need an option to let applier thread ignore virtual columns on replica.. http://bugs.mysql.com/bug.php?id=106437 Submitted by: Shane Bester
Category: Server: RBR
Status: Verified
Severity: 2
OS: Any
Version: 8.0.28
]]> Thu, 10 Feb 2022 23:42:02 +0000 Server: RBR http://bugs.mysql.com/108500 #108500: updateBlob fails with ClassCastException when replication is in use http://bugs.mysql.com/bug.php?id=108500 Submitted by: Stephen Baker
Category: Connector/J
Status: Verified
Severity: 2
OS: Any
Version: 8.0.30
]]> Thu, 15 Sep 2022 20:03:34 +0000 Connector/J http://bugs.mysql.com/108563 #108563: Cannot create json index in procedure http://bugs.mysql.com/bug.php?id=108563 Submitted by: Shaohua Wang
Category: Server: DDL
Status: Verified
Severity: 3
OS: Any
Version: 8.0.28, 8.0.30
]]> Wed, 21 Sep 2022 09:36:13 +0000 Server: DDL http://bugs.mysql.com/110681 #110681: Setting rewriteBatchedStatements=true with multi-host connections bug http://bugs.mysql.com/bug.php?id=110681 Submitted by: Tomonori Iida
Category: Connector/J
Status: Verified
Severity: 3
OS: Any
Version: 8.0.32
]]> Thu, 13 Apr 2023 11:53:08 +0000 Connector/J http://bugs.mysql.com/112053 #112053: COALESCE a null value with a JSON object returns hex string http://bugs.mysql.com/bug.php?id=112053 Submitted by: Douglas Sims
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Sat, 12 Aug 2023 19:55:20 +0000 Server: JSON http://bugs.mysql.com/114217 #114217: Unexpected Results by Minus Sign http://bugs.mysql.com/bug.php?id=114217 Submitted by: JINSHENG BA
Category: Server: DML
Status: Verified
Severity: 2
OS: Any
Version: 8.2.0, 8.3.0, 8.0.36
]]> Tue, 05 Mar 2024 04:48:44 +0000 Server: DML http://bugs.mysql.com/116724 #116724: Issues with CASE statements http://bugs.mysql.com/bug.php?id=116724 Submitted by: PeiQi Luo
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.4.2, 8.0.40
]]> Wed, 20 Nov 2024 07:44:27 +0000 Server: Optimizer http://bugs.mysql.com/116725 #116725: Issues with CASE statements. http://bugs.mysql.com/bug.php?id=116725 Submitted by: PeiQi Luo
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 8.4.2, 8.0.40
]]> Wed, 20 Nov 2024 07:44:58 +0000 Server: Optimizer http://bugs.mysql.com/118063 #118063: Wrong Join Result after creating index on expressions http://bugs.mysql.com/bug.php?id=118063 Submitted by: Zhaokun Xiang
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 9.0, 8.0, 8.0.42, 8.4.5, 9.3.0
]]> Sun, 27 Apr 2025 19:02:05 +0000 Server: Optimizer http://bugs.mysql.com/118299 #118299: Multi-valued Index on Composite Key Returns Incomplete Results for Rows with Empty JSON Array('[]') http://bugs.mysql.com/bug.php?id=118299 Submitted by: Yichang Song
Category: Server: InnoDB
Status: Verified
Severity: 2
OS: Any
Version: 8.0.42, 8.4.5
]]> Thu, 29 May 2025 06:57:11 +0000 Server: InnoDB http://bugs.mysql.com/118393 #118393: while the having subquery return NULL actually, the query using this having query returns a wrong result. http://bugs.mysql.com/bug.php?id=118393 Submitted by: SamonBing SamonBing
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41
]]> Mon, 09 Jun 2025 01:36:33 +0000 Server: Optimizer http://bugs.mysql.com/118839 #118839: a query including the having subclause that returns NULL, return a wrong nonempty result. http://bugs.mysql.com/bug.php?id=118839 Submitted by: Alice Alice
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41
]]> Thu, 14 Aug 2025 03:13:54 +0000 Server: DML http://bugs.mysql.com/119363 #119363: Complex WHERE Expression on Indexed FLOAT Column Evaluates Incorrectly http://bugs.mysql.com/bug.php?id=119363 Submitted by: zz z
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 9.4.0 8.4.6
]]> Wed, 12 Nov 2025 02:52:14 +0000 Server: Optimizer 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: Verified
Severity: 1
OS: Any
Version: 9.5.0
]]> Fri, 09 Jan 2026 02:04:38 +0000 Server: Optimizer http://bugs.mysql.com/119802 #119802: Assertion 'is_nullable()' failed in Item_typecast_signed::val_int() http://bugs.mysql.com/bug.php?id=119802 Submitted by: Jason Tang
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 8.0.42+
]]> Wed, 28 Jan 2026 13:49:51 +0000 Server: Optimizer http://bugs.mysql.com/63410 #63410: string corrupted in stored procedure concat and cast http://bugs.mysql.com/bug.php?id=63410 Submitted by: Mark Robson
Category: Server: SP
Status: Verified
Severity: 3
OS: FreeBSD (x86_64)
Version: 5.1.60, 5.1.61
]]> Wed, 23 Nov 2011 21:17:05 +0000 Server: SP http://bugs.mysql.com/118858 #118858: Inconsistency between the results returned by MySQL and other vendors' database systems was found during differentiation http://bugs.mysql.com/bug.php?id=118858 Submitted by: 策 吕
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Linux
Version: 9.2.0
]]> Wed, 20 Aug 2025 08:51:36 +0000 Server: Optimizer http://bugs.mysql.com/118544 #118544: A potential join operator bug http://bugs.mysql.com/bug.php?id=118544 Submitted by: 策 吕
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Linux
Version: 9.2.0 , 9.3.0
]]> Fri, 27 Jun 2025 14:18:27 +0000 Server: Optimizer http://bugs.mysql.com/113768 #113768: return error with cast http://bugs.mysql.com/bug.php?id=113768 Submitted by: Alice Alice
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux
Version: 8.0.35
]]> Fri, 26 Jan 2024 02:40:14 +0000 Server: DML http://bugs.mysql.com/71777 #71777: Incorrect results are returned with NULLIF() http://bugs.mysql.com/bug.php?id=71777 Submitted by: Saulius Gurklys
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Linux (ubuntu0.13.10.1)
Version: 5.5.35-0ubuntu0.13.10.1
]]> Thu, 20 Feb 2014 09:39:16 +0000 Server: Optimizer http://bugs.mysql.com/82582 #82582: inconsistent and ambiguous results with cast decimal to datetime http://bugs.mysql.com/bug.php?id=82582 Submitted by: 帅 Bang
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux
Version: 5.6/5.7
]]> Mon, 15 Aug 2016 11:05:01 +0000 Server: DML http://bugs.mysql.com/20924 #20924: CAST(expr as UNSIGNED) returns SIGNED value when used in various functions http://bugs.mysql.com/bug.php?id=20924 Submitted by: Matthew Montgomery
Category: Server: Types
Status: Verified
Severity: 2
OS: Linux (Linux 2.6)
Version: All
]]> Sun, 09 Jul 2006 06:42:05 +0000 Server: Types http://bugs.mysql.com/49253 #49253: Inconsistent behavior concering overflow using numeric expressions and literals. http://bugs.mysql.com/bug.php?id=49253 Submitted by: Horst Hunger
Category: Server: Types
Status: Verified
Severity: 2
OS: Linux (SUSE 11.1, Linux 2.6.27.37-0.1-default #1 SMP x86_64 )
Version: 5.1.41, mysql-next-mr(-alik)
]]> Tue, 01 Dec 2009 09:38:54 +0000 Server: Types http://bugs.mysql.com/69100 #69100: CAST in IF function fails in some case http://bugs.mysql.com/bug.php?id=69100 Submitted by: Gabriel Delépine
Category: Server: InnoDB
Status: Verified
Severity: 1
OS: Linux (Debian 6 / Debian 7 / Ubuntu 12.10 / Windows 8)
Version: 5.5.31-0, 5.5.30-1, 5.5.29-0, 5.5.25-1, 5.5.16, 5.5.30-1.1, 5.6.10, 5.0.97, 5.1.70, 5.5.29, 5.7.2
]]> Tue, 30 Apr 2013 09:53:07 +0000 Server: InnoDB http://bugs.mysql.com/118949 #118949: MySQL 9.2.0: Complex CASE in JOIN makes INNER vs INTERSECT yield different rows http://bugs.mysql.com/bug.php?id=118949 Submitted by: 策 吕
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Linux (ubuntu 20.04)
Version: 9.2.0
]]> Fri, 05 Sep 2025 13:57:11 +0000 Server: Optimizer http://bugs.mysql.com/119513 #119513: MySQL Router SSL Error Leading to Crash http://bugs.mysql.com/bug.php?id=119513 Submitted by: Hyun Young Jung
Category: Router
Status: Open
Severity: 2
OS: Linux (Rocky Linux 8.10 (Green Obsidian))
Version: 8.0.40
]]> Fri, 05 Dec 2025 01:27:09 +0000 Router http://bugs.mysql.com/70598 #70598: Premature expression evaluation prevents short-circuited conditionals http://bugs.mysql.com/bug.php?id=70598 Submitted by: Christopher Shumake
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (.6.18-348.16.1.el5)
Version: 5.5.32,5.5.34, 5.6.14, 5.7.2
]]> Thu, 10 Oct 2013 22:19:06 +0000 Server: Optimizer http://bugs.mysql.com/83146 #83146: time to bit produces inconsistent results http://bugs.mysql.com/bug.php?id=83146 Submitted by: 帅 Bang
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux
Version: 5.6, 5.7
]]> Mon, 26 Sep 2016 07:39:53 +0000 Server: DML http://bugs.mysql.com/110556 #110556: When we use json to build an index, we will get wrong results http://bugs.mysql.com/bug.php?id=110556 Submitted by: linkang zhang
Category: Server: JSON
Status: Verified
Severity: 2
OS: Linux
Version: 8.0.28, 8.0.32
]]> Thu, 30 Mar 2023 02:46:40 +0000 Server: JSON http://bugs.mysql.com/119927 #119927: Inconsistent results between direct query and derived table with BIGINT column and FLOAT predicate (IN clause) http://bugs.mysql.com/bug.php?id=119927 Submitted by: 策 吕
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Linux
Version: 8.0.45
]]> Fri, 20 Feb 2026 10:28:13 +0000 Server: Optimizer http://bugs.mysql.com/105783 #105783: `datetime <cmp> int` returns different result in different SQLs http://bugs.mysql.com/bug.php?id=105783 Submitted by: Huaiyu Xu
Category: Server: DML
Status: Verified
Severity: 2
OS: MacOS
Version: 8.0, 5.7
]]> Fri, 03 Dec 2021 03:18:03 +0000 Server: DML http://bugs.mysql.com/100608 #100608: Beautify query doesn't work when CAST(<field>) AS DOUBLE is used http://bugs.mysql.com/bug.php?id=100608 Submitted by: Arend-Henk Huzen
Category: MySQL Workbench: SQL Editor
Status: Verified
Severity: 3
OS: MacOS
Version: 8.0.21, 8.0.31, 8.0.32, 8.0.33
]]> Fri, 21 Aug 2020 18:25:06 +0000 MySQL Workbench: SQL Editor http://bugs.mysql.com/105379 #105379: select greatest("2020-12-12 12:12:12a", cast("2020-12-12 12:12:12" as datetime)) http://bugs.mysql.com/bug.php?id=105379 Submitted by: Huaiyu Xu
Category: Server: DML
Status: Verified
Severity: 3
OS: MacOS
Version: 8.0, 5.7
]]> Fri, 29 Oct 2021 09:28:44 +0000 Server: DML http://bugs.mysql.com/118161 #118161: Having Homebrew-installed googletest breaks build http://bugs.mysql.com/bug.php?id=118161 Submitted by: Laurynas Biveinis
Category: Server: Compiling
Status: Verified
Severity: 3
OS: MacOS (15.4.1)
Version: 8.0.43
]]> Mon, 12 May 2025 06:57:38 +0000 Server: Compiling http://bugs.mysql.com/105355 #105355: time <cmp> string returns wrong result http://bugs.mysql.com/bug.php?id=105355 Submitted by: Huaiyu Xu
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: MacOS
Version: 5.7.36, 8.0.27
]]> Thu, 28 Oct 2021 08:33:11 +0000 Server: Optimizer http://bugs.mysql.com/115471 #115471: Linker errors with enabled LTO http://bugs.mysql.com/bug.php?id=115471 Submitted by: Laurynas Biveinis
Category: Server: Compiling
Status: Verified
Severity: 3
OS: MacOS (14.5)
Version: 8.0.37, 8.4.0
]]> Mon, 01 Jul 2024 05:04:04 +0000 Server: Compiling http://bugs.mysql.com/113113 #113113: Build failure with Homebrew LLVM 14-19 on macOS http://bugs.mysql.com/bug.php?id=113113 Submitted by: Laurynas Biveinis
Category: Server: Compiling
Status: Verified
Severity: 3
OS: MacOS
Version: 8.0.41
]]> Thu, 16 Nov 2023 20:26:17 +0000 Server: Compiling http://bugs.mysql.com/119238 #119238: Compilation error with clang 20 http://bugs.mysql.com/bug.php?id=119238 Submitted by: Laurynas Biveinis
Category: Server: Compiling
Status: Open
Severity: 3
OS: MacOS (26.0.1)
Version: 8.0.45
]]> Mon, 27 Oct 2025 07:31:37 +0000 Server: Compiling http://bugs.mysql.com/119239 #119239: Compilation error with clang 21 http://bugs.mysql.com/bug.php?id=119239 Submitted by: Laurynas Biveinis
Category: Server: Compiling
Status: Open
Severity: 3
OS: MacOS (26.0.1)
Version: 8.0.45, 8.4.8
]]> Mon, 27 Oct 2025 07:53:17 +0000 Server: Compiling http://bugs.mysql.com/119242 #119242: 8.4.7 fails to build with clang 21 http://bugs.mysql.com/bug.php?id=119242 Submitted by: Laurynas Biveinis
Category: Server: Compiling
Status: Open
Severity: 3
OS: MacOS (26.0.1)
Version: 8.4.7
]]> Mon, 27 Oct 2025 12:13:48 +0000 Server: Compiling http://bugs.mysql.com/119246 #119246: 9.5.0 compilation error with LLVM 21 http://bugs.mysql.com/bug.php?id=119246 Submitted by: Laurynas Biveinis
Category: Server: Compiling
Status: Open
Severity: 3
OS: MacOS (26.0.1)
Version: 8.4.8, 9.6.0
]]> Mon, 27 Oct 2025 15:02:46 +0000 Server: Compiling http://bugs.mysql.com/117096 #117096: The result of using CAST AS DOUBLE in the query does not meet expectations. http://bugs.mysql.com/bug.php?id=117096 Submitted by: wang jack
Category: Server: DML
Status: Verified
Severity: 3
OS: Windows (windows 11)
Version: 8.4.1, 8.0.40
]]> Thu, 02 Jan 2025 08:43:36 +0000 Server: DML http://bugs.mysql.com/61472 #61472: "Specified cast is not valid" error even when datatypes are perfectly aligned http://bugs.mysql.com/bug.php?id=61472 Submitted by: Pierce Morton
Category: Connector/ODBC
Status: Analyzing
Severity: 1
OS: Windows (XP SP3)
Version: 5.1.8
]]> Fri, 10 Jun 2011 07:26:30 +0000 Connector/ODBC http://bugs.mysql.com/117091 #117091: Using two mutually exclusive predicates as WHERE conditions returned the same result. http://bugs.mysql.com/bug.php?id=117091 Submitted by: wang jack
Category: Server: DML
Status: Verified
Severity: 3
OS: Windows (windows 11)
Version: 8.4.3, 8.0.40
]]> Wed, 01 Jan 2025 15:26:06 +0000 Server: DML http://bugs.mysql.com/117128 #117128: Query results do not meet expectations when the predicate involves CAST AS FLOAT and >> operator http://bugs.mysql.com/bug.php?id=117128 Submitted by: wang jack
Category: Server: DML
Status: Verified
Severity: 3
OS: Windows (windows 11)
Version: 8.4.1, 8.0.40
]]> Wed, 08 Jan 2025 05:42:58 +0000 Server: DML http://bugs.mysql.com/117131 #117131: Query results don't match expectations with FIELD function in predicate. http://bugs.mysql.com/bug.php?id=117131 Submitted by: wang jack
Category: Server: DML
Status: Verified
Severity: 3
OS: Windows (windows 11)
Version: 8.4.1, 8.0.40
]]> Wed, 08 Jan 2025 07:52:29 +0000 Server: DML http://bugs.mysql.com/74196 #74196: Extraneous / unnecessary column output in derived tables (i.e. `Filter1`, etc.) http://bugs.mysql.com/bug.php?id=74196 Submitted by: Ryan Griffith
Category: Connector/Net
Status: Analyzing
Severity: 3
OS: Windows
Version: 6.9.2
]]> Thu, 02 Oct 2014 16:37:52 +0000 Connector/Net http://bugs.mysql.com/101704 #101704: JSON type in CAST() and CONVERT() is recognized as error in model editors http://bugs.mysql.com/bug.php?id=101704 Submitted by: Ju-Myoung Kim
Category: MySQL Workbench: Modeling
Status: Verified
Severity: 3
OS: Windows (Microsoft Windows 10 Pro)
Version: 8.0.22
]]> Sat, 21 Nov 2020 05:02:59 +0000 MySQL Workbench: Modeling http://bugs.mysql.com/102827 #102827: beautifying SQL script http://bugs.mysql.com/bug.php?id=102827 Submitted by: Claude Renglet
Category: MySQL Workbench: SQL Editor
Status: Verified
Severity: 1
OS: Windows (Microsoft Windows 10 Enterprise)
Version: 8.0.23
]]> Fri, 05 Mar 2021 13:57:23 +0000 MySQL Workbench: SQL Editor http://bugs.mysql.com/117089 #117089: Inconsistent results using equivalent predicates in two queries. http://bugs.mysql.com/bug.php?id=117089 Submitted by: wang jack
Category: Server: DML
Status: Verified
Severity: 3
OS: Windows (windows 11)
Version: 8.4.1, 8.0.40
]]> Wed, 01 Jan 2025 08:37:25 +0000 Server: DML http://bugs.mysql.com/61114 #61114: ODBC doesn't support Uint32 / Uint64 ? <-> OdbcType.Int / BigInt http://bugs.mysql.com/bug.php?id=61114 Submitted by: Aswin Coolsaet
Category: Connector/ODBC
Status: Verified
Severity: 3
OS: Windows (7)
Version: connector 5.1.8
]]> Tue, 10 May 2011 11:02:18 +0000 Connector/ODBC http://bugs.mysql.com/92440 #92440: mysql 8.0 and VS 2017 - editing trigger fails with 'unable to load object' http://bugs.mysql.com/bug.php?id=92440 Submitted by: guenter strubinsky
Category: MySQL Visual Studio Integration
Status: Verified
Severity: 3
OS: Windows
Version: 8.0
]]> Sat, 15 Sep 2018 21:02:36 +0000 MySQL Visual Studio Integration http://bugs.mysql.com/118053 #118053: cast((NULLIF) as datetime) returns incorrect result http://bugs.mysql.com/bug.php?id=118053 Submitted by: Chunling Qin
Category: Server: DML
Status: Verified
Severity: 2
OS: CentOS
Version: 8.4.3, 9.3.0, 8.4.5, 8.0.42
]]> Thu, 24 Apr 2025 15:47:56 +0000 Server: DML http://bugs.mysql.com/102601 #102601: nested nullif of json values fails http://bugs.mysql.com/bug.php?id=102601 Submitted by: Dave Pullin
Category: Server: JSON
Status: Verified
Severity: 3
OS: CentOS (CentOS Linux release 7.6.1810 (Core))
Version: 5.7.31, 5.7.33
]]> Mon, 15 Feb 2021 13:42:21 +0000 Server: JSON http://bugs.mysql.com/81116 #81116: Evaluating between DECIMAL and string returns different result depends on index http://bugs.mysql.com/bug.php?id=81116 Submitted by: Tsubasa Tanaka
Category: Server: Types
Status: Verified
Severity: 2
OS: CentOS (6.7)
Version: 5.6.30, 5.5.49
]]> Mon, 18 Apr 2016 02:14:49 +0000 Server: Types http://bugs.mysql.com/102086 #102086: the result of order by cast(field1 as char) is unexpect. http://bugs.mysql.com/bug.php?id=102086 Submitted by: GONGTUI FU
Category: Server: DML
Status: Verified
Severity: 3
OS: Red Hat (7.4)
Version: 8.0.18
]]> Tue, 29 Dec 2020 12:06:04 +0000 Server: DML http://bugs.mysql.com/110751 #110751: rhel8 rpm : mysqlrouter 8.0.33 aborts initial connection http://bugs.mysql.com/bug.php?id=110751 Submitted by: Fred Milonni
Category: Router
Status: Verified
Severity: 3
OS: Red Hat ( 8.4 (Ootpa))
Version: 8.0.33 and 8.0.33
]]> Thu, 20 Apr 2023 15:50:18 +0000 Router http://bugs.mysql.com/110322 #110322: Binary column primary key query with wrong result http://bugs.mysql.com/bug.php?id=110322 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Ubuntu (22.04)
Version: 8.0.32
]]> Thu, 09 Mar 2023 11:41:09 +0000 Server: Optimizer http://bugs.mysql.com/109736 #109736: ANY query with wrong result http://bugs.mysql.com/bug.php?id=109736 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Ubuntu (22.04)
Version: 8.0.32
]]> Mon, 23 Jan 2023 10:41:54 +0000 Server: Optimizer http://bugs.mysql.com/111918 #111918: Auto increment column query wrong result http://bugs.mysql.com/bug.php?id=111918 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Ubuntu (22.04)
Version: 8.1.0, 8.0.34, 5.7.43
]]> Sun, 30 Jul 2023 06:12:00 +0000 Server: Optimizer http://bugs.mysql.com/119998 #119998: ERROR 1292 Incorrect value on INSERT…SELECT when CAST result is NULL http://bugs.mysql.com/bug.php?id=119998 Submitted by: mu mu
Category: Server: Optimizer
Status: Open
Severity: 3
OS: Ubuntu (22.04)
Version: 8.4.8
]]> Fri, 06 Mar 2026 14:56:00 +0000 Server: Optimizer http://bugs.mysql.com/77805 #77805: NULLIF cause wrong value with cast datetime http://bugs.mysql.com/bug.php?id=77805 Submitted by: James Fan
Category: Server: DML
Status: Verified
Severity: 1
OS: Ubuntu (Ubuntu 14.04.2 LTS x86_64)
Version: 5.6.25 MySQL Community Server (GPL)
]]> Thu, 23 Jul 2015 02:01:35 +0000 Server: DML http://bugs.mysql.com/109824 #109824: Bit query with wrong result http://bugs.mysql.com/bug.php?id=109824 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Ubuntu (22.04)
Version: 8.0.32
]]> Fri, 27 Jan 2023 15:43:16 +0000 Server: Optimizer http://bugs.mysql.com/110250 #110250: Right join query with wrong result http://bugs.mysql.com/bug.php?id=110250 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Ubuntu (22.04)
Version: 8.0.32
]]> Wed, 01 Mar 2023 11:59:34 +0000 Server: Optimizer http://bugs.mysql.com/110301 #110301: Change column wrong result http://bugs.mysql.com/bug.php?id=110301 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Ubuntu (22.04)
Version: 8.0.32
]]> Wed, 08 Mar 2023 11:13:16 +0000 Server: Optimizer http://bugs.mysql.com/110310 #110310: BETWEEN query with wrong result http://bugs.mysql.com/bug.php?id=110310 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Ubuntu (22.04)
Version: 8.0.32
]]> Thu, 09 Mar 2023 08:41:43 +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/110988 #110988: VIEW call error http://bugs.mysql.com/bug.php?id=110988 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Ubuntu (22.04)
Version: 8.0.33
]]> Thu, 11 May 2023 08:06:13 +0000 Server: Optimizer http://bugs.mysql.com/95957 #95957: IN operator issue when comparing signed column and the column cast to unsigned http://bugs.mysql.com/bug.php?id=95957 Submitted by: Manuel Rigger
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Ubuntu
Version: 8.0.16, 5.7.26, 5.6.44
]]> Mon, 24 Jun 2019 16:26:58 +0000 Server: Optimizer http://bugs.mysql.com/95964 #95964: Compare that uses UNSIGNED cast and function malfunctions in the MEMORY engine http://bugs.mysql.com/bug.php?id=95964 Submitted by: Manuel Rigger
Category: Server: Memory
Status: Verified
Severity: 3
OS: Ubuntu
Version: 8.0.16, 5.7.26, 5.6.44
]]> Mon, 24 Jun 2019 22:23:25 +0000 Server: Memory http://bugs.mysql.com/109608 #109608: Exists query with wrong result http://bugs.mysql.com/bug.php?id=109608 Submitted by: Pedro Ferreira
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Ubuntu (22.04)
Version: 8.0.31
]]> Thu, 12 Jan 2023 15:11:54 +0000 Server: Optimizer http://bugs.mysql.com/111310 #111310: Prepared statement with CTE memory leak http://bugs.mysql.com/bug.php?id=111310 Submitted by: Pedro Ferreira
Category: Server: PS
Status: Verified
Severity: 3
OS: Ubuntu (22.04)
Version: 8.0.33
]]> Wed, 07 Jun 2023 06:51:48 +0000 Server: PS http://bugs.mysql.com/48238 #48238: Test "partition_alter4_innodb" fails due to "Out of memory" http://bugs.mysql.com/bug.php?id=48238 Submitted by: Joerg Bruehe
Category: Tests: Server
Status: Verified
Severity: 3
OS: Other (AIX + HP-UX, 32 bit)
Version: 5.1.40
]]> Thu, 22 Oct 2009 17:38:44 +0000 Tests: Server