Showing all 222
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 118858 | 2025-08-20 8:51 | 2025-09-23 4:03 | MySQL Server: Optimizer | Verified (418 days) | S2 | 9.2.0 | Linux | Any | Inconsistency between the results returned by MySQL and other vendors' database systems was found during differentiation |
| 78415 | 2015-09-12 6:17 | 2015-09-12 9:50 | MySQL Server: DML | Verified (4082 days) | S3 | 5.6.22, 5.6.26, 5.7.9 | Any | Any | Equivalent SQL like "select cast( varchar as decimal)" returns different results |
| 121327 | 2026-09-20 20:19 | 2026-10-20 5:02 | MySQL Server: Optimizer | Verified (26 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Any | Any | TIME(N) compared with a non-constant string is compared as text, not as a time |
| 118544 | 2025-06-27 14:18 | 2025-09-23 4:03 | MySQL Server: Optimizer | Verified (418 days) | S2 | 9.2.0 , 9.3.0 | Linux | Any | A potential join operator bug |
| 121431 | 2026-10-04 5:24 | 2026-10-13 9:30 | MySQL Server: Optimizer | Verified (33 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Any | Any | Index on BIGINT hides rows equal to a DOUBLE constant just above BIGINT max (range optimizer: value_out_of_range) |
| 117096 | 2025-01-02 8:43 | 2025-01-02 11:59 | MySQL Server: DML | Verified (682 days) | S3 | 8.4.1, 8.0.40 | Windows (windows 11) | x86 (x86_64) | The result of using CAST AS DOUBLE in the query does not meet expectations. |
| 100567 | 2020-08-19 3:37 | 2020-08-27 11:24 | MySQL Server: JSON | Verified (2279 days) | S3 | 8.0, 8.0.21, 8.0.11 | Any | Any | Unexpected cast to float from attribute of a JSON datum |
| 121226 | 2026-09-03 7:52 | 2026-09-03 13:01 | MySQL Server: Optimizer | Verified (73 days) | S3 | 9.7.2 | Any | Any | WHERE int_col = CAST(decimal AS DOUBLE) index access stores the rounded key and returns wrong rows (literal path correct |
| 46037 | 2009-07-08 11:11 | 2018-11-04 20:45 | MySQL Server: Data Types | Verified (6339 days) | S3 | mysql-azalea/5.1 | Any | Any | Inconsistent behavior when casting floating point numbers to integer |
| 50567 | 2010-01-23 15:46 | 2025-12-07 20:45 | MySQL Server: General | Verified (6140 days) | S3 | 5.1+ | Any | Any | CAST from large double to integer produces inconsistent results |
| 119032 | 2025-09-18 7:52 | 2025-09-23 0:51 | MySQL Server: Optimizer | Verified (419 days) | S2 | 9.2.0 | Any | Any | Inconsistency with MySQL 8.0.36 in MySQL 9.2.0: Equivalent INTERSECT query does not match INNER JOIN result and returns |
| 105783 | 2021-12-03 3:18 | 2023-10-21 9:37 | MySQL Server: DML | Verified (1808 days) | S2 | 8.0, 5.7 | MacOS | x86 | `datetime <cmp> int` returns different result in different SQLs |
| 120011 | 2026-03-09 10:29 | 2026-03-09 11:16 | MySQL Server: Optimizer | Verified (251 days) | S1 | 8.0.44 | Any | Any | The normal query generated a non-optimal query plan with index. |
| 121432 | 2026-10-04 5:27 | 2026-10-13 9:37 | MySQL Server: JSON | Verified (33 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Any | Any | Multi-valued index on CAST(... AS UNSIGNED ARRAY) rounds 1.5 to 2; DELETE ... WHERE 2 MEMBER OF removes it |
| 121513 | 2026-10-15 5:12 | 2026-10-20 4:23 | MySQL Server: Data Types | Verified (26 days) | S3 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Any | Any | TIME string parser takes the hour, minute and second fields modulo 2^64: CAST('18446744073709551635:40:27' AS TIME) = 19 |
| 79917 | 2016-01-11 12:41 | 2016-01-13 8:10 | MySQL Server: DML | Verified (3959 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Func COALESCE( date, timestamp) and datetime are not working consistently |
| 110322 | 2023-03-09 11:41 | 2023-03-09 12:31 | MySQL Server: Optimizer | Verified (1347 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | Binary column primary key query with wrong result |
| 113768 | 2024-01-26 2:40 | 2024-01-26 8:53 | MySQL Server: DML | Verified (1024 days) | S3 | 8.0.35 | Linux | Any | return error with cast |
| 116335 | 2024-10-10 16:53 | 2025-09-10 1:54 | MySQL Server: Optimizer | Verified (765 days) | S5 | 8.0.39 | Any | Any | Multi-valued index isn't used with some range scans on composite indexes |
| 120737 | 2026-06-22 8:28 | 2026-06-22 10:31 | MySQL Server: Optimizer | Verified (146 days) | S1 | 8.0.45 | Any | Any | Inconsistent CAST Handling of Out-of-Range TEXT Values in Single Table vs. View/Join Paths |
| 121240 | 2026-09-07 3:00 | 2026-09-07 9:15 | MySQL Server: Data Types | Verified (69 days) | S3 | 8.4.11 | Linux (Oracle Linux Server 9.8; mysql:8.4.11 Docker image via Docker Desktop on Windows/WSL2) | x86 (x86_64 / amd64) | Scientific-notation strings: integer casts differ from arithmetic conversion |
| 31776 | 2007-10-23 8:19 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6962 days) | S3 | 5.0.45, 4.1, 5.0, 5.1, 5.2 BK | Any (Linux, Microsoft Windows XP SP2) | Any | CAST AS CHAR with SELECT DISTINCT |
| 48238 | 2009-10-22 17:38 | 2012-05-18 20:19 | Tests: Server | Verified | S3 | 5.1.40 | Other (AIX + HP-UX, 32 bit) | Any | Test "partition_alter4_innodb" fails due to "Out of memory" |
| 71777 | 2014-02-20 9:39 | 2014-02-20 10:54 | MySQL Server: Optimizer | Verified (4651 days) | S2 | 5.5.35-0ubuntu0.13.10.1 | Linux (ubuntu0.13.10.1) | Any | Incorrect results are returned with NULLIF() |
| 79915 | 2016-01-11 8:18 | 2016-01-11 9:34 | MySQL Server: DML | Verified (3961 days) | S3 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | Function NULLIF + CAST is not working as expected |
| 109736 | 2023-01-23 10:41 | 2023-01-25 7:41 | MySQL Server: Optimizer | Verified (1390 days) | S2 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | ANY query with wrong result |
| 118278 | 2025-05-27 8:29 | 2026-02-06 13:01 | MySQL Server: Optimizer | Verified (282 days) | S3 | 8.0.41 | Any | Any | two query SQL statements filling with opposite semantics in the where clause, result same result |
| 118833 | 2025-08-14 2:43 | 2025-08-19 0:36 | MySQL Server: Optimizer | Verified (453 days) | S3 | 8.0.41 | Any | Any | Two queries that use the where clause with opposite semantics return the same result. |
| 118837 | 2025-08-14 3:05 | 2025-08-18 23:51 | MySQL Server: Optimizer | Verified (454 days) | S3 | 8.0.41 | Any | Any | After having(col) in the query statement is changed to having min(col), the returned result is incorrect. |
| 34562 | 2008-02-14 18:55 | 2018-09-09 20:45 | MySQL Server: Data Types | Verified (6841 days) | S3 | 5.1.22-rc-log | Any | Any | CAST does not accept standard-sql numeric types |
| 34564 | 2008-02-14 19:20 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (6810 days) | S3 | 5.1.22-rc-log | Any | Any | CAST does not accept varchar type |
| 44363 | 2009-04-20 9:56 | 2025-12-07 20:45 | MySQL Server: General | Verified (6417 days) | S2 | 5.1.15, 5.1.35-bzr | Any | Any | IDIV not rounding off float/decimals correctly ? |
| 79925 | 2016-01-12 8:07 | 2023-04-10 2:40 | MySQL Server: DML | Verified (3960 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | String const '69E5' is not treated as scientific notation when casting to int |
| 81673 | 2016-06-01 11:12 | 2016-06-01 11:28 | MySQL Server: DML | Verified (3819 days) | S3 | 5.7.8 | Any | Any | UNION ALL returned incorrect result |
| 116723 | 2024-11-20 7:35 | 2024-11-20 8:45 | MySQL Server: Optimizer | Verified (725 days) | S2 | 8.4.2, 8.0.40 | Any | Any | Issues with explicit type casting using CAST. |
| 120022 | 2026-03-11 2:22 | 2026-03-11 7:10 | MySQL Server: Optimizer | Verified (249 days) | S3 | MySQL 8.0.28 | Any | Any | CAST(AVG()) returns a different result than CAST(SUM()/COUNT()) on DECIMAL values |
| 120809 | 2026-06-29 7:31 | 2026-07-02 14:07 | MySQL Server: Optimizer | Verified (136 days) | S5 | 9.7.1 and 8.0.31 | Ubuntu (22.04.4 LTS) | Any | Optimizer misses DISTINCT early-out and chooses 40M-row hash join Cartesian product |
| 121368 | 2026-09-24 8:43 | 2026-09-24 11:00 | MySQL Server: GIS | Verified (52 days) | S3 | 8.4.11, 9.7.2, 26.7.0 | Any | Any | Possible to store an empty value into a non-NULL GEOMETRY column |
| 36539 | 2008-05-06 15:44 | 2025-12-07 20:45 | MySQL Server: Data Types | Verified (6767 days) | S2 | 5.0.38+, 5.1, 6.0 | Any | Any | data truncation and implicit cast return different values than explicit cast |
| 61472 | 2011-06-10 7:26 | 2025-10-12 20:45 | Connector / ODBC | Analyzing (5599 days) | S1 | 5.1.8 | Windows (XP SP3) | Any | "Specified cast is not valid" error even when datatypes are perfectly aligned |
| 68759 | 2013-03-24 12:49 | 2013-03-25 5:31 | MySQL Server: Data Types | Verified (4983 days) | S3 | 5.6.10 | Any | Any | Inconsistent results on comparison a time field with a non-time literal |
| 79110 | 2015-11-04 4:17 | 2015-11-04 7:23 | MySQL Server: DML | Verified (4029 days) | S3 | 5.7.8,5.1.77,5.5.47,5.6.27,5.7.9 | Any | Any | When casting a BIG number to unsigned, get inconsistent result for same number |
| 79292 | 2015-11-16 9:48 | 2015-11-19 22:03 | MySQL Server: DML | Verified (4014 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | cast('-123.9' as signed) returns -123, not expected -124 |
| 79518 | 2015-12-04 7:42 | 2015-12-07 7:01 | MySQL Server: DML | Verified (3996 days) | S3 | 5.7.8, 5.5.48, 5.6.29, 5.7.11 | Any | Any | Get inconsistent string when converting year column to char |
| 81508 | 2016-05-19 13:22 | 2016-05-20 8:52 | MySQL Server: DML | Verified (3831 days) | S3 | 5.7.8, 5.7.12, 5.6.30 | Any | Any | Type in meta data for "cast('a' as char(100))" is VAR_STRING |
| 82582 | 2016-08-15 11:05 | 2016-08-15 13:34 | MySQL Server: DML | Verified (3744 days) | S3 | 5.6/5.7 | Linux | Any | inconsistent and ambiguous results with cast decimal to datetime |
| 84558 | 2017-01-18 17:07 | 2017-01-18 19:36 | MySQL Server: Data Types | Verified (3588 days) | S3 | 5.5/5.6/5.7/8.0 | Any | Any | Cast to NUMERIC not working |
| 100985 | 2020-09-29 7:42 | 2020-09-29 9:18 | MySQL Server: Optimizer | Verified (2238 days) | S3 | 8.0.21, 5.7.31, 5.6.48 | Any | Any | Stored value for 0.001 is inconsistent, and casted to decimal is also different |
| 102831 | 2021-03-05 16:32 | 2021-04-19 6:39 | MySQL Server: InnoDB storage engine | Verified (2080 days) | S2 | 5.7.31, 5.7.33 | Any (CentOS, Ubuntu) | Any | transaction-isolation level is not honored when changed at session level |
| 111918 | 2023-07-30 6:12 | 2023-07-31 6:33 | MySQL Server: Optimizer | Verified (1203 days) | S3 | 8.1.0, 8.0.34, 5.7.43 | Ubuntu (22.04) | x86 (x86_64) | Auto increment column query wrong result |
| 112816 | 2023-10-24 16:15 | 2023-12-13 12:00 | MySQL Server: Optimizer | Verified (1108 days) | S2 | 8.0, 8.1 | Any | Any | Inconsistent results when JOINed in different order |
| 112910 | 2023-11-01 7:20 | 2023-11-01 7:31 | MySQL Server: Optimizer | Verified (1110 days) | S2 | 8.1.0, 8.0.35 | Any | Any | Incorrect results when add an uncorrelated row |
| 117091 | 2025-01-01 15:26 | 2025-01-02 7:37 | MySQL Server: DML | Verified (682 days) | S3 | 8.4.3, 8.0.40 | Windows (windows 11) | x86 (x86_64) | Using two mutually exclusive predicates as WHERE conditions returned the same result. |
| 117128 | 2025-01-08 5:42 | 2025-01-13 9:23 | MySQL Server: DML | Verified (676 days) | S3 | 8.4.1, 8.0.40 | Windows (windows 11) | x86 | Query results do not meet expectations when the predicate involves CAST AS FLOAT and >> operator |
| 117714 | 2025-03-14 15:36 | 2025-03-21 1:11 | MySQL Server: Optimizer | Verified (607 days) | S2 | 5.7.42 | Any | Any | Incorrect row filtering when using CAST(... AS DATE) adding an AND condition. |
| 118750 | 2025-07-30 3:33 | 2025-09-21 20:45 | MySQL Server: Prepared statements | Analyzing (473 days) | S3 | 9.3.0 | Any | Any | binary comparison has different results in prepared statement and normal SELECT query |
| 119035 | 2025-09-18 10:11 | 2025-09-23 0:48 | MySQL Server: Optimizer | Verified (419 days) | S3 | 9.4.0 8.4.6 | Any | Any | Incorrect result for BETWEEN with mixed types on a BINARY column with a UNIQUE key |
| 119369 | 2025-11-12 9:10 | 2026-01-20 7:17 | MySQL Server: SYS Schema | Open (299 days) | S3 | MySQL 8.0 | Any | Any | MySQL 8.0 sys.x$innodb_lock_waits has Unnecessary type conversion |
| 119670 | 2026-01-13 13:46 | 2026-01-13 14:51 | MySQL Server: Optimizer | Verified (306 days) | S1 | 8.0.44 | Any | Any | Incorrect result caused by index |
| 119716 | 2026-01-19 1:36 | 2026-01-19 9:16 | MySQL Server: Optimizer | Verified (300 days) | S1 | 8.0.44 | Any | Any | Suboptimal query plan generated by normal query compare to prepared statement |
| 119793 | 2026-01-27 10:32 | 2026-02-04 16:32 | MySQL Server: Prepared statements | Verified (284 days) | S1 | 9.5.0 | Any | Any | Incorrect result of prepared SELECT when running with JDBC |
| 120275 | 2026-04-16 7:10 | 2026-04-20 6:51 | MySQL Server: Optimizer | Verified (209 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | DATE Index Lookup Loses Existing JOIN Matches Even with Explicit CAST(MEDIUMTEXT AS DATE), Causing S1/S2 Divergence |
| 121126 | 2026-08-19 11:43 | 2026-09-24 5:39 | MySQL Server: Optimizer | Verified (52 days) | S3 | 8.4.10 | Any | Any | Prepared Cast Unsigned Parameter Truncation |
| 121509 | 2026-10-15 5:00 | 2026-10-20 4:31 | MySQL Server: Data Types | Verified (26 days) | S3 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Any | Any | Integer >= 2^63 converted to TIME is read as signed: CAST(18446744073709551614 AS TIME) = -00:00:02, TIME_TO_SEC() = -2 |
| 47483 | 2009-09-21 14:05 | 2025-12-07 20:45 | MySQL Server: C API (client library) | Verified (6264 days) | S3 | 5.1 | Any | Any | SELECT UNION wrong length after prepare |
| 49253 | 2009-12-01 9:38 | 2018-09-09 20:45 | MySQL Server: Data Types | Verified (6193 days) | S2 | 5.1.41, mysql-next-mr(-alik) | Linux (SUSE 11.1, Linux 2.6.27.37-0.1-default #1 SMP x86_64 ) | Any | Inconsistent behavior concering overflow using numeric expressions and literals. |
| 69100 | 2013-04-30 9:53 | 2015-03-15 20:45 | MySQL Server: InnoDB storage engine | Verified (4941 days) | S1 | 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 | Linux (Debian 6 / Debian 7 / Ubuntu 12.10 / Windows 8) | Any | CAST in IF function fails in some case |
| 78640 | 2015-09-30 8:42 | 2015-09-30 9:28 | MySQL Server: Data Types | Verified (4064 days) | S3 | 5.7.8, 5.5.47, 5.6.28, 5.7.10 | Any | Any | CAST OF 'DOUBLE' VALUE TO 'UNSIGNED' GIVES INCORRECT VALUE |
| 78821 | 2015-10-13 15:28 | 2015-10-15 8:13 | MySQL Server: DML | Verified (4049 days) | S2 | 5.7.8, 5.7.10, 5.6.27, 5.5.47 | Any | Any | When comparing bigint and varchar constant, inconsistent results are returned |
| 79295 | 2015-11-16 15:48 | 2017-08-28 15:00 | MySQL Server: Data Types | Verified (3366 days) | S3 | 5.7.8 | Any | Any | select cast(-1 as unsigned) returns 18446744073709551615 |
| 79916 | 2016-01-11 9:34 | 2016-01-15 4:25 | MySQL Server: DML | Verified (3957 days) | S3 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | Comparison gives inconsistent result for time(1) column and explicit cast result |
| 88033 | 2017-10-09 18:38 | 2021-06-06 8:13 | MySQL Server: JSON | Verified (1988 days) | S3 | 8.0.24, 5.7.19 | Any | Any | Generated INT column with value from JSON document |
| 102086 | 2020-12-29 12:06 | 2020-12-31 1:15 | MySQL Server: DML | Verified (2145 days) | S3 | 8.0.18 | Red Hat (7.4) | Any | the result of order by cast(field1 as char) is unexpect. |
| 114380 | 2024-03-17 13:19 | 2024-03-20 11:21 | MySQL Server: DML | Verified (972 days) | S3 | 8.0.13, 8.0.35, 8.0.36 | Any | Any | Incorrect query result may caused by TIMESTAMP |
| 115778 | 2024-08-06 6:24 | 2024-08-07 7:17 | MySQL Server: DML | Verified (830 days) | S3 | 8.4.0, 8.0 | Any | Any | Cast DATE_ADD/SUB result as double get wrong result. |
| 116726 | 2024-11-20 8:22 | 2024-11-20 8:50 | MySQL Server: Optimizer | Verified (725 days) | S1 | 8.4.2, 8.0.40 | Any | Any | Issues with the combination of CAST and DATE. |
| 116846 | 2024-12-02 14:42 | 2024-12-04 15:06 | MySQL Server: Data Types | Verified (711 days) | S3 | 8.0 | Any | Any | The logical error of the NULLIF function in the WHERE condition. |
| 117131 | 2025-01-08 7:52 | 2025-01-09 9:20 | MySQL Server: DML | Verified (675 days) | S3 | 8.4.1, 8.0.40 | Windows (windows 11) | x86 (x86_64) | Query results don't match expectations with FIELD function in predicate. |
| 117927 | 2025-04-10 6:25 | 2025-04-10 7:35 | MySQL Server: JSON | Verified (584 days) | S2 | 8.0.41, 8.4 | Any | Any | duplicate key in table while using tmp table for group by a json data |
| 118949 | 2025-09-05 13:57 | 2025-09-10 0:42 | MySQL Server: Optimizer | Verified (433 days) | S2 | 9.2.0 | Linux (ubuntu 20.04) | Any | MySQL 9.2.0: Complex CASE in JOIN makes INNER vs INTERSECT yield different rows |
| 119354 | 2025-11-10 15:51 | 2025-12-06 21:52 | MySQL Server: Optimizer | Verified (344 days) | S3 | 9.4.0 8.4.6 | Any | Any | IN subquery evaluates incorrectly when using IFNULL and CAST AS DATETIME |
| 119692 | 2026-01-16 5:23 | 2026-01-16 8:09 | MySQL Server: Optimizer | Verified (303 days) | S1 | 8.0.44 | Any | Any | The normal query generated a non-optimal query plan. |
| 120524 | 2026-05-22 9:40 | 2026-05-26 6:27 | MySQL Server: Optimizer | Verified (173 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Materialized Correlated EXISTS Returns Positive COUNT(*) But No Rows for Implicit VARCHAR-to-YEAR Comparison |
| 120903 | 2026-07-13 9:57 | 2026-07-21 15:45 | MySQL Server: Optimizer | Verified (124 days) | S1 | 8.0.46, 8.4.10, 9.7.1 | Any | Any | WITH ROLLUP in Derived Table Incorrectly Evaluates IFNULL Expression Due to Partial NULL Propagation |
| 120909 | 2026-07-13 11:05 | 2026-07-21 15:16 | MySQL Server: Optimizer | Verified (124 days) | S1 | 8.0.46, 8.4.10, 9.7.1 | Any | Any | ROLLUP Incorrectly Sets Base Group Row to NULL for Constant Folded Expression |
| 120976 | 2026-07-22 4:45 | 2026-07-22 9:34 | MySQL Server: Optimizer | Verified (116 days) | S1 | 9.3 | Any | Any | LATERAL Derived Table Causes IFNULL to Ignore Inner Table Column, Returning NULL for All Rows |
| 121099 | 2026-08-16 22:01 | 2026-08-19 4:53 | MySQL Server: Optimizer | Verified (88 days) | S3 | 8.0.46, 8.4.11, 9.7.2 | Linux | ARM | Merged CASE/CAST view + aliased HAVING MIN(col) >= IFNULL(col, col) returns wrong result |
| 121326 | 2026-09-20 20:03 | 2026-09-21 12:29 | MySQL Server: Optimizer | Verified (55 days) | S2 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | YEAR column compared to a non-integral constant returns and drops wrong rows |
| 121541 | 2026-10-18 18:55 | 2026-10-18 18:55 | MySQL Server: User-defined functions ( UDF ) | Open | S2 | 8.4.0 through 8.4.11 | Any | Any | Loadable function receives a corrupted string argument when the argument is CONCAT(...) of a CAST(... AS CHAR) (MySQL 8. |
| 121757 | 2026-11-13 3:01 | 2026-11-13 3:01 | MySQL Server | Open | S2 | 26.7.0 | Any | Any | ADDDATE() interprets a large positive BIGINT UNSIGNED value as a negative day interval |
| 39125 | 2008-08-29 16:31 | 2026-02-08 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified (6390 days) | S3 | mysql-5.1-telco-6.3 | Any | Any | Result file for test contains a "temporary error", how can this be stable ? |
| 62156 | 2011-08-12 15:57 | 2012-05-18 20:19 | MySQL Server: Tests | Verified (5574 days) | S3 | 5.5 | Any | Any | main.func_str fails when run with --repeat=2 |
| 63410 | 2011-11-23 21:17 | 2012-02-17 18:50 | MySQL Server: Stored Routines | Verified (5385 days) | S3 | 5.1.60, 5.1.61 | FreeBSD (x86_64) | Any | string corrupted in stored procedure concat and cast |
| 64791 | 2012-03-28 20:17 | 2015-07-09 8:35 | MySQL Server: Optimizer | Verified (5344 days) | S2 | 5.1.61, 5.5 | Any | Any | Mixed String/Int values in IN list cause full table scan |
| 74196 | 2014-10-02 16:37 | 2026-09-29 22:50 | Connector / NET | Verified (47 days) | S3 | 6.9.2 | Windows | Any | Extraneous / unnecessary column output in derived tables (i.e. `Filter1`, etc.) |
| 77805 | 2015-07-23 2:01 | 2026-10-14 8:36 | MySQL Server: DML | Verified (4133 days) | S1 | 5.6.25 MySQL Community Server (GPL) | Ubuntu (Ubuntu 14.04.2 LTS x86_64) | Any | NULLIF cause wrong value with cast datetime |
| 79656 | 2015-12-16 4:00 | 2015-12-16 7:59 | MySQL Server: DML | Verified (3987 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | "'2' + 0.0, group_concat('2') + 0.0" are returning different result |
| 79974 | 2016-01-14 3:04 | 2016-01-14 13:08 | MySQL Server: DML | Verified (3958 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | "Out of range value for column '(null)'" is not clear enough |
| 80154 | 2016-01-26 12:33 | 2016-01-26 13:41 | MySQL Server: DML | Verified (3946 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | Function ROUND( int value, 10) gets padding 0s |
| 93010 | 2018-10-30 14:40 | 2018-10-30 20:23 | MySQL Server: JSON | Verified (2938 days) | S3 | 8.0.13 | Any | Any | JSON_SET() does not create intermediate objects |
| 94925 | 2019-04-06 0:15 | 2019-04-24 13:37 | MySQL Server: Performance Schema | Verified (2762 days) | S3 | 8.0.15 | Any | Any | Wrong Query Sample Text in Performance Query |
| 102601 | 2021-02-15 13:42 | 2021-02-16 9:14 | MySQL Server: JSON | Verified (2098 days) | S3 | 5.7.31, 5.7.33 | CentOS (CentOS Linux release 7.6.1810 (Core)) | Any | nested nullif of json values fails |
| 105379 | 2021-10-29 9:28 | 2021-10-29 10:21 | MySQL Server: DML | Verified (1843 days) | S3 | 8.0, 5.7 | MacOS | x86 | select greatest("2020-12-12 12:12:12a", cast("2020-12-12 12:12:12" as datetime)) |
| 105875 | 2021-12-13 9:40 | 2021-12-13 10:52 | Shell General / Core Client | Verified (1798 days) | S1 | 8.0.27 | Any | Any | Unexpected output for CAST('2000' AS YEAR) when using MySQL Shell |
| 106225 | 2022-01-20 9:54 | 2023-02-15 7:31 | MySQL Server: DML | Verified (1760 days) | S3 | 5.7, 8.0, 8.0.32 | Any | Any | select bin("") should return 0 instead of null |
| 106654 | 2022-03-07 12:06 | 2022-03-10 14:01 | MySQL Server: Optimizer | Verified (1711 days) | S5 | 8.0 | Any | Any | join on json key can not use index, but join on virtual column can use index |
| 107645 | 2022-06-24 3:00 | 2022-06-28 13:48 | MySQL Server: DML | Verified (1605 days) | S3 | 5.7.38, 8.0.29 | Any | Any | the cast function gets an incorrect result if with wrong encoding |
| 108357 | 2022-09-01 4:10 | 2022-09-05 4:22 | MySQL Server: DDL | Verified (1532 days) | S3 | 8.0.26, 5.7.39, 8.0.30 | Any | Any | inconsistent behavior about the cast function and modify column |
| 109824 | 2023-01-27 15:43 | 2023-01-28 8:04 | MySQL Server: Optimizer | Verified (1387 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | Bit query with wrong result |
| 110250 | 2023-03-01 11:59 | 2023-03-24 11:16 | MySQL Server: Optimizer | Verified (1349 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | Right join query with wrong result |
| 110301 | 2023-03-08 11:13 | 2023-03-09 12:30 | MySQL Server: Optimizer | Verified (1347 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | Change column wrong result |
| 110310 | 2023-03-09 8:41 | 2023-04-29 15:24 | MySQL Server: Optimizer | Verified (1347 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | BETWEEN query with wrong result |
| 110563 | 2023-03-30 8:21 | 2023-03-30 8:48 | MySQL Server: Optimizer | Verified (1326 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | NULL safe equality operator query with wrong result |
| 110751 | 2023-04-20 15:50 | 2023-04-25 17:14 | MySQL Router | Verified (1301 days) | S3 | 8.0.33 and 8.0.33 | Red Hat ( 8.4 (Ootpa)) | x86 | rhel8 rpm : mysqlrouter 8.0.33 aborts initial connection |
| 110988 | 2023-05-11 8:06 | 2023-07-10 13:11 | MySQL Server: Optimizer | Verified (1224 days) | S3 | 8.0.33 | Ubuntu (22.04) | x86 (x86_64) | VIEW call error |
| 111415 | 2023-06-14 9:39 | 2023-06-19 14:12 | MySQL Server: Optimizer | Verified (1245 days) | S3 | 8.0 | Any | Any | Correlated group query wrong result |
| 115085 | 2024-05-22 20:39 | 2024-06-27 8:11 | MySQL Server: DML | Verified (906 days) | S2 | 8.0.34, 8.4.0 | Any (Docker Image) | x86 | INDEX using CAST (json_column) AS ARRAY drops rows containing empty array |
| 116775 | 2024-11-25 18:34 | 2024-11-28 8:00 | MySQL Server: Optimizer | Verified (717 days) | S5 | 596f0d23 (9.0.0), 8.0.40 | Any | Any | Performance of TPC-DS Query 16 |
| 117089 | 2025-01-01 8:37 | 2025-01-01 9:29 | MySQL Server: DML | Verified (683 days) | S3 | 8.4.1, 8.0.40 | Windows (windows 11) | x86 (x86_64) | Inconsistent results using equivalent predicates in two queries. |
| 117130 | 2025-01-08 7:03 | 2025-01-08 7:50 | MySQL Server: Parser | Verified (676 days) | S3 | 9.1.0 | Any | Any | error occurs when using cast collate binary |
| 118161 | 2025-05-12 6:57 | 2025-10-27 6:49 | MySQL Server: Compiling | Verified (384 days) | S3 | 8.0.43 | MacOS (15.4.1) | ARM | Having Homebrew-installed googletest breaks build |
| 118336 | 2025-06-03 8:24 | 2026-02-06 12:26 | MySQL Server: Optimizer | Verified (282 days) | S3 | 8.0.41 | Any | Any | after adding a having clause equivalent to "having 1", the returned result set is wrong |
| 118621 | 2025-07-09 12:39 | 2025-07-09 14:19 | MySQL Server: Optimizer | Verified (494 days) | S3 | 9.3.0, 8.0.42 | Any | Any | subquery_to_derived optimizer makes query produce incorrect result |
| 118836 | 2025-08-14 3:01 | 2025-08-18 23:56 | MySQL Server: Optimizer | Verified (454 days) | S3 | 8.0.41 | Any | Any | adding a having clause that return 1/TRUE, the query returns a different and wrong empty result. |
| 119033 | 2025-09-18 9:16 | 2025-09-23 0:51 | MySQL Server: Optimizer | Verified (419 days) | S3 | 9.4.0 8.4.6 | Any | Any | Incorrect filtering when comparing a BINARY-cast integer to a BIT column with a UNIQUE key |
| 119346 | 2025-11-10 9:43 | 2025-11-20 12:40 | MySQL Server: Optimizer | Verified (360 days) | S3 | 8.0 | Any | Any | CASE expression evaluates incorrectly |
| 119513 | 2025-12-05 1:27 | 2025-12-08 1:12 | MySQL Router | Open (342 days) | S2 | 8.0.40 | Linux (Rocky Linux 8.10 (Green Obsidian)) | x86 | MySQL Router SSL Error Leading to Crash |
| 119669 | 2026-01-13 13:27 | 2026-01-13 14:53 | MySQL Server: Optimizer | Verified (306 days) | S1 | 8.0.44 | Any | Any | Inconsistent behaviour between normal query and prepared statement |
| 119752 | 2026-01-22 15:08 | 2026-01-22 21:36 | MySQL Server: Optimizer | Verified (297 days) | S3 | 8.0.44 | Any | Any | after changing MINUTE(subq.c1) to MINUTE(subq.c1 + INTERVAL '60' MINUTE),the result become empty. |
| 119790 | 2026-01-27 10:14 | 2026-01-27 12:07 | MySQL Server: Optimizer | Verified (292 days) | S1 | 8.0.44 | Any | Any | Unexpected result of expression IN NULL |
| 119823 | 2026-02-01 11:42 | 2026-02-02 3:55 | MySQL Server: Optimizer | Verified (286 days) | S3 | 8.0.44 | Any | Any | drop index can lead to different results |
| 119955 | 2026-02-27 5:03 | 2026-06-04 8:37 | MySQL Server: Optimizer | Verified (164 days) | S2 | 8.0.43 (MySQL Community Server - GPL) | Any (Docker container) | Any (x86_64) | Semantically equivalent scalar expressions yield different result sets in WHERE clause involving RPAD() |
| 120019 | 2026-03-10 12:29 | 2026-03-10 14:40 | MySQL Server: Optimizer | Verified (250 days) | S2 | 8.0.41 | Any | Any | query result change after removing partitioning |
| 120094 | 2026-03-18 8:29 | 2026-03-18 9:35 | MySQL Server: Optimizer | Verified (242 days) | S1 | 8.0.45 | Any | Any | Query returns incorrect results due to incorrect handling of predicate logic |
| 120296 | 2026-04-20 7:50 | 2026-04-20 9:24 | MySQL Server: Optimizer | Verified (209 days) | S2 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Materialized Correlated EXISTS Loses Implicit VARCHAR-to-YEAR Coercion,Causing Plan-Dependent Result Divergence |
| 120650 | 2026-06-09 19:25 | 2026-06-09 19:25 | MySQL Server: Compiling | Open | S3 | 8.0.46 | MacOS (26.5.1) | ARM | -Wunused-but-set-variable failing build |
| 120675 | 2026-06-13 17:32 | 2026-06-30 13:24 | MySQL Server: Optimizer | Verified (138 days) | S3 | 9.6.0 | Ubuntu | Any | Incorrect result for `CAST(NULL) IN col || CASE ... IN col` |
| 120687 | 2026-06-15 8:48 | 2026-06-15 11:06 | MySQL Server: JSON | Verified (153 days) | S3 | 9.7.0 | Any | Any | Incorrect result of MEMBER OF |
| 121040 | 2026-07-30 9:06 | 2026-08-03 8:00 | MySQL Server: Optimizer | Verified (104 days) | S2 | 8.0.46, 8.4.10, 9.7.1 | MacOS | ARM | derived condition pushdown across a set operation ignores collation equality, breaking predicate monotonicity (default) |
| 121044 | 2026-07-31 10:50 | 2026-07-31 11:01 | MySQL Server: InnoDB storage engine | Open (107 days) | S1 | 8.0.44, 8.0.45, 8.4.7, 8.4.8 | Linux (Official mysql Docker image (Oracle Linux 9); also Azure Database for MySQL Flexible Server) | ARM (aarch64 (local repro); production/test instances affected are x86_64) | mysqld crashes (signal 11) building multi-valued index via ALTER TABLE on JSON column holding both empty and non-empty a |
| 121100 | 2026-08-16 22:04 | 2026-08-19 5:22 | MySQL Server: Optimizer | Verified (88 days) | S3 | 8.0.46, 8.4.11, 9.7.2 | Linux | ARM | Merged `CAST(col AS CHAR) COLLATE utf8mb4_0900_bin` makes col = UPPER(col) return wrong result |
| 121157 | 2026-08-23 6:37 | 2026-08-25 9:36 | MySQL Server: Optimizer | Verified (82 days) | S1 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | Timezone-dependent generated column breaks UNIQUE and makes table unrestorable |
| 121214 | 2026-09-03 7:23 | 2026-09-03 9:16 | MySQL Server: Optimizer | Verified (73 days) | S3 | 9.7.2 | Any | Any | TIME column compared with a >= 10^10 integer constant returns inverted results (column vs literal context semantic split |
| 121218 | 2026-09-03 7:36 | 2026-09-03 12:04 | MySQL Server: Optimizer | Verified (73 days) | S3 | 9.7.2 | Any | Any | TIME column vs TIMESTAMP/DATETIME constant: the constant's date part is silently discarded |
| 121325 | 2026-09-20 20:01 | 2026-09-21 8:46 | MySQL Server: Optimizer | Verified (55 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.10.0 | Any | Any | MIN()/MAX() with BETWEEN and a non-integral bound returns NULL while rows match |
| 121395 | 2026-09-29 9:54 | 2026-09-30 7:16 | MySQL Server: Optimizer | Verified (46 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Linux | Any | BIGINT UNSIGNED column incorrectly matches a negative value in an IN (...) list when that value is derived from a non-co |
| 121511 | 2026-10-15 5:02 | 2026-10-20 4:26 | MySQL Server: Data Types | Verified (26 days) | S3 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Any | Any | FORMAT(X, D) takes D modulo 2^32: FORMAT(1.5, 4294967298) = '1.50' and FORMAT(1.5, 2147483648) = '2' |
| 121531 | 2026-10-16 9:20 | 2026-10-19 6:05 | MySQL Server: Optimizer | Verified (27 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Any | Any | IP address validation functions incorrectly return 0 instead of NULL for integer-typed NULL arguments |
| 121572 | 2026-10-22 3:33 | 2026-10-26 12:42 | MySQL Server: DML | Verified (20 days) | S2 | 9.7.2, 26.07 | Any | Any | A valid `CAST(... AS DATE)` element of an `IN` constant list is wrongly treated as NULL |
| 24424 | 2006-11-19 4:28 | 2020-05-03 20:45 | MySQL Server: Data Types | Verified (6890 days) | S1 | 5.1.11 | Any (ALL) | Any | CHAR data-type not space-padding |
| 29202 | 2007-06-19 9:11 | 2019-01-02 14:14 | MySQL Server: User-defined functions ( UDF ) | Verified (7010 days) | S3 | 5.1 | Any | Any | Result of UDF in subquery is truncated |
| 56025 | 2010-08-16 18:25 | 2018-09-09 20:45 | MySQL Server: General | Verified (5935 days) | S3 | 5.0.67, 5.0, 5.1, 5.6.99 | Any | Any | Weird date between behavior, not consistent between versions |
| 61114 | 2011-05-10 11:02 | 2025-10-12 20:45 | Connector / ODBC | Verified (5668 days) | S3 | connector 5.1.8 | Windows (7) | Any | ODBC doesn't support Uint32 / Uint64 ? <-> OdbcType.Int / BigInt |
| 64589 | 2012-03-08 5:08 | 2012-03-16 15:56 | MySQL Server: Data Types | Verified (5357 days) | S3 | 5.1; 5.5 | Any | Any | Alphanumeric strings bring back results on integer columns - SQL mode needed! |
| 64769 | 2012-03-26 22:27 | 2012-03-27 7:05 | MySQL Server: DML | Verified (5346 days) | S3 | 5.1.61 | Any (Debian unstable) | Any | comparing indexed ENUM with 0+string constant does not use index properly |
| 68864 | 2013-04-04 8:17 | 2013-04-04 8:37 | MySQL Server: Data Types | Verified (4973 days) | S2 | 5.6.10 | Any | Any | INTERVAL treats null values of text columns as float/int |
| 70598 | 2013-10-10 22:19 | 2013-10-13 11:23 | MySQL Server: Optimizer | Verified (4781 days) | S3 | 5.5.32,5.5.34, 5.6.14, 5.7.2 | Linux (.6.18-348.16.1.el5) | Any | Premature expression evaluation prevents short-circuited conditionals |
| 70684 | 2013-10-22 8:13 | 2013-10-22 11:35 | MySQL Server: Optimizer | Verified (4772 days) | S3 | 5.5.33, 5.6.14 | Any | Any | HAVING referring to subquery results in WARNING 1292 |
| 76215 | 2015-03-09 1:57 | 2015-03-11 12:48 | MySQL Server: Charsets | Verified (4267 days) | S3 | 5.5.44, 5.6.25 | Any | Any | Implicit casts to string by COLLATE don't use character_set_connection |
| 80045 | 2016-01-19 9:03 | 2016-01-19 10:52 | MySQL Server: DML | Verified (3953 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Syntax error returned for invalid D in DECIMAL(M, D), ERROR 1427 expected |
| 81116 | 2016-04-18 2:14 | 2016-05-02 9:11 | MySQL Server: Data Types | Verified (3863 days) | S2 | 5.6.30, 5.5.49 | CentOS (6.7) | Any | Evaluating between DECIMAL and string returns different result depends on index |
| 82308 | 2016-07-21 14:54 | 2023-07-31 15:25 | MySQL Server: MyISAM storage engine | Verified (3769 days) | S1 | 5.7 | Any | Any | use of DISTINCT with BIT and LONGTEXT leads to erroneous results |
| 83146 | 2016-09-26 7:39 | 2016-09-26 10:34 | MySQL Server: DML | Verified (3702 days) | S3 | 5.6, 5.7 | Linux | Any | time to bit produces inconsistent results |
| 84082 | 2016-12-06 19:01 | 2016-12-08 23:04 | MySQL Server: JSON | Verified (3629 days) | S3 | 5.7.14-google-log | Any | Any | JSON_OBJECT("k", dateTime) adds milliseconds to time |
| 86043 | 2017-04-22 2:23 | 2026-09-29 18:08 | Connector / NET | Verified (47 days) | S1 | 6.8.8 | Any | Any | Can't use BigInt or Double as userId instead of Int32 (default) |
| 92440 | 2018-09-15 21:02 | 2018-09-17 12:39 | MySQL Visual Studio Integration | Verified (2981 days) | S3 | 8.0 | Windows | Any | mysql 8.0 and VS 2017 - editing trigger fails with 'unable to load object' |
| 95957 | 2019-06-24 16:26 | 2019-06-25 5:15 | MySQL Server: Optimizer | Verified (2700 days) | S3 | 8.0.16, 5.7.26, 5.6.44 | Ubuntu | x86 | IN operator issue when comparing signed column and the column cast to unsigned |
| 95964 | 2019-06-24 22:23 | 2020-03-30 15:38 | MySQL Server: Memory storage engine | Verified (2421 days) | S3 | 8.0.16, 5.7.26, 5.6.44 | Ubuntu | x86 | Compare that uses UNSIGNED cast and function malfunctions in the MEMORY engine |
| 101945 | 2020-12-09 22:03 | 2020-12-10 5:02 | MySQL Server: JSON | Verified (2166 days) | S3 | 5.7.31, 8.0.22 | Any | Any | JSON Unsigned Integer out of range for Unsigned Bigint column |
| 102224 | 2021-01-11 23:14 | 2021-01-18 13:05 | MySQL Server: InnoDB storage engine | Verified (2130 days) | S3 | 8.0 | Any | Any | dtuple_get_nth_field is not const clean |
| 102873 | 2021-03-09 7:23 | 2021-03-09 9:38 | MySQL Server: DML | Verified (2077 days) | S3 | 8.0.23 | Any | Any | implicit cast WHERE datetime_column = 0 not producing Incorrect DATETIME value |
| 105355 | 2021-10-28 8:33 | 2021-11-29 13:09 | MySQL Server: Optimizer | Verified (1844 days) | S3 | 5.7.36, 8.0.27 | MacOS | x86 | time <cmp> string returns wrong result |
| 105652 | 2021-11-22 4:41 | 2021-11-23 14:20 | MySQL Server: InnoDB storage engine | Verified (1819 days) | S2 | 5.7, 8.0 | Any | Any | buffer pool flush_rbt could be disorded with innodb tablespace > 32TB |
| 106437 | 2022-02-10 23:42 | 2026-05-28 1:13 | MySQL Server: Row Based Replication ( RBR ) | Patch pending | S2 | 8.0.28 | Any | Any | need an option to let applier thread ignore virtual columns on replica.. |
| 108500 | 2022-09-15 20:03 | 2022-09-16 10:32 | Connector / J | Verified (1521 days) | S2 | 8.0.30 | Any | x86 | updateBlob fails with ClassCastException when replication is in use |
| 108563 | 2022-09-21 9:36 | 2022-09-21 9:40 | MySQL Server: DDL | Verified (1516 days) | S3 | 8.0.28, 8.0.30 | Any | Any | Cannot create json index in procedure |
| 109608 | 2023-01-12 15:11 | 2023-01-24 11:39 | MySQL Server: Optimizer | Verified (1391 days) | S3 | 8.0.31 | Ubuntu (22.04) | x86 (x86_64) | Exists query with wrong result |
| 110556 | 2023-03-30 2:46 | 2026-03-25 20:22 | MySQL Server: JSON | Verified (1326 days) | S2 | 8.0.28, 8.0.32 | Linux | Any | When we use json to build an index, we will get wrong results |
| 111310 | 2023-06-07 6:51 | 2023-06-08 8:30 | MySQL Server: Prepared statements | Verified (1256 days) | S3 | 8.0.33 | Ubuntu (22.04) | x86 (x86_64) | Prepared statement with CTE memory leak |
| 112053 | 2023-08-12 19:55 | 2023-08-21 12:36 | MySQL Server: JSON | Verified (1187 days) | S3 | 8.0 | Any | Any | COALESCE a null value with a JSON object returns hex string |
| 114217 | 2024-03-05 4:48 | 2024-03-05 7:01 | MySQL Server: DML | Verified (985 days) | S2 | 8.2.0, 8.3.0, 8.0.36 | Any | Any | Unexpected Results by Minus Sign |
| 115471 | 2024-07-01 5:04 | 2024-07-04 8:23 | MySQL Server: Compiling | Verified (864 days) | S3 | 8.0.37, 8.4.0 | MacOS (14.5) | ARM | Linker errors with enabled LTO |
| 113113 | 2023-11-16 20:26 | 2025-10-28 10:13 | MySQL Server: Compiling | Verified (383 days) | S3 | 8.0.41 | MacOS | Any | Build failure with Homebrew LLVM 14-19 on macOS |
| 116724 | 2024-11-20 7:44 | 2024-11-20 8:49 | MySQL Server: Optimizer | Verified (725 days) | S1 | 8.4.2, 8.0.40 | Any | Any | Issues with CASE statements |
| 116725 | 2024-11-20 7:44 | 2024-11-20 8:54 | MySQL Server: Optimizer | Verified (725 days) | S1 | 8.4.2, 8.0.40 | Any | Any | Issues with CASE statements. |
| 118063 | 2025-04-27 19:02 | 2025-04-28 7:39 | MySQL Server: Optimizer | Verified (566 days) | S1 | 9.0, 8.0, 8.0.42, 8.4.5, 9.3.0 | Any | Any | Wrong Join Result after creating index on expressions |
| 118299 | 2025-05-29 6:57 | 2025-08-21 2:18 | MySQL Server: InnoDB storage engine | Verified (451 days) | S2 | 8.0.42, 8.4.5 | Any | Any | Multi-valued Index on Composite Key Returns Incomplete Results for Rows with Empty JSON Array('[]') |
| 118393 | 2025-06-09 1:36 | 2026-02-05 22:47 | MySQL Server: Optimizer | Verified (283 days) | S3 | 8.0.41 | Any | Any | while the having subquery return NULL actually, the query using this having query returns a wrong result. |
| 118839 | 2025-08-14 3:13 | 2025-08-18 23:50 | MySQL Server: DML | Verified (454 days) | S3 | 8.0.41 | Any | Any | a query including the having subclause that returns NULL, return a wrong nonempty result. |
| 119238 | 2025-10-27 7:31 | 2026-06-09 13:52 | MySQL Server: Compiling | Open (159 days) | S3 | 8.0.45 | MacOS (26.0.1) | ARM | Compilation error with clang 20 |
| 119363 | 2025-11-12 2:52 | 2025-11-12 3:10 | MySQL Server: Optimizer | Verified (368 days) | S3 | 9.4.0 8.4.6 | Any | Any | Complex WHERE Expression on Indexed FLOAT Column Evaluates Incorrectly |
| 119802 | 2026-01-28 13:49 | 2026-01-28 15:52 | MySQL Server: Optimizer | Verified (291 days) | S2 | 8.0.42+ | Any | Any | Assertion 'is_nullable()' failed in Item_typecast_signed::val_int() |
| 119927 | 2026-02-20 10:28 | 2026-02-25 8:56 | MySQL Server: Optimizer | Verified (263 days) | S2 | 8.0.45 | Linux | Any | Inconsistent results between direct query and derived table with BIGINT column and FLOAT predicate (IN clause) |
| 120099 | 2026-03-18 12:08 | 2026-03-19 8:04 | MySQL Server: Optimizer | Verified (241 days) | S1 | 8.0.45 | Any | Any | Query returns wrong result when condition involves CAST(division AS CHAR) |
| 120244 | 2026-04-10 12:40 | 2026-04-10 13:51 | MySQL Server: DDL | Open | S1 | 9.6.0 | Any | Any | Unexpected error `'0' for column '' at row -1` triggered by ALTER |
| 120253 | 2026-04-13 9:14 | 2026-04-13 10:18 | MySQL Server: Optimizer | Verified (216 days) | S3 | 8.0.45 | Ubuntu (Ubuntu 20.04.4 LTS) | x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache)) | Index Lookup Skips CAST for LONGTEXT-to-DATE Coercion in JOIN,Causing Plan-Dependent Result Divergence |
| 119246 | 2025-10-27 15:02 | 2026-06-24 21:31 | MySQL Server: Compiling | Open (157 days) | S3 | 8.0.46, 8.4.9, 9.7.0-er2 | MacOS (26.0.1) | ARM | 9.7.0-er2 compilation error with LLVM 21 |
| 120263 | 2026-04-14 5:30 | 2026-04-14 10:56 | MySQL Server: JSON | Verified (215 days) | S2 | 8.0.45 | Any | Any | Inconsistent results for query with JSON_CONTAINS and CAST(... AS SIGNED) |
| 120456 | 2026-05-12 15:02 | 2026-05-17 23:00 | MySQL Server: Optimizer | Verified (182 days) | S2 | 8.0.46 | Linux | Any | Semijoin Nested Loop index lookup uses raw VARCHAR keys against a DOUBLE B-tree, causing mismatches when the string over |
| 120491 | 2026-05-18 5:53 | 2026-05-18 12:22 | MySQL Server: Optimizer | Verified (181 days) | S2 | 8.0.46 | CentOS | Any | Semijoin returns wrong results for VARCHAR-to-DECIMAL comparison with non-canonical numeric strings |
| 120584 | 2026-06-01 5:18 | 2026-06-01 7:16 | MySQL Server: Optimizer | Verified (167 days) | S2 | 8.0.45 | Any | Any | Optimizer picks BIGINT gen col index for DECIMAL expression, BIGINT truncation falsely matches fractional values |
| 120653 | 2026-06-10 7:44 | 2026-06-11 9:51 | MySQL Server: Compiling | Open (157 days) | S3 | 8.0.46, 8.4.9 | MacOS (26.5.1) | ARM | LLVM 21 -Wformat / -Wmissing-format-attribute warnings |
| 119239 | 2025-10-27 7:53 | 2026-06-11 4:05 | MySQL Server: Compiling | Open (157 days) | S3 | 8.0.46, 8.4.9 | MacOS (26.0.1) | ARM | Compilation error with clang 21 / XCode |
| 119242 | 2025-10-27 12:13 | 2026-06-11 4:08 | MySQL Server: Compiling | Open (157 days) | S3 | 8.0.46, 8.4.9 | MacOS (26.0.1) | ARM | Clang 21 / XCode build warnings |
| 120664 | 2026-06-12 7:56 | 2026-06-15 8:33 | MySQL Server: JSON | Verified (153 days) | S3 | 9.6.0 | Any | Any | INDEX hint blocks generated column substitution for multi-valued indexes with MEMBER OF |
| 120716 | 2026-06-17 12:31 | 2026-06-17 12:53 | MySQL Server: Optimizer | Verified (151 days) | S1 | 8.0.45 | Any (Storage Engine: MEMORY) | Any | MEMORY Engine Empty Outer Join Derived Table Causes Incorrect Aggregate Result (Should Be NULL) |
| 120717 | 2026-06-17 13:33 | 2026-07-07 19:02 | MySQL Server: Compiling | Open (131 days) | S3 | 9.7.0, 26.7.0-er | MacOS (26.5.1) | ARM | Build fails under macOS with LLVM 18 |
| 120832 | 2026-07-02 10:02 | 2026-07-20 11:08 | MySQL Server: Optimizer | Verified (136 days) | S1 | 9.1 | Any | Any | WITH ROLLUP Super‑Aggregate Row Missing in Zero Input Rows Short‑Circuit Path |
| 120834 | 2026-07-02 10:38 | 2026-07-21 16:25 | MySQL Server: Optimizer | Verified (136 days) | S1 | 8.0.46, 8.4.10, 9.7.1 | Any | Any | AVG on Large DOUBLE Values Returns Inconsistent Results Across Execution Paths (Index Scan vs. Temporary Table) |
| 121149 | 2026-08-21 13:17 | 2026-08-21 20:37 | MySQL Server: Optimizer | Verified (86 days) | S2 | 9.7.1 | Any | Any | MySQL temporal implicit conversion changes `TIMEDIFF` predicate results after materialization |
| 121181 | 2026-08-28 8:03 | 2026-08-31 5:41 | MySQL Server: Optimizer | Verified (76 days) | S2 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | Temporal BETWEEN returns FALSE instead of NULL when LHS->temporal conversion fails (uninitialized Time_val/Date_val comp |
| 121187 | 2026-08-29 13:28 | 2026-09-01 4:53 | MySQL Server: Optimizer | Verified (75 days) | S2 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | Materializing a `TIME` expression changes comparison with `DATETIME` literals |
| 121216 | 2026-09-03 7:28 | 2026-09-03 10:13 | MySQL Server: Optimizer | Verified (73 days) | S3 | 8.4 | Any | Any | VARCHAR column vs DATE constant: failed conversion silently acts as a "smallest sentinel" |
| 121236 | 2026-09-05 4:57 | 2026-09-08 9:23 | Connector / ODBC | Open (68 days) | S1 | 26.7.1 | Any | x86 | TINYINT UNSIGNED values corrupted (negative or 18446744073709551615) when read via SSPS |
| 121377 | 2026-09-28 7:07 | 2026-09-29 10:30 | MySQL Server: Optimizer | Verified (47 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Linux | Any | LIKE with an equivalent computed numeric pattern returns inconsistent results under utf16_unicode_ci |
| 121385 | 2026-09-28 11:48 | 2026-10-07 14:48 | MySQL Router | Documenting (45 days) | S3 | 26.10.0-er | MacOS (27.0) | ARM | "ignoring return value of function declared with 'nodiscard' attribute" |
| 121386 | 2026-09-28 12:19 | 2026-09-28 12:19 | MySQL Server: Compiling | Open | S3 | 26.10.0-er | MacOS (27.0) | ARM | "no matching constructor for initialization of 'MutexLock' (aka 'testing::internal::GTestMutexLock')" |
| 121430 | 2026-10-04 0:02 | 2026-10-05 8:55 | MySQL Server: Optimizer | Verified (41 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Any | Any | ORDER BY on a 64-member SET column sorts values containing member 64 as negative |
| 121512 | 2026-10-15 5:03 | 2026-10-20 4:24 | MySQL Server: Data Types | Verified (26 days) | S3 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Any | Any | ELT(N, ...) wraps N modulo 2^32 in numeric context: ELT(4294967297,1,2,3)+0 = 1 while ELT(4294967297,1,2,3) IS NULL |
| 121515 | 2026-10-15 7:58 | 2026-10-20 4:19 | MySQL Server: Optimizer | Verified (26 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Any | Any | Unexpected NUL-byte padding in EXCEPT result involving numeric BIT_XOR() and SUBTIME() |
| 121559 | 2026-10-20 6:59 | 2026-10-20 6:59 | MySQL Server: Data Types | Open | S3 | 9.7, 2X | Any | Any | STRING_TO_VECTOR() refuses valid float32 denormal components with ER_TO_VECTOR_CONVERSION |
| 121751 | 2026-11-12 8:09 | 2026-11-12 8:09 | MySQL Server: Optimizer | Open | S3 | 9.7.2 | Any | Any | Query with `~ CAST(FALSE AS BINARY)` and IN subquery fails with ERROR 3854 when index access is disabled |
Showing all 222
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.036 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.