error 1091 changing prop of column indexed by a multi column inde

MySqlCC reports error 1091 on attempts to change an attribute of a InnoDB
table column
that is indexed as part of a multi column unique index.
The system is Redhat7.3 system fully updated using Redhat's up2date service.
The version of MySQLCC is 0.8.7-alpha.
How-To-Repeat:
0. Use MySqlCC v0.8.7-alpha for the following steps
1. Create an InnoDB table in a database.
2. Create a column - Col1 - of type integer.
3. Create a column - Col2 - of type datetime.
4. Create a Multi column index - Col1Col2Idx - of type UNIQUE of Col1 and
Col2.
5. Save changes.
6. Change the type of column Col1 to unsigned integer instead of integer.
MySqlCC does not carry out step 6 but writes a message under Messages
saying:
ERROR 1091: Can't DROP Col1Col2Idx. Check that column/key exists.

------------------------------------------------------------ ---------
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-thread13473@lists.mysql.com
To unsubscribe, e-mail

Re: error 1091 changing prop of column indexed by a multi column index using mysqlcc

Hi!

Thanks for the bug report. This is now fixed in the 0.8.8 tree!

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/


----- Original Message -----
From: "Claus Olesen"
To:
Sent: Monday, January 13, 2003 5:25 PM
Subject: error 1091 changing prop of column indexed by a multi column index
using mysqlcc


> MySqlCC reports error 1091 on attempts to change an attribute of a InnoDB
> table column
> that is indexed as part of a multi column unique index.
> The system is Redhat7.3 system fully updated using Redhat's up2date
service.
> The version of MySQLCC is 0.8.7-alpha.
> How-To-Repeat:
> 0. Use MySqlCC v0.8.7-alpha for the following steps
> 1. Create an InnoDB table in a database.
> 2. Create a column - Col1 - of type integer.
> 3. Create a column - Col2 - of type datetime.
> 4. Create a Multi column index - Col1Col2Idx - of type UNIQUE of Col1 and
> Col2.
> 5. Save changes.
> 6. Change the type of column Col1 to unsigned integer instead of integer.
> MySqlCC does not carry out step 6 but writes a message under Messages
> saying:
> ERROR 1091: Can't DROP Col1Col2Idx. Check that column/key exists.
>
> ------------------------------------------------------------ ---------
> 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-thread13473@lists.mysql.com
> To unsubscribe, e-mail
>



------------------------------------------------------------ ---------
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-thread13475@lists.mysql.com
To unsubscribe, e-mail