View Revisions: Issue #1974

All RevisionsBack to Issue
Summary 0001974: fallback to update fails with implied load transform that adds to pk
Revision 2014-09-17 19:29 by chenson
Description fallback to update fails with implied load transform that adds to pk

client:
create table test (id1 integer, note varchar(100), primary key (id1))

server:
create table test (id1 integer, id2 varchar(100), note varchar(100), primary key (id1,id2))

create load transform with a constant column values for id2
config sync from client to server

insert rows to client
let them sync to server
perform a reverse initial load

watch the fallback fail
Revision 2014-09-17 19:28 by chenson
Description mix of old and null pk column values on fallback from insert can cause conflict issue when load transform is applied

client:
create table test (id1 integer, note varchar(100), primary key (id1))

server:
create table test (id1 integer, id2 varchar(100), note varchar(100), primary key (id1,id2))

create load transform with a constant column values for id2
config sync from client to server

insert rows to client
let them sync to server
perform a reverse initial load

watch the fallback fail