Bug #50791 Workbench SQL Editor - Execute button missing
Submitted: 1 Feb 2010 13:17 Modified: 10 Feb 2010 13:37
Reporter: d m Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.15 OSS beta Rev5053 OS:Windows (XP Pro SP3)
Assigned to: Sergei Tkachenko CPU Architecture:Any

[1 Feb 2010 13:17] d m
Description:
Using mysql-workbench-oss-5.2.15a-beta-win32-noinstall.zip the SQL editor appears to have lost the 'Execute SQL Script in Connected Server' button.

I can only execute queries using Ctrl+Enter.

How to repeat:
1. Unzip MySQL Workbench into new directory. 
2. Double-click MySQLWorkbench.exe - Workbench 5.2.15 OSS beta loads.
3. In 'Home' tab, 'Workspace' section double-click a stored connection in box under 'Open Connection to start Querying' - SQL editor loads in new tab.

Expected result (as experienced previously in WB 5.2.14 OSS Beta rev. 4990):
Toolbar contains 13 buttons:
Open a SQL Script File
Save SQL Script to File
Save SQL to Snippets List
Execute SQL Script in Connected Server
Explain selected SQL
Stop the query being executed (...)
Toggle whether the execution of SQL script should continue ...
Commit
Rollback
Toggle auto-commit mode
Reconnect to DBMS
Refresh state of database structures: ...
Toggle whether query result tabs should be kept ...

Enter SQL query and click 'Execute SQL Script in Connected Server' button and resultset is returned.

Actual Result:
Toolbar contains 13 buttons:
Open a SQL Script File
Save SQL Script to File
Save SQL to Snippets List
***** BUTTON MISSING ***** Execute SQL Script in Connected Server
Explain selected SQL
Stop the query being executed (...)
Toggle whether the execution of SQL script should continue ...
Commit
Rollback
Toggle auto-commit mode
Reconnect to DBMS
Refresh state of database structures: ...
Toggle whether query result tabs should be kept ...

Enter SQL query  - only way to execute query is to hit Ctrl+Enter.

Notes:
After removing previous install (WB 5.2.14 OSS Beta rev. 4990) by deleting folder, I ran CCleaner to try and clean up any registry entries that might confuse the issue.

Suggested fix:
Add button back
- or let me know if there are some configuration settings I have messed up that I can correct to make the button reappear.

Thanks!
[1 Feb 2010 16:29] Johannes Taxacher
fix confirmed. additional "execute current sql statement" button has also been added.
will be included in 5.2.16
[2 Feb 2010 17:31] d m
Thanks for speedy response - keep up the great work!

Looking forward to the next iteration.
[10 Feb 2010 13:37] Tony Bedford
An entry has been added to the 5.2.16 changelog:

In the SQL Editor the toolbar button to execute SQL statements was missing.

MySQL Workbench also now includes a new toolbar button to execute a single statement.