Bug #61345 History improperly reloaded - contains XML escape sequences
Submitted: 29 May 2011 19:24 Modified: 31 Aug 2011 23:22
Reporter: John Vanderburg Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.34 CE 7780 OS:Any (v7sp1 64bit, Mac OS X)
Assigned to: CPU Architecture:Any
Tags: history

[29 May 2011 19:24] John Vanderburg 
Description:
When MySQL Workbench is restarted, many (most?) statements in the history contain XML escape sequences such as ' and 


As a result it is so difficult to work with it is almost unusable.

How to repeat:
1. In the editor, execute a statement such as:  select 'a', 'b', 'c';
2. Exit MySQL Workbench.
3. Start MySQL workbench, open a connection and find the last entry in the history.  You should see the completely unusable entry of:
select 'a', 'b', 'c';
[30 May 2011 3:16] Valeriy Kravchuk 
Verified on Mac OS X also. I've got the following entries:

select 1, 
2, 
3

when new lines were used originally:

select 1,
2,
3
[31 May 2011 16:36] Alfredo Kojima 
Bug #61362 is a duplicate
[13 Jul 2011 17:43] Dave Brown 
Same problem escaping greater-than and less-than symbols. I get entries in the history like this:

select * from t where t.created_at < '2011-01-01';
[31 Aug 2011 23:22] Philip Olson 
This is fixed as of 5.2.35:

+        The SQL Editor <guilabel>Output</guilabel>,
+        <guilabel>History</guilabel> window contained escaped
+        characters. For example, a "<literal>'</literal>" was written as
+        "<literal>&amp;apos;</literal>".