| Showing 1-30 of 739 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 12113 | 2005-07-22 14:23 | 2014-01-24 12:43 | MySQL Server: Optimizer | Verified (3735 days) | S1 | 5.0.28-BK, 4.0,5.0 | Any | Any | Composite index chosen partially for ORDER BY ... LIMIT query. |
| 35633 | 2008-03-28 8:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5863 days) | S1 | 5.0.54, 5.0.56 | Linux (2.6.25-rc4) | Any | Column cant be NULL error on SELECT...FROM (SELECT not_null_column, agg_func...) |
| 45741 | 2009-06-25 10:46 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5405 days) | S1 | 5.0.83, 5.0, 5.1, 5.5.8 | Linux | Any | Memory of server increases abnormally for sql with mass <> condition |
| 58604 | 2010-11-30 21:28 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4884 days) | S1 | 5.5.7, 5.5.9, 5.6.1 | Any | Any | crash in cleanup code of explain partitions after killing connection |
| 64002 | 2012-01-11 20:01 | 2012-01-19 11:52 | MySQL Server: Optimizer | Verified (4478 days) | S1 | 5.5.19 | Any (Debian, Windows XP) | Any | Aggregate queries with multiple columns and no GROUP BY produce bogus results |
| 66849 | 2012-09-17 18:49 | 2013-06-10 19:50 | MySQL Server: Optimizer | Verified (3963 days) | S1 | 5.5.16, 5.1.70, 5.5.32, 5.6.12 | Linux | Any | [REGRESSION] this query hangs the server (100% CPU for several minutes) |
| 71206 | 2013-12-22 17:13 | 2013-12-31 20:00 | MySQL Server: Optimizer | Verified (3767 days) | S1 | 5.5.32-0ubuntu0.12.04.1-log, 5.6.15, 5.1.72, 5.5.35, 5.7.3 | Linux (ubuntu 12.04) | Any | GROUP_CONCAT changes GROUP BY behavior |
| 73284 | 2014-07-13 19:12 | 2014-07-14 8:47 | MySQL Server: Optimizer | Verified (3564 days) | S1 | 5.5.35, 5.5.38 | Any | Any | Wrong query result when search from 2 related views |
| 85126 | 2017-02-22 10:42 | 2017-02-28 7:19 | MySQL Server: Optimizer | Verified (2604 days) | S1 | 5.6.35 | Any | Any | Delete by range in presence of partitioning and no PK always picks wrong index |
| 86973 | 2017-07-06 13:26 | 2017-07-07 7:19 | MySQL Server: Optimizer | Verified (2475 days) | S1 | 5.6, 5.5.56, 5.6.36, 5.7.18 | Any | Any | BIN() function error |
| 90847 | 2018-05-12 16:57 | 2018-08-18 11:52 | MySQL Server: Optimizer | Verified (2164 days) | S1 | 5.7.22, 8.0.11 | Windows (W10 64bit) | x86 | Query returns wrong data if order by is present |
| 91362 | 2018-06-21 15:18 | 2019-02-13 14:05 | MySQL Server: Optimizer | Verified (2125 days) | S1 | 5.6.36 - 5.6.40 and 5.7.18 - 5.7.22, 5.6.40, 5.7.22 | Any | Any | Incorrect query results under certain conditions. |
| 99244 | 2020-04-14 3:22 | 2020-04-22 12:45 | MySQL Server: Optimizer | Verified (1456 days) | S1 | 8.0.19 | Any | Any | bad performance in hash join because join with no join condition between tables |
| 100504 | 2020-08-12 11:58 | 2020-08-18 2:50 | MySQL Server: Optimizer | Verified (1337 days) | S1 | 8.0.21, 5.7.31 | Linux (Arch Linux) | x86 (x86_64) | Count distinct is inconsistent when swapping two fields being counted. |
| 102291 | 2021-01-19 9:17 | 2021-01-19 9:58 | MySQL Server: Optimizer | Verified (1183 days) | S1 | 8.0, 8.0.22, 8.0.23 | Any | Any | Subquery produces wrong result when set big_tables = 1 |
| 104629 | 2021-08-16 3:08 | 2021-08-16 7:09 | MySQL Server: Optimizer | Verified (974 days) | S1 | 8.0.25,5.7.35, 8.0.26 | Any | Any | wrong result when outer join prune partition tables with is null predicate |
| 106651 | 2022-03-07 4:34 | 2022-03-11 14:21 | MySQL Server: Optimizer | Verified (771 days) | S1 | 5.7.*, 5.7.37, 8.0.28 | Any | Any | Query wrong result when the condition is "where id ('decimal_a', 'decimal_b')" |
| 106938 | 2022-04-07 2:26 | 2022-04-08 1:35 | MySQL Server: Optimizer | Verified (739 days) | S1 | 8.0, 8.0.28 | Any | Any | lateral derived table with LIMIT produces wrong result |
| 109212 | 2022-11-27 8:34 | 2022-11-27 9:20 | MySQL Server: Optimizer | Verified (506 days) | S1 | 8.0.30, 8.0.31 | Any | Any | Incorrect Hash Semijoin Execution |
| 109311 | 2022-12-08 3:40 | 2022-12-09 3:36 | MySQL Server: Optimizer | Verified (494 days) | S1 | 8.0.22 8.0.30, 8.0.31 | Any | Any | Wrong result |
| 109728 | 2023-01-21 19:27 | 2023-09-05 8:45 | MySQL Server: Optimizer | Verified (420 days) | S1 | 8.0.30 | Any | Any | SELECT statement: Result is not proper with GROUP BY with LIMIT OFFSET |
| 110125 | 2023-02-19 8:48 | 2023-02-20 5:04 | MySQL Server: Optimizer | Verified (421 days) | S1 | 8.0.32, 5.7 | Ubuntu | Any | Unexpected query result fetched from an indexed column |
| 110587 | 2023-04-03 7:51 | 2023-04-03 9:37 | MySQL Server: Optimizer | Verified (379 days) | S1 | 8.0.27, 8.0.32, 5.7.41 | Any | Any | Bit with index range query may produce different results |
| 110984 | 2023-05-11 2:24 | 2023-05-11 6:59 | MySQL Server: Optimizer | Verified (341 days) | S1 | 8031, 5.7.42, 8.0.33 | Linux | x86 | Subqueries with 'limit 1' cause concat strings to report errors |
| 111097 | 2023-05-22 6:40 | 2024-04-10 9:51 | MySQL Server: Optimizer | Verified (330 days) | S1 | 8031, 5.7.42, 8.0.33, 8.0.36 | Linux | x86 | Query statement results with subqueries are unstable |
| 112198 | 2023-08-28 8:21 | 2024-03-05 6:06 | MySQL Server: Optimizer | Verified (232 days) | S1 | 8.0, 8.0.34 | Any | Any | Incorrect multiple equality optimization causes performance degradation |
| 113534 | 2024-01-02 8:27 | 2024-01-05 2:27 | MySQL Server: Optimizer | Verified (102 days) | S1 | 8.0.35 | Any | Any | table join return Unexpected result when drived table using include join index |
| 114539 | 2024-04-03 7:36 | 2024-04-03 8:14 | MySQL Server: Optimizer | Verified (13 days) | S1 | 8.0.36 | Any | Any | Unexpected Results by the hint NO_INDEX |
| 114568 | 2024-04-07 13:43 | 2024-04-08 7:28 | MySQL Server: Optimizer | Verified (8 days) | S1 | 8.0.36 | Any | Any | Different join orders cause inconsistent results |
| 18465 | 2006-03-23 17:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5317 days) | S2 | 5.0.20-BK, 5.0.19, 5.0.85 | Any (any) | Any | Optimizer/execution plan bug with dependent subqueries in ON clauses of JOINs |
| Showing 1-30 of 739 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
