MySqlCC 0.8.8 error 1075 renaming field

How-To-Repeat:
Use MySqlCC 0.8.8-beta.
1. add a new table.
2. add a field of type integer,unsigned and auto increment.
3. add a named index of type unique for the field.
4. set table type InnoDB.
5. save.
6. modify the name of the field.
7. save.
At this point under the messages tab MySqlCC reports "ERROR 1075: Incorrect
table definition; There can only be one auto column and it must be defined as
a key".

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13517@lists.mysql.com
To unsubscribe, e-mail

Re: MySqlCC 0.8.8 error 1075 renaming field

Hi!

> How-To-Repeat:
> Use MySqlCC 0.8.8-beta.
> 1. add a new table.
> 2. add a field of type integer,unsigned and auto increment.
> 3. add a named index of type unique for the field.
> 4. set table type InnoDB.
> 5. save.
> 6. modify the name of the field.
> 7. save.
> At this point under the messages tab MySqlCC reports "ERROR 1075:
Incorrect
> table definition; There can only be one auto column and it must be defined
as
> a key".

This is not a bug. What happens is you defined an index with a certain name
and when you modify the column (rename, change data-type or even field
properties), the index automatically gets removed from the 'Index Fields'.
Basically, if you're going to be changing index properties, you need to
re-add the modified column to the index.

Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/?ref=mjdc
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Jorge del Conde
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql.com

MySQL Users Conference and Expo
http://www.mysql.com/events/uc2003/



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13522@lists.mysql.com
To unsubscribe, e-mail