View Issue Details

IDProjectCategoryView StatusLast Update
0003711SymmetricDSBugpublic2018-09-10 07:45
ReportergwilmerAssigned Togwilmer 
Priorityhigh 
Status assignedResolutionopen 
Product Version3.9.12 
Target VersionFixed in Version 
Summary0003711: Table reload request for a table with a foreign to itself and a data row where the row fk is to itself doesn't load any data
DescriptionTable reload request for a table with a foreign to itself and a data row where the row fk is to itself doesn't load any data to the target table
Steps To Reproduce1. Create simple 2 node sync scenario (server -> client)
2. Create the following table:

CREATE TABLE "TEST"(
    "ID" INTEGER NOT NULL,
    "NAME" CHAR(50) NULL,
    "PARENT_ID" INTEGER,
    PRIMARY KEY ("ID")
);
ALTER TABLE "TEST"
    ADD CONSTRAINT "CONSTRAINT_273C" FOREIGN KEY ("PARENT_ID") REFERENCES "TEST" ("ID");

Add the following data to the table on the server:

insert into test values (1,'first row',1)
insert into test values (2,'child',1)

3. Configure table test to sync from server to client
4. Initiate a reload request of table test from server to client

Batch will be created, and be sent OK with zero rows.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2018-09-08 09:18 gwilmer New Issue
2018-09-10 07:45 gwilmer Assigned To => gwilmer
2018-09-10 07:45 gwilmer Status new => assigned