Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.3, 10.4, 10.5, 10.5.8
-
Component/s: Versioned Tables
-
Labels: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
-