Bug #16146 export of empty column
Submitted: 3 Jan 2006 8:24 Modified: 6 Jan 2006 8:52
Reporter: Jens Doll Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.1.3 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[3 Jan 2006 8:24] Jens Doll
Description:
The Administrator produces a "lonely quote" on export of a table if the last column of the table is an empty string. The export is correct for non-empty columns.
Regards
Jens Doll

--------------- a sample export is here ------------------------

INSERT INTO `urltable` (`ipfrom`,`count`,`firstdate`,`lastdate`,`request`,`referrer`,`domainfrom`,`target`) VALUES 
 ('12.210.176',1,'2005-11-17 16:48:46','2005-11-17 16:48:46','http://www.cococo.de/CoCoCo/index.jsp','http://www.cococo.de/CoCoCo/index.jsp','insightBB....;),
 

How to repeat:
export a table with an empty character field at the last position
[3 Jan 2006 17:18] Valeriy Kravchuk
Thank you for a problem report. What exact version of MySQL Administrator do you use?
[3 Jan 2006 18:08] Jens Doll
Hello Valeriy,

the version number 5.0 belongs to the server. The MySQL-Administrator has got 1.1.3

Regards
JD
[5 Jan 2006 16:09] Valeriy Kravchuk
Please, try to use newer version (1.1.5 in case of Linux). Inform about the results.
[6 Jan 2006 8:52] Jens Doll
the lonely quotes in are now paired in Version 1.1.6