Bug #103068 WHERE clause empty on Update
Submitted: 23 Mar 2021 4:38 Modified: 20 Jul 2021 19:55
Reporter: Steven Cinquegrana Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.23 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Other (64)
Tags: UPDATE, where

[23 Mar 2021 4:38] Steven Cinquegrana
When updating a table row, if the update completes and another update is attempted without a refresh, the WHERE clause is empty and therefore fails.

How to repeat:
Update a row, make a subsequent change, click Apply, click Apply, the update fails because the WHERE clause is empty.
[23 Mar 2021 4:39] Steven Cinquegrana
Fixed Windows version.
[24 Mar 2021 10:47] MySQL Verification Team
Hello Steven Cinquegrana,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with workbench 8.0.23 but I am not seeing any issues at my end. 

Ashwini Patil
[24 Mar 2021 15:48] Steven Cinquegrana
Missing WHERE Clause

Attachment: 13-02-2021 11-24-06.png (image/png, text), 3.78 KiB.

[24 Mar 2021 15:49] Steven Cinquegrana
Missing last row until refreshed

Attachment: 24-03-2021 09-45-26.png (image/png, text), 23.95 KiB.

[24 Mar 2021 15:49] Steven Cinquegrana
Added two screen grabs showing missing WHERE and missing final row after Apply but before Refresh.
[20 Jul 2021 19:55] Steven Cinquegrana
This still occurring as of 8.0.26, 100% repeatable. Just 'cos you can't replicate it does not mean it's not happening. Happy to have a screen share to demonstrate.

Also, this was fixed in a previous version, not sure which, and returned in 8.0.23 or possibly prior.
[20 Jul 2021 19:55] Steven Cinquegrana
How can I re-open this bug?