| « Show Previous 30 Entries | Showing 31-60 of 308 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 21705 | 2006-08-17 22:50 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6440 days) | S2 | 4.1.21/4.1/5.0/5.1BK | Linux (Linux) | Any | COUNT(DISTINCT field) with GROUP BY forces incorrect behaviour of LIMIT |
| 22395 | 2006-09-15 15:15 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6420 days) | S2 | 5.1.12-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Optimizer: wrong result after AND with different COLLATE clauses |
| 22930 | 2006-10-03 12:41 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6301 days) | S3 | 5.1-bk | Any | Wrong EXPLAIN output for query with subquery | |
| 23322 | 2006-10-16 5:50 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (4255 days) | S2 | 5.0.28-BK, 5.0.27-BK, 5.0.24, 5.1.37-bzr | Linux (Linux) | Any | Optimizer sometimes erroniously prefers other index over index merge |
| 23410 | 2006-10-18 7:47 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6253 days) | S5 | 5.0.26 | Any (*) | Any | "select * from... where .. order by" very slow when 0 rows match the where cond |
| 23485 | 2006-10-20 1:01 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6386 days) | S3 | 4.1 | Any | SELECT NULL IN (SELECT nothing) returns NULL instead of FALSE: unoptimized case | |
| 25548 | 2007-01-11 14:47 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (6306 days) | S2 | 5.0.34-BK, 5.0.27, 5.1 | Linux (Linux, Mac OSX Intel) | Any | Behavior change in INSERT INTO SELECT DISTINCT @var between 5.0.18 and 5.0.27 |
| 27917 | 2007-04-18 7:48 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (3270 days) | S5 | 5.0.40-BK, 5.0.32-Debian_3 | Linux | Any | Spatial (rtree) index not used with "OR" clause. |
| 28378 | 2007-05-11 14:00 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6186 days) | S2 | 5.0.41/5.1 | Linux | Any | query that worked in 5.0.27, doesn't work anymore in 5.0.41 |
| 28801 | 2007-05-31 9:51 | 2007-12-02 20:12 | MySQL Server: Optimizer | Duplicate (5989 days) | S2 | 5.1.20 | Windows | Any | vs debug warnings: stack around variable 'buf' was corrupted |
| 29297 | 2007-06-22 9:06 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6148 days) | S3 | 5.0.37, 5.0 BK, 5.1 BK | Any | Any | Wrong result with aggregation and a subquery |
| 30584 | 2007-08-23 3:31 | 2022-09-04 20:45 | MySQL Server: Optimizer | Duplicate (5572 days) | S5 | 5.0.37,5.1.22 | Any | Any | delete with order by and limit clauses does not use limit efficiently |
| 31141 | 2007-09-22 9:46 | 2007-09-22 16:47 | MySQL Server: Optimizer | Duplicate (6060 days) | S1 | 5.1.21/5.0 | Windows (Linux) | Any | Sorting DESC no longer working. |
| 32787 | 2007-11-27 19:22 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5988 days) | S1 | 6.0 | Any | Any | on-disk filesorts return empty datasets in case of 'ref' scans |
| 33402 | 2007-12-20 13:41 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5970 days) | S3 | 5.0, 5.1, 6.0 | Any | Any | ROUND with decimal and non-constant cannot round to 0 decimal places |
| 33659 | 2008-01-03 16:53 | 2020-11-22 20:45 | MySQL Server: Optimizer | Duplicate (5931 days) | S3 | 6.0.5-alpha-debug | Linux (SUSE 10 64-bit) | Any | Partitions: Falcon table, indexed varchar column, wrong result |
| 34590 | 2008-02-15 11:51 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (5209 days) | S3 | 6.0.4 | Any | Any | Innodb crash in build_template() on multi-table delete |
| 34591 | 2008-02-15 11:56 | 2016-10-09 20:45 | MySQL Server: Optimizer | Duplicate (5209 days) | S1 | 6.0.4 | Any | Any | Innob crash in row_sel_store_mysql_rec() on multi-table delete |
| 34869 | 2008-02-27 2:00 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5788 days) | S3 | 5.0 | Any | Any | Almost 300% regression in index merge intersect performance |
| 35032 | 2008-03-04 11:44 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5836 days) | S3 | 6.0.4 | Any | Any | Wrong execution plan for uncorrelated subquery when semijoin is applicable |
| 35061 | 2008-03-05 2:25 | 2008-03-06 6:43 | MySQL Server: Optimizer | Duplicate (5894 days) | S3 | 5.0.50a | Linux | Any | order by returns unsorted results with limit and force index |
| 35080 | 2008-03-05 13:00 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (5172 days) | S3 | 6.0-falcon-team,6.0 | Any | Any | Innodb crash at mem_block_get_len line 72 |
| 35136 | 2008-03-07 8:34 | 2008-07-21 11:36 | MySQL Server: Optimizer | Duplicate (5757 days) | S3 | 5.0.54 | Any | Any | Obviously slower plan is choosed at searching uses LIKE '%xxx%' clause |
| 35311 | 2008-03-15 17:19 | 2022-09-04 20:45 | MySQL Server: Optimizer | Duplicate (5567 days) | S3 | 5.0.38+ | Any | Any | ROW(...) IN (SELECT outer field,... FROM DUAL)" always returns TRUE |
| 35458 | 2008-03-20 12:36 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5808 days) | S3 | 6.0.4 | Any | Any | Wrong execution strategy for uncorrelated subquery |
| 35803 | 2008-04-03 14:36 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5830 days) | S1 | 6.0 | Any | Any | subselect_notembedded crashes the server |
| 35819 | 2008-04-04 2:32 | 2022-09-04 20:45 | MySQL Server: Optimizer | Duplicate (5300 days) | S3 | 5.0.54, 5.0.56 | Any | Any | Multi column IN does not use index |
| 36015 | 2008-04-12 14:07 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5853 days) | S1 | 5.0.54, 5.0.58 | Linux (Gentoo, Windows) | Any | Crash on simple select |
| 36024 | 2008-04-13 13:29 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5853 days) | S1 | 5.0.58, 5.1.24 | Any | Any | group_concat distinct in subquery crash |
| 36130 | 2008-04-16 11:21 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5845 days) | S1 | 6.0.4-nt, 6.0.5-bk | Any | Any | crash with subquery and explain in 6.0 |
| « Show Previous 30 Entries | Showing 31-60 of 308 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
