MySQL Bugs: #16706: export results creating additional column

Bug #16706	export results creating additional column
Submitted:	22 Jan 2006 4:20	Modified:	23 Jan 2006 22:32
Reporter:	Brandon	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.18	OS:	Windows (XP Pro 2002)
Assigned to:		CPU Architecture:	Any

Description:
I am using MySQL Query Browser to Export results to HTML. Within the Query Browser the results look fine but upon exporting to HTML or Excel there is an additional column being added on.

Example:

Query Browser data looks like:

ORDER_NUM | ORDER_DATE | CUSTOMER_NUM

Exported data looks like:

ORDER_NUM | ORDER_DATE | CUSTOMER_NUM | ORDER_NUM 

How to repeat:
Export data to a HTML or Excel file. View that exported document.

Thank you for a problem report. Sorry, but I was not able to repeat the behaviour you described with export to HTML in QB 1.1.18 on a simple tables. So, please, send the SHOW CREATE TABLE results for the table that is exported incorrectly.

Here is the requested data:

'ORDERS', 'CREATE TABLE `ORDERS` (
  `ORDER_NUM` char(5) NOT NULL,
  `ORDER_DATE` date default NULL,
  `CUSTOMER_NUM` char(3) default NULL,
  PRIMARY KEY  (`ORDER_NUM`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1'

I was unable to repeat with 1.1.19 either exporting to HTML or Excel file.
Please upgrade and test.

The upgrade to 1.1.19 seems to have fixed the problem. Thanks!

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

Thank you for the feedback.