Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5.8, 10.3(EOL), 10.4(EOL), 10.5
-
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
-
here the row_end column is invisible, SHOW CREATE TABLE does not show it as a part of the primary key. So it should not cause the error.