Bug #50745 select displays unexpected result
Submitted: 29 Jan 2010 18:11 Modified: 1 Feb 2010 12:30
Reporter: Peter Ripley Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:5.2.14 beta OS:MacOS (10.6.2)
Assigned to: CPU Architecture:Any

[29 Jan 2010 18:11] Peter Ripley 
Description:
I have a table with a column called field_id_238.

Some of the values in this column are "No".

When I do a search in 5.2.14 beta like so:

select field_id_238 from exp_weblog_data where field_id_238 = "No"

The expected number of records are returned, but rather than displaying "No" in the field_id_238 column I see an ellipsis (...).

When issuing the same query under MySQL Query Browser 1.2.12 results are returned as expected.

How to repeat:
Client side:
MacOSX 10.6.2
MySQL Client Version 5.1.8

Server Side:
MySQL 5.0.77-log via TCP/IP

Table details:
Type: MyISAM
Row Format: Dynamic

Column Details:
Type: Text
NN
Not a key
Default Value: Null
Char Set: cp1252 Western European
Collation: latin1_swedish_ci
[29 Jan 2010 18:45] Johannes Taxacher 
Hello Peter,

is this column in question of type TEXT? in that case, its expected behaviour as WBs editor currently doesn't handle column content of BLOB/TEXT types.
[29 Jan 2010 19:25] Peter Ripley 
Yes it is indeed type "TEXT".  Thanks for following up.

I'll look forward to using this tool when it is a little more feature complete then.

Until then it will be the crash-prone Query Browser.

Many thanks.
[1 Feb 2010 12:30] Sergei Tkachenko 
Duplicate of #50692.