MySQL Bugs: #53438: Cannot edit schema properties

Bug #53438	Cannot edit schema properties
Submitted:	5 May 2010 15:25	Modified:	20 May 2010 14:51
Reporter:	Mihail Lukin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	5.2.21	OS:	Linux (Ubuntu 10.04 amd64)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
Cannot rename default schema "mydb", cannot change schema's collation/default character set/comment.

How to repeat:
1. Create new EER model (default schema "mydb" is created)
2. Right click "mydb" tab in "Physical schemata" section (popup menu raises)
3. "Delete 'mydb'" item is enabled, "Copy SQL to clipboard" is enabled when at least one table is selected, other items are grayed out (is it just how it should be?).
4. Add new schema (schema properties tab is shown, but I still cannot change default character set, there is no such field on a form)
5. Close schema properties tab
6. Repeat 2-3 for newly created schema (all menu items except "Delete" are grayed out)

What operation system are you on? I can not repeat this with 5.2.20 on Mac OS X 10.5.x, for example.

Fedora 12 i686, Ubuntu 9.10 amd64

Maybe I am doing something wrong? In what cases "Edit Schema" menu item could be disabled?

I was able to repeat on Ubuntu 10.04 X86_64.

Fixed double-clicking and Edit Schema item in context menu.

Still here in version 5.2.21 on Ubuntu 10.04 amd64

bug was fixed post 5.2.21

As a workaround you can select a Diagram and right-click the Schema item in the Catalog tree.
The Edit Schema item will be enabled there.

It works well, thanks!
Is there a way to change default character set for schema?

fix confirmed in repository

An entry has been added to the 5.2.22 changelog:

It was not possible to edit schema properties, such as name and default collation, in the schema editor.