| « Show Previous 30 Entries | Showing 31-60 of 99 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 30927 | 2007-09-10 9:24 | 2007-10-10 14:43 | MySQL Server: Optimizer | No Feedback (6035 days) | S1 | 5.0.45 | Windows (Prof) | Any | no key is used when using stored function |
| 31079 | 2007-09-18 13:20 | 2007-10-29 17:55 | MySQL Server: Optimizer | No Feedback (6016 days) | S5 | 5.1.20-beta | Linux (2.6.9-34.ELsmp) | Any | Optimizer slow with multiple joins of same tables |
| 31678 | 2007-10-17 23:51 | 2018-02-11 20:45 | MySQL Server: Optimizer | No Feedback (5636 days) | S1 | 5.0.48 | Any | Any | optimizer makes wrong index choice |
| 32146 | 2007-11-06 14:07 | 2008-01-08 19:39 | MySQL Server: Optimizer | No Feedback (5945 days) | S2 | 5.0.44 Gentoo Linux mysql-5.0.44 | Linux (Linux pavhome 2.6.22-gentoo-r8 #1 SMP Wed Oct 10 21:25:31 NOVST 2007 i686 Intel(R) Core(TM)2 CPU 660) | Any | Optimizer crushes under high load |
| 32272 | 2007-11-12 10:33 | 2008-09-09 6:04 | MySQL Server: Optimizer | No Feedback (5700 days) | S5 | 5.0.42, 5.0.51 | Solaris (Solaris 10 U4 patch 120012-14) | Any | innodb does sequential scan even when index should be used |
| 32527 | 2007-11-20 14:40 | 2012-09-02 20:45 | MySQL Server: Optimizer | No Feedback (5945 days) | S5 | 5.0.42 | Solaris (Solaris 10 U4 patch 120012-14) | Any | when selecting from a view, filesort is needlessly used |
| 33251 | 2007-12-14 19:41 | 2008-10-14 16:18 | MySQL Server: Optimizer | No Feedback (5665 days) | S2 | 5.0.52 5.0.54 5.0.58 5.0.66a | Linux (x86) | Any | MySQL segfault after select in optimizer opt_range.cc -Field_string:type method. |
| 36109 | 2008-04-16 5:12 | 2012-05-18 20:19 | MySQL Server: Optimizer | No Feedback (5396 days) | S3 | 5.0.44, 5.0.51, 5.0.66a, 5.1.26-rc | Any | Any | index on part of varchar field is not used when it could be |
| 36681 | 2008-05-13 8:11 | 2012-05-18 20:19 | MySQL Server: Optimizer | No Feedback (5311 days) | S3 | 5.0.54 | Any | Any | Insufficient plans for huge tables |
| 37166 | 2008-06-03 17:11 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5562 days) | S5 | 5.1.25 | Linux (SLES 10) | Any | Performance regression w/ certain FlightStats queries running on 5.1.25 |
| 40663 | 2008-11-12 12:14 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5606 days) | S1 | 6.0.4 Alpha | Windows (2003 server) | Any | Server crashes with Update with Inner Join |
| 41790 | 2008-12-30 3:35 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5557 days) | S5 | 5.0.51a | Linux | Any | Wrong optimization on large offsets for LIMIT clause |
| 42282 | 2009-01-22 22:23 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5534 days) | S3 | 5.0.67 | Any | Any | Failure to use index for group-by |
| 42596 | 2009-02-04 15:21 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5523 days) | S3 | 5.1.30-community | Linux (CentOS release 5.2 (Final)) | Any | select count(*) |
| 42759 | 2009-02-11 12:35 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5239 days) | S5 | 5.0.51, 5.1.30 | Linux | Any | optimizer choosing different plans/index for the same query |
| 42898 | 2009-02-16 18:25 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5506 days) | S2 | 5.0.67 | Linux (Red Hat ES 4 Update 5) | Any | Slow mysql response time |
| 43067 | 2009-02-20 21:22 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5291 days) | S5 | 6.0.9-alpha-community | Windows | Any | Bug on index query |
| 44391 | 2009-04-21 20:50 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5432 days) | S2 | 5.1.33 | MacOS | Any | SELECT COUNT(*) FROM `backticks` LIMIT 1 on empty table returns 1 |
| 44851 | 2009-05-13 17:14 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5423 days) | S3 | 5.0.72-enterprise-gpl-log | Linux | Any | Subquery column names verified on outer table columns (should return error) |
| 45095 | 2009-05-26 11:18 | 2012-05-18 20:19 | MySQL Server: Optimizer | No Feedback (5254 days) | S3 | 5.1.32, 4.1, 5.0, 5.1, 6.0 bzr | Any | Any | order by not using index |
| 45226 | 2009-05-31 22:42 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5290 days) | S3 | 5.4 | Any | Any | extra rows returned for queries using IN,GROUP BY and HAVING clauses |
| 45228 | 2009-05-31 22:56 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5290 days) | S3 | 5.4 | Any | Any | Queries with WHERE <col_1> AND <condition> GROUP BY <col_2> produce bad results |
| 45886 | 2009-07-01 18:38 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5314 days) | S3 | 5.0.45-log, 5.0.83 | Any | Any | Index |
| 47906 | 2009-10-08 4:56 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5275 days) | S1 | 5.0.85, 5.1.37, 5.1.39, 6.0.9 | Any | Any | Having an extra field in a table changes optimizer index choice for other column |
| 48068 | 2009-10-15 6:49 | 2011-12-17 16:51 | MySQL Server: Optimizer | No Feedback (4506 days) | S5 | MYSQL-5.0.45 | Linux (RHEL 5.2) | Any | "Copying to tmp table" taking too much time to execute |
| 49092 | 2009-11-25 9:37 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5228 days) | S5 | 5.0.26 | Linux | Any | EXISTS clause optimization |
| 49360 | 2009-12-02 17:53 | 2013-02-03 19:22 | MySQL Server: Optimizer | No Feedback (4764 days) | S3 | 5.0.66 , 5.0.84 , 5.0.84 , 5.1.41, 5.1.43 | Any | Any | In some circumstances, GROUP BY WITH ROLLUP is faster then GROUP BY |
| 50707 | 2010-01-29 1:18 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5163 days) | S5 | Ver 5.1.26-rc-5.1.26rc-log for debian-li | Linux (Debian) | Any | InnoDB optimizer does a full table scan for query with IN (...) ORDER BY pk |
| 51097 | 2010-02-11 14:05 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5152 days) | S3 | 5.0.51b | Windows (WinXP sys32) | Any | SELECT INDEX USE |
| 51677 | 2010-03-03 8:32 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5024 days) | S5 | 5.1.34sp1 | Linux (rh5.3) | Any | optimizer choose wrong index when using uncorrect character for client |
| « Show Previous 30 Entries | Showing 31-60 of 99 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
