Bug #80443 Regressoin: Editing of BIT values not working.
Submitted: 19 Feb 2016 12:10 Modified: 19 Feb 2016 22:54
Reporter: Marco Janc Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.6 64-bit OS:Windows (7 64-bit)
Assigned to: CPU Architecture:Any
Tags: bit, Edit, MySQL Workbench

[19 Feb 2016 12:10] Marco Janc
I updated to 6.3.6 64-bit and I cannot edit BIT values in cell anymore since it encloses the bit value with quotes, thinking its a literal.

It more seems like all numeric values are unnecessary enclosed with quotes like strings.

UPDATE `table` 
SET `bitColumn`='1'
WHERE `id`='1';

How to repeat:
Create a table with BIT column. Query data and edit in cell and try to apply changes.

Suggested fix:
Do not enclose numeric fields with quotes in update statement.
[19 Feb 2016 12:13] Marco Janc
Similar to http://bugs.mysql.com/bug.php?id=79604
[19 Feb 2016 12:46] MySQL Verification Team
Hello Marco,

Thank you for the report.
This is duplicate of Bug #79604.

[19 Feb 2016 22:54] Marco Janc
This bug does not just affects bit values. It affects also integer values and other numbers. They are all enclosed in quotes.