Bug #67637 | EXPLAIN UPDATE output doesn't match query execution | ||
---|---|---|---|
Submitted: | 19 Nov 2012 16:44 | Modified: | 22 Jan 2013 13:50 |
Reporter: | Sergey Petrunya | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | 5.6.7, 5.6.8 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[19 Nov 2012 16:44]
Sergey Petrunya
[19 Nov 2012 16:53]
Sergey Petrunya
Correction: the table has not 10K rows, but 100k. Everything else holds.
[22 Jan 2013 13:50]
Paul DuBois
Noted in 5.6.10, 5.7.1 changelogs. For single-table DELETE or UPDATE statements, EXPLAIN displayed a type value of ALL (full-table scan access method) even if the optimizer chose to scan the table by an index access method. Now the type value is displayed as index.