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 Email Updates:
Status: Closed Impact on me:
None 
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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.