| Showing all 23 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 119944 | 2026-02-25 22:14 | 2026-02-26 13:13 | MySQL Server: Optimizer | Verified (238 days) | S1 | 8.0, 8.4, 9.X | Any | Any | Feature Request: Extend TIMESTAMP range beyond 2038-01-19 by switching to 64-bit signed storage (Year 2038 Problem) |
| 121157 | 2026-08-23 6:37 | 2026-08-25 9:36 | MySQL Server: Optimizer | Verified (58 days) | S1 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | Timezone-dependent generated column breaks UNIQUE and makes table unrestorable |
| 121404 | 2026-09-30 7:03 | 2026-10-08 8:58 | MySQL Server: Optimizer | Verified (14 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Linux | Any | Wrong result: row constructor comparison in WHERE returns no rows when a tuple element is a null-extended outer-join col |
| 114970 | 2024-05-13 3:42 | 2024-05-13 6:04 | MySQL Server: Optimizer | Verified (892 days) | S1 | 8.0.33 | Any | Any | prev_record_reads() use stale cardinality to calculate after plan enumeration |
| 81803 | 2016-06-10 12:35 | 2016-06-15 16:58 | MySQL Server: Optimizer | Verified (3781 days) | S5 | >=5.1 | Any | Any | Mysql 5.1 and later Update performance regression |
| 99354 | 2020-04-25 13:34 | 2020-04-25 18:21 | MySQL Server: Optimizer | Verified (2371 days) | S3 | 5.7.26, 8.0.19 | Any | Any | Nondeterministic stored function returns incorrect results |
| 111669 | 2023-07-06 0:47 | 2023-07-12 13:04 | MySQL Server: Optimizer | Verified (1198 days) | S5 | 8.0.33 | Any | Any | Simple Query Times Out |
| 119963 | 2026-03-02 9:08 | 2026-03-02 13:43 | MySQL Server: Optimizer | Verified (234 days) | S3 | 8.0.45 | Any | Any | Inconsistent Results When Comparing Identical Aggregate Calculations Between Main Query and Correlated Subquery |
| 121327 | 2026-09-20 20:19 | 2026-10-20 5:02 | MySQL Server: Optimizer | Verified (2 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 |
| 121581 | 2026-10-22 13:20 | 2026-10-22 13:20 | MySQL Server: Optimizer | Open | S2 | 8.4.13, 9.7.4, 26.10.0 | Any | Any | ORDER BY satisfied by index scan returns wrong order when skipped const keypart is expanding collation prefix |
| 121480 | 2026-10-11 15:44 | 2026-10-15 9:37 | MySQL Server: Optimizer | Verified (7 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Ubuntu (24.04) | x86 (x86_64) | Wrong result with subquery materialization: lookup on <auto_distinct_key> converts the probe value to the key type |
| 121398 | 2026-09-29 17:27 | 2026-09-30 8:45 | MySQL Server: Optimizer | Verified (22 days) | S2 | 26.10.0 | Linux | Any | UNION loses a distinct DATE value after changing sql_mode on a partitioned table |
| 121329 | 2026-09-21 2:45 | 2026-10-15 9:38 | MySQL Server: Optimizer | Verified (7 days) | S2 | 8.0.46, 8.4.11, 9.7.2, 26.07 | Any | Any | MIN()/MAX() on indexed DATETIME with a range predicate returns a value it excludes |
| 121226 | 2026-09-03 7:52 | 2026-09-03 13:01 | MySQL Server: Optimizer | Verified (49 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 |
| 121113 | 2026-08-18 9:22 | 2026-08-19 14:23 | MySQL Server: Optimizer | Verified (64 days) | S3 | 8.0.46, 8.4.11, 9.7.2 | Any | Any | `JSON_QUOTE()` metadata overflow truncates valid output |
| 120457 | 2026-05-12 15:03 | 2026-05-28 1:13 | MySQL Server: Optimizer | Patch pending (158 days) | S2 | 9.7 | CentOS | x86 | Hypergraph optimizer returns wrong results for LEFT JOIN LATERAL with SEMI JOIN when derived_merge |
| 110406 | 2023-03-17 4:58 | 2023-03-20 14:08 | MySQL Server: Optimizer | Verified (1312 days) | S3 | 8.0 | Any | Any | Storing rows with null in join key in hash table for outer join is useless |
| 100985 | 2020-09-29 7:42 | 2020-09-29 9:18 | MySQL Server: Optimizer | Verified (2214 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 |
| 95938 | 2019-06-24 6:51 | 2019-07-23 11:46 | MySQL Server: Optimizer | Verified (2648 days) | S3 | 8.0.16, 5.7.26, 5.6.44 | Ubuntu | x86 | Function return value with newline yields wrong result when used as a boolean |
| 83627 | 2016-11-01 8:16 | 2016-11-01 9:36 | MySQL Server: Optimizer | Verified (3642 days) | S3 | 5.7/8.0 | Linux | Any | inconsistent results with generated column when meets char and padding |
| 74083 | 2014-09-25 18:11 | 2014-10-09 12:58 | MySQL Server: Optimizer | Verified (4396 days) | S5 | 5.6.20, 5.6.22 | Linux (CentOS 6.5) | Any | ENUM index scan is slower than INT index scan |
| 35724 | 2008-03-31 22:24 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6441 days) | S2 | MySQL 5.0.51a-community-nt, 5.1, 6.0 BK | Any | Any | Non-found left join data passed as a parameter to a function in WHERE |
| 8113 | 2005-01-24 15:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6274 days) | S5 | 5.0, 5.1, azalea bzr | Any | Any | Select with between optimization |
| Showing all 23 (Edit, Save, CSV, Feed) |
