MySQL Bugs: #5830: Exporting resultset as XML file generates invalid XML and DTD file

Bug #5830	Exporting resultset as XML file generates invalid XML and DTD file
Submitted:	30 Sep 2004 17:56	Modified:	1 Oct 2004 15:46
Reporter:	Shuichi Tamagawa	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.0.7-beta	OS:	Windows (Win XP / SP2)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
Exporting resultset as XML file generates invalid XML and DTD file.

How to repeat:
Execute a query and get result set.
Right click on the result area.
Select 'Export as XML file' and seve the file.
Open the generated XML file with browser.
-> Can not open XML file

Suggested fix:
Let's say you save the file as test.xml.

In test.xml file:
<!DOCTYPE ROOT SYSTEM ".dtd"> should be
<!DOCTYPE ROOT SYSTEM "test.dtd">

In test.dtd file:
<!ELEMENT ROOT ()+> should be
<!ELEMENT ROOT (row)+>

<!ELEMENT (c1,c2,c3)> should be
<!ELEMENT row (c1,c2,c3)>

Note: c1, c2, c3 is column name in the exported result set.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html