View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000755SymmetricDSBugpublic2012-08-08 06:422019-04-26 19:52
Reporterkienkou Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Target Version3.10.0Fixed in Version3.10.0 
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

Relationships

related to 0003521 closedjosh-a-hicks Create Table First is creating table with all columns as primary key instead of none 

Activities

chenson

2012-08-08 11:41

administrator   ~0000058

Can you please give more details on how to reproduce?

kienkou

2012-08-09 01: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 21: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 06:42 kienkou New Issue
2012-08-08 11:41 chenson Note Added: 0000058
2012-08-09 01:11 kienkou Note Added: 0000060
2014-12-31 21:49 chenson Note Added: 0000643
2019-04-12 17: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 17:37 admin Tag Attached: data sync
2019-04-26 19:52 elong Relationship added related to 0003521
2019-04-26 19:52 elong Assigned To => elong
2019-04-26 19:52 elong Status new => closed
2019-04-26 19:52 elong Resolution open => fixed
2019-04-26 19:52 elong Fixed in Version => 3.10.0