Showing 1-30 of 308 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
107840 | 2022-07-11 21:26 | 2022-07-12 11:51 | MySQL Server: Optimizer | Duplicate (626 days) | S3 | Windows (XP SP3) | Any | MySQL 5.6.20 | |
46547 | 2009-08-04 16:15 | 2011-02-16 23:44 | MySQL Server: Optimizer | Duplicate (5350 days) | S3 | Any | Any | Azalea processing simple WHERE / IN subqueries differently than 5.1 | |
60281 | 2011-02-28 14:01 | 2013-01-15 14:37 | MySQL Server: Optimizer | Duplicate (4091 days) | S5 | Any | Any | Performance suggestion: optimize large and simple "LIMIT" queries | |
91091 | 2018-05-31 13:08 | 2019-12-16 9:31 | MySQL Server: Optimizer | Duplicate (1565 days) | S1 | >= 5.7.18, 5.7.22 | Any | Any | Inconsistent SELECT...ORDER BY results with euckr charset / euckr_bin collation |
17841 | 2006-03-01 20:51 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (6540 days) | S3 | 4.0, 4.1, 5.0, 5.1 | Any | HAVING ... BETWEEN does not treat a Quoted DATETIME without delimiters properly | |
51808 | 2010-03-07 12:09 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (5126 days) | S1 | 4.0.24,4.1.25,5.0.90,5.1.44,5.5.2 | Any | Any | update .. order by .. limit 1 scans too many rows instead of single index read |
23485 | 2006-10-20 1:01 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6359 days) | S3 | 4.1 | Any | SELECT NULL IN (SELECT nothing) returns NULL instead of FALSE: unoptimized case | |
18457 | 2006-03-23 14:46 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6535 days) | S3 | 4.1 BK | Linux (Linux Suse 10) | Any | wrong, non-empty recordset returned |
8632 | 2005-02-20 13:11 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6968 days) | S3 | 4.1.10 | Any | SQL_CALC_FOUND_ROWS and DUAL | |
10164 | 2005-04-25 23:20 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6870 days) | S2 | 4.1.11 | Linux (Linux 2.4 debian stable) | Any | Simple GROUP BY with index gives: ERROR 1032 (HY000): Can't find record in '' |
10221 | 2005-04-27 22:17 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6892 days) | S2 | 4.1.11 | Linux (Fedora Core 2, x86_64) | Any | simple join query can crash mysql server |
11594 | 2005-06-27 20:47 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6849 days) | S3 | 4.1.11 | Linux (RedHat Linux ES3) | Any | CONCAT_WS Behavior |
13379 | 2005-09-21 13:42 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6407 days) | S3 | 4.1.11/BK source | Linux (Linux 2.4.21) | Any | Loss of DB connection with certain subselects |
11624 | 2005-06-29 0:26 | 2011-02-16 23:43 | MySQL Server: Optimizer | Duplicate (5218 days) | S2 | 4.1.12 | Windows (Windows Server 2003) | Any | Follow up on Bug #11254 |
11223 | 2005-06-10 2:08 | 2005-06-10 12:21 | MySQL Server: Optimizer | Duplicate (6867 days) | S1 | 4.1.12/4.1.13 BK | Windows (Windows) | Any | Cybozu's mysqld has been crashed at special query |
15146 | 2005-11-22 18:46 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6481 days) | S3 | 4.1.13-nt | Any (All) | Any | Large tables joined on a null key should be faster |
12883 | 2005-08-30 15:18 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6771 days) | S3 | 4.1.14 | FreeBSD (freebsd, Windows) | Any | min/max inconsistent behaviour in amount of retuned rows |
12890 | 2005-08-30 18:17 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (6737 days) | S3 | 4.1.14/5.0 BK | * / freebsd | Any | group_concat with order, not distinct in join |
18789 | 2006-04-05 7:55 | 2006-04-06 7:02 | MySQL Server: Optimizer | Duplicate (6567 days) | S3 | 4.1.18 | Linux (Linux x86_64) | Any | Subselect slower than hand written statement |
21705 | 2006-08-17 22:50 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6413 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 |
60034 | 2011-02-09 6:06 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (4113 days) | S1 | 4.1.25,5.0.92,5.1.56,5.5.10,5.6.2 | Any | Any | valgrind errors then assertion in make_sortkey when grouping by make_set |
8139 | 2005-01-26 7:49 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5626 days) | S3 | 4.1.8 | Linux (Linux) | Any | subselect index not used for "in" but used for "=" |
21184 | 2006-07-20 15:25 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6401 days) | S2 | 5.0 | Any (all) | Any | Bug with a Query with "NOT IN" |
34869 | 2008-02-27 2:00 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5761 days) | S3 | 5.0 | Any | Any | Almost 300% regression in index merge intersect performance |
19843 | 2006-05-16 10:16 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6527 days) | S1 | 5.0, 5.1 | Any | crash in WHERE NOT IN() | |
33402 | 2007-12-20 13:41 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5943 days) | S3 | 5.0, 5.1, 6.0 | Any | Any | ROUND with decimal and non-constant cannot round to 0 decimal places |
47541 | 2009-09-23 8:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (4113 days) | S2 | 5.0, 5.1, next | Any | Any | MIN/MAX does not work when applined on a subquery with two left outer join |
46091 | 2009-07-09 15:14 | 2022-09-04 20:45 | MySQL Server: Optimizer | Duplicate (5043 days) | S3 | 5.0,5.1,5.4 | Any | Any | STRAIGHT_JOIN + RIGHT JOIN returns different result |
48044 | 2009-10-14 15:13 | 2022-09-04 20:45 | MySQL Server: Optimizer | Duplicate (5142 days) | S3 | 5.0,5.1,6.0 | Any | Any | MySQL processing HAVING clauses incorrectly without DISTINCT clause |
16247 | 2006-01-06 9:03 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6416 days) | S3 | 5.0.18 | Linux (Linux, MacOSX) | Any | Compound (cola,colb) IN ((x,y)) statements do not use indexes. |
Showing 1-30 of 308 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |