View Issue Details

IDProjectCategoryView StatusLast Update
0000755SymmetricDSBugpublic2019-04-12 13:37
ReporterkienkouAssigned To 
Prioritynormal 
Status newResolutionopen 
Product Version 
Target VersionFixed in Version 
Summary0000755: When missing primary key, update where clause needs to use "is null" for null values
DescriptionWhen a table has nullable fields , has blob field, and without primary key, sync works unnoramlly.
Tagsdata sync

Activities

chenson

2012-08-08 07:41

administrator   ~0000058

Can you please give more details on how to reproduce?

kienkou

2012-08-08 21:11

reporter   ~0000060

When create triggers for a table ,which has nullable fields , has blob field, and without primary key , you will makeAllColumnsPrimaryKeys, and the where condition will be like "orig.field = inserted.field ..." , you have ignored (orig.field is null and inserted.field is null).

NULL value can not compare with "=".

chenson

2014-12-31 16:49

administrator   ~0000643

Where are you running into this issue? Do you have a stacktrace available?

Issue History

Date Modified Username Field Change
2012-08-08 02:42 kienkou New Issue
2012-08-08 07:41 chenson Note Added: 0000058
2012-08-08 21:11 kienkou Note Added: 0000060
2014-12-31 16:49 chenson Note Added: 0000643
2019-04-12 13:37 admin Summary When a table has nullable fields , has blob field, and without primary key, sync works unnoramlly. => When missing primary key, update where clause needs to use "is null" for null values
2019-04-12 13:37 admin Tag Attached: data sync