Bug #26772 export to xml fails on quote
Submitted: 1 Mar 2007 20:57 Modified: 27 Apr 2007 15:51
Reporter: Martin Friebe (Gold Quality Contributor) (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.9 OS:Microsoft Windows (Windows XP)
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: qc, XML

[1 Mar 2007 20:57] Martin Friebe
Description:
Exportinfg a result set to xml, produces incorrect xml, if the column name contains a " double quote.

select 'a " x';

<field name="a " x">

How to repeat:
select 'a " x';

results in

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE ROOT SYSTEM "t.dtd">
<ROOT>
    <row>
      <field name="a " x">a &quot; x</field>
    </row>
</ROOT>

Suggested fix:
-
[1 Mar 2007 21:07] Valeriy Kravchuk
Thank you for a bug report. Verified just as described.
[27 Apr 2007 15:51] Alfredo Kojima
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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html