View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006623 | SymmetricDS | Bug | public | 2024-10-23 20:29 | 2024-10-31 18:12 |
| Reporter | pbelov | Assigned To | pbelov | ||
| Priority | normal | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.10 | Fixed in Version | 3.15.10 | ||
| Summary | 0006623: The isNull transform converts an empty string to NULL | ||||
| Description | The isNull transform converts an empty string to NULL, breaking the intent behind avoiding NULL value. | ||||
| Steps To Reproduce | Test table: CREATE TABLE SymmetricRoot (and on SymmetricClient).dbo.test_nullable( col1 nvarchar(7) ,col2 int NULL ,comments nvarchar(max) NULL -- >> But set to NOT NULL on the client! ,CONSTRAINT UX_test_nullable UNIQUE (col1) ); Set up IMPLICIT transform (the isNull kind) for the NULLable column comments to an empty expression. INSERT into SymmetricRoot.dbo.test_nullable VALUES (16, null, null); Observe data change batch fail due to inserting NULL into comments column, which does not allow NULL on the client. | ||||
| Additional Information | Release notes will benefit from a warning to users: Examine your Column Transforms, which utilize the isNull type of transform - if you use an empty string for the expression, the behavior had changed to enforce such empty string (as opposed to allowing a NULL value through before this release). No impact to isNull transforms with non-empty expression text. | ||||
| Tags | transformation | ||||
|
|
Merged code fix into the 3.15 branch |
|
|
Issued a patch with the code fix: https://downloads.jumpmind.com/symmetricds/patches/3.15/patch-0006623.jar |
|
|
Pending release of the 3.15.10 version |
|
SymmetricDS: 3.15 e9f51f2f 2024-10-23 20:55:15 Committer: GitHub Details Diff |
0006623: The isNull transform - prevent converting an empty string expression to NULL (0000204) 0006623: Empty string path for the isNull transform to prevent converting an empty string expression to NULL |
Affected Issues 0006623 |
|
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/IsNullTransform.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-10-23 20:29 | pbelov | New Issue | |
| 2024-10-23 20:29 | pbelov | Status | new => assigned |
| 2024-10-23 20:29 | pbelov | Assigned To | => pbelov |
| 2024-10-23 20:29 | pbelov | Tag Attached: transformation | |
| 2024-10-23 21:00 | pbelov | Changeset attached | => SymmetricDS 3.15 e9f51f2f |
| 2024-10-23 21:07 | pbelov | Note Added: 0002511 | |
| 2024-10-24 00:19 | pbelov | Status | assigned => confirmed |
| 2024-10-24 00:19 | pbelov | Note Added: 0002512 | |
| 2024-10-24 00:22 | pbelov | Additional Information Updated | View Revisions |
| 2024-10-31 18:12 | pbelov | Status | confirmed => resolved |
| 2024-10-31 18:12 | pbelov | Resolution | open => fixed |
| 2024-10-31 18:12 | pbelov | Fixed in Version | => 3.15.10 |
| 2024-10-31 18:12 | pbelov | Note Added: 0002519 |