| Server IP : 172.67.216.182 / Your IP : 162.158.108.52 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/innodb/r/ |
Upload File : |
CREATE TABLE Bug_60196_FK1 (Primary_Key INT PRIMARY KEY) ENGINE=InnoDB; CREATE TABLE Bug_60196_FK2 (Primary_Key INT PRIMARY KEY) ENGINE=InnoDB; CREATE TABLE Bug_60196 ( FK1_Key INT NOT NULL, FK2_Key INT NOT NULL, PRIMARY KEY (FK2_Key, FK1_Key), KEY FK1_Key (FK1_Key), KEY FK2_Key (FK2_Key), CONSTRAINT FK_FK1 FOREIGN KEY (FK1_Key) REFERENCES Bug_60196_FK1 (Primary_Key) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT FK_FK2 FOREIGN KEY (FK2_Key) REFERENCES Bug_60196_FK2 (Primary_Key) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB; INSERT INTO Bug_60196_FK1 VALUES (1), (2), (3), (4), (5); INSERT INTO Bug_60196_FK2 VALUES (1), (2), (3), (4), (5); INSERT INTO Bug_60196 VALUES (1, 1); INSERT INTO Bug_60196 VALUES (1, 2); INSERT INTO Bug_60196 VALUES (1, 3); INSERT INTO Bug_60196 VALUES (1, 99); ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`bug_60196`, CONSTRAINT `FK_FK2` FOREIGN KEY (`FK2_Key`) REFERENCES `Bug_60196_FK2` (`Primary_Key`) ON DELETE CASCADE ON UPDATE CASCADE) INSERT INTO Bug_60196 VALUES (99, 1); ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`bug_60196`, CONSTRAINT `FK_FK1` FOREIGN KEY (`FK1_Key`) REFERENCES `Bug_60196_FK1` (`Primary_Key`) ON DELETE CASCADE ON UPDATE CASCADE) SELECT * FROM bug_60196_FK1; Primary_Key 1 2 3 4 5 SELECT * FROM bug_60196_FK2; Primary_Key 1 2 3 4 5 SELECT * FROM bug_60196; FK1_Key FK2_Key 1 1 1 2 1 3 # restart # # Try to insert more to the example table with foreign keys. # Bug60196 causes the foreign key file not to be found after # the resstart above. # SELECT * FROM Bug_60196; FK1_Key FK2_Key 1 1 1 2 1 3 INSERT INTO Bug_60196 VALUES (2, 1); INSERT INTO Bug_60196 VALUES (2, 2); INSERT INTO Bug_60196 VALUES (2, 3); SELECT * FROM Bug_60196; FK1_Key FK2_Key 1 1 1 2 1 3 2 1 2 2 2 3 # Clean up. DROP TABLE Bug_60196; DROP TABLE Bug_60196_FK1; DROP TABLE Bug_60196_FK2; CREATE TABLE Bug_60309_FK ( ID INT PRIMARY KEY, ID2 INT, KEY K2(ID2) ) ENGINE=InnoDB; CREATE TABLE Bug_60309 ( ID INT PRIMARY KEY, FK_ID INT, KEY (FK_ID), CONSTRAINT FK FOREIGN KEY (FK_ID) REFERENCES Bug_60309_FK (ID) ) ENGINE=InnoDB; INSERT INTO Bug_60309_FK (ID, ID2) VALUES (1, 1), (2, 2), (3, 3); INSERT INTO Bug_60309 VALUES (1, 1); INSERT INTO Bug_60309 VALUES (2, 99); ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`bug_60309`, CONSTRAINT `FK` FOREIGN KEY (`FK_ID`) REFERENCES `Bug_60309_FK` (`ID`)) SELECT * FROM Bug_60309_FK; ID ID2 1 1 2 2 3 3 SELECT * FROM Bug_60309; ID FK_ID 1 1 # restart # # Try to insert more to the example table with foreign keys. # Bug60309 causes the foreign key file not to be found after # the resstart above. # SELECT * FROM Bug_60309; ID FK_ID 1 1 INSERT INTO Bug_60309 VALUES (2, 2); INSERT INTO Bug_60309 VALUES (3, 3); SELECT * FROM Bug_60309; ID FK_ID 1 1 2 2 3 3 # Clean up. DROP TABLE Bug_60309; DROP TABLE Bug_60309_FK;