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 208222 - SQL Result table parses cells containing <HTML>..</HTML> tags as HTML
Summary: SQL Result table parses cells containing <HTML>..</HTML> tags as HTML
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 7.1
Hardware: All All
: P3 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords: NETFIX
: 209064 (view as bug list)
Depends on:
Blocks:
 
Reported: 2012-02-09 23:12 UTC by dnelson
Modified: 2012-03-03 11:33 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Example of parsed HTML in results pane (28.09 KB, image/gif)
2012-02-09 23:12 UTC, dnelson 		Details
Part 1 of the patch for this problem (cellrendering and tooltop) (2.48 KB, patch)
2012-02-17 22:23 UTC, matthias42 		Details | Diff
Part 2 of 2 of the patch for this problem (column header - try "select '<html><b>test</b></html>'" on mysql)) (2.92 KB, patch)
2012-02-18 20:30 UTC, matthias42 		Details | Diff
Part 2 of 2 (v2) of the patch for this problem (column header - try "select '<html><b>test</b></html>'" on mysql)) (4.22 KB, patch)
2012-02-19 20:32 UTC, matthias42 		Details | Diff
Show Obsolete (1) Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description dnelson 2012-02-09 23:12:02 UTC 
Created attachment 115556 [details]
Example of parsed HTML in results pane

This is probably a regression of bug 124876 , but it's so old I thought It'd be better to create a new bug instead of re-opening that one.  The oldest copy of NB I have is 6.9, and it's reproducible there and in 7.1.

Testcase:  open up a database in Netbeans's Services tab and Excecute this command:

select '<html>test<img src="http://www.google.com/images/feed-icon.gif"></html>'; 

If using Java DB, add "from sysibm.sysdummy1" at the end.  If using Oracle, add "from dual".

The result table will have a cell with the word "test" followed by a little RSS image instead of the literal text.  I assume the fix is similar to what was used back in bug 124876 .
Comment 1 matthias42 2012-02-17 22:23:46 UTC 
Created attachment 115901 [details]
Part 1 of the patch for this problem (cellrendering and tooltop)
Comment 2 matthias42 2012-02-18 20:30:14 UTC 
Created attachment 115910 [details]
Part 2 of 2 of the patch for this problem (column header - try "select '<html><b>test</b></html>'" on mysql))
Comment 3 matthias42 2012-02-19 20:32:45 UTC 
Created attachment 115925 [details]
Part 2 of 2 (v2) of the patch for this problem (column header - try "select '<html><b>test</b></html>'" on mysql))
Comment 4 Jiri Rechtacek 2012-03-01 11:03:09 UTC 
core-main/rev/9e3478f097ef
Comment 5 Jiri Rechtacek 2012-03-01 17:24:49 UTC 
*** Bug 209064 has been marked as a duplicate of this bug. ***
Comment 6 Quality Engineering 2012-03-03 11:33:35 UTC 
Integrated into 'main-golden', will be available in build *201203030400* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/9e3478f097ef
User: Jiri Rechtacek <jrechtacek@netbeans.org>
Log: #208222: SQL Result table parses cells containing <HTML>..</HTML> tags as HTML;
applied matthias42's patch, thanks