| Showing 1-30 of 269 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 8652 | 2005-02-21 16:28 | 2010-05-12 5:07 | MySQL Server: Optimizer | Not a Bug (6896 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 (6998 days) | S2 | 4.1.10 | Linux (Linux kernel 2.4.26) | Any | user variables' behaviour depends on using DISTINCT |
| 8821 | 2005-02-26 12:00 | 2005-06-15 9:12 | MySQL Server: Optimizer | Not a Bug (6889 days) | S2 | Ver 14.7 Distrib 4.1.9, for dec-osf5.1b | alphaev67 | Any | join to subquery without distinct causes bad COUNT |
| 9228 | 2005-03-16 18:37 | 2005-04-26 21:31 | MySQL Server: Optimizer | Not a Bug (6939 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 (6967 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 (6943 days) | S3 | 4.1.11 | Any (*) | Any | wrong result for subselect in on duplicate key update (query cache) |
| 9693 | 2005-04-06 19:29 | 2005-06-20 5:38 | MySQL Server: Optimizer | Not a Bug (6884 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) |
| 10266 | 2005-04-29 15:47 | 2005-06-09 17:17 | MySQL Server: Optimizer | Not a Bug (6895 days) | S2 | 4.1 | Windows (Windows 2000) | Any | Order of multiple left joins matters? |
| 10512 | 2005-05-10 14:21 | 2005-05-17 12:27 | MySQL Server: Optimizer | Not a Bug (6918 days) | S2 | 4.0.25 forward | Any | Optimizer selecting wrong index with composite indexes | |
| 10557 | 2005-05-11 14:44 | 2005-05-11 15:41 | MySQL Server: Optimizer | Not a Bug (6924 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" |
| 10792 | 2005-05-22 23:02 | 2005-06-02 19:00 | MySQL Server: Optimizer | Not a Bug (6902 days) | S3 | 5.0.4-beta-standard-log | Linux (linux) | Any | unexpected result of IF declaredVar IS NULL |
| 11071 | 2005-06-03 12:59 | 2005-06-27 13:27 | MySQL Server: Optimizer | Not a Bug (6877 days) | S1 | 4.1 bk tree | Linux (linux) | Any | SELECT crashes MySQL server |
| 11303 | 2005-06-14 1:40 | 2005-06-14 13:50 | MySQL Server: Optimizer | Not a Bug (6890 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 (6858 days) | S3 | 4.1.12 | Linux (Linux Fedora Core 2) | Any | slow query due to datatype cast? |
| 11713 | 2005-07-03 20:36 | 2005-07-21 14:51 | MySQL Server: Optimizer | Not a Bug (6853 days) | S3 | 4.1-bk | Any | OUTER JOIN incorrectly converted to INNER for complex WHERE clause | |
| 11716 | 2005-07-04 2:48 | 2005-08-19 8:41 | MySQL Server: Optimizer | Not a Bug (6824 days) | S3 | 5.0.7 beta max | Linux (Linux (FC 4)) | Any | Extremely poor performance when joining tables and views |
| 11936 | 2005-07-14 12:46 | 2005-07-17 18:36 | MySQL Server: Optimizer | Not a Bug (6857 days) | S2 | 5.0.7-beta-nt/5.0.10 BK | Any (any) | Any | Lock table failing create table ....select |
| 12106 | 2005-07-22 8:40 | 2006-03-29 13:38 | MySQL Server: Optimizer | Not a Bug (6602 days) | S3 | 4.1.12a-nt, 5.0.9-beta-nt | Windows (XP) | Any | EXPLAIN shows incorrect select_type for subquery |
| 12605 | 2005-08-16 16:50 | 2005-08-17 0:43 | MySQL Server: Optimizer | Not a Bug (6826 days) | S2 | 5.0 | Any | JOIN with ON condition gets now error response | |
| 12617 | 2005-08-17 8:19 | 2005-08-18 21:52 | MySQL Server: Optimizer | Not a Bug (6825 days) | S2 | 5.0.11 | Any (all) | Any | CREATE TABLE ... SELECT does not respect column order |
| 12747 | 2005-08-23 6:03 | 2005-08-25 11:58 | MySQL Server: Optimizer | Not a Bug (6818 days) | S2 | 5.0.12 (all) | Linux (Linux) | Any | Multiple JOINs fail with 5.0.12 (column not found) |
| 12816 | 2005-08-25 23:58 | 2005-08-29 7:38 | MySQL Server: Optimizer | Not a Bug (6814 days) | S2 | 5.0.13-bk | Linux (Linux) | Any | JOIN with USING clause doesn't return expected result |
| 12934 | 2005-09-01 17:42 | 2005-09-08 23:16 | MySQL Server: Optimizer | Not a Bug (6804 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 |
| 12971 | 2005-09-03 20:10 | 2005-09-07 17:46 | MySQL Server: Optimizer | Not a Bug (6805 days) | S2 | 5.0.12-beta | Linux (Linux, Windows) | Any | Inconsistent data in a view |
| 13569 | 2005-09-28 14:09 | 2005-09-28 15:00 | MySQL Server: Optimizer | Not a Bug (6784 days) | S3 | all | Any (all) | Any | User friendly |
| 13874 | 2005-10-09 16:23 | 2006-10-27 0:42 | MySQL Server: Optimizer | Not a Bug (6390 days) | S3 | 4.1.14, 5.0.13, 5.0.15-BK | Linux (Linux, Windows, FreeBSD) | Any | Incorrect subquery handling in "exists" |
| 14006 | 2005-10-13 14:46 | 2005-10-19 7:42 | MySQL Server: Optimizer | Not a Bug (6763 days) | S3 | 5.0 | Linux (Linux) | Any | GROUP BY doesn't work |
| 14100 | 2005-10-18 0:54 | 2006-07-14 16:10 | MySQL Server: Optimizer | Not a Bug (6495 days) | S3 | 5.0.13-rc/4.1.XX | Windows (Windows/FreeBSD) | Any | STRAIGHT_JOIN hint causes a eq_ref to become ref and fail to see 0/1 rowmatches |
| 14220 | 2005-10-21 21:00 | 2017-11-16 7:45 | MySQL Server: Optimizer | Not a Bug (2353 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) |
| 14237 | 2005-10-23 12:55 | 2006-05-25 10:32 | MySQL Server: Optimizer | Not a Bug (6545 days) | S1 | ALL | Any (ALL) | Any | Distinct breaks order of results with enum fields |
| Showing 1-30 of 269 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
