Bug #63861 Workbench Open Script Page offers incorrect file type option
Submitted: 27 Dec 2011 23:17 Modified: 3 Feb 2012 4:08
Reporter: David Berg Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.37 CE (Rev 8576) OS:Windows (XP Pro SP3)
Assigned to: CPU Architecture:Any

[27 Dec 2011 23:17] David Berg
When opening a script file in Workbench Version 37, the File Type options, which used to be SQL Files (.sql) and All Files, are now SQL Files(.sql) and Query Browser Files (.dbquery).

The only problem is that Query Browser Files are suffixed with .qbquery, not .dbquery. Therefore, Query Browser files are no longer selectable in Workbench without changing their suffix.

The workaround is to change the suffix of affected files to .dbquery before attempting to open them.

How to repeat:
Start MySQL Workbench Version 5.2.37.

Press File --> Open SQL Script (or press the correpsonding icon). 

Press the drop-down arrow for 'Files of Type.'

Note that the only two selections are .sql and .dbquery.

Suggested fix:
Change the File Type options to .sql and .qbquery. Perhaps also add All Files as a third option for users who may have SQL code in a file of some other denomination.
[28 Dec 2011 5:42] Valeriy Kravchuk
Thank you for the problem report.
[3 Feb 2012 4:08] Philip Olson
Fixed as of 5.2.38:

The "File", "Open SQL Script",
"Files of Type" dialogue would incorrectly give
the option to open files with the ".dbquery"
suffix, instead of ".qbquery".
[27 Mar 2012 18:37] David Crow
Is there a reason why "All Files" was not added back?  So many DB scripts do not have a .sql extension.