| Showing 1-49 of 49 (Edit, Save, CSV, Feed) |
| ID# | Date | Type | Status | Sev | Version | Target | OS | Summary | Assigned |
|---|---|---|---|---|---|---|---|---|---|
| 41759 | 2008-12-27 2:16 | Server | Documenting (8 days) | S3 | Any | Valgrind warning: Invalid read of size 1 open_tables() with ps-protocol | Sergey Petrunia | ||
| 9622 | 2005-04-04 21:31 | Server: Optimizer | In progress (988 days) | S2 | 5.0,4,1,5.0 | 6.0-beta | Any (*) | Optimizer makes join index mistake | Sergey Petrunia |
| 25764 | 2007-01-22 21:59 | Server: Optimizer | In progress (3 days) | S3 | 5.0.36-BK, 6.0.8-bzr | 6.0-beta | Linux (Linux, Mac OS X) | Query Cost Estimate seems to only cover a part of subqueries, not full query. | Sergey Petrunia |
| 28554 | 2007-05-21 11:32 | Server: Optimizer | In progress (511 days) | S3 | 4.1.22, 5.0.42-BK | 5.1 | Any | Optimizer wrongly prefers index for (col = value) over (PK <= value) | Sergey Petrunia |
| 29443 | 2007-06-29 15:28 | Server: Optimizer | In progress (531 days) | S3 | 5.1.19 | 6.0-rc | Any | cost calculations are off | Sergey Petrunia |
| 31480 | 2007-10-09 15:29 | Server: Optimizer | In progress (415 days) | S2 | 6.0-{main, opt} | 6.0-beta | Any | Incorrect result for nested subquery when executed via semi join | Sergey Petrunia |
| 32254 | 2007-11-10 3:06 | Server: Optimizer | In progress (153 days) | S3 | 5.0.50, 5.1.22, 5.0.66a | 6.0-beta | Any | Index merge used unnecessarily | Sergey Petrunia |
| 34590 | 2008-02-15 12:51 | Server: Optimizer | In progress (138 days) | S3 | 6.0.4 | 6.0-beta | Any | Innodb crash in build_template() on multi-table delete | Sergey Petrunia |
| 37208 | 2008-06-05 0:19 | Server: Optimizer | In progress (162 days) | S3 | 6.0 | 6.0-beta | Any | Wrong query result for big innodb table when index condition pushdown is used | Sergey Petrunia |
| 40151 | 2008-10-19 20:12 | Server: Optimizer | Open | S3 | 6.0 | Any | EXPLAIN doesn't show DISTINCT+join optimization | Sergey Petrunia | |
| 37842 | 2008-07-03 19:05 | Server: Optimizer | Patch approved (4 days) | S1 | 6.0 | 6.0-beta | Any | Assertion in DsMrr_impl::dsmrr_init, at handler.cc:4307 | Sergey Petrunia |
| 38049 | 2008-07-11 16:50 | Server: Optimizer | Patch approved (115 days) | S5 | 5.0.60, 5.0.68-bzr, 5.1.28-bzr | 6.0 | Any | incorrect rows estimations with references from preceding table | Sergey Petrunia |
| 37822 | 2008-07-02 22:00 | Server: Optimizer | Patch pending (171 days) | S2 | 5.0,5.1,6.0 | 5.1+ | Any | Correlated subquery with IN and IS UNKNOWN provides wrong result | Sergey Petrunia |
| 32665 | 2007-11-23 17:26 | Server: Optimizer | Patch queued (3 days) | S3 | 5.1.22-rc-Debian_1-log | 6.0-beta | Any | Query with dependent subquery is too slow | Sergey Petrunia |
| 39447 | 2008-09-15 10:57 | Server: Optimizer | Patch queued (8 days) | S3 | 6.0.5, 6.0 BZR | 6.0-beta | Any (Linux, MS Windows XP SP2) | Error with NOT NULL condition and LIMIT 1 | Sergey Petrunia |
| 40974 | 2008-11-24 12:42 | Server: Optimizer | Patch queued (15 days) | S2 | 5.0/5.1/6.0 | 5.0+ | Any | Incorrect query results when using clause evaluated using range check | Sergey Petrunia |
| 26232 | 2007-02-09 18:28 | Server: Optimizer | Verified (691 days) | S3 | 4.1.22, 5.0.34, 5.0.36-BK | 6.0 | Linux (Linux) | review of bug #20944 / proof of concept attached | Sergey Petrunia |
| 26284 | 2007-02-12 13:32 | Server: Optimizer | Verified (422 days) | S3 | 5.0.bk | 6.0 | Linux (Linux) | bug #26273 / optimize, not executed for index, if datafile is gap-free | Sergey Petrunia |
| 26630 | 2007-02-26 12:21 | Server: Optimizer | Verified (82 days) | S5 | 5.1.18-BK, 5.1.14-beta | Linux (linux) | Partition pruning not working against joins | Sergey Petrunia | |
| 28338 | 2007-05-09 20:50 | Server: Optimizer | Verified (82 days) | S2 | 5.0.42-BK, 5.0.37 | Any | Optimizer doesn't choose the correct plan on a 3 table join | Sergey Petrunia | |
| 30278 | 2007-08-07 18:47 | Server: InnoDB | Verified | S5 | 5.1.20 | 6.0 | Any | InnoDB: performance regression for update_with_key_prefix operation(mysql-bench) | Sergey Petrunia |
| 30733 | 2007-08-30 21:36 | Server: Optimizer | Verified (494 days) | S3 | 5.1.20, 5.0.45, 4.1 BK | 6.0 | Linux | Using where is shown in EXPLAIN output when there is no condition pushdown. | Sergey Petrunia |
| 31188 | 2007-09-25 18:52 | Server: Optimizer | Verified (418 days) | S5 | 5.0.37 | 6.x | Any | Optimizer does not do index range scans using predicates in IN lists | Sergey Petrunia |
| 31648 | 2007-10-16 21:01 | Server: Optimizer | Verified (416 days) | S2 | 5.1.22, 5.0.50 | 6.0-rc | Any | full table scans being done when range should be used | Sergey Petrunia |
| 33730 | 2008-01-08 1:18 | Server: Optimizer | Verified (82 days) | S5 | 5.1.22 | 6.0-beta | Linux | Full table scan instead selected partitions for query more than 10 partitions | Sergey Petrunia |
| 34591 | 2008-02-15 12:56 | Server: Optimizer | Verified (320 days) | S1 | 6.0.4 | 6.0-beta | Any | Innob crash in row_sel_store_mysql_rec() on multi-table delete | Sergey Petrunia |
| 35676 | 2008-03-29 20:36 | Server: Optimizer | Verified (283 days) | S3 | 6.0-bk | 6.0 | Any | @@optimizer_switch not present in mysqld options | Sergey Petrunia |
| 35080 | 2008-03-05 14:00 | Server: Optimizer | Verified (181 days) | S3 | 6.0-falcon-team, 6.0 | 6.0-beta | Any | Innodb crash at mem_block_get_len line 72 | Sergey Petrunia |
| 35633 | 2008-03-28 9:19 | Server: Optimizer | Verified (284 days) | S1 | 5.0.54, 5.0.56 | 6.0 | Linux (2.6.25-rc4) | Column cant be NULL error on SELECT...FROM (SELECT not_null_column, agg_func...) | Sergey Petrunia |
| 35794 | 2008-04-03 14:06 | Server: Optimizer | Verified (204 days) | S3 | 5.0.45, 5.0, 5.1, 6.0 BK | 6.0-rc | Any | Very bad query optimization on DELETE with subquery | Sergey Petrunia |
| 36259 | 2008-04-22 19:11 | Server: Optimizer | Verified (191 days) | S5 | 5.0.54, 5.1.23, 5.1.24, 5.1.25 | 5.1+ | Microsoft Windows | Optimizing with ORDER BY | Sergey Petrunia |
| 36422 | 2008-04-30 4:19 | Server: Optimizer | Verified (251 days) | S3 | 6.0.x | 6.0 | Any | EXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins | Sergey Petrunia |
| 36681 | 2008-05-13 10:11 | Server: Optimizer | Verified (225 days) | S3 | 5.0.54 | 6.0 | Any | Insufficient plans for huge tables | Sergey Petrunia |
| 36716 | 2008-05-14 18:29 | Server: Optimizer | Verified (237 days) | S3 | 6.0.x | 6.0-rc | Any | optimizer_use_mrr: cannot set at server startup, does not appear in help message | Sergey Petrunia |
| 36725 | 2008-05-14 22:19 | Server: Optimizer | Verified (42 days) | S2 | 5.1.22/5.0BK/5.1BK | 6.0-rc | Linux (Ubuntu 7.04) | UPDATE takes too long to execute | Sergey Petrunia |
| 36981 | 2008-05-26 17:20 | Server: Optimizer | Verified (225 days) | S1 | 6.0.6bk, 6.0.8 | 6.0-beta | Any | innodb crash when selecting for update | Sergey Petrunia |
| 38010 | 2008-07-10 11:36 | Server: Optimizer | Verified (180 days) | S2 | 6.0 | 6.0-rc | Any | Wrong result returned when outer join, semijoin and "use index" | Sergey Petrunia |
| 37328 | 2008-06-11 6:50 | Server: Optimizer | Verified (209 days) | S3 | 5.0.60, 5.0.64 | 6.0 | Any | Optimizer prefers ref access on multiple-column index over simple range access | Sergey Petrunia |
| 37415 | 2008-06-15 19:56 | Server: Optimizer | Verified (181 days) | S1 | 6.0 | 6.0-beta | Any | Crash in row_sel_field_store_in_mysql_format on multiple-table update | Sergey Petrunia |
| 37576 | 2008-06-23 8:29 | Server: Optimizer | Verified (195 days) | S5 | 6.0 | 6.0-rc | Linux (SLES10SP1 (2.6.16.46-0.12-smp)) | MySQL6.0 performance regression compared with MySQL5.1 using Sysbench read test | Sergey Petrunia |
| 37893 | 2008-07-05 22:00 | Server: Optimizer | Verified | S1 | 6.0 | 6.0-beta | Any | Crash in select_describe line 19251 on a FirstMatch query with OUTER JOIN | Sergey Petrunia |
| 38015 | 2008-07-10 15:11 | Server: Optimizer | Verified (180 days) | S2 | 6.0 | 6.0-beta | Any | Bad result: inconsistent treatment of comparisons between data types in subquery | Sergey Petrunia |
| 38075 | 2008-07-12 20:40 | Server: Optimizer | Verified (177 days) | S2 | 6.0.6 bzr | 6.0-beta | Any | Wrong result: rows matching a subquery with outer join not returned | Sergey Petrunia |
| 38201 | 2008-07-17 17:36 | Server: Optimizer | Verified (173 days) | S2 | 6.0 | 6.0-beta | Any | Wrong result when left join + subquery + semijoin | Sergey Petrunia |
| 38550 | 2008-08-04 23:47 | Server: Optimizer | Verified (82 days) | S5 | 5.0.60, 5.1 | 6.0 | Any | multiple optimizer bugs for queries with references from preceding table | Sergey Petrunia |
| 40154 | 2008-10-19 21:05 | Tests: Server | Verified (42 days) | S2 | 6.0 | 6.0-beta | Any | main.subselect_sj2 fails sporadically on pushbuild | Sergey Petrunia |
| 40992 | 2008-11-24 20:14 | Server: Optimizer | Verified (41 days) | S3 | 6.0 bzr | 6.0-beta | Any | InnoDB: Crash when engine_condition_pushdown is on | Sergey Petrunia |
| 41029 | 2008-11-25 20:37 | Server: Optimizer | Verified (32 days) | S3 | 6.0bzr | 6.0-beta | Any | MRR: SELECT FOR UPDATE fails to lock gaps | Sergey Petrunia |
| 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 Petrunia |
| Showing 1-49 of 49 (Edit, Save, CSV, Feed) |
