[MDEV-16331] Support instant DROP CHECK CONSTRAINT Created: 2018-05-30  Updated: 2018-05-30  Resolved: 2018-05-30

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2.1, 10.3.0
Fix Version/s: 10.3.6, 10.4.0

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: ddl, instant, performance

Issue Links:
Problem/Incident
is caused by MDEV-7563 Support CHECK constraint as in (or cl... Closed

 Description   

When MDEV-7563 introduced support for the CHECK constraint, it failed to add the flag for DROP CONSTRAINT to INNOBASE_INPLACE_IGNORE. Thus, dropping a CHECK constraint will unnecessarily require the table to be rebuilt, with ALGORITHM=COPY.

ADD [CONSTRAINT] CHECK does not strictly require a rebuild. As part of MDEV-16291 we can implement validation of all rows without copying the table.

 Comments   
Comment by Marko Mäkelä [ 2018-05-30 ]

This was fixed in MariaDB Server 10.3.6 as part of a code refactoring that added ALTER_DROP_CHECK_CONSTRAINT to INNOBASE_INPLACE_IGNORE.

Generated at Thu Feb 08 08:28:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.