View Issue Details

IDProjectCategoryView StatusLast Update
0004514SymmetricDSBugpublic2022-10-04 15:15
Reporterpmarzullo Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.2 
Target Version3.14.2Fixed in Version3.14.2 
Summary0004514: DbCompare: The output script to fix issues on the target does not support null values.
DescriptionIt will write SQL update statement with "where COLUMN = null" instead of "where COLUMN is not null" or "where COLUMN is null".
As it is pointing to the expected PK, I understand that null is not expected, but still it could exist. On Oracle, it will allow a NULL value for primary key column.
Tagsdbcompare

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 60e83dad

2022-09-09 20:01:02

evan-miller-jumpmind

Details Diff
0004514: Fixed dbcompare not supporting null values in unique columns Affected Issues
0004514
mod - symmetric-db/src/main/java/org/jumpmind/db/sql/DmlStatement.java Diff File

Issue History

Date Modified Username Field Change
2020-08-31 12:07 pmarzullo New Issue
2020-08-31 12:07 pmarzullo Tag Attached: dbcompare
2020-09-16 17:49 elong Description Updated View Revisions
2022-09-09 20:01 emiller Assigned To => emiller
2022-09-09 20:01 emiller Status new => resolved
2022-09-09 20:01 emiller Resolution open => fixed
2022-09-09 20:01 emiller Fixed in Version => 3.14.2
2022-09-09 21:00 Changeset attached => SymmetricDS 3.14 60e83dad
2022-10-04 15:15 admin Status resolved => closed