Bug #92254 | select for update produces error 1143 (42000) since mysql 8 | ||
---|---|---|---|
Submitted: | 31 Aug 2018 7:56 | Modified: | 3 Oct 2018 2:02 |
Reporter: | Hans Desmet | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Security: Privileges | Severity: | S2 (Serious) |
Version: | 8.0.12 | OS: | Windows |
Assigned to: | CPU Architecture: | x86 (64 bit) | |
Tags: | regression |
[31 Aug 2018 7:56]
Hans Desmet
[31 Aug 2018 9:29]
MySQL Verification Team
Hello Hans Desmet, Thank you for the report! Verified as described with 8.0.12 build. regards, Umesh
[3 Oct 2018 2:02]
Paul DuBois
Posted by developer: Fixed in 8.0.14. Incorrect privilege checking could produce an error for SELECT ... FOR UPDATE statements that executed successfully in MySQL 5.7.