Bug #48982 TEXT columns shown as boolean

• Submitted: 23 Nov 2009 10:39
• Modified: 25 Nov 2009 11:58
• Reporter: Ángel Eduardo García Hernández
• Status: Closed
• Category: MySQL Workbench
• Severity: S1 (Critical)
• Version: 5.2.8 Beta
• OS: MacOS
• Assigned to: Sergei Tkachenko
• CPU Architecture: Any

[23 Nov 2009 10:39] Ángel Eduardo García Hernández

Description:
Any TEXT column I have in my databases is shown either as a 0 or a 1

How to repeat:
1. Connect to any server
2. Either do a SELECT * FROM <table>.<database> or double-click on the schemata window in any table with TEXT columns.

In your TEXT columns, you'll see a 0 or a 1

[24 Nov 2009 16:40] Johannes Taxacher

fix confirmed. will be included in 5.2.9

[25 Nov 2009 11:58] Tony Bedford

An entry was added to the 5.2.9 changelog:

Any TEXT columns in the Table Editor, or TEXT columns in the SQL Editor results tabsheet, were displayed as BOOLEAN values, either 1 or 0.

[27 Nov 2009 10:43] Richard Joseph

Sorry, I realise this thread is closed, but I'd just like to add that this exact same issue (TEXT-type columns showing 0/1) is also an issue in version 5.2.8 Beta on Ubuntu 9.10 (x86). 

I'd LIKE to think that that this is also fixed for Ubuntu/Linux, due to code sharing etc., but obviously, it is better to draw your attention to the problem, just in case ;-D .

Cheers

Rich

[27 Nov 2009 10:47] Johannes Taxacher

thx for the info richard, but your guess was right. this is fixed x-platform in 5.2.9

[2 Dec 2009 11:48] Johannes Taxacher

Bug #49328 has been marked as duplicate of this one