We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
CREATE TABLE t1 (a INT PRIMARY KEY); CREATE TABLE t2 (b INT); INSERT INTO t1 VALUES (1), (2), (5); INSERT INTO t2 VALUES (1), (5); ALTER TABLE t2 ADD CONSTRAINT FOREIGN KEY(b) REFERENCES t1(a); DELETE IGNORE FROM t1;
The last DELETE statement should execute success, but failed in TiDB.
DELETE
> DELETE IGNORE FROM t1; (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk_1` FOREIGN KEY (`b`) REFERENCES `t1` (`a`))')
master: 2ea253e
The text was updated successfully, but these errors were encountered:
UPDATE/INSERT/DELETE ignore
2de388b
Successfully merging a pull request may close this issue.
Reproduce
The last
DELETE
statement should execute success, but failed in TiDB.TiDB Version
master: 2ea253e
The text was updated successfully, but these errors were encountered: