Bug #103068 WHERE clause empty on Update

• Submitted: 23 Mar 2021 4:38
• Modified: 20 Jul 2021 19:55
• Reporter: Steven Cinquegrana
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 8.0.23
• OS: Windows (Microsoft Windows 10 Pro)
• CPU Architecture: Other (64)
• Tags: UPDATE, where

[23 Mar 2021 4:38] Steven Cinquegrana

Description:
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. 

Regards,
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?