View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005901 | SymmetricDS | Bug | public | 2023-06-27 18:52 | 2023-07-10 15:00 |
| Reporter | cquamme | Assigned To | cquamme | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Target Version | 3.14.8 | Fixed in Version | 3.14.8 | ||
| Summary | 0005901: DBCompare produces output SQL with invalid syntax | ||||
| Description | When 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 Reproduce | Run DBCompare where the source side has a value that is null and the target side is not null. | ||||
| Tags | No tags attached. | ||||
| 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 |