navicat恢复数据库报错
【GBase版本】:GBase8a-NoLicense-Free-8.6.2_build43-R7-redhat7.3-x86_64
【操作系统】:CentOS-7
【CPU】:13th Gen Intel(R) Core(TM) i5-13500H
【问题描述】*:
使用navicat连接数据库,使用create语句创建表,报错。
创建语句:
CREATE TABLE `jbpm4_deployprop` (
`DBID_` bigint NOT NULL,
`DEPLOYMENT_` bigint DEFAULT NULL,
`OBJNAME_` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`KEY_` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`STRINGVAL_` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`LONGVAL_` bigint DEFAULT NULL,
PRIMARY KEY (`DBID_`),
KEY `IDX_DEPLPROP_DEPL` (`DEPLOYMENT_`),
KEY `FK_DEPLPROP_DEPL` (`DEPLOYMENT_`),
CONSTRAINT `FK_DEPLPROP_DEPL` FOREIGN KEY (`DEPLOYMENT_`) REFERENCES `jbpm4_deployment` (`DBID_`)
)
报错提示:
[Err] 1733 - (GBA-01EX-700) Gbase general error: unsupported key algorithm
热门帖子
- 12025-12-01浏览数:182759
- 22023-05-09浏览数:25044
- 42023-09-25浏览数:18519
- 52020-05-11浏览数:17526

GBase8a数据库不支持外键约束,主键约束仅兼容语法不报错但实际不起作用。请参考GBase8a产品手册创建表