Bug #73900 EDIT DATA - SQL script preview pops-up when auto-commit is on
Submitted: 11 Sep 2014 23:48 Modified: 10 Oct 2014 4:22
Reporter: Javier Treviño Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S2 (Serious)
Version:1.2.0 OS:Any
Assigned to: CPU Architecture:Any

[11 Sep 2014 23:48] Javier Treviño 
Description:
The SQL script preview dialog that shows up when the "Preview SQL statements before they are sent to the server" option is set in the Global Options dialog, is being shown even when the "Auto-Commit" checkbox in the Edit Data dialog is checked. The SQL script preview should not be shown when auto-commit is on, since the whole point of it is that the user can commit data immediately without doing any other action like reviewing a script.

How to repeat:
1. Open MySQL for Excel
2. Select any schema and table
3. Click Edit MySQL data
4. Click the Options button in the Database Objects selection panel
5. Check the "Preview SQL statements before they are sent to the server" option
6. On the Edit Data dialog check the "Auto-Commit" option
7. In Excel change the value of any cell and hit <ENTER>, note the SQL Script Preview dialog is shown, but it should not since the "Auto-Commit" option is on.
[12 Sep 2014 17:30] Javier Treviño 
Posted by developer:
 
Fixed code to show the SQL Script Preview dialog on Edit Data operations when the "Preview SQL statements before they are sent to the server" global option is on and only if the "Auto-Commit" checkbox on the Edit Data dialog is off.
[10 Oct 2014 4:22] Philip Olson 
Posted by developer:
 
Fixed as of the upcoming MySQL for Excel 1.3.3 release, and here's the changelog entry:

The "Preview SQL statements before they are sent to the server" option is
now overridden when the "Auto-Commit" checkbox in the Edit Data dialog is
checked. Before, each edit (that was auto committed) would first show the
preview dialog.

Thank you for the bug report.