Bug #25179 display column width is too high

• Submitted: 19 Dec 2006 14:56
• Modified: 9 Sep 2007 1:45
• Reporter: Hans Ginzel
• Status: Won't fix
• Category: MySQL Query Browser
• Severity: S4 (Feature request)
• Version: 1.2.8, 1.2.12
• OS: Windows (Windows XP)
• CPU Architecture: Any
• Tags: column width

[19 Dec 2006 14:56] Hans Ginzel

Description:
Consider [var]char(64) column c which consist only max(length(c))=10 strings.

Column width will be too high for such column in query browser. If there is more such columns, screen is used unefficiently.

How to repeat:
select * from mysql.db limit 30;

select * from table_with_[var]char_columns limit 30;

Suggested fix:
1. column width should be modified after a query run by the *real* max lenght of column in result set.

2. It should be possible to mark all/some columns and ask to adjust optimal width of selected columns by doubleclicking on a column border (as in MS Excel).

[19 Dec 2006 15:00] Hans Ginzel

3. Manualy adjusted column width should be preserved for query refreshing (runnig same query again).

[9 Sep 2007 1:45] Valeriy Kravchuk

Thank you for a reasonable feature request.

[2 Oct 2007 13:40] media forest

3. Manualy adjusted column width should be preserved for query refreshing (runnig same
query again).

+ 1

[13 Mar 2014 13:35] Omer Barnir

This bug is not scheduled to be fixed at this time.