| Bug #44087 | Table Editor allows erroneous ALTER statements with a default value for an ENUM | ||
|---|---|---|---|
| Submitted: | 4 Apr 2009 9:41 | Modified: | 14 May 2009 10:59 |
| Reporter: | Stephen Holsinger | Email Updates: | |
| Status: | Unsupported | Impact on me: | |
| Category: | MySQL GUI Common | Severity: | S2 (Serious) |
| Version: | 1.2.12 | OS: | MacOS (OS X 10.5 (Leopard)) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | alter, enum, table editor | ||
[5 Apr 2009 16:37]
Valeriy Kravchuk
There is no problem like this in QB 1.2.17 on Windows.
[14 May 2009 10:59]
Susanne Ebrecht
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL GUI Tools into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here: http://www.mysql.com/support/supportedplatforms/tools.html More informations about MySQL Workbench you will find here: http://dev.mysql.com/workbench/
Description: Table Editor does not automatically add string delimiting quotes to ENUM DEFAULT values. How to repeat: 1) Create a new table, or open an existing one in the "Table Editor" while using MySQL Query Browser. 2) Add a new field using the "+" button at the bottom of the column list. 3) Change the Data Type of the new column to ENUM('VALUE1','VALUE2') 4) Set the default value to (without single quotes) 'VALUE1' 5) Click "Apply". Suggested fix: When specifying a default value for an ENUM field, the program should detect whether or not the default value has been entered as: 'value' or value and add the string delimiters if they are not provided in the input. Users of the current version can bypass this issue by simply entering the default value with single quotes around it. Additionally, if the user experiences an error they can add the single quotes around the value within the query preview dialog and click "Execute".