MySQL Bugs: #54248: Select Rows - Limit 1000 blows away the contents of the active query window

Bug #54248	Select Rows - Limit 1000 blows away the contents of the active query window
Submitted:	5 Jun 2010 0:18	Modified:	14 Jun 2010 12:56
Reporter:	David Marwick	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.22	OS:	Windows (Win7 Pro)
Assigned to:		CPU Architecture:	Any

Description:
Right-clicking on a table and choosing "Select Rows - Limit 1000" replaces the entire contents of the active SQL editor window with the "SELECT * FROM <table>;" command.

How to repeat:
1. Open a connection to a database
2. Type something in the SQL query window
3. Right-click on a table and choose "Select Rows - Limit 1000"
4. Observe that whatever you typed in step 2 has been destroyed
5. Press ctrl-Z to undo this action and restore the original text in the window

Suggested fix:
Make "Select Rows - Limit 1000" automatically open a new query tab with the select * command.

Can you, please, double check this? Pressing Ctrl+Z restores original SQL for me on Windows XP SP3.

Yes, Ctrl+Z restores the original SQL for me as well, but I would not expect that I would have to do this. Why not simply open a new tab rather than risk destroying an unsaved one?

I agree that using separate window/tab is better, but as there is a workaround to get your SQL back, I'd say this is just a request for a new (lost :) feature.

Duplicate of bug #54362