Showing 1-30 of 269 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
49078 | 2009-11-24 21:31 | 2009-11-30 14:54 | MySQL Server: Optimizer | Not a Bug (5233 days) | S3 | Any | Any | MySQL orders NULLS differently than JavaDB and Postgres (first rather than last) | |
85150 | 2017-02-23 13:06 | 2017-02-23 14:51 | MySQL Server: Optimizer | Not a Bug (2591 days) | S5 | Any | Any | MYSQL Performance Issue in CLOUD | |
97575 | 2019-11-11 9:28 | 2019-11-11 12:47 | MySQL Server: Optimizer | Not a Bug (1600 days) | S3 | CentOS | x86 | the max() is wrong | |
105836 | 2021-12-08 13:40 | 2021-12-16 13:03 | MySQL Server: Optimizer | Not a Bug (834 days) | S3 | Any | Any | KeyFields are optimzied away with no collation in Item::eq_by_collation | |
106987 | 2022-04-12 7:30 | 2022-04-12 14:09 | MySQL Server: Optimizer | Not a Bug (717 days) | S3 | Any | Any | when set prefer_ordering_index=off, a very simple sql become very slow | |
107559 | 2022-06-14 8:45 | 2022-06-14 12:23 | MySQL Server: Optimizer | Not a Bug (654 days) | S3 | Any | Any | Why Switch_ref_item_slice in TemptableAggregateIterator::Init | |
29357 | 2007-06-26 11:34 | 2007-08-06 7:39 | MySQL Server: Optimizer | Not a Bug (6080 days) | S2 | 5.1.19-beta-log MySQL, 5.0 BK | Any | Any | Filtering on view with group don't works. |
95462 | 2019-05-21 18:42 | 2023-02-06 18:59 | MySQL Server: Optimizer | Not a Bug (1709 days) | S3 | 8.0.16 | Any | Any | Data comparison broke in MySQL 8.0.16 |
108454 | 2022-09-10 21:59 | 2022-09-23 16:41 | MySQL Server: Optimizer | Not a Bug (553 days) | S3 | 12c | Any | x86 | LEAD/LAG results do not filter as original column |
80043 | 2016-01-19 6:19 | 2018-10-25 8:46 | MySQL Server: Optimizer | Not a Bug (1982 days) | S3 | 14.14 Distrib 5.6.27, for Linux (x86_64) | Ubuntu (Linux Mint 17 Qiana (Ubuntu 14.04 LTS)) | Any | No double escapes required inside square brackets |
9693 | 2005-04-06 19:29 | 2005-06-20 5:38 | MySQL Server: Optimizer | Not a Bug (6857 days) | S3 | 3.23.41, 4.0.24, 4.1 | Linux (linux) | Any | bug in trying to join a value on a range (using indexes) |
24341 | 2006-11-15 18:28 | 2006-11-21 16:37 | MySQL Server: Optimizer | Not a Bug (6338 days) | S5 | 4, 5 | Any (All) | Any | Performance problem when using ORDER BY in fulltext query |
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) |
10512 | 2005-05-10 14:21 | 2005-05-17 12:27 | MySQL Server: Optimizer | Not a Bug (6891 days) | S2 | 4.0.25 forward | Any | Optimizer selecting wrong index with composite indexes | |
10266 | 2005-04-29 15:47 | 2005-06-09 17:17 | MySQL Server: Optimizer | Not a Bug (6868 days) | S2 | 4.1 | Windows (Windows 2000) | Any | Order of multiple left joins matters? |
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 |
11071 | 2005-06-03 12:59 | 2005-06-27 13:27 | MySQL Server: Optimizer | Not a Bug (6850 days) | S1 | 4.1 bk tree | Linux (linux) | Any | SELECT crashes MySQL server |
11713 | 2005-07-03 20:36 | 2005-07-21 14:51 | MySQL Server: Optimizer | Not a Bug (6826 days) | S3 | 4.1-bk | Any | OUTER JOIN incorrectly converted to INNER for complex WHERE clause | |
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 |
9228 | 2005-03-16 18:37 | 2005-04-26 21:31 | MySQL Server: Optimizer | Not a Bug (6912 days) | S3 | 4.1.10 | Any (*) | Any | optimizer on alternating function with no ref to columns |
9451 | 2005-03-29 12:58 | 2005-03-29 19:47 | MySQL Server: Optimizer | Not a Bug (6940 days) | S3 | 4.1.10-nt-log | Windows (Windows XP) | Any | Selecting rows with null primary key does not always return the empty set |
9689 | 2005-04-06 17:37 | 2005-04-22 21:10 | MySQL Server: Optimizer | Not a Bug (6916 days) | S3 | 4.1.11 | Any (*) | Any | wrong result for subselect in on duplicate key update (query cache) |
12934 | 2005-09-01 17:42 | 2005-09-08 23:16 | MySQL Server: Optimizer | Not a Bug (6777 days) | S2 | 4.1.11-standard, 4.1.14-nt | Linux (Linux, Windows) | Any | Select without `where` does not show row that same select with `where` returns |
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? |
12106 | 2005-07-22 8:40 | 2006-03-29 13:38 | MySQL Server: Optimizer | Not a Bug (6575 days) | S3 | 4.1.12a-nt, 5.0.9-beta-nt | Windows (XP) | Any | EXPLAIN shows incorrect select_type for subquery |
13874 | 2005-10-09 16:23 | 2006-10-27 0:42 | MySQL Server: Optimizer | Not a Bug (6363 days) | S3 | 4.1.14, 5.0.13, 5.0.15-BK | Linux (Linux, Windows, FreeBSD) | Any | Incorrect subquery handling in "exists" |
17847 | 2006-03-01 23:57 | 2006-05-04 15:47 | MySQL Server: Optimizer | Not a Bug (6539 days) | S5 | 4.1.19-BK, 4.0.24 | Linux (Linux, FreeBSD) | Any | Complex WHERE/ORDER/LIMIT runs much slower with DESC than ASC |
20944 | 2006-07-10 15:25 | 2006-10-19 2:13 | MySQL Server: Optimizer | Not a Bug (6371 days) | S2 | 4.1.22-BK, 4.1.20, 5.0.22, 5.0.25-BK | Linux (Linux, freebsd) | Any | optimizer estimates more rows if condition gets narrowed / combined key / range |
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 |
Showing 1-30 of 269 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |