Bug #29831 Bit columns display "b" regardless of value
Submitted: 16 Jul 2007 18:14 Modified: 26 May 2009 13:09
Reporter: Adrian Price Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.12 OS:MacOS (10.4.9)
Assigned to: CPU Architecture:Any

[16 Jul 2007 18:14] Adrian Price 
Description:
Using MySQL Query Browser 1.2.12 on MacOS 10.4.9 connecting to MySQL Community Server 5.0.37. When issuing any query that returns BIT columns, the column(s) display "b" regardless of actual value. Workaround is possible by selecting column+0, which will return 0 for false and 1 for true.

How to repeat:
CREATE TABLE `test` (`testcol` BIT);
INSERT INTO `test` (`testcol`) VALUES (true), (false);
SELECT * FROM `test`

The last line, obviously, must be run in the query browser.

Suggested fix:
Display 1|0, true|false, or some other appropriate indication of value.
[17 Jul 2007 8:30] Sveta Smirnova 
Thank you for the report.

Verified as described.
[26 May 2009 13:09] Susanne Ebrecht 
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/