| Showing all 20 (Edit, Save, CSV, Feed) |
| ID# | Date | Type | Status | Sev | Version | Target | OS | Summary | Assigned |
|---|---|---|---|---|---|---|---|---|---|
| 25764 | 2007-01-22 21:59 | Server: Optimizer | Verified (303 days) | S3 | 5.0.36-BK, 6.0.8-bzr | Linux (Linux, Mac OS X) | Query Cost Estimate seems to only cover a part of subqueries, not full query. | Sergey Petrunya | |
| 26232 | 2007-02-09 18:28 | Server: Optimizer | Verified (1013 days) | S3 | 4.1.22, 5.0.34, 5.0.36-BK | Linux (Linux) | review of bug #20944 / proof of concept attached | Sergey Petrunya | |
| 26284 | 2007-02-12 13:32 | Server: Optimizer | Verified (744 days) | S3 | 5.0.bk | Linux (Linux) | bug #26273 / optimize, not executed for index, if datafile is gap-free | Sergey Petrunya | |
| 28338 | 2007-05-09 20:50 | Server: Optimizer | Verified (404 days) | S2 | 5.0.42-BK, 5.0.37 | Any | Optimizer doesn't choose the correct plan on a 3 table join | Sergey Petrunya | |
| 29443 | 2007-06-29 15:28 | Server: Optimizer | In progress (853 days) | S3 | 5.1.19 | Any | cost calculations are off | Sergey Petrunya | |
| 30733 | 2007-08-30 21:36 | Server: Optimizer | Verified (816 days) | S3 | 5.1.20, 5.0.45, 4.1 BK | Linux | Using where is shown in EXPLAIN output when there is no condition pushdown. | Sergey Petrunya | |
| 31648 | 2007-10-16 21:01 | Server: Optimizer | Verified (738 days) | S2 | 5.1.22, 5.0.50 | Any | full table scans being done when range should be used | Sergey Petrunya | |
| 35633 | 2008-03-28 9:19 | Server: Optimizer | Verified (606 days) | S1 | 5.0.54, 5.0.56 | Linux (2.6.25-rc4) | Column cant be NULL error on SELECT...FROM (SELECT not_null_column, agg_func...) | Sergey Petrunya | |
| 35794 | 2008-04-03 14:06 | Server: Optimizer | Verified (526 days) | S3 | 5.0.45, 5.0, 5.1, 6.0 BK | Any | Very bad query optimization on DELETE with subquery | Sergey Petrunya | |
| 36422 | 2008-04-30 4:19 | Server: Optimizer | Verified (573 days) | S3 | 6.0.x | Any | EXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins | Sergey Petrunya | |
| 36716 | 2008-05-14 18:29 | Server: Optimizer | Verified (559 days) | S3 | 6.0.x | Any | optimizer_use_mrr: cannot set at server startup, does not appear in help message | Sergey Petrunya | |
| 36725 | 2008-05-14 22:19 | Server: Optimizer | Verified (364 days) | S2 | 5.1.22/5.0BK/5.1BK | Linux (Ubuntu 7.04) | UPDATE takes too long to execute | Sergey Petrunya | |
| 37328 | 2008-06-11 6:50 | Server: Optimizer | Verified (531 days) | S3 | 5.0.60, 5.0.64 | Any | Optimizer prefers ref access on multiple-column index over simple range access | Sergey Petrunya | |
| 38550 | 2008-08-04 23:47 | Server: Optimizer | Verified (404 days) | S5 | 5.0.60, 5.1 | Any | multiple optimizer bugs for queries with references from preceding table | Sergey Petrunya | |
| 40154 | 2008-10-19 21:05 | Tests: Server | Verified (364 days) | S2 | 6.0 | Any | main.subselect_sj2 fails sporadically on pushbuild | Sergey Petrunya | |
| 41229 | 2008-12-04 15:22 | Server: Optimizer | Verified | S3 | mysql-6.0-wl4520 | 6.0 | Any | EXPLAIN CONDS crash when conditions referres to a non-existing field. | Sergey Petrunya |
| 41659 | 2008-12-20 17:28 | Server: Optimizer | Verified (339 days) | S3 | 5.0/5.1/6.0 | Any | "Range checked for each record" is not used for conditions with outer query refs | Sergey Petrunya | |
| 42259 | 2009-01-22 7:36 | Server: DML | Verified (55 days) | S5 | 5.4.2 | Microsoft Windows (XP Pro x64) | SELECT WHERE IN performs poorly (slow) with views and functions | Sergey Petrunya | |
| 42808 | 2009-02-12 23:17 | Server: Optimizer | Verified (284 days) | S5 | 4.1, 5.0, 5.1 | Any | Execution Plan Cache | Sergey Petrunya | |
| 43219 | 2009-02-26 10:49 | Server: Optimizer | Verified (271 days) | S3 | 5.0.70, 4.1, 5.0, 5.1, 6.0 bzr | Linux (Gentoo) | delete does not use index when using OR in where clause | Sergey Petrunya |
| Showing all 20 (Edit, Save, CSV, Feed) |
