Bug #75424 | EXPLAIN for insert into a view shows wrong table for insertion | ||
---|---|---|---|
Submitted: | 6 Jan 2015 14:23 | Modified: | 7 Apr 2015 13:44 |
Reporter: | Roy Lyseng | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | 5.7 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[6 Jan 2015 14:23]
Roy Lyseng
[7 Apr 2015 13:44]
Paul Dubois
Noted in 5.7.8, 5.8.0 changelogs. EXPLAIN for INSERT ... SELECT statements into a multiple-table view always displayed the first table of the view as the table being inserted into, even if it was not.