Bug #112748 bit type not uodating from UI
Submitted: 17 Oct 2023 11:35 Modified: 20 Oct 2023 11:57
Reporter: Amandeep Singh Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.34 OS:MacOS (unknown)
Assigned to: CPU Architecture:ARM
Tags: WBBugReporter

[17 Oct 2023 11:35] Amandeep Singh 
Description:
When i try to update bit type column to 0 or 1 from UI and execute query. it doesn't  update the value because query should be 

UPDATE `xx_dev`.`category` SET `is_deleted` = b'1' WHERE (`id` = '16');

but instead it shows 

UPDATE `mnemosyne_dev`.`category` SET `is_deleted` = '1' WHERE (`id` = '16');

Please resolve this issue.

How to repeat:
try updating bit type by directing editing from UI

Suggested fix:
introduce b in query for bit type

e.g UPDATE `xx_dev`.`category` SET `is_deleted` = b'0' WHERE (`id` = '16');
[20 Oct 2023 11:57] MySQL Verification Team 
Hello Amandeep,

Thank you for the bug report.
Imho this is duplicate of Bug #79604, please see Bug #79604.

Regards,
Ashwini Patil