Bug #99789 Workbench updates the wrong sql_history file and hangs
Submitted: 5 Jun 2020 15:46 Modified: 7 Jul 2020 12:29
Reporter: Edward Leigh Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:8.0.20 OS:Microsoft Windows (Microsoft Windows 10 Home)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[5 Jun 2020 15:46] Edward Leigh
Description:
When editing a particular statement in the SQL editor window, it hangs requiring a forced close. When I looked in the sql_history file, I discovered that the content of the editor window was being saved to the wrong date file: in the first instance, 2016-05-01 and then subsequently 2016-05-03. Today's date is 2020-06-05.

How to repeat:
This is a sample query that precipitates the problem:

SELECT caption FROM assets WHERE
     caption LIKE "% Lent for scanning by The Gallery of Illustration%"
  OR caption LIKE "% Lent for scanning by The Gallery of lllustration%"
  OR caption LIKE "% Lent for scanning by The Gallery fo Illustration%"
  OR caption LIKE "% Lent for scanning  by The Gallery of Illustration%"
  OR caption LIKE "% Lent for scanning by The Gallery of Ilustration%"
  OR caption LIKE "% Lent for scanning by The Gallery of Illustrtion%"
  OR caption LIKE "% Lent for scanning by the Illustration Art Gallery%"
  OR caption LIKE "% Lent for scanning by the Illustration Art Hallery%"
  OR caption LIKE "% Lent for scanning by the Illustation Art Gallery%"
  OR caption LIKE "% Lent for scanning by the Illsutration Art Gallery%"
  OR caption LIKE "% Lent for scanning by the Illustraton Art Gallery%"
  OR caption LIKE "% Lent for scanning by the Illustratioin Art Gallery%"
  OR caption LIKE "% Loaned for scanning by the Illustration Art Gallery%"
  OR caption LIKE "% Loaned for scanning by the Illustraton Art Gallery%"
  OR caption LIKE "% oaned for scanning by the Illustration Art Gallery%"
  OR caption LIKE "% Original loaned for scanning by the Illustraton Art Gallery%"
  OR caption LIKE "% Original artwork loaned for scanning by the Illustration Art Gallery%"
  OR caption LIKE "% Original artwork % loaned for scanning by the Illustration Art Gallery%"
  OR caption LIKE "% Original artwork % loaned for scanning by the Illustration Art Galelry%"
  OR caption LIKE "% Oriiginal artwork loaned for scanning by the Illustration Art Gallery%"
  OR caption LIKE "% Original artwokr loaned for scanning by the Illustration Art Gallery%"
  OR caption LIKE "% Original arwork loaned for scanning by the Illustration Art Gallery%"
  OR caption LIKE "% Original artwork loaned for scanning by teh Illustration Art Gallery%"
  OR caption LIKE "% Original cover artwork loaned for scanning by the Illustration Art Gallery%"
  OR caption LIKE "% Original artwork loaned to Look and Learn for scanning by the Illustration Art Gallery%"
  OR caption LIKE "% Original artwork loaned for scanning%"
  OR caption LIKE "% Original illustrat loaned for scanning by the Illustration Art Gallery%"
  OR caption LIKE "% Lent to Look and Learn for scanning%"
  OR caption LIKE "% Lent to Look and Learn for scanning by The Gallery of Illustration%"
  OR caption LIKE "% Artwork lent to Look and Learn for scanning by The Gallery of Illustration%"
  OR caption LIKE "% Artwork loaned to Look and Learn for scanning by The Gallery of Illustration%"
  OR caption LIKE "% Artwork loaned for scanning by The Gallery of Illustration%"
  OR caption LIKE "% Artwork loaned for scanning by The Illustration Art Gallery%"
  OR caption LIKE "% Original artwork loaned for scanning by Norman Wright%"
  OR caption LIKE "% Artwork loaned for scanning by Norman Wright%";
  
If I try to complete the word 'illustration' on line 28, it hangs.

This occurred both when the SQL window is named and saved or unnamed and autosaved.

wb.log has no entries for over an hour before the hang.

The most recent {GUID}.info file in the relevant .autosave folder contains:
type=file
orig_encoding=
title=SQL File 3
show_special=0
word_wrap=0
caret_pos=36
first_visible_line=0

Suggested fix:
Identify and rectify the cause of the hang?
[7 Jul 2020 12:29] MySQL Verification Team
Hello Edward Leigh,

Thank you for the bug report.
Verified as described.

Regards,
Ashwini Patil
[7 Jul 2020 12:35] MySQL Verification Team
8.0.20 test results

Attachment: 99789_test_results.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document, text), 129.57 KiB.