Bug #53359 Edit SQL Script does not open selected script
Submitted: 3 May 2010 5:34 Modified: 7 May 2010 12:59
Reporter: Mich?le Garoche Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.20 Beta revision 5783 OS:MacOS
Assigned to: Alfredo Kojima CPU Architecture:Any

[3 May 2010 5:34] Mich?le Garoche
System/Machine: 10.5.8 Intel Core 2 Duo
WorkBench installation: mysql-workbench-oss-5.2.20-osx10.5-i686.dmg

Clicking on Edit SQL Script, open a dialog where you can browse for a script and check for execute. 
When using it, it opens the SQL Editor empty and nothing is executed.

On the other hand, when double-clicking on a connection, and using the Open a SQL Script File button in the toolbar, the script is opened.

It would be nice to have the same working behaviour when clicking on Edit SQL Script.

How to repeat:
1 - Click on Edit SQL Script
2 - Select a Stored Connection in Connection Options, click on Continue
3 - Browse for a SQL script, click on Open, eventually check Execute file after opening (it does not matter if it is checked or not, the behaviour is the same), click on Finish
4 - Observe that the SQL Editor opens with an empty SQL Query page and that nothing has been executed (if the Execute file after opening has been checked)

Now for the part that works:
1 - Double-click on a stored connection
2 - Eventually use the tab workaround if prompted for the already stored in Keychain Access password
3 - Click on Open a SQL Script File button in the toolbar
4 - Browse for the script, click on Open
5 - Observe that the SQL Editor now displays the selected script
6 - Click on Execute SQL Script in Connected Server
7 - Observe that the script is executed
[4 May 2010 12:22] Alfredo Kojima
[5 May 2010 21:16] Johannes Taxacher
fix confirmed in repository
[7 May 2010 12:59] Tony Bedford
An entry has been added to the 5.2.21 changelog:

When using the Edit SQL Script action item on the Home screen, the script failed to load and execute.