[MDEV-12923] MyISAM allows CHECK constraint violation in ALTER TABLE Created: 2017-05-26  Updated: 2017-07-05  Resolved: 2017-07-05

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Storage Engine - MyISAM
Affects Version/s: 10.2
Fix Version/s: 10.2.7

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: check_constraints

Issue Links:
Relates
relates to MDEV-12389 ADD CHECK leaves an orphaned .par file Closed

 Description   

The test case added in
MDEV-12389 ADD CHECK leaves an orphaned .par file
fails in an unexpected way in 10.2.
For InnoDB, the statement

ALTER TABLE t1 ADD CHECK(b IN (0,1));

fails as expected, because the column contains the values 0 and 10. However, MyISAM accepts the invalid constraint and only enforces it on subsequent DML operations.
Generated at Thu Feb 08 08:01:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.