Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.5.8, 10.3(EOL), 10.4(EOL)
-
None
Description
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;
|
Attachments
Issue Links
- causes
-
MDEV-25327 Unexpected ER_DUP_ENTRY upon dropping PK column from system-versioned table
- Closed
- relates to
-
MDEV-11114 Cannot drop column referenced by CHECK constraint
- Closed
-
MDEV-13613 Dropping column from table that is part of a key fails in 10.2.8
- Closed