Bug #99195 Apply script doesnt handle bit fields properly
Submitted: 7 Apr 2020 1:36 Modified: 6 Jun 2024 21:39
Reporter: Mark Kentwell Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S7 (Test Cases)
Version:8.0.19 OS:Windows (Microsoft Windows 11)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[7 Apr 2020 1:36] Mark Kentwell 
Description:
When updating a bit field, the resultant SQL in the Apply modal doesnt write the SQL properly. The set argument offers the update as x = '1' as opposed to x = b'1'.

When inserting a row (or number), the first bit field is identified properly and the value is setup correctly, however, every single field after that field (in that and subsequent statements) is identified as bit.

How to repeat:
Update a bit field via the grid edit and insert a new record - for both of these have a table where only one of the fields is bit. Once you select the Apply button and review the resultant SQL, you will see this issue.

Suggested fix:
Fix the logic?
[15 May 2020 11:14] Tad Adams 
I am having this issue, also.  I placed bug report #99585.
[15 Sep 2020 22:00] MySQL Verification Team 
Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=99585.
[6 Jun 2024 21:39] Mark Kentwell 
This was reported 4 years ago and still nothing?