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.

Bug 143802 - Need a way to easily view large text column data
Summary: Need a way to easily view large text column data
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: _ ahimanikya
URL:
Keywords: RANDOM
: 142942 (view as bug list)
Depends on:
Blocks:
 
Reported: 2008-08-13 19:00 UTC by David Vancouvering
Modified: 2008-09-19 17:35 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
Results of SHOW CREATE PROCEDURE (60.35 KB, image/jpeg)
2008-09-03 17:32 UTC, David Vancouvering
Details

Note You need to log in before you can comment on or make changes to this bug.
Description David Vancouvering 2008-08-13 19:00:26 UTC
If a column contains a lot of text - say a memo or a blog or stored procedure text - it's pretty much impossible to
resize the column big enough to see all the text.  The only way to see it all is through tooltip, which comes up and
then disappears quickly.

Also, if the column is read-only, there is no way to copy-and-paste the contents into a separate text file.
Comment 1 David Vancouvering 2008-08-13 19:03:02 UTC
Actually, the more I think about it, the more crucial it is to fix this.  Otherwise commands like SHOW CREATE PROCEDURE
and SHOW TRIGGERS are useless as you can't see the SQL text associated with it.
Comment 2 _ ahimanikya 2008-08-19 13:20:17 UTC
*** Issue 142942 has been marked as a duplicate of this issue. ***
Comment 3 _ ahimanikya 2008-08-29 06:37:56 UTC
I think this is very important to have a way to see larger text, and I don't think its difficult to implement it. 
Comment 4 _ ahimanikya 2008-08-29 21:21:37 UTC
http://hg.netbeans.org/main/rev/fe3d085208c1
Comment 5 Quality Engineering 2008-08-30 05:41:32 UTC
Integrated into 'main-golden', available in build *200808300201* on http://bits.netbeans.org/dev/nightly/
Changeset: http://hg.netbeans.org/main/rev/fe3d085208c1
User: ahimanikya@netbeans.org
Log: #143802  Need a way to easily view large text column data
Comment 6 David Vancouvering 2008-09-03 17:29:44 UTC
Hi, Ahi.  It doesn't look like this is fixed.  I'll attach a screen shot...  Notice that I also still get the 1s and 0s,
so even though it works for you it doesn't work for me.  I wonder what the difference is...
Comment 7 David Vancouvering 2008-09-03 17:31:33 UTC
Doesn't work for me on this platform:

Product Version: NetBeans IDE Dev (Build 080902)
Java: 1.5.0_13; Java HotSpot(TM) Client VM 1.5.0_13-119
System: Mac OS X version 10.5.4 running on i386; MacRoman; en_US (nb)
Comment 8 David Vancouvering 2008-09-03 17:32:55 UTC
Created attachment 68975 [details]
Results of SHOW CREATE PROCEDURE
Comment 9 David Vancouvering 2008-09-03 17:36:20 UTC
I discovered you can copy/paste the entire row, but you can't do one field at a time.  And the 0011 stuff is still an
issue. 

Here's the copy/paste of the row:

film_in_stock
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER
CREATE00100000DEFINER=`root`@`localhost`00100000PROCEDURE00100000`film_in_stock`(IN00100000p_film_id00100000INT,00100000IN00100000p_store_id00100000INT,00100000OUT00100000p_film_count00100000INT)0000101000100000001000000010000000100000READS00100000SQL00100000DATA00001010BEGIN000010100010000000100000001000000010000000100000SELECT00100000inventory_id000010100010000000100000001000000010000000100000FROM00100000inventory000010100010000000100000001000000010000000100000WHERE00100000film_id00100000=00100000p_film_id000010100010000000100000001000000010000000100000AND00100000store_id00100000=00100000p_store_id000010100010000000100000001000000010000000100000AND00100000inventory_in_stock(inventory_id);00001010000010100010000000100000001000000010000000100000SELECT00100000FOUND_ROWS()00100000INTO00100000p_film_count;00001010END
Comment 10 _ ahimanikya 2008-09-04 10:24:15 UTC
I am using exactly same platform as yours, but I don't see any 0s and 1s

And if you double click you will see a button where you can see the full text. Can someone else who has similar platform
verify this?
Comment 11 _ ahimanikya 2008-09-08 09:50:27 UTC
This one works for me in both Windows and Mac, so marking it as random and downgrading it.
Comment 12 Roman Mostyka 2008-09-10 17:57:45 UTC
View of large text is fixed as I see on Mac OS X. So I close this issue as FIXED.
David, if you still see this issue, then probably you should do cooperate with Ahi and try to reproduce on your host,
since for me and for him this issue isn't reproducible on Mac OS X.
I filed another issue #146821 for Mac OS X which, probably, interferes you to see large text, please look at it.
Problem with 0011 stuff should be discussed in separate issue. Do you have it? If not it should be filed.
Comment 13 Roman Mostyka 2008-09-10 17:58:37 UTC
Verified with build 080909.
Comment 14 David Vancouvering 2008-09-10 18:02:35 UTC
This is good.  Can anyone see the 001 stuff?  If not, I'll assume it's my environment; if so, let's open an issue.
Comment 15 Roman Mostyka 2008-09-10 18:52:28 UTC
I don't see it.
Comment 16 Quality Engineering 2008-09-19 17:35:19 UTC
Integrated into 'main-golden', will be available in build *200809191401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main/rev/281f39306468
User: ahimanikya@netbeans.org
Log: #143802  Fix minor issue for Mac rendering.