| Showing 1-30 of 465 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 44549 | 2009-04-29 17:47 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0.80, 5.1.34 | Any | Any | optimizer incorrectly chooses table scan and filesort over index |
| 45680 | 2009-06-23 14:15 | 2020-04-01 13:16 | MySQL Server: Optimizer | Verified | S3 | 5.0.54, 5.0.82, 5.1.35, 6.0.12 | Any | Any | wrong results when using index for lookup with implicitly casted values |
| 45880 | 2009-07-01 14:21 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0, 5.1 | Any | Any | OUTER JOINed tables with no condition in WHERE must be at the end of explain |
| 46056 | 2009-07-08 20:24 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0,5.1,5.4 | Any | Any | Duplicate rows returned on MAX + ORDER BY |
| 46217 | 2009-07-16 11:16 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0,5.1,5.4 | Any | Any | Wrong result on aggregate + JOIN + ORDER BY + LIMIT |
| 46277 | 2009-07-17 21:33 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0, 5.1, 5.4, 6.0 | Any | Any | differing results for equivalent queries using VAR_POP() & AVG() with DISTINCT |
| 46283 | 2009-07-18 15:22 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0, 5.1, 5.4, 6.0 | Any | Any | COUNT() returning bad values when LIMIT 1 clause added to query |
| 46517 | 2009-08-02 21:54 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.4,5.6.99 | Any | Any | Queries with constant / null only WHERE clause interpreted differently in azalea |
| 48049 | 2009-10-14 16:46 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.1.37, 5.5.7 | Any | Any | SELECT MIN(1) reports differently for MERGE tables in 5.0 and 5.1 |
| 48103 | 2009-10-16 0:32 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.1, 6.0 | Any | Any | Using STRAIGHT_JOIN with Innodb tables can produce duplicate results |
| 48190 | 2009-10-20 14:59 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.1,6.0 | Any | Any | Error processing ALL subqueries on empty sets - different than JavaDB/Postgres |
| 49590 | 2009-12-10 16:03 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0+ | Any | Any | Server reporting different result sets for a query depending on use of indexes |
| 50388 | 2010-01-16 4:13 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S5 | 5.1.41,5.1.42, 5.1.43-bzr | Any | Any | partition pruning not working with some right joins |
| 54179 | 2010-06-02 11:37 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.1.37 , 5.1.47 , 5.5.4 | Any | Any | Index is not used for range scan on SET field |
| 60023 | 2011-02-08 21:45 | 2014-05-22 12:13 | MySQL Server: Optimizer | Verified | S5 | 5.5.8 , 5.1.51 | Any | Any | No Loose Index Scan for GROUP BY / DISTINCT on InnoDB partitioned table |
| 69350 | 2013-05-30 5:44 | 2014-02-20 5:48 | MySQL Server: Optimizer | Verified | S5 | 5.6 | Any | Any | performance regression between 5.5 and 5.6 for simple statement in routine loop |
| 69891 | 2013-08-01 6:33 | 2014-09-18 21:25 | MySQL Server: Optimizer | Verified | S3 | 5.1.31 | Any | Any | since 5.1.31 REPLACE() function concats it's results under certain conditions |
| 72501 | 2014-05-01 17:31 | 2014-05-01 18:12 | MySQL Server: Optimizer | Verified | S3 | 5.6.17 | Any | Any | joining NULLs + different collation is not efficient |
| 80206 | 2016-01-30 6:13 | 2016-01-30 6:13 | MySQL Server: Optimizer | Verified | S3 | 5.7.10 | Any | Any | EQ_REF extension should be skipped for the last joined table |
| 95543 | 2019-05-27 12:37 | 2019-05-29 12:34 | MySQL Server: Optimizer | Verified | S2 | 5.7.26 | Any | Any | optimizer prefers index for order by rather than filtering - (70x slower) |
| 102686 | 2021-02-22 12:50 | 2021-02-24 16:01 | MySQL Server: Optimizer | Verified (9 days) | S5 | 8.0 | Any | Any | The query plan changed cause query too long |
| 102681 | 2021-02-22 5:29 | 2021-02-22 6:05 | MySQL Server: Optimizer | Verified (11 days) | S3 | 8.0,5.7.33, 8.0.23 | Any | Any | result of "datetime_val not between NULL and NULL" is unexpected |
| 102656 | 2021-02-19 3:52 | 2021-02-19 6:59 | MySQL Server: Optimizer | Verified (14 days) | S3 | 8.0.22, 8.0.23 | Any | Any | SELECT results containing the special character " ︠e " is different |
| 102655 | 2021-02-19 3:07 | 2021-02-19 6:34 | MySQL Server: Optimizer | Verified (14 days) | S3 | 8.0, 8.0.23 | Any | Any | results from SELECT are different when use WHERE or not |
| 102634 | 2021-02-18 3:26 | 2021-02-18 7:36 | MySQL Server: Optimizer | Verified (15 days) | S3 | 8.0.17+ | Any | Any | Optimizer loses part of range when OR multiple identical ranges in range plan |
| 102481 | 2021-02-04 15:37 | 2021-02-05 14:40 | MySQL Server: Optimizer | Verified (28 days) | S3 | 8.0.23 | Any | Any | EXPLAIN FOR CONNECTION not good |
| 102468 | 2021-02-03 10:06 | 2021-02-03 10:21 | MySQL Server: Optimizer | Verified (30 days) | S3 | 8.0.22, 8.0.23 | Any | Any | Temptable storage engine returns error: doesn't support update of indexes |
| 102444 | 2021-02-02 1:10 | 2021-02-02 5:20 | MySQL Server: Optimizer | Verified (31 days) | S2 | 5.7.22 - 5.7.32; 8.0.12, 5.7.33 | Any | x86 | Dependent subquery with ORDER BY return NULL value |
| 102429 | 2021-01-30 8:52 | 2021-01-31 3:00 | MySQL Server: Optimizer | Verified (34 days) | S2 | 8.0.23 | Any | Any | Table #sql13c8_4a4_d' uses an extension that doesn't exist in this MySQL version |
| 102359 | 2021-01-24 8:57 | 2021-01-27 18:48 | MySQL Server: Optimizer | Verified (37 days) | S2 | 8.0.23 | Any | Any | Functional Index ignored by Select query from within a Stored Function |
| Showing 1-30 of 465 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
