Bug #90745 sqlide-history parser fails to parse entries with some html encodings
Submitted: 4 May 2018 8:38 Modified: 4 May 2018 10:01
Reporter: Fredric Johansson Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.11 OS:Any
Assigned to: CPU Architecture:Any

[4 May 2018 8:38] Fredric Johansson
Description:
History entries with certain html encodings like ä , í and á fails to parse with the XML parser in workbench 8.0.11. I don't remember seeing this in the log for earlier versions like 6.3. These entries does not appear in the history

Messages from the log:
########################
10:36:08 [ERR][  XML Functions]: LibXml: Entity: line 1: 
10:36:08 [ERR][  XML Functions]: LibXml: parser 
10:36:08 [ERR][  XML Functions]: LibXml: error : 
10:36:08 [ERR][  XML Functions]: LibXml: Entity 'aring' not defined

10:36:08 [ERR][  XML Functions]: LibXml: <ENTRY timestamp='10:35:13'>INSERT INTO t (ds) VALUES('&aring;&auml;&ouml;')</EN

10:36:08 [ERR][  XML Functions]: LibXml:                                                               ^

10:36:08 [ERR][  XML Functions]: LibXml: Entity: line 1: 
10:36:08 [ERR][  XML Functions]: LibXml: parser 
10:36:08 [ERR][  XML Functions]: LibXml: error : 
10:36:08 [ERR][  XML Functions]: LibXml: Entity 'auml' not defined

10:36:08 [ERR][  XML Functions]: LibXml: <ENTRY timestamp='10:35:13'>INSERT INTO t (ds) VALUES('&aring;&auml;&ouml;')</EN

10:36:08 [ERR][  XML Functions]: LibXml:                                                                     ^

10:36:08 [ERR][  XML Functions]: LibXml: Entity: line 1: 
10:36:08 [ERR][  XML Functions]: LibXml: parser 
10:36:08 [ERR][  XML Functions]: LibXml: error : 
10:36:08 [ERR][  XML Functions]: LibXml: Entity 'ouml' not defined

10:36:08 [ERR][  XML Functions]: LibXml: <ENTRY timestamp='10:35:13'>INSERT INTO t (ds) VALUES('&aring;&auml;&ouml;')</EN

10:36:08 [ERR][  XML Functions]: LibXml:                                                                           ^

10:36:08 [ERR][ sqlide-history]: Can't parse <ENTRY timestamp='10:35:13'>INSERT INTO t (ds) VALUES('&aring;&auml;&ouml;')</ENTRY>, of file: C:\Users\fredric\AppData\Roaming\MySQL\Workbench\sql_history\2017-06-22
########################

How to repeat:
1. Insert an valid entry containing &auml; like the one above in the history. i.e. run
CREATE TEMPORARY TABLE t (
`id` INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
`ds` VARCHAR(244)
);    
INSERT INTO t (ds) VALUES('åäö');

2. Open history for that date
[4 May 2018 9:33] Chiranjeevi Battula
Hello Fredric,

Thank you for the bug report.
I could not repeat the issue at our end using with MySQL workbench 8.0.11 version.
Could you please provide repeatable steps (exact steps, screenshot, provide full MySQL Workbench Log file etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[4 May 2018 9:50] Fredric Johansson
The action output after running the queries

Attachment: actionoutput.PNG (image/png, text), 10.56 KiB.

[4 May 2018 9:51] Fredric Johansson
The history output after running the query

Attachment: historyoutput.PNG (image/png, text), 7.45 KiB.

[4 May 2018 9:53] Fredric Johansson
The history file causing this

Attachment: 2018-05-04 (application/octet-stream, text), 338 bytes.

[4 May 2018 10:01] Chiranjeevi Battula
Hello Fredric,

Thank you for the feedback.
Verified this behavior on MySQL Workbench in 8.0.11 version.

Thanks,
Chiranjeevi.