Showing 1-30 of 1272 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
112541 | 2023-09-27 14:59 | 2024-04-11 10:19 | MySQL Server: Optimizer | Closed (52 days) | S2 | 8.1, 8.0.34 | Any | Any | Incorrect results when using group by loose index scan |
113711 | 2024-01-22 16:35 | 2024-02-28 14:47 | MySQL Server: Optimizer | Closed (51 days) | S5 | 8.0.36 | Linux (debian11) | x86 | Mrr implement runs much slower than before |
113647 | 2024-01-16 8:55 | 2024-03-07 20:37 | MySQL Server: Optimizer | Closed (43 days) | S5 | 8.0.35,8.2.0 | Any | Any | identical tables are checked in HashJoin because of no STOP_AT_MATERIALIZATION |
113405 | 2023-12-13 11:04 | 2023-12-14 4:50 | MySQL Server: Optimizer | Closed (127 days) | S3 | 8.0.35 | Any | Any | 'covering index' is not shown entirely in EXPLAIN FORMAT=TREE. |
113318 | 2023-12-04 6:37 | 2024-03-01 20:38 | MySQL Server: Optimizer | Closed (49 days) | S2 | mysql-8.0.33, 8.0.35, 8.1.0, 8.2.0 | Any | Any | unnest scalar subquery using groupby produces wrong result |
113188 | 2023-11-22 17:51 | 2023-12-21 10:18 | MySQL Server: Optimizer | Closed (120 days) | S1 | 8.2.0 | Any | Any | LEFT JOIN returns results that do not exist in table |
113047 | 2023-11-10 15:17 | 2024-01-17 13:52 | MySQL Server: Optimizer | Closed (93 days) | S2 | 8.0.35 | Any | Any | MTR test main.derived_limit fails with small cost differences |
113046 | 2023-11-10 14:58 | 2023-12-22 4:40 | MySQL Server: Optimizer | Closed (119 days) | S2 | 8.0.35, 8.2.0 | Any | Any | MTR tests for SELECT fail with ICP, MRR, possibly other flags |
111189 | 2023-05-29 15:04 | 2023-08-09 12:50 | MySQL Server: Optimizer | Closed (254 days) | S3 | 8.0 | Any | Any | Scalar correlated subquery with group by clause mistakenly transformed |
112460 | 2023-09-26 7:22 | 2024-01-03 16:18 | MySQL Server: Optimizer | Closed (107 days) | S2 | 8.0.33, 8.0.34 | Any | Any | Inconsistent results of SELECT statement with window functions |
112304 | 2023-09-09 18:07 | 2024-01-03 15:22 | MySQL Server: Optimizer | Closed (107 days) | S3 | 8.0 | Any | Any | MEM_ROOT::AllocBlock() does not satisfy minimum_length bigger than wanted_length |
112296 | 2023-09-08 0:48 | 2024-01-03 16:02 | MySQL Server: Optimizer | Closed (107 days) | S3 | 8.1.0, 8.0.34 | Any | Any | Unexpected Result by NO_BNL |
112180 | 2023-08-25 8:50 | 2023-08-29 9:51 | MySQL Server: Optimizer | Closed (234 days) | S1 | 8.0.34 | Any | Any | "Skip Scan Range Access Method" may lead to incorrect query results |
111663 | 2023-07-05 7:38 | 2023-10-12 16:07 | MySQL Server: Optimizer | Closed (190 days) | S2 | 5.7.42 | CentOS (3.10.0-957.21.2.el7.x86_64) | x86 | Same data, same SQL, return different results |
111564 | 2023-06-26 12:33 | 2023-08-10 12:21 | MySQL Server: Optimizer | Closed (253 days) | S3 | 8.0 | Any | Any | Contribution by Tencent: explain format=tree lost the subquery in the hash join |
111290 | 2023-06-06 7:48 | 2023-11-03 20:58 | MySQL Server: Optimizer | Closed (255 days) | S3 | 8.0.23, 8.0.33, 5.7 | Any | Any | No matching rows when joining multiple tables on binary/varbinary key |
111252 | 2023-06-02 2:10 | 2023-06-08 19:06 | MySQL Server: Optimizer | Closed (316 days) | S2 | 8.0.23, 5.7, 8.0 | Any | Any | order by random_bytes has no effect |
58660 | 2010-12-02 14:46 | 2012-03-26 19:32 | MySQL Server: Optimizer | Closed (4407 days) | S3 | 5.0.91, 5.1.39, 5.0, 5.1, 5.6.1 | Linux | Any | Index not used with a subquery |
58705 | 2010-12-03 16:14 | 2011-05-03 1:07 | MySQL Server: Optimizer | Closed (4735 days) | S1 | 5.1.54, 5.1.55, 5.5.9, 5.6.1 | Any | Any | optimizer let engine depend on uninitialized values created by opt_sum_query |
58731 | 2010-12-04 15:24 | 2012-07-29 22:52 | MySQL Server: Optimizer | Closed (4282 days) | S3 | 5.5.9, 5.6.2m5 | Any | Any | Use_count: Wrong count for key at 0x7fffd423ede0, 0 should be 1 |
58834 | 2010-12-09 8:15 | 2011-06-03 2:04 | MySQL Server: Optimizer | Closed (4704 days) | S2 | 5.6.2-m5, 5.5.9, 5.1.56 | Any | Any | 'range access' may incorrectly filter away qualifying rows |
59203 | 2010-12-29 4:38 | 2015-02-24 16:10 | MySQL Server: Optimizer | Closed (3342 days) | S1 | 5.0.91,5.1.39,5.1.55,5.5.8 | Any | Any | Serious optimizer failure when query is encapsulated in additional SELECT/INSERT |
59487 | 2011-01-13 21:15 | 2012-02-10 3:11 | MySQL Server: Optimizer | Closed (4452 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | wrong result with STRAIGHT_JOIN and RIGHT JOIN |
59493 | 2011-01-14 8:28 | 2012-10-15 13:40 | MySQL Server: Optimizer | Closed (4204 days) | S2 | 5.1.56, 5.5.9 | Any | Any | An assertion failure with a multiway join |
59546 | 2011-01-17 10:43 | 2011-11-11 18:24 | MySQL Server: Optimizer | Closed (4543 days) | S1 | 5.0.93, 5.1.56, 5.5.9, 5.6.2-m5 | Any (Debug) | Any | Assertion m_sp == __null fails in Item_func_sp::init_result_field with functions |
59736 | 2011-01-26 10:33 | 2011-09-30 18:13 | MySQL Server: Optimizer | Closed (4585 days) | S2 | >=5.0.60,>=5.1.24,5.5.10,5.6.2 | Any | Any | select distinct.. incorrect result with deterministic function in where clause |
59851 | 2011-01-31 16:07 | 2011-08-16 1:38 | MySQL Server: Optimizer | Closed (4630 days) | S2 | 5.0.93,5.1.56, 5.5.10,5.6.2 | Any | Any | uninitialised value in Item_func_like::select_optimize with subquery and like |
59919 | 2011-02-03 10:49 | 2011-04-21 1:00 | MySQL Server: Optimizer | Closed (4747 days) | S1 | 5.6.2-m5 (mysql-next-mr-opt-backpointing) | Any | Any | Crash in TMP_TABLE_PARAM::init() with semijoin=on |
59943 | 2011-02-04 11:12 | 2012-07-29 22:37 | MySQL Server: Optimizer | Closed (4282 days) | S1 | 5.6.2-m5 | Any | Any | materialization=on/off leads to different result set when using IN & VAR_POP |
60080 | 2011-02-10 9:29 | 2012-02-10 3:11 | MySQL Server: Optimizer | Closed (4452 days) | S3 | 5.5, mysql-trunk | Any | Any | STRAIGHT_JOIN is not enforced when right-hand table is itself a JOIN |
Showing 1-30 of 1272 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |