Bug #80655 | Error message from UPDATE of non-updatable part of join view is inaccurate | ||
---|---|---|---|
Submitted: | 8 Mar 2016 9:10 | Modified: | 30 Jun 2020 0:19 |
Reporter: | Roy Lyseng | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | 5.6.31 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[8 Mar 2016 9:10]
Roy Lyseng
[8 Mar 2016 9:45]
MySQL Verification Team
Hello Roy, Thank you for the report and test case. Thanks, Umesh
[30 Jun 2020 0:19]
Jon Stephens
Documented fix as follows in the MySQL 8.0.22 changelog: For a view based on a join having an updatable part and one that was not, the error message generated when attempting to update a column that was not updatable referenced the source table or view instead of the view actually named in the offending UPDATE statement. Fixed as part of work done for WL#9384. Closed.