Bug #103673 SQL Script Generator Fails to add 'b' for a bit column
Submitted: 12 May 2021 23:51 Modified: 24 Jun 2021 21:20
Reporter: Brian Eng Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.24 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[12 May 2021 23:51] Brian Eng 
Description:
Changing a bit(1) column fails because the script generator failed to prepend a 'b' to the content string.

How to repeat:
Create a table with a bit(1) column and add rows
In Navigator, Schemas, right-click on the table, Select Rows
Change or set the bit(1) column in one of the rows to '1', Apply
Expected:
  UPDATE statement will have '<column name>' = b'1'
  'Apply' will succeed
Actual:
  UPDATE statement has '<column name>' = '1'
  'Apply' fails with 1406: Data too long for column
[12 May 2021 23:52] Brian Eng 
Message log

Attachment: Capture.PNG (image/png, text), 34.40 KiB.
[13 May 2021 13:17] MySQL Verification Team 
Hello Brian Eng,

Thank you for the report and feedback.
Imho this is duplicate of Bug #99585, please see Bug #99585.
Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Regards,
Ashwini Patil
[24 Jun 2021 21:20] Brian Eng 
While I agree that this bug is related to Bug #99585 and likely involves the same code that would be patched to fix Bug #99585, I believe keeping this as a separate open bug would have been better
-  The test case to verify this bug is very different.  Verifying a fix for
   Bug #99585 would not verify this bug is fixed.
-  Having more than one test cases in Bug #99585 would be confusing and can
   lead to one of them being forgotten and dropped
-  Fixing Bug #99585 may not automatically fix this bug