Bug #57670 Wrong schema is selected if Metadata Schemata is enabled
Submitted: 22 Oct 2010 18:59 Modified: 29 Mar 2012 3:59
Reporter: Markus Popp Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.29 OS:Linux (Fedora 64bit (others?))
Assigned to: CPU Architecture:Any

[22 Oct 2010 18:59] Markus Popp
If "Show Metadata Schemata" is enabled and a database above INFORMATION_SCHEMA is set as the default schema (using the context menu in the Object list on the left), the database above the chosen one is set as default.

How to repeat:
* Open MySQL Workbench and the SQL Editor
* Select Edit -> Preferences...
* go to "SQL Editor" tab
* enable "Show Metadata Schemata" and click OK
* refresh schema list in the Object list sidebar (so that information_schema and mysql get displayed)
* right click a database above information_schema or information_schema itself in the Object list sidebar on the left and select "Set as Default Schema"

Result: the database above the selected one gets set as Default Schema, or if the first database in the list is selected, information_schema gets set as Default.

Suggested fix:
The correct database should be selected.
[22 Oct 2010 21:53] MySQL Verification Team
Thank you for the bug report.