View Issue Details

IDProjectCategoryView StatusLast Update
0004931SymmetricDSBugpublic2024-08-23 12:55
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.0 
Target Version3.12.9Fixed 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

Relationships

related to 0006562 closedelong Stream LOB when row is deleted can get exception ColumnNotFoundException 

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
2021-05-07 13:07 elong Status resolved => closed
2021-05-07 13:07 elong Target Version => 3.12.9
2024-08-23 12:55 elong Relationship added related to 0006562