| Showing 1-30 of 11333 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 120051 | 2026-03-13 9:31 | 2026-03-13 14:54 | MySQL Server: Optimizer | Verified | S1 | 8.0.45 | Linux (ubuntu 20.04) | Any | Wrong result for derived-table rewrite of GROUP BY ... HAVING query |
| 120047 | 2026-03-13 5:08 | 2026-03-13 5:57 | MySQL Server: Optimizer | Verified | S3 | 9.5.0 | Any | Any | Incorrect empty update result when weakening WHERE clause in UPDATE IGNORE with CROSS JOIN and IN subquery |
| 120037 | 2026-03-12 2:46 | 2026-03-13 11:31 | MySQL Server: Optimizer | Verified | S3 | 8.4.8 | Any | Any | Query Results Differ Between Tables with Same Data and Query Due to RENAME Operation |
| 120036 | 2026-03-12 2:09 | 2026-03-13 13:15 | MySQL Server: Optimizer | Verified | S3 | 8.0.45 | Any | Any | Different results for semantically equivalent expressions using CASE and MIN(CASE ...) with GROUP BY on a FLOAT column |
| 120034 | 2026-03-11 15:13 | 2026-03-11 21:10 | MySQL Server: Optimizer | Verified (2 days) | S3 | 8.4.8 | Any | Any | Wrong Results with LOG(1, N) <=> NULL: UNIQUE Constraint Causes Incorrect Row Deduplication |
| 120033 | 2026-03-11 15:01 | 2026-03-11 21:02 | MySQL Server: Optimizer | Verified (2 days) | S3 | 8.4.8 | Any | Any | Inconsistent Results with SUBTIME(1, SYSDATE()) in HAVING Clause: UNIQUE Constraint Affects Optimizer Evaluation |
| 120032 | 2026-03-11 14:56 | 2026-03-11 20:56 | MySQL Server: Optimizer | Verified (2 days) | S3 | 8.4.8 | Any | Any | Inconsistent Aggregation Results in Derived Tables: PRIMARY KEY Affects AVG(NOT(...)) Evaluation and Optimizer Execution |
| 120031 | 2026-03-11 14:48 | 2026-03-11 20:46 | MySQL Server: Optimizer | Verified (2 days) | S3 | 8.4.8 | Any | Any | Inconsistent INTERSECT Results in Derived Tables: Impact of PRIMARY KEY on JSON_OBJECTAGG and LEAST Operators |
| 120030 | 2026-03-11 14:44 | 2026-03-11 20:31 | MySQL Server: Optimizer | Verified (2 days) | S3 | 8.4.8 | Any | Any | Query Results Differ Due to Primary Key and INTERSECT Operation |
| 120029 | 2026-03-11 14:42 | 2026-03-11 20:19 | MySQL Server: Optimizer | Verified (2 days) | S3 | 8.4.8 | Any | Any | Query Results Differ Due to Primary Key Column - Issue with MIN, MAX, and Time-Related Functions |
| 120028 | 2026-03-11 14:38 | 2026-03-11 19:59 | MySQL Server: Optimizer | Verified (2 days) | S3 | 8.4.8 | Any | Any | Query Results Differ Due to Primary Key Column and TRUNCATE Function Behavior |
| 120027 | 2026-03-11 14:34 | 2026-03-11 19:48 | MySQL Server: Optimizer | Verified (2 days) | S3 | 8.4.8 | Any | Any | Query Results Differ Due to Presence of Primary Key - Issue with MIN and DATE_ADD Functions |
| 120022 | 2026-03-11 2:22 | 2026-03-11 7:10 | MySQL Server: Optimizer | Verified (2 days) | S3 | MySQL 8.0.28 | Any | Any | CAST(AVG()) returns a different result than CAST(SUM()/COUNT()) on DECIMAL values |
| 120021 | 2026-03-11 1:41 | 2026-03-11 14:54 | MySQL Server: Optimizer | Verified (2 days) | S4 | 8.4.x | Any | Any | Add heuristic IN-list sampling (eq_range_index_dive_sample_count/method) to replace statistics fallback |
| 120019 | 2026-03-10 12:29 | 2026-03-10 14:40 | MySQL Server: Optimizer | Verified (3 days) | S2 | 8.0.41 | Any | Any | query result change after removing partitioning |
| 120016 | 2026-03-09 17:41 | 2026-03-10 7:58 | MySQL Server: Documentation | Verified (3 days) | S2 | 8.0, 8.4, 9.x | Any | Any | Documentation "Exchanging Partitions and Subpartitions with Tables" not mentioning limitation about ALGORITHM=INSTANT. |
| 120015 | 2026-03-09 13:48 | 2026-03-09 14:14 | MySQL Server: Optimizer | Verified (4 days) | S1 | 8.0.45 | Any | Any | Incorrect retention of NULL rows due to CASE evaluation error in WHERE clause. |
| 120011 | 2026-03-09 10:29 | 2026-03-09 11:16 | MySQL Server: Optimizer | Verified (4 days) | S1 | 8.0.44 | Any | Any | The normal query generated a non-optimal query plan with index. |
| 120010 | 2026-03-09 9:56 | 2026-03-09 10:21 | MySQL Server: Optimizer | Verified (4 days) | S1 | 8.0.45 | Any | Any | Incorrect result set when evaluating IS NULL on a derived table containing logical AND expressions |
| 120005 | 2026-03-08 0:14 | 2026-03-10 8:04 | MySQL Server: Optimizer | Verified (3 days) | S2 | 8.4.7 | Any | Any | Wrong results with subquery with semijoin=on and antijoin optimization |
| 120004 | 2026-03-07 19:38 | 2026-03-09 9:48 | MySQL Server: Optimizer | Verified (4 days) | S2 | 8.0.31 | Any | Any | IndexSkipScanIterator Assertion Failure |
| 120003 | 2026-03-07 12:14 | 2026-03-09 9:41 | MySQL Server: Optimizer | Verified (4 days) | S3 | 8.0.45 | Any | Any | column name unexpectedly change because of '1' as a column |
| 119995 | 2026-03-06 9:51 | 2026-03-09 9:55 | MySQL Server: Optimizer | Verified (4 days) | S2 | 8.0.45 | Any | Any | Function find_in_set return wrong result |
| 119991 | 2026-03-06 5:56 | 2026-03-06 11:27 | MySQL Server: Optimizer | Verified (7 days) | S2 | 8.0.45 | Linux | x86 | Incorrect result with LEFT/RIGHT JOIN when comparing boolean expression with = 0 in presence of functional index |
| 119977 | 2026-03-03 13:44 | 2026-03-03 20:55 | MySQL Server: Optimizer | Verified (10 days) | S3 | 8.0.36 | Any (windows 11) | Any | NULL > ALL(subquery) produces NULL but IS NULL / IS UNKNOWN both return FALSE |
| 119973 | 2026-03-02 21:01 | 2026-03-03 8:45 | MySQL Server: Optimizer | Verified (10 days) | S1 | 8.0.45 | Any | Any | Inconsistent results depending on whether the column has a PRIMARY KEY index |
| 119972 | 2026-03-02 19:47 | 2026-03-03 9:47 | MySQL Server: Optimizer | Verified (10 days) | S1 | 8.0.45 | Any | Any | Incorrect Result from IN Subquery with UNIQUE Index |
| 119965 | 2026-03-02 11:56 | 2026-03-02 13:58 | MySQL Server: Partitions | Verified (11 days) | S3 | 8.0.35 | Any | Any | The results of the same query statement are inconsistent when it is executed multiple times. |
| 119963 | 2026-03-02 9:08 | 2026-03-02 13:43 | MySQL Server: Optimizer | Verified (11 days) | S3 | 8.0.45 | Any | Any | Inconsistent Results When Comparing Identical Aggregate Calculations Between Main Query and Correlated Subquery |
| 119959 | 2026-03-01 14:50 | 2026-03-02 13:16 | MySQL Server: Optimizer | Verified (11 days) | S3 | 8.0.45 | Linux (ubuntu 20.04) | x86 | Inconsistent results between direct query and derived table query involving NULLIF and IS NOT UNKNOWN |
| Showing 1-30 of 11333 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
