create table t1(id1 int NOT NULL PRIMARY KEY, data char(8), id3 int not null, unique(id3)) engine=ndb comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM"; create table t2(id2 int NOT NULL PRIMARY KEY, id1 int, data char(8), id3 int) engine=ndb comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM"; alter table t2 algorithm=inplace, add constraint id1 foreign key (id1) references t1(id1); alter table t2 algorithm=inplace, add constraint id3 foreign key (id3) references t1(id3); load data local infile 'suite/ndb/data/table_data10000.dat' into table t1 fields terminated by ' ' lines terminated by '\n' ignore 900 lines (@id, data) set id1 = @id, id3 = -@id; load data local infile 'suite/ndb/data/table_data10000.dat' into table t2 fields terminated by ' ' lines terminated by '\n' ignore 900 lines (@id, data) set id1 = @id, id2 = -@id, id3=-@id; SELECT partitions, fragments, hash_map from ndbinfo.dictionary_tables WHERE table_name in ("t1", "t2"); partitions fragments hash_map 2 2 DEFAULT-HASHMAP-3840-2 2 2 DEFAULT-HASHMAP-3840-2 Nodegroup 1 created Drop Node Group 1 done Nodegroup 1 created alter table t2 algorithm=inplace, reorganize partition; alter table t1 algorithm=inplace, reorganize partition; SELECT partitions, fragments, hash_map from ndbinfo.dictionary_tables WHERE table_name in ("t1", "t2"); partitions fragments hash_map 4 4 DEFAULT-HASHMAP-3840-4 4 4 DEFAULT-HASHMAP-3840-4 Check node restart after reorg with foreign keys --- Wait for node to stop --- Startup node again --- Wait for node to recover * 1006: Illegal reply from server * error: -2 drop table t2,t1; Drop Node Group 1 done