View Issue Details

IDProjectCategoryView StatusLast Update
0005901SymmetricDSBugpublic2023-07-10 15:00
Reportercquamme Assigned Tocquamme  
Status closedResolutionfixed 
Target Version3.14.8Fixed in Version3.14.8 
Summary0005901: DBCompare produces output SQL with invalid syntax
DescriptionWhen you run DBCompare and it produces output SQL where the user needs to update a value to be null, it will produce somehting like the following SQL:

update TABLE set "SOME_VALUE" is null where "SOME_OTHER_VALUE" = 1;

This is invalid syntax, as the "is null" in the set part of the query should be "= null" instead.
Steps To ReproduceRun DBCompare where the source side has a value that is null and the target side is not null.
TagsNo tags attached.


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 ecb4d7b5

2023-07-10 14:27:58


Details Diff
0005901: DBCompare produces output SQL with invalid syntax Affected Issues
mod - symmetric-db/src/main/java/org/jumpmind/db/sql/ Diff File

Issue History

Date Modified Username Field Change
2023-06-27 18:52 cquamme New Issue
2023-06-27 18:52 cquamme Status new => assigned
2023-06-27 18:52 cquamme Assigned To => cquamme
2023-07-10 14:32 cquamme Status assigned => resolved
2023-07-10 14:32 cquamme Resolution open => fixed
2023-07-10 14:32 cquamme Target Version => 3.14.8
2023-07-10 15:00 cquamme Changeset attached => SymmetricDS 3.14 ecb4d7b5
2023-07-19 12:58 admin Status resolved => closed