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

[5 Jun 2010 0:18] David Marwick
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.
[9 Jun 2010 9:16] Valeriy Kravchuk
Can you, please, double check this? Pressing Ctrl+Z restores original SQL for me on Windows XP SP3.
[9 Jun 2010 14:23] David Marwick
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?
[10 Jun 2010 5:52] Valeriy Kravchuk
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.
[14 Jun 2010 12:56] Alfredo Kojima
Duplicate of bug #54362

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

Page generated in 0.041 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.