Showing 1-30 of 269 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
112629 | 2023-10-05 8:26 | 2023-10-06 13:20 | MySQL Server: Optimizer | Not a Bug (175 days) | S3 | 8.0.28 | Any (AWS managed RDS) | Any | Index is not used if there is some constant boolean expressions |
114435 | 2024-03-21 6:56 | 2024-03-24 7:48 | MySQL Server: Optimizer | Not a Bug (5 days) | S1 | 8.0.36 | Any | Any | Incorrect query results caused by the subquery optimization. |
114058 | 2024-02-20 7:28 | 2024-02-20 11:06 | MySQL Server: Optimizer | Not a Bug (38 days) | S3 | 8.0.35 | Any | Any | The return value of the CAST(... AS UNSIGNED) expression is out of range. |
113423 | 2023-12-14 13:19 | 2023-12-14 14:36 | MySQL Server: Optimizer | Not a Bug (106 days) | S3 | 8.0.35 | Any | Any | Unexpected result appeared |
113043 | 2023-11-10 10:47 | 2023-11-10 13:03 | MySQL Server: Optimizer | Not a Bug (140 days) | S3 | 8.0.1 | Any | Any | Inner join behaves like left join with aggregate function |
112915 | 2023-11-01 10:27 | 2023-11-02 8:08 | MySQL Server: Optimizer | Not a Bug (148 days) | S3 | 8.1.0, 8.0.35 | Ubuntu (22.04) | x86 (x86_64) | CTE double materialization issue |
112876 | 2023-10-28 16:43 | 2023-11-10 11:34 | MySQL Server: Optimizer | Not a Bug (140 days) | S3 | 8.0.33 | Any | Any | ICP (Index condition pushdown) causing BIGINT UNSIGNED value out of range error |
112768 | 2023-10-19 7:15 | 2023-10-19 10:12 | MySQL Server: Optimizer | Not a Bug (162 days) | S3 | 8.1.0, 8.0.34 | Any | Any | Inconsistent results when tables are JOINed in a different order |
112641 | 2023-10-05 18:40 | 2023-10-06 13:27 | MySQL Server: Optimizer | Not a Bug (175 days) | S2 | 8.0.28, 5.7.43, 8.0.34, 8.1.0 | Any | Any | ORDER BY does not work with CREATE TEMPORARY TABLE |
111218 | 2023-05-31 11:41 | 2023-06-01 13:11 | MySQL Server: Optimizer | Not a Bug (302 days) | S3 | 8.0.33 | Ubuntu (ubuntu0.20.04.2) | x86 (x86_64) | Logic bug: logic equal sqls return different results |
112600 | 2023-10-03 13:56 | 2023-10-05 12:34 | MySQL Server: Optimizer | Not a Bug (176 days) | S3 | 8.0 | Any | Any | The inconsistencies between the expr in the SELECT clause and WHERE clause |
112395 | 2023-09-20 13:24 | 2023-09-21 8:55 | MySQL Server: Optimizer | Not a Bug (190 days) | S3 | 8.0.33 | Any | Any | The results on the open source 8.0.33 are not as expected. |
112108 | 2023-08-18 7:13 | 2023-08-22 7:18 | MySQL Server: Optimizer | Not a Bug (220 days) | S3 | 8.0.33, 8.0.34 | Red Hat (8) | Any | VIEW reference in a SELECT subquery returns different results between 5.7 & 8.0 |
112084 | 2023-08-16 11:44 | 2023-08-17 9:13 | MySQL Server: Optimizer | Not a Bug (225 days) | S5 | 8.0.34 | Any | Any | performance optimization |
111695 | 2023-07-08 1:57 | 2023-07-12 12:30 | MySQL Server: Optimizer | Not a Bug (261 days) | S3 | 8.0.28 | Ubuntu | Any | Different results when change t0.c0 into t1.c1 |
111636 | 2023-06-30 22:34 | 2023-07-03 12:41 | MySQL Server: Optimizer | Not a Bug (270 days) | S5 | 8.0.33,5.7.41 | Any | Any | Query not using the index even with FORCE INDEX |
111299 | 2023-06-06 14:14 | 2023-06-07 13:02 | MySQL Server: Optimizer | Not a Bug (296 days) | S3 | 8.0.33 | Ubuntu (20.04.2) | x86 (x86_64) | Return incorrect result |
111265 | 2023-06-03 3:40 | 2023-06-06 12:10 | MySQL Server: Optimizer | Not a Bug (297 days) | S3 | 8.0.33 | Ubuntu (20.04.2) | x86 (x86_64) | Return wrong result |
8652 | 2005-02-21 16:28 | 2010-05-12 5:07 | MySQL Server: Optimizer | Not a Bug (6869 days) | S3 | 4.1.10 | Any | Any | group by part of rand() returns duplicate key error |
8810 | 2005-02-25 16:15 | 2005-02-26 21:22 | MySQL Server: Optimizer | Not a Bug (6971 days) | S2 | 4.1.10 | Linux (Linux kernel 2.4.26) | Any | user variables' behaviour depends on using DISTINCT |
10557 | 2005-05-11 14:44 | 2005-05-11 15:41 | MySQL Server: Optimizer | Not a Bug (6897 days) | S3 | 5.0.4-beta-debug | Linux (linux 2.6.8-24.14 smp) | Any | Too few results when "Using index for group-by" |
11303 | 2005-06-14 1:40 | 2005-06-14 13:50 | MySQL Server: Optimizer | Not a Bug (6863 days) | S1 | 4.1 | Windows (windows) | Any | sql bug |
11346 | 2005-06-15 9:48 | 2005-07-16 20:31 | MySQL Server: Optimizer | Not a Bug (6831 days) | S3 | 4.1.12 | Linux (Linux Fedora Core 2) | Any | slow query due to datatype cast? |
12605 | 2005-08-16 16:50 | 2005-08-17 0:43 | MySQL Server: Optimizer | Not a Bug (6799 days) | S2 | 5.0 | Any | JOIN with ON condition gets now error response | |
12816 | 2005-08-25 23:58 | 2005-08-29 7:38 | MySQL Server: Optimizer | Not a Bug (6787 days) | S2 | 5.0.13-bk | Linux (Linux) | Any | JOIN with USING clause doesn't return expected result |
13569 | 2005-09-28 14:09 | 2005-09-28 15:00 | MySQL Server: Optimizer | Not a Bug (6757 days) | S3 | all | Any (all) | Any | User friendly |
14220 | 2005-10-21 21:00 | 2017-11-16 7:45 | MySQL Server: Optimizer | Not a Bug (2326 days) | S3 | 4.0, 4.1, 5.0, 5.1 | Any | Any | Optimizer does not use index when using numeric lookup on varchar field (MyISAM) |
18922 | 2006-04-09 17:40 | 2006-04-09 21:15 | MySQL Server: Optimizer | Not a Bug (6564 days) | S3 | 5.0 | Linux (FC4 AMD64) | Any | Nothing should have a value and be null. That is crazy talk :) |
20722 | 2006-06-27 13:39 | 2006-07-28 3:01 | MySQL Server: Optimizer | Not a Bug (6454 days) | S3 | 5.1.12-BK, 5.1.7-beta-log | Linux (Linux) | Any | Difference in EXPLAIN between IN and UNION |
24111 | 2006-11-08 23:29 | 2006-12-05 19:01 | MySQL Server: Optimizer | Not a Bug (6324 days) | S5 | 5.0.32-BK, 5.0 and 5.1 | Linux (Linux) | Any | slow performance of sequential "order by" queries |
Showing 1-30 of 269 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |