View Issue Details

IDProjectCategoryView StatusLast Update
0006623SymmetricDSBugpublic2024-11-13 20:31
Reporterpbelov Assigned Topbelov  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.10Fixed in Version3.15.10 
Summary0006623: The isNull transform converts an empty string to NULL
DescriptionThe isNull transform converts an empty string to NULL, breaking the intent behind avoiding NULL value.
Steps To ReproduceTest 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 InformationRelease 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.
Tagstransformation

Activities

pbelov

2024-10-23 21:07

manager   ~0002511

Merged code fix into the 3.15 branch

pbelov

2024-10-24 00:19

manager   ~0002512

Issued a patch with the code fix:
https://downloads.jumpmind.com/symmetricds/patches/3.15/patch-0006623.jar

pbelov

2024-10-31 18:12

manager   ~0002519

Pending release of the 3.15.10 version

Related Changesets

SymmetricDS: 3.15 e9f51f2f

2024-10-23 20:55:15

pbelov


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

Issue History

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
2024-11-13 20:31 pbelov Status resolved => closed