Bug #66419 right clicking on a table to get "copy insert statement" produces an insert that
Submitted: 16 Aug 2012 14:23 Modified: 7 Sep 2012 6:18
Reporter: mike coutinho Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.42 OS:MacOS (Darwin 11.4.0)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[16 Aug 2012 14:23] mike coutinho 
Description:
If you right click on one of the tables and select the "copy insert statement" it will produce an input statement that has all the columns listed alpha
This is a change from previous versions which list the table as it was actually written in the database.

The object info at the bottom left corner of the screen also shows the items alpha instead of their actual layout.  Unless I am halucinating….

----- Developer Notes -----

MySQL Workbench CE for Mac OS X version 5.2.42  revision 9752
Configuration Directory: /Users/coutinho/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.9.1
OS: Darwin 11.4.0
CPU: 8x Intel(R) Core(TM) i7-2720QM CPU @ 2.20GHz, 8.0 GB RAM

How to repeat:
see above
[23 Aug 2012 7:16] Olag Ulga 
this change in behaviour is annoying
[7 Sep 2012 6:18] Philip Olson 
Fixed as of the upcoming Workbench 5.2.43, and here's the changelog entry:

 Right-clicking on a table and selecting "Copy Insert Statement" would
 generate SQL with the columns sorted in alphabetical order. The SQL is
 now generated in the order listed in the database. 

Thank you for the report.
[24 Sep 2012 19:21] Mike Reid 
Just wanted to express my appreciation for fixing this bug. Thank you!

I can now INSERT INTO [...] SELECT [...] again without having to define the columns alphabetically to match the generated SQL.