Bug #106644 Autogenerated INSERT query in MySQL Workbench has syntax error
Submitted: 4 Mar 2022 19:09 Modified: 5 Mar 2022 7:24
Reporter: Gretchen Raff Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.28 OS:Windows (10)
Assigned to: CPU Architecture:Any

[4 Mar 2022 19:09] Gretchen Raff 
Description:
I am entering a new record in a table in MySQL Workbench. I enter the values and click Apply. Here is the error:

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'b'Dena_Kos', b'1', b'1', b'1', b'0')' at line 1

In between 2 bit(1) fields is a Varchar(45). The syntax that it generates is correct for the bit fields, but the Varchar field value has a b before the first single quote which generates a syntax error. Deleting the rogue b fixes the syntax.

How to repeat:
Create a table that has a bit(1) field, then a Varchar(45) field, then another bit(1) field. Try entering data in a record in the table in MySQL Workbench and clicking apply so that it autogenerates the INSERT query.
[5 Mar 2022 7:24] MySQL Verification Team 
Hello  	Gretchen Raff,

Thank you for the report and feedback.
IMHO this is duplicate of Bug #95746, please see Bug #95746

regards,
Umesh