Bug #23801 editing default value in the fields' listing results behaves weirdly

• Submitted: 31 Oct 2006 11:49
• Modified: 16 Apr 2009 13:12
• Reporter: Cezary Okupski
• Status: Unsupported
• Category: MySQL Administrator
• Severity: S3 (Non-critical)
• Version: 1.2.4rc, 1.2.6rc
• OS: MacOS (Mac OS X)
• CPU Architecture: Any
• Tags: DEFAULT, disappear, null, table editor

[31 Oct 2006 11:49] Cezary Okupski

Description:
I have spotted two visual bugs when editing field's default value. They are best illustrated in screenshots I took and attached.

How to repeat:
first one: start editing a table that has got a field with the default value null. Double-click in the fields' listing on the intersection of the mentioned column and Default Value. "NULL image" does not disappear, there is editing box next to it, like this "NULL_________".

second one:  start editing a table that has got a field without the default value specified. Double-click in the fields' listing on the intersection of the mentioned column and Default Value. Headers disappear. You can edit nothing.

Suggested fix:
Either make some intelligent default value editing in the fields' listing or disable it. Maybe it is enough to edit default value in the form at the bottom of table editor.

[31 Oct 2006 11:50] Cezary Okupski

the default value was not null

Attachment: default other.jpg (image/jpeg, text), 48.36 KiB.

[31 Oct 2006 11:51] Cezary Okupski

the default value was null

Attachment: default null.jpg (image/jpeg, text), 52.69 KiB.

[21 Nov 2006 15:09] Valeriy Kravchuk

Thank you for a problem report. Please, try to repeat with a newer version, 1.2.5 rc, and inform about the results.

[10 Dec 2006 13:30] Cezary Okupski

It remains to be fixed in 1.2.6rc.

[21 Dec 2006 7:24] Sveta Smirnova

Thank you for the report.

"NULL" bug (http://bugs.mysql.com/file.php?id=4752) is repeatable with last 1.0.7 version

[1 Apr 2007 20:35] Robert Sinton

Mac OS X 10.4, MySQL Administrator 50.r11 :

This behaviour, or very similar, still occurs.

Simple way to replicate:
- Create new table
- Click '+' to add a new column
- Double-click in Default Value field
- Double-click in another input field, e.g. Name
- Double-click in Default Value field again

Result: column headings disappear.

After this, the problem recurrs more easily, e.g. all that is necessary is to open the table editor and double-click on Default Value.

[16 Apr 2009 13:12] Axel Schwenke

Thank you for reporting a bug. Unfortunately we no longer support MySQL Administrator on your platform. So this bug will not be fixed. Our new GUI tool MySQL Workbench will be supported on Windows, Linux and Mac. We plan to implement all features from Administrator into Workbench (if not already there).