View Issue Details

IDProjectCategoryView StatusLast Update
0004931SymmetricDSBugpublic2021-03-31 13:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.12.0 
Fixed in Version3.12.9 
Summary0004931: Stream LOB when row is deleted can get not null error when required by constraint
DescriptionWhen stream LOB is used, the trigger will capture a null value for the column, then extract the LOB later. But if the row has been deleted by then, a null is sent to the target database. If the column is defined as not null, the row will not load. Use an empty LOB instead, so the constraint is satisfied.
Tagslarge objects

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 98a3164e

2021-03-31 12:21:31

admin

Details Diff
0004931: Stream LOB when row is deleted can get not null error when
required by constraint
Affected Issues
0004931
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/reader/ExtractDataReader.java Diff File

Issue History

Date Modified Username Field Change
2021-03-31 12:20 elong New Issue
2021-03-31 12:20 elong Status new => assigned
2021-03-31 12:20 elong Assigned To => elong
2021-03-31 12:20 elong Tag Attached: large objects
2021-03-31 12:21 elong Status assigned => resolved
2021-03-31 12:21 elong Resolution open => fixed
2021-03-31 12:21 elong Fixed in Version => 3.12.9
2021-03-31 13:00 admin Changeset attached => SymmetricDS 3.12 98a3164e