ALTER TABLE MODIFY adds duplicate keys

[anzenews]

Hello!

I have a weird problem... The application I use issues this SQL from
time to time:

alter table t modify id int(6) unique not null auto_increment;

The problem is that this SQL adds a key on id every time it is run!

mysql> show keys;

+-------+------------+----------+--------------+-------------+--
| Table | Non_unique | Key_name | Seq_in_index | Column_name |
+-------+------------+----------+--------------+-------------+--
| t | 0 | PRIMARY | 1 | id |
| t | 0 | id | 1 | id |
| t | 0 | id_2 | 1 | id |
| t | 0 | id_3 | 1 | id |
| t | 0 | id_4 | 1 | id |
| t | 0 | id_5 | 1 | id |
| t | 0 | id_6 | 1 | id |
| t | 0 | id_7 | 1 | id |
+-------+------------+----------+--------------+-------------+--

(output after 7 runs of the above SQL query)

Is this normal behaviour or is it a bug? I would say it is a bug but I
haven't found anything on the topic on the Internet.
Is there an equivalent SQL that does not create duplicate keys?

I want my application to take care of fields data type and I don't want
to 'know' the current data type - the application should just issue
'alter table modify' query and change data type as appropriate. It all
works well except for this glitch.

The database in question runs very slowly once it has 32 indexes... :(

Could someone verify this behaviour on MySQL 3.x database?

Any comments are welcome - I could really use some help here.

Thank you!

Anze