MySQL Bugs: #51388: Keep query history between sessions

Bug #51388	Keep query history between sessions
Submitted:	22 Feb 2010 13:27	Modified:	9 Sep 2011 11:42
Reporter:	Alex Whitman	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S4 (Feature request)
Version:	5.2.16	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	history, query, SQL

Description:
Currently query history is lost when closing MySQL Workbench.  It would be very useful to be able to keep the history between sessions.

How to repeat:
- Run MySQL Workbench
- Connect to a database
- Run a query
- Query can be found in history tab
- Close MySQL Workbench
- Re-open MySQL Workbench
- Connect to same server
- Nothing available in history tab

Suggested fix:
Store query history on disk between sessions.  History should be grouped by days/weeks like the history used to in MySQL Query Browser.  It would also be useful for history to be stored on a per database connection basis.

Thank you for the feature request.

This has now been documented. This change affects 5.2.35+

+        The query history is now saved between Workbench sessions.

I've been testing the 5.2.35 pre-release binaries and while the history is available, the Date and Time columns are not sortable and have the earliest Date and Time at the top.  To get to a recent entry in the history I have to scroll to the bottom of the list (I've got history entries from over a year ago).