Bug #114835 Input value in bit column from result grid make generated request bad

• Submitted: 1 May 10:31
• Modified: 1 May 14:21
• Reporter: Sébastien F.
• Status: Verified
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 8.0.36
• OS: Windows
• CPU Architecture: Any

[1 May 10:31] Sébastien F.

Description:
When I input values in boolean column from result grid, the generated request is bad. The columns following the boolean column are prefixed binary.

How to repeat:
SQL editor :

create table test (
    id int auto_increment primary key,
    c1 int,
    c2 bit(1),
    c3 int
);

select all * from test; -- For manual input

Result grid input :

c1 = 123
c2 = 1
c3 = 234

Generated request when I apply :

INSERT INTO `xsor`.`test` (`c1`, `c2`, `c3`) VALUES ('123', b'1', b'234'); -- b'234'

Awaited request :

INSERT INTO `xsor`.`test` (`c1`, `c2`, `c3`) VALUES ('123', b'1', '234'); -- No b'234'

[1 May 14:21] MySQL Verification Team

Hello Sébastien F.,

Thank you for the report and test case.
Verified as described.

regards,
Umesh