MySQL Bugs: #23466: Problem alter table add enum column

Bug #23466	Problem alter table add enum column
Submitted:	19 Oct 2006 14:32	Modified:	22 Jan 2007 8:38
Reporter:	Lieven Pouwelse	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.4	OS:	Windows (Windows XP Pro)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
Problems adding enum field to a table, mysql query browsers procudes a wrong query.

How to repeat:
Modify table, add new column type ENUM(ja,nee) then apply changes. Query is wrong

Suggested fix:
Allow quotes ENUM('ja','nee') OR automiticly add quotes

Thank you for the bug report.

Lieven, please check against the latest build. I could not reproduce a problem here. I added a new column to an existing table and modified the data type to ENUM('yes', 'no') and it worked flawlessly.

Problem still occurs in version 1.2.8. folowwing query is generated and crashed. Even i am not allowed to manually add quotes in the table editor

ALTER TABLE `bestandmap` MODIFY COLUMN `value` ENUM('yes','no', mayby) NOT NULL DEFAULT 'yes'
, ENGINE = MyISAM;

Lieven, are you aware that you ommitted the quotes around "maybe"? I get this SQL if I correctly add quotes to the enum members:

ALTER TABLE `test`.`t1` MODIFY COLUMN `value` ENUM('yes','no','maybe') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'no'
, ENGINE = InnoDB;

(ignore the charset addition). So it seems your problem turns out to be a quoting problem. What exactly happens when you try to add quotes? Do you get an error message? Does nothing happen?

That's te problem i cannot add the quotes, only if i copy paste from notepad, editplus etc..

Lieven, sorry, I don't get that. Do you say you cannot type quotes in the edit field? Any other char works, only quotes do not (what about back ticks and double quotes)? Hard to believe, particularly because it works on any other machine I tried and I also don't see any reason why exactly this one character should not be allowed to go in the edit field.

Yes indeed that's my problem. The following characters ' " ~ ` ^ are not allowed in the edit field `datatype`. And i need the quotes.. Maybey it are my keyboard / language settings. These characters don't work at home even at work. I live in the netherlands(holland). So maybey the problem is an europeen keyboard????.

I'm sorry, but I cannot reproduce this problem, nor do I have the slightest idea why the described behavior could appear. I'm using a german keyboard without any problem, so it hasn't to do with a european keyboard layout. Try changing the layout when you are in the edit field. Try also other machines. I suppose other application on your box don't have this problem. Try also the latest release of our tools, if that helps you in any way.

I'm sorry for not being of more help.