Bug #81525 Update Bit Value (Boolean)
Submitted: 20 May 2016 17:03 Modified: 20 May 2016 22:46
Reporter: Vittorio Zapponi Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.3 OS:MacOS
Assigned to: CPU Architecture:Any
Tags: update fields bit type

[20 May 2016 17:03] Vittorio Zapponi 
Description:
when I try to modify a value of type bit (boolean) with this sql auto generated:
UPDATE `utenti`.`web_users` SET `LOCKED`='1' WHERE `ID`='16';

This is the result
Operation failed: There was an error while applying the SQL script to the database.
Executing:
UPDATE `utenti`.`web_users` SET `LOCKED`='1' WHERE `ID`='16';

ERROR 1406: 1406: Data too long for column 'LOCKED' at row 1
SQL Statement:
UPDATE `utenti`.`web_users` SET `LOCKED`='1' WHERE `ID`='16'

If I take off the ' from 1 value all it's ok

How to repeat:
Always
[20 May 2016 22:46] MySQL Verification Team 
Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=79604.