Bug #83294 UPDATE a BIT(1) field in Workbench GUI
Submitted: 7 Oct 2016 0:04 Modified: 7 Oct 2016 0:35
Reporter: Paolo Groppo Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.3.7 buit 1199 CE 64bits OS:MacOS
Assigned to: CPU Architecture:Any

[7 Oct 2016 0:04] Paolo Groppo
When you change a value of a BIT(1) field directly in application GUI, the UPDATE statement proposed by Workbench to be applied  use quotation marks, that cause UPDATE to fail.

How to repeat:
1) Suppose a field myfield BIT(1)
2) Change value in Workbench GUI
3) Workbench propose: UPDATE mytable SET myfield='0'

Suggested fix:
Workbench must propose the update without quotation marks for BIT(1) fields:

UPDATE mytable SET myfield=0
[7 Oct 2016 0:35] MySQL Verification Team
Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=79604.