[DERBY-4903] Plan exporter tool produces broken output if query contains less-than operator

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.7.1.1
• Fix Version/s: 10.7.1.1, 10.8.1.2
• Component/s: Tools
• Assignee: Nirmal Fernando
• Reporter: Knut Anders Hatlen
• Created: 15/Nov/10 14:34
• Updated: 19/Apr/11 16:39
• Resolved: 01/Feb/11 08:24

Description

The plan exporter tool fails to produce well-formed output for the following query:

ij> select * from sysibm.sysdummy1 where ibmreqd < 'Z';

The generation of XML doesn't fail, but when I open the file in Firefox, I see this message:

XML Parsing Error: not well-formed
Location: file:///tmp/plan.xml
Line Number 9, Column 11:

Operator: <
----------^

HTML generation prints the following error, and produces an empty file:

ERROR: 'The value of attribute "scan_qualifiers" associated with an element type "null" must not contain the '<' character.'

Issue Links

• is related to: DERBY-4919 Use the built-in XML libraries for generating XML in PlanExporter