mirror of
https://github.com/MariaDB/server.git
synced 2025-11-01 11:26:11 +01:00
e2b984f3d5
Test that foreign key's constraint name is in correct case, when output via SHOW CREATE, for lower_case_table_name=0.
21 lines
903 B
Text
21 lines
903 B
Text
CREATE TABLE `FAMILY_PARENT` (
|
|
`PARENT_ID` char(36) NOT NULL,
|
|
`PARENT_NAME` varchar(200) NOT NULL,
|
|
PRIMARY KEY (`PARENT_ID`)
|
|
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
|
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 CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
|
SHOW CREATE TABLE FAMILY_CHILD;
|
|
Table 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_bin
|
|
DROP TABLE FAMILY_CHILD;
|
|
DROP TABLE FAMILY_PARENT;
|