Showing all 21 (Edit, Save, CSV, Feed)
ID# Date Type Status Sev Version Target OS Summary Assigned
294432007-06-29
15:28
Server: OptimizerIn progress
(858 days)
S35.1.19Anycost calculations are off Sergey Petrunya
401512008-10-19
20:12
Server: OptimizerOpenS36.0AnyEXPLAIN doesn't show DISTINCT+join optimization Sergey Petrunya
412292008-12-04
15:22
Server: OptimizerVerifiedS3mysql-6.0-wl45206.0AnyEXPLAIN CONDS crash when conditions referres to a non-existing field. Sergey Petrunya
422592009-01-22
7:36
Server: DMLVerified
(60 days)
S55.4.2Microsoft Windows (XP Pro x64)SELECT WHERE IN performs poorly (slow) with views and functions Sergey Petrunya
432192009-02-26
10:49
Server: OptimizerVerified
(276 days)
S35.0.70, 4.1, 5.0, 5.1, 6.0 bzrLinux (Gentoo)delete does not use index when using OR in where clause Sergey Petrunya
428082009-02-12
23:17
Server: OptimizerVerified
(289 days)
S54.1, 5.0, 5.1AnyExecution Plan Cache Sergey Petrunya
257642007-01-22
21:59
Server: OptimizerVerified
(308 days)
S35.0.36-BK, 6.0.8-bzrLinux (Linux, Mac OS X)Query Cost Estimate seems to only cover a part of subqueries, not full query. Sergey Petrunya
416592008-12-20
17:28
Server: OptimizerVerified
(344 days)
S35.0/5.1/6.0Any"Range checked for each record" is not used for conditions with outer query refs Sergey Petrunya
367252008-05-14
22:19
Server: OptimizerVerified
(369 days)
S25.1.22/5.0BK/5.1BKLinux (Ubuntu 7.04)UPDATE takes too long to execute Sergey Petrunya
401542008-10-19
21:05
Tests: ServerVerified
(369 days)
S26.0Anymain.subselect_sj2 fails sporadically on pushbuild Sergey Petrunya
283382007-05-09
20:50
Server: OptimizerVerified
(409 days)
S25.0.42-BK, 5.0.37AnyOptimizer doesn't choose the correct plan on a 3 table join Sergey Petrunya
385502008-08-04
23:47
Server: OptimizerVerified
(409 days)
S55.0.60, 5.1Anymultiple optimizer bugs for queries with references from preceding table Sergey Petrunya
357942008-04-03
14:06
Server: OptimizerVerified
(531 days)
S35.0.45, 5.0, 5.1, 6.0 BKAnyVery bad query optimization on DELETE with subquery Sergey Petrunya
373282008-06-11
6:50
Server: OptimizerVerified
(536 days)
S35.0.60, 5.0.64AnyOptimizer prefers ref access on multiple-column index over simple range access Sergey Petrunya
367162008-05-14
18:29
Server: OptimizerVerified
(564 days)
S36.0.xAnyoptimizer_use_mrr: cannot set at server startup, does not appear in help message Sergey Petrunya
364222008-04-30
4:19
Server: OptimizerVerified
(578 days)
S36.0.xAnyEXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins Sergey Petrunya
356332008-03-28
9:19
Server: OptimizerVerified
(611 days)
S15.0.54, 5.0.56Linux (2.6.25-rc4)Column cant be NULL error on SELECT...FROM (SELECT not_null_column, agg_func...) Sergey Petrunya
316482007-10-16
21:01
Server: OptimizerVerified
(743 days)
S25.1.22, 5.0.50Anyfull table scans being done when range should be used Sergey Petrunya
262842007-02-12
13:32
Server: OptimizerVerified
(749 days)
S35.0.bkLinux (Linux)bug #26273 / optimize, not executed for index, if datafile is gap-free Sergey Petrunya
307332007-08-30
21:36
Server: OptimizerVerified
(821 days)
S35.1.20, 5.0.45, 4.1 BKLinuxUsing where is shown in EXPLAIN output when there is no condition pushdown. Sergey Petrunya
262322007-02-09
18:28
Server: OptimizerVerified
(1018 days)
S34.1.22, 5.0.34, 5.0.36-BKLinux (Linux)review of bug #20944 / proof of concept attached Sergey Petrunya
Showing all 21 (Edit, Save, CSV, Feed)