MySQL Bugs: #49373: Default schema selector does nothing

Bug #49373	Default schema selector does nothing
Submitted:	2 Dec 2009 21:17	Modified:	11 Dec 2009 17:35
Reporter:	Todd Farmer (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.10 r4680	OS:	Windows (XP)
Assigned to:	Sergei Tkachenko	CPU Architecture:	Any

Description:
In the Schemata palette for SQL Editor, there is a drop down titled "Default", and listing each schema.  Changing this has no impact, and the selected value is not retained across WB restarts.  No idea what it's meant to do, really, but if it's not going to do anything, best to remove it.

How to repeat:
See above.

Suggested fix:
Remove or make do something.

this selector executes a "use <DB>" statement, so subsequent calls without schema qualifier will go the schema selected there. its only set on query-session launch if theres a "default schema" selected in profile.
this works fine for me in general, but there seems to be a problem with schema names including a dot char. (looks like the dbname isn't quoted in the use statement)

Patched MySQL C++ Connector library. Now schema name with escaped characters is processed properly.

fix confirmed. will be included in 5.2.11

I've updated the Schemata Palette documentation to be a bit clearer on this.

An entry has been added to the 5.2.11 changelog:

In the Schemata Palette of the SQL Editor the default schema drop down selector did not work if the schema name contained a '.' character.