| « Show Previous 30 Entries | Showing 31-55 of 55 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 68299 | 2013-02-07 5:40 | 2013-05-30 2:07 | MySQL Server: Optimizer | Closed (3978 days) | S3 | 5.6 | Any | Any | unexcepted "Using where" in "explain update/delete" |
| 86574 | 2017-06-03 16:16 | 2017-06-03 19:36 | MySQL Server: Optimizer | Verified (2513 days) | S3 | 5.6 | Any | Any | Confusing EXPLAIN output for INSERT Queries |
| 78213 | 2015-08-25 20:03 | 2015-10-23 12:55 | MySQL Server: Optimizer | Closed (3118 days) | S2 | 5.6, 5.6.26, 5.5.46, 5.1.77 | Any (Mac OS X 10.9 and CentOS 6) | Any | Spatial index causes incorrect cardinality for all non-primary indexes |
| 73305 | 2014-07-17 7:27 | 2017-05-15 12:39 | MySQL Server: Documentation | Closed (2532 days) | S2 | 5.6, 5.7 | Any | Any | Manual does not explain all cases when SHOW VIEW privilege is needed |
| 69795 | 2013-07-19 17:54 | 2016-06-16 20:32 | MySQL Server: Optimizer | Verified (2865 days) | S3 | 5.6.12 | Any | Any | EXPLAIN FORMAT=JSON doesn't show Using filesort for UNIONs |
| 70014 | 2013-08-13 13:34 | 2013-11-19 16:31 | MySQL Server: Optimizer | Closed (3805 days) | S2 | 5.6.12-debug, 5.6.13-debug , 5.7.2-m12-enterprise-commercial-advanced-debug | Linux (Fedora 18) | Any | MySQL crashes on explain with JSON formatting (debug builds) |
| 71981 | 2014-03-08 20:24 | 2014-03-13 11:15 | MySQL Server: DML | Verified (3691 days) | S3 | 5.6.16 | Any | Any | Strange result on explain |
| 72031 | 2014-03-13 8:22 | 2014-03-13 11:14 | MySQL Server: Optimizer | Verified (3691 days) | S3 | 5.6.16 | Any | Any | Strange explain behaviour |
| 78412 | 2015-09-11 16:17 | 2017-01-13 9:03 | MySQL Server: Documentation | Closed (3053 days) | S2 | 5.6.24 | Any | Any | UPDATE with subquery is NOT optimized the same way as equivalent SELECT |
| 78943 | 2015-10-23 13:52 | 2015-10-26 7:19 | MySQL Server: Optimizer | Not a Bug (3099 days) | S3 | 5.6.24-72.2-log, 5.6.27 | Ubuntu (14.04) | Any | EXPLAIN FORMAT="JSON" ignores FORCE INDEX for some output parts |
| 83062 | 2016-09-20 13:18 | 2018-04-24 20:15 | MySQL Server: Optimizer | Verified (2768 days) | S3 | 5.6.32, 5.7.14, 5.6.33, 5.7.15 | Any | Any | it's no longer possible to determine used key parts by looking at key_length |
| 67230 | 2012-10-15 8:59 | 2013-02-06 8:54 | MySQL Server: Optimizer | Closed (4177 days) | S1 | 5.6.7 5.6.8 | Windows (7 64bit) | Any | EXPLAIN can crash server or deny service on SELECT statement |
| 68255 | 2013-02-02 20:22 | 2013-02-06 1:55 | MySQL Server: Optimizer | Not a Bug (4091 days) | S3 | 5.6.9-rc | Windows (Vista 32 bit) | Any | Query uses temporary table, but "explain" does not mention temporary table |
| 79717 | 2015-12-21 2:47 | 2016-02-26 0:13 | MySQL Server: Documentation | Closed (2976 days) | S3 | 5.7 | Any | Any | Document Bug about "EXPLAIN Output Format" |
| 83398 | 2016-10-16 11:09 | 2017-02-17 18:00 | MySQL Server: Documentation | Closed (2619 days) | S3 | 5.7.15 | Any | Any | Slow and unexpected explain output on FTS |
| 88817 | 2017-12-07 14:26 | 2018-01-19 11:17 | MySQL Server | Not a Bug (2283 days) | S3 | 5.7.17 | Linux (AWS RDS) | Any | Field or reference of SELECT #2 was resolved in SELECT #1 |
| 71973 | 2014-03-07 13:28 | 2014-05-14 23:41 | MySQL Workbench: SQL Editor | Closed (3629 days) | S3 | 6.1.2.11661 | Any | Any | Visual explain fails on large explain plan |
| 71980 | 2014-03-08 19:44 | 2014-05-14 1:34 | MySQL Workbench: SQL Editor | Closed (3629 days) | S3 | 6.1.2.11661 | Any | Any | canvas too small for visual explain in export |
| 89047 | 2017-12-23 20:01 | 2023-02-02 20:53 | MySQL Workbench: SQL Editor | Verified (2151 days) | S3 | 6.3.10 and 8.0.11RC | MacOS (macOS 10.13.x High Sierra x86_64) | Any | Visual explain tooltip cropped |
| 86897 | 2017-07-02 13:15 | 2017-07-02 18:26 | MySQL Workbench: SQL Editor | Duplicate (2484 days) | S3 | 6.3.6 | Windows (Microsoft Windows 10 Home) | Any | invalid literal for int() with base 10 |
| 110117 | 2023-02-17 13:22 | 2023-02-17 15:32 | MySQL Server: Documentation | Verified (428 days) | S3 | 8.0 | Any | Any | Lack of instrumentation for index condition impact on the query plan |
| 111564 | 2023-06-26 12:33 | 2023-08-10 12:21 | MySQL Server: Optimizer | Closed (254 days) | S3 | 8.0 | Any | Any | Contribution by Tencent: explain format=tree lost the subquery in the hash join |
| 111580 | 2023-06-27 11:01 | 2023-06-28 13:40 | MySQL Server: Security: Privileges | Not a Bug (297 days) | S3 | 8.0, 8.0.31 | Any | Any | view CREATE with SQL SECURITY DEFINER can SELECT but cannot EXPLAIN |
| 99707 | 2020-05-27 12:33 | 2020-06-01 12:29 | MySQL Server: Documentation | Closed (1419 days) | S3 | 8.0.20, 5.7.30 | Any | Any | EXPLAIN requires more than SELECT |
| 106838 | 2022-03-25 11:30 | 2022-03-25 12:03 | MySQL Workbench | Verified (757 days) | S3 | 8.0.28 | MacOS (11.1) | Any | hover tooltip is cut when using query explain tab |
| « Show Previous 30 Entries | Showing 31-55 of 55 (Edit, Save, CSV, Feed) |
