Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.9.3
-
None
-
Windows 10 x64
Description
Can not create the FK between these two tables.
Works fine in MySQL and other DBMSs but fails on MariaDB.
create table in_sync_data_source |
(
|
ds_oid integer not null auto_increment, |
dbms_name varchar(256) character set utf8mb4 not null, |
server_name varchar(256) character set utf8mb4, |
cluster_id varchar(256) character set utf8mb4, |
database_name varchar(520) character set utf8mb4, |
logid varchar(256) character set utf8mb4, |
owner_oid int, |
root_rs_oid int, |
readonly_ind tinyint not null, |
ctrl_ins_dtm timestamp(6) not null default current_timestamp(6), |
ctrl_upd_dtm timestamp(6) not null default current_timestamp(6) on update current_timestamp(6), |
ctrl_usr_id varchar(256) character set utf8mb4 not null, |
primary key (ds_oid) |
);
|
|
create table in_sync_object |
(
|
rs_oid int not null, |
ds_oid integer not null, |
object_cat varchar(520) character set utf8mb4 collate utf8mb4_bin, |
object_schem varchar(256) character set utf8mb4 collate utf8mb4_bin, |
object_name varchar(256) character set utf8mb4 collate utf8mb4_bin not null, |
object_sig varchar(512) character set utf8mb4, |
object_subtype varchar(60), |
object_ignore_ind tinyint not null default 0, |
ctrl_ins_dtm timestamp(6) not null default current_timestamp(6), |
ctrl_upd_dtm timestamp(6) not null default current_timestamp(6) on update current_timestamp(6), |
ctrl_usr_id varchar(256) character set utf8mb4 not null, |
primary key (rs_oid) |
);
|
|
create unique index IX1IN_SYNC_OBJECT on in_sync_object |
(
|
ds_oid,
|
object_cat,
|
object_schem,
|
object_name,
|
object_sig
|
);
|
-- [10.9.3-MariaDB]Can't create table `in_sync_object` (errno: 150 "Foreign key constraint is incorrectly formed")
|
alter table in_sync_object add constraint FK_IST_ISDS_DS_OID foreign key (ds_oid)
|
references in_sync_data_source (ds_oid) on delete restrict on update restrict;
|
Attachments
Activity
Transition | Time In Source Status | Execution Times |
---|
|
1d 17h 39m | 1 |