Re: SupportWizard: bug in mysql: "ALTER TABLE CHANGE COLUMN A" can damage autoincrement column B!

2001-11-16 Thread Sinisa Milivojevic
Max writes: > >Description: > I am using russian values(cp1251 charset) for ENUM items. > Here is an example how to damage ID field by query to change > F_Category Enum. > >How-To-Repeat: > # Create tableA with ID field. > CREATE TABLE tableA ( > ID int(11) NOT NULL auto

SupportWizard: bug in mysql: "ALTER TABLE CHANGE COLUMN A" can damage autoincrement column B!

2001-11-15 Thread Max
>Description: I am using russian values(cp1251 charset) for ENUM items. Here is an example how to damage ID field by query to change F_Category Enum. >How-To-Repeat: # Create tableA with ID field. CREATE TABLE tableA ( ID int(11) NOT NULL auto_increment, F_ReportID b