Showing 1-30 of 740 (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 (3738 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 (5866 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 (5408 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 (4887 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 (4481 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 (3966 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 (3770 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 (3567 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 (2607 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 (2478 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 (2167 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 (2128 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 (1459 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 (1340 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 (1186 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 (977 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 (774 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 (742 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 (509 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 (497 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 (423 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 (424 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 (382 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 (344 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 (333 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 (235 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 (105 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 (16 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 (11 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 (5320 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 740 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |