View Issue Details

IDProjectCategoryView StatusLast Update
0004814SymmetricDSBugpublic2021-02-25 21:33
Reporterpmarzullo Assigned Topmarzullo  
Status closedResolutionfixed 
Product Version3.12.6 
Target Version3.12.7Fixed in Version3.12.7 
Summary0004814: binary column that is zero length (not null) sends to null to target during initial load
DescriptionWhen a column is a binary type, and the type does not use the trigger template during initial load, and the value in the database is zero length (but it is not null), the CSV value that is sent to the target is a null representation of the value instead of two double quotes that indicate not null but empty.
Steps To Reproduce1. Create a table with a varbinary type of column defined as NOT NULL on both the source and the target.
2. Insert a record with a value in the varbinary column with an empty value, but not null.
3. Initial load the table.
Tagsinitial/partial load


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 08b7d79f

2021-02-05 16:02:21


Details Diff
0004814: binary column that is zero length (not null) sends to null to
target during initial load
Affected Issues
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/ Diff File

Issue History

Date Modified Username Field Change
2021-02-05 15:57 pmarzullo New Issue
2021-02-05 15:57 pmarzullo Status new => assigned
2021-02-05 15:57 pmarzullo Assigned To => pmarzullo
2021-02-05 15:57 pmarzullo Tag Attached: initial/partial load
2021-02-05 17:00 pmarzullo Changeset attached => SymmetricDS 3.12 08b7d79f
2021-02-25 14:35 elong Status assigned => resolved
2021-02-25 14:35 elong Resolution open => fixed
2021-02-25 14:35 elong Fixed in Version => 3.12.7
2021-02-25 21:33 admin Status resolved => closed