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>".

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.