[MDEV-24690] Dropping primary key column from versioned table always fails with 1072 - Jira

XML

Word

Printable

Example code:

CREATE TABLE abc (a INT NOT NULL, b INT NOT NULL, PRIMARY KEY (b)) WITH SYSTEM VERSIONING;

We now have a table with one primary key. Dropping column 'a' is no problem, but dropping column 'b' always fails with error code 1072.

SET SESSION system_versioning_alter_history=KEEP;

ALTER TABLE abc DROP COLUMN b;

causes

MDEV-25327 Unexpected ER_DUP_ENTRY upon dropping PK column from system-versioned table

relates to

MDEV-11114 Cannot drop column referenced by CHECK constraint

MDEV-13613 Dropping column from table that is part of a key fails in 10.2.8