MySQL Bugs: #61966: Cannot enter bit notation in table inserts

Bug #61966	Cannot enter bit notation in table inserts
Submitted:	25 Jul 2011 10:25	Modified:	14 Jan 2014 17:20
Reporter:	Chris Buckley	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.34	OS:	Linux (Debian squeeze)
Assigned to:		CPU Architecture:	Any

Description:
When in the table editor, on the "inserts" tab, it is not possible to enter b'1' or 0b1 notation for value in a BIT field. (Non-binary notation works as expected.)

How to repeat:
* On a new EER diagram, create a new table with a field of type BIT.
* Switch to "inserts" tab.
* Add a new row with the field set to b'1'.
* Click "Apply changes to data".
* Click to close the editor tab.

Dialogue is shown:

There are unsaved changes in the INSERTS editor
Please Apply or Revert these changes before closing.

Thank you for the bug report.

Evidence

Attachment: bitProblem.JPG (image/jpeg, text), 154.23 KiB.

Posted by developer:
 
Verified in:
Windows 7x64
Ubuntu 13.10x86
WB 6.0.9.11410
A BIT value can be entered and saved without problems in the "Inputs" tab.

Fixed as of the old MySQL Workbench 5.2.47 release, and here is the changelog entry:

In the inputs tab of the table editor, it was not possible enter values
using binary notation, such as b'1' or 0b1, for a value in a BIT field.

Thank you for the bug report.