This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Summary: | SQL result column width/alignment inconvenient | ||
---|---|---|---|
Product: | db | Reporter: | nathanielkofalt <nathanielkofalt> |
Component: | Code | Assignee: | Libor Fischmeistr <lfischmeistr> |
Status: | NEW --- | ||
Severity: | blocker | CC: | romanmostyka, wernerm |
Priority: | P4 | ||
Version: | 6.x | ||
Hardware: | All | ||
OS: | Windows Vista | ||
Issue Type: | ENHANCEMENT | Exception Reporter: | |
Attachments: |
Example of integer/double problem
The structure of the example table shown in the previous image |
Description
nathanielkofalt
2009-02-11 06:05:24 UTC
Created attachment 76831 [details]
Example of integer/double problem
Created attachment 76832 [details]
The structure of the example table shown in the previous image
Reassigned to new owner. *** Bug 212965 has been marked as a duplicate of this bug. *** *** Bug 136781 has been marked as a duplicate of this bug. *** (In reply to nathanielkofalt from comment #0) > 1) The column widths are not shrunk to the widest data shown, so the columns > take up a lot of extra space. This is > inconvenient if you have a lot of double columns. Why not shrink the columns > depending on the data shown, with some > wiggle room? Or have a visible option to do so? [WORKS FOR ME] The columns are spaced according to the database metadata - while this is not the best way, I'd consider scanning the current dataset and the info from the metadata to be equivalent. If you'd scale according to the current data you would need to resize on each data page, as there could be different lengths of data on each page. > > 2) Integers are aligned on the left side of their column, doubles on the > right. Attached is Example1.jpg which > illustrates the hard-to-read result from this behavior. [FIXED] Tested with: create table x (column1 int, column2 double, column3 int, column4 double); insert into x VALUES (1, 1.0, 2, 2.0); insert into x VALUES (3, 3.0, 4, 4.0); In netbeans 7.4 all column entries are right aligned => its readable. > 3) Resizing the columns is reset if you run the same or similar query again. Ack. - Though it would narrow the problem down to - resizing the columns is reset when you run the same query again. (Same could be interpreted as "resulting in the same column name order than a previous query). > 4) You cannot double-click a column's width adjustment area to shrink the > column to fit (as you could in, say Excel). > Adding this small functionality would be nice. [FIXED] Checked in netbeans 7.4 -> works |