Bug #35205 Impossible to insert booleans
Submitted: 11 Mar 2008 10:34 Modified: 15 Mar 2008 12:52
Reporter: moi meme Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.14b OS:Any
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: BOOL, boolean, insert

[11 Mar 2008 10:34] moi meme
It seems impossible to insert boolean values into a table:
when you type "TRUE" in the editor, it's automaticly replaced by "'TRUE'" with quotes, which is not a valid boolean value.

How to repeat:
CREATE a table with a boolean attribute
go to insert menu and add a row with the boolean
quotes will automaticly add :(

Suggested fix:
in the insert editor, verify the type entered, and make specific treatment.
[11 Mar 2008 10:52] MySQL Verification Team
Thank you for the bug report.
[14 Mar 2008 15:13] Johannes Taxacher
fixed in svn rev 2750
[15 Mar 2008 12:52] MC Brown
A note has been added to the 5.15 changelog: 

Boolean values were unsupported when trying to insert values into a table, the TRUE would instead be replaced by a textual, quoted version 'TRUE'.