View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004814 | SymmetricDS | Bug | public | 2021-02-05 15:57 | 2021-02-25 21:33 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.6 | ||||
| Target Version | 3.12.7 | Fixed in Version | 3.12.7 | ||
| Summary | 0004814: binary column that is zero length (not null) sends to null to target during initial load | ||||
| Description | When 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 Reproduce | 1. 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. | ||||
| Tags | initial/partial load | ||||
| 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 |