after table creation with foreign key constraint, the reference table name is defined in lowercase, even it was provided in upper case.
CREATE TABLE `FAMILY_PARENT` (
|
`PARENT_ID` char(36) NOT NULL,
|
`PARENT_NAME` varchar(200) NOT NULL,
|
PRIMARY KEY (`PARENT_ID`)
|
) ENGINE=InnoDB ;
|
|
CREATE TABLE `FAMILY_CHILD` (
|
`PARENT_ID` char(36) NOT NULL,
|
`CHILD_NAME` varchar(200) NOT NULL,
|
PRIMARY KEY (`PARENT_ID`,`CHILD_NAME`),
|
CONSTRAINT `CHILD_FK` FOREIGN KEY (`PARENT_ID`) REFERENCES `FAMILY_PARENT` (`PARENT_ID`) ON DELETE CASCADE
|
) ENGINE=InnoDB ;
|
|
SHOW CREATE TABLE `FAMILY_CHILD`;
|
|
CREATE TABLE `FAMILY_CHILD` (
|
`PARENT_ID` char(36) NOT NULL,
|
`CHILD_NAME` varchar(200) NOT NULL,
|
PRIMARY KEY (`PARENT_ID`,`CHILD_NAME`),
|
CONSTRAINT `CHILD_FK` FOREIGN KEY (`PARENT_ID`) REFERENCES `family_parent` (`PARENT_ID`) ON DELETE CASCADE
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
Bug
Major
MDEV-35854 Clean up some DDL code around FOREIGN KEY constraints
