Bug #114835 Input value in bit column from result grid make generated request bad
Submitted: 1 May 2024 10:31 Modified: 1 May 2024 14:21
Reporter: Sébastien F. Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.36 OS:Windows
Assigned to: CPU Architecture:Any

[1 May 2024 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 2024 14:21] MySQL Verification Team 
Hello Sébastien F.,

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

regards,
Umesh