Bug #94644 Issue inserting row with bit field
Submitted: 13 Mar 2019 21:32 Modified: 13 Mar 2019 22:15
Reporter: Dwain Bethel Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.15 OS:MacOS
Assigned to: CPU Architecture:Any

[13 Mar 2019 21:32] Dwain Bethel 
Description:
When you have a table with a bit column and attempt to insert a new row from the query table, it adds a `b` to all subsequent values.

How to repeat:
Create a table with a bit field:
CREATE TABLE `test`.`test` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `col1` VARCHAR(45) NULL,
  `col2` BIT(1) NULL,
  `col3` VARCHAR(45) NULL,
  PRIMARY KEY (`id`));

Select all to see the rows.
Within the result grid, add a new row by clicking into the col1, col2, col3 fields and adding values.
Click the Apply button.
This pops the Review dialog with the following SQL:
INSERT INTO `test`.`test` (`col1`, `col2`, `col3`) VALUES ('1', b'1', b'1');
INSERT INTO `test`.`test` (`col1`, `col2`, `col3`) VALUES (b'2', b'0', b'2');
When it should be:
INSERT INTO `test`.`test` (`col1`, `col2`, `col3`) VALUES ('1', b'1', '1');
INSERT INTO `test`.`test` (`col1`, `col2`, `col3`) VALUES ('2', b'0', '2');
[13 Mar 2019 22:06] MySQL Verification Team 
Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=93060.
[13 Mar 2019 22:13] Dwain Bethel 
Sorry about submitting the duplicate bug, I searched for one but somehow missed this one.  Thank you,

Dwain
[13 Mar 2019 22:15] Dwain Bethel 
Forgot to provide the version and OS