2
# Bug #13083023 - 60229: BROKEN COMPATIBILITY: ERROR WHILE CREATE TABLE
3
# WITH FOREIGN KEY CONSTRAINT.
5
-- source include/have_innodb.inc
8
PERSON_ID VARCHAR(50) NOT NULL,
9
DOB VARCHAR(50) NOT NULL,
10
NAME NVARCHAR(255) NOT NULL,
11
CONSTRAINT PK_PERSON PRIMARY KEY (PERSON_ID, DOB)
16
PERSON_ID VARCHAR(50) NOT NULL,
17
DOB VARCHAR(50) NOT NULL,
18
PHOTO_DETAILS VARCHAR(50) NULL,
19
CONSTRAINT PK_PHOTO PRIMARY KEY (PERSON_ID, DOB),
20
CONSTRAINT FK_PHOTO_2_PERSON FOREIGN KEY (PERSON_ID, DOB) REFERENCES PERSON (PERSON_ID, DOB)
24
CREATE TABLE ADDRESS (
25
PERSON_ID VARCHAR(50) NOT NULL,
26
DOB VARCHAR(50) NOT NULL,
27
ADDRESS_ID VARCHAR(50) NOT NULL,
28
ADDRESS_DETAILS NVARCHAR(250) NULL,
29
CONSTRAINT PK_ADDRESS PRIMARY KEY (PERSON_ID, DOB, ADDRESS_ID),
30
CONSTRAINT FK_ADDRESS_2_PERSON FOREIGN KEY (PERSON_ID, DOB) REFERENCES PERSON (PERSON_ID, DOB) ON DELETE CASCADE
33
INSERT INTO PERSON VALUES("10", "11011999", "John");
34
INSERT INTO PHOTO VALUES("10", "11011999", "new photo");