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

Summary:	SQL Result table parses cells containing <HTML>..</HTML> tags as HTML
Product:	db	Reporter:	dnelson
Component:	Show Data	Assignee:	Jiri Rechtacek <jrechtacek>
Status:	RESOLVED FIXED
Severity:	normal	CC:	pejot
Priority:	P3	Keywords:	NETFIX
Version:	7.1
Hardware:	All
OS:	All
Issue Type:	DEFECT	Exception Reporter:
Attachments:	Example of parsed HTML in results pane Part 1 of the patch for this problem (cellrendering and tooltop) Part 2 of 2 of the patch for this problem (column header - try "select '<html><b>test</b></html>'" on mysql)) Part 2 of 2 (v2) of the patch for this problem (column header - try "select '<html><b>test</b></html>'" on mysql))

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