Re: Primary Key Bug with Multiples of Same Column

[John Glista]

The result of select version() is:

5.7.32-log

We do not get an error executing ALTER TABLE package_tracking DROP PRIMARY KEY if we first remove the auto-increment attribute of the id column. But yes, if that is present, we do get the error you described.

We completely dropped the id column and attempted to re-create it using the syntax you provided:

alter table package_tracking add column id int unsigned primary key auto_increment;

And now, we have even more "id" values inside the primary key, as shown by the DDL dump:

create table if not exists package_tracking
(
tracking_id varchar(50) not null,
status_description varchar(256) null,
customer_order_number varchar(50) null,
distribution_order_number varchar(50) null,
service_description varchar(256) null,
actual_delivery_timestamp timestamp null,
actual_pickup_date timestamp null,
actual_ship_date date null,
actual_tender_date date null,
delivery_attempts int(5) null,
delivery_city varchar(100) null,
delivery_state varchar(50) null,
delivery_zip varchar(50) null,
delivery_country varchar(50) null,
event_timestamp timestamp null,
id int unsigned auto_increment,
primary key (id, id, id, id, id, id, id, id, id, id, id, id, id, id)
);